• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
The Newsletter Plugin Documentation

The Newsletter Plugin Documentation

Every little detail discovered.

  • Premium
  • Support Ticket
  • Account
  • Blog

Advanced Import

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.

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!

Primary Sidebar

  • Installation
  • Getting Started
  • How to Install Addons
  • How to install the Addons Manager
  • Main Configuration
  • The Status Panel
  • Subscription
  • Subscription Basics
  • Lists
  • Spam Subscriptions
  • Subscription forms and shortcodes
  • Custom coded forms
  • GDPR compliancy
  • Subscribers and management
  • Profile page
  • Cancellation
  • Subscribers Statistics
  • Subscribers Management
  • Newsletters
  • Create and Send Newsletters
  • The Newsletter Composer
  • Targeting
  • Extra Profile Fields and Profile Fields Targeting
  • Tags
  • Multilanguage
  • Addons
  • Delivery Addons
  • Amazon SES Addon
  • SendGrid Addon
  • Sendinblue Addon
  • SparkPost Addon
  • ElasticEmail Addon
  • Mailgun Addon
  • MailJet Addon
  • Extended Features
  • Advanced Import
  • Automated
  • Autoresponder
  • Bounce Management
  • Geolocation Extension
  • Google Analytics Extension
  • Leads Extension
  • Locked Content
  • Reports and Retargeting
  • Archive
  • Speed Control
  • Subscribe on Comment
  • WP User Registration
  • Integrations
  • BuddyPress Integration
  • Contact Form 7 Integration
  • Event Manager Integration
  • Facebook Integration
  • Ninja Forms Integration
  • The Events Calendar Integration
  • Translatepress Integration
  • WooCommerce Integration
  • WP Forms Integration
  • Instasend
  • Customization
  • Forms style
  • Message templates
  • Delivery and spam
  • Delivery Speed And The Cron Problem
  • Email Delivery Issues
  • The Spam Problem
  • Developers & Advanced Topics
  • Backup, Recovery, Delete
  • Composer Blocks
  • Constants
  • Filters and Actions
  • Incompatibilities
  • Newsletter API Version 2
  • Newsletter API version 1
  • Newsletter Legacy API