Advanced Import

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.

Which data can be imported

  • Email (this is of course a required field)
  • 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 data 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.

Debugging import errors

it’s possible to ask this addon to log what happens when importing. On Newsletter main setting, change the log level to debug and run the import. Then move to the System>Logs panel where you should find an import-xxx.txt file where details are recorded.

Set the log level to error once finished.

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.

Have you ever considered going premium?

With a premium plan, you'll get whole collection of 30+ professional addons, along with a full year of updates and priority support. No automatic renewals, frequent releases and a solid 30 days refund policy.

Go Premium Now!