With Advanced Import Addon for the Newsletter plugin, you can import a list of contact 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.
The file 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@thenewsletterplugin.com;Lissa;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 Lissa;stefano@thenewsletterplugin.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 canot 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 user text deliemiters.
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 registsred 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.