DEPRECATION WARNING

This documentation is not using the current rendering mechanism and will be deleted by December 31st, 2020. The extension maintainer should switch to the new system. Details on how to use the rendering mechanism can be found here.

Importing a csv list of email addresses

The Recipient Lists module gives you the option to import a csv (comma-separates list) of address records and create a recipient list containing the imported records.

To make it easier to import csv records, there is a wizard, which guide you through the process.

In the first step you can choose to upload a csv file or paste the records into a text field. You can use comma (;), semicolon (;), or colon (:) as field delimiter. This can be configured in the second step.

img-11

By clicking the next button, the csv file or csv records are uploaded and the second step is shown. In this step you can specify the detail information of the csv data, such as field delimiter, field encapsulation, and field name in the first line. You can also specify the SysFolder, where the records should be imported to, the uniqueness of the records, rename or update the records if a similar record is found, or to empty the SysFolder before importing.

img-12

ATTENTION! If you set the field “remove all Addresses in the storage folder before importing”, all records in this SysFolder WILL be physically deleted .

After specifying the configuration you can start mapping the fields. There are 3 columns in the mapping step. The description column shows the first row of the csv records (if you set in the configuration that the first row is the field names) or shows only field_xx (where xx is continuous number).

The mapping column shows only the list of field, which are part of tt_address table. You must at least map the field “Name” and “Email”.

The value column shows the first up to three rows from the csv records. They should help you to map the field.

img-13 img-14

There are some new feature in the importer. You can now set HTML flag or categories to all records you are importing. In the select box, which contains the field names of tt_adress, there's a new entry called “categories”. This entry can be mapped to a comma-separated list of direct mail category IDs. This value will overwrite whatever categories you selected in the “Additional options” section.

After mapping the fields you are ready to start the import process. To start the import click the import button. After the importing, a list of new imported, invalid email, updated and doublet records will be shown.

img-15