Subscribers: ImportYou have probably already compiled a list of addresses that you want to send newsletters to. The universal CSV file format lets you export your addresses from almost any database or spreadsheet program (e.g. Microsoft Office or OpenOffice) and then import them into emma. To make it easier to map the columns (e.g. first name, last name, email) during the import, the first line of your CSV file should contain meaningful column headings. An example:
When saving your data, choose the export format CSV UTF-8 (Comma delimited) or CSV (Comma delimited), depending on the version of your Office package. The import step by stepTo import your CSV file into emma, select 'Import' in the 'Subscribers' menu:
Step 1 - Import fileSelect the CSV file you want to import. To speed up the upload of large files, you can compress the file as a ZIP archive first. The name of the ZIP file must be identical to the name of the CSV file it contains. Note: The CSV file should not be larger than 200 MB. Please split larger files before importing them.
Then click 'Next'. Step 2 - File structureStep 2 shows a preview of the first lines of your CSV file. Here you can check what the import will look like with the current settings.
Set the 'Field separator' and 'Text separator' so that the columns you need (e.g. first name, last name, email) are displayed side by side. In most cases, the default settings (semicolon as field separator, quotation marks as text separator) already fit. emma usually detects the 'Character set' automatically from the special characters in the CSV file (e.g. German umlauts). Please check how the characters are displayed in the preview. If characters are displayed incorrectly in the preview, proceed as follows:
The 'First line contains column headings' option specifies whether the first line of your CSV file contains the column headings (e.g. first name, last name, email) or starts directly with subscriber data. Then click 'Next'. --> Tip: If you are unsure about the format of your CSV file, open it in a text editor. Here is an example of a CSV file with column headings, semicolon as field separator and quotation marks as text separator:
Step 3 - Subscriber listsNow select the emma subscriber list your CSV file should be imported into. If you have not created a subscriber list of your own in emma yet (see the Subscriber lists menu), you can start right away with the empty subscriber list 'Demo-Liste'. This list is usually created when your emma account is set up and contains one sample subscriber for demonstration.
You can also select several subscriber lists if you want to import into several lists at once. After selecting the list(s), click 'Apply' and then 'Next'. You can change the name of a subscriber list at any time in the Subscriber lists menu. Step 4 - Field mappingIn step 4 you tell emma which column of your CSV file (e.g. first name, last name) should be imported into which emma subscriber field. Typical subscriber fields such as 'Email', 'Salutation', 'First name' and 'Last name' already exist in emma.
The left side shows the content of your CSV file once more, using the first two subscribers as an example. On the right side, select the 'Field type' that matches each content. emma maps the fields automatically if the CSV column heading and the name of the emma subscriber field are identical. If no matching subscriber field is found, the new field content is set to 'ignore'. In this case, either select one of the existing fields or use the 'New subscriber field' option to create a new field and give it a name. New fields created here always get the type 'Multi-line text', see also the tip below. Then click 'Next'. --> Tip: Ideally, take the time before your first import to create all fields in the emma menu 'Subscriber fields' so that field names and field types match your imported data. You will then benefit from automatic field mapping, which saves time on recurring imports and prevents errors caused by unsuitable field types or manual mapping. Step 5 - Import typeHere you define how your newly imported data is matched against the existing 'old' data of the selected emma subscriber list(s).
Four different import types are available. The examples below use Max and Lina ('old' data) and Alex and Leon (new data): --> Import type: AddAll new records are added, regardless of the existing records. All old records are kept. Any duplicates created this way can be removed later using Duplicate matching. In the example, Alex and Leon are added, Max and Lina are kept. |
--> Import type: ReplaceAll data in the selected list(s) is deleted and replaced by the content of the imported CSV file. Please note that deleting subscribers from the list also deletes their previous user behavior (opens, clicks, bounces), e.g. 'received last mailing', and any target group definitions based on it. If you do not want this, use 'Import type: Update and add' instead.
In the example, Max and Lina are deleted, then Alex and Leon are created. --> Import type: Update
Only the data of existing subscribers is updated. New subscribers are ignored, i.e. not added. You define in Step 6 - Options which data identifies a subscriber as 'already existing' (e.g. customer number or email address). If the option 'Delete recipients from subscriber list who are missing in the import file' is activated, subscribers missing from the CSV file are treated as 'please delete'. Only subscribers who are in both the old and the new list are kept. In the example, this option updates only Max. Lina is removed because she is missing from the CSV file. --> Import type: Update and add
In addition to the update described in the previous section, new subscribers from the CSV file are added if their data could not be matched to any subscriber already in the list. |
|
Combined with the option 'Delete recipients from subscriber list who are missing in the import file', this works like 'Import type: Replace', but keeps existing subscribers. This means: the new content of the CSV file is taken over completely, but unlike 'Import type: Replace', existing subscribers are recognized and their previous user behavior (opens, clicks, bounces) is kept. With this option, in the example, Max is updated (+music), Alex and Leon are added. Lina is removed because she is missing from the CSV file. |
|
You define in Step 6 - Options which data identifies a subscriber as 'already existing' (e.g. customer number or email address). Click 'Next'. Step 6 - OptionsHere you define the final details of the import.
|
















