Importing mailing list
In the Peppered Dashboard, go to Mailings > Mailing list import
This module imports e-mail addresses and optional other personal data from a csv file and adds these records to a specific mailing list.
This module ensures that no duplicates email addresses will arise; if the e-mail address already exist, the data will be updated.
Creating the CSV file
A list of e-mail addresses must be imported as a CSV file. CSV stands for comma separated values. With a program such as Excel or OpenOffice's Calc it is very easy to create a CSV file.
Create a spreadsheet with 5 columns with these names on the first row (these names are checked, so make sure they are exact):
- gender
- first name
- surname prefix
- last name
You can now add the following data in each of the columns
- email: this column cannot be left blank. A blank field can result in failure during import, so make sure all e-mail address fields are properly filled in with correct e-mail addresses.
- gender: the value 'man' (male) or 'vrouw' (female) can be shown here (sorry, old Dutch remnants), or the column can be left empty. This can be used in salutation in mailings. If there are other values, for example M for man, then these values can be changed by selecting the entire column. In the browser menu, choose edit -> find and then choose the 'replace' tab. Specify the value that you want to replace, and below it the new value. Select 'Search: By Column', under the options, and press 'replace everything'.
- first name: may remain empty. Can be used in salutation in mailings
- surname prefix: may remain empty. Can be used in salutation in mailings
- last name: may remain empty. Can be used in salutation in mailings
Go to 'Save as ...', and choose CSV (Comma Separated Values) (* .csv) as the file type (NB: On a Mac, choose file type "list separators (for Windows)"). Preferably choose a name without spaces, capital letters or weird characters.
- Note: File must be encoded using UTF-8.
- Note: Land must be in ISO 2 format (eg.: NL, BE, FR).
- Note that the columns must be separated with a comma or semicolon, and that the columns can only be delimited with double quotes. (Delimit is optional and only used when comma’s or semicolons can be within the data itself)
- Only the first column must be filled, the rest can just be empty, but make sure the columns are in the correct order.
Import the CSV file
- Choose and upload the file you just created
- Select an existing mailinglist to import the data to. If you want to upload to a new mailing list, first create a mailing list in the “mailing list” module.
- Select the separator type of the CSV file (rows can be separated by semi colon (;) or comma (,) in the CSV
- If the first line of the file does not contains the titles of the fields, select the "skip validation" checkbox.
- If the personal data of existing persons does not need to be updated, deselect the "overwrite personal data" checkbox.
GDPR & privacy
When importing new e-mail addresses, it is important to take the GDPR into consideration. You cannot use e-mail addresses in mailings without consent. If consent was already given, consider importing consent data too via our Opt-in import feature.