Import addresses from CSV

When importing a CSV or text database, the first step is to select and upload such a file. 

CSV stands for Comma Separated Value and describes a text file in which addresses are saved separated by commas. This looks like this, for example:

In the next step, you must assign the fields from your CSV file to the fields in [MNR_ProductName]. The system will attempt to make a preselection automatically. 

The corresponding table has three columns:

• Import field - If the field names are listed in the top line of your CSV file, they will be displayed one below the other in this column. 
• Value of the 1. Line displays the value contained in the first data line. 
• In target field - Here you select the field from the mynewsletter.rocks database into which the value is to be written. 

When selecting the target field, either select an existing field into which the data is to be imported or choose one of the following options:

• Do not import - The field is not imported
• Create new field - A new field is created and has the same name as specified in the CSV file. 

If you import files with umlauts, the encoding of the file may not be recognized correctly. 

If this is the case, delete the imported list and select an encoding manually the next time you try.

Click on Importto start the import.

Depending on the size of the list, it may take a while for the file to be imported. It is then added to the list of addresses and selected as shown in the screenshot. 

Attention: This function is only included in mynewsletter.rocks or the News & Mail Service 'On Premise'. With the News & Mail Service for cobra, addresses are managed exclusively in cobra.