With Advanced Import Addon for the Newsletter plugin, you can import a list of contacts saved in CSV format and mapping the CSV columns to the subscriber’s fields.
What can be imported
- Email (required)
- First name
- Last name
- Gender
- Country
- Region
- All extra profile fields
- All active lists
There are three import modes: update, overwrite and skip. They’re explained later.
File or copy and paste
Data can be available in a text file (CSV) or can be copied and pasted. Sometimes copy and paste can be the best choice if there are problems with encoding and language-specific characters.
The format
A CSV file can be generated by Excel using the “Save as” feature, or copying and pasting from Excel to a text editor (and saving the file with “csv” extension).
The file must have a first line with the field names (there are no constraints on how the fields are named). For example:
Email;Last name;First name;City stefano@example.com;Litracus;Stefano;Roma
You can then map those columns to the subscriber’s fields on a special configuration panel during the import process.
The column order is not important since you later will map the columns to the fields.
Last name;Email;First name;City Litracus;stefano@example.com;Stefano;Roma
Columns to not be imported
If the CSV contains columns not relevant for your import, there are no problems, just don’t map those columns to subscriber fields and they’ll be ignored.
Facebook export and errors
Facebook exports are coded in a special way (UTF-16 LE) and that format can’t be read by this addon. To convert it, just open the Facebook CSV file with Excel and resave it as UTF-8 CSV. Do not use text delimiters.
If an import is not working, probably the file is not in the right format or encoding. So open it with Excel (or equivalent) and export the data in UTF-8 encoded CSV without text delimiters. The field separator can be a semicolon or a tab.
Subscriber matching
The only required field is the email address. It is even used to check if the subscriber is already in your database and, following the “import mode”, the importer treats the data in different ways. See later the “import mode” paragraph.
Import mode
When importing your data can contain emails already registered. You should then select how to treat those already registered subscribers.
- Skip mode – means no action is taken and the impoting data is ignored
- Update mode – the subscriber profile is updated with the new data but old data not involved by the import action is preserved; for example if the extra field 2 is not imported, the original one is kept
- Overwrite mode – the subscriber data is emptied and then refilled with the importing data; that preserves the subscriber id and history (clicks, newsletters received, …) but everything else is blanked (fields, lists, gender, name, …)
Of course new subscribers are just created.
Activation and welcome emails
NO welcome or activation emails are sent during the import.
If you want to ask the subscribers to activate, import them as “not confirmed” and send them a newsletter with the {subscription_confirmation_url} link, inviting the to join your community.