Import

This screen enables you to import users from different sources.

AcyMailing keeps track of your users' subscription and unsubscription! This way, even if you try to import twice the same users, AcyMailing will take care of the duplicate entries and won't subscribe an unsubscribed user again. Nevertheless, if you import the users to a newly created list, all the imported users will be subscribed to this list.

Source

You can import users from different sources according to your needs.

  • Import from file : Import your users from a CSV or a text file.

  • Import from text : Instead of uploading a file, you can directly copy/paste your contacts in an input box and let AcyMailing import them.

  • Joomla! / WordPress Users : Synchronise/Import the users that have an account on your website

  • Database : If you have a table in your database with a list of users you would like to use, you can import them using this option

Import from file

You can browse a CSV file to import it.

The first line of your CSV file can tell AcyMailing the name of the fields to import (column names of the #_acym_user table from the database if you want AcyMailing to assign them automatically). For example, if your file contains a list of users with the format "email,name,active", this first line of your file should be "email,name,active" (always in English).

If your file only contains a list of e-mail addresses, simply add them one per line, AcyMailing will know what to do ;)

If you are not sure about your column names, simply try to upload your file and AcyMailing will allow you to assign the columns to the right fields.

For the field confirmed, the values should be 0 (for not confirmed) or 1 (for confirmed). If you don't specify this column in your file, the default value is 0 (not confirmed).

name,email
john,john@example.com
adrien,adrien@example.com
mike,mike@example.com

If you have an excel file with all your contacts, simply add a new line at the top to indicate the column name (email, name...) and then save your file in a CSV format (Save as -> CSV). You can then import your CSV file in AcyMailing. You can open your file with a text editor (notepad for example) to check if your file has the right format.

In some cases you want to import users and individually subscribe them to some lists. In that case you can add a column called listids in your import file. If you do so, you can then specify the ids of the AcyMailing lists you want the user to be subscribed to during the import.

name,email,listids
Adrien,adrien@acyba.com,3
John,john@acyba.com,8-4

So Adrien will be subscribed to the list with the ID 3 and John will be subscribed to the lists with the IDs 8 and 4. If you want to subscribe them all to the same list, please remember you don't have to use this extra parameter!

You can also add a column called "listname" in your import file. If you do so, you can then specify the name of the AcyMailing lists you want the user to be subscribed to during the import. If the list doesn't exist yet, it will be automatically created.

name,email,listname
Adrien,adrien@acyba.com,My list A
John,john@acyba.com,My list B - My new list C

So Adrien will be subscribed to list A and John will be subscribed to lists B and C. As the list C doesn't exist yet, AcyMailing will create it.

Once you selected your file, click on the "Import" button, you will get to the next import page where you will find all the import options.

Import from text

This option enables you to directly write a series of email addresses in addition to as many fields as you want in this input and import them in AcyMailing. That will enable you to avoid any access rights or encoding issue you may have with the file import function.

The content is built the same way as the file described before.

Once you filled in the text area with your users, click on the "Import" button, you will get to the next import page where you will find all the import options.

Second import step

AcyMailing will automatically suggest which columns to assign to the data you want to import. But you can modify and complete it if needed. You can assign a column to an AcyMailing default field or a custom field or ignore some columns. You can ignore all the unassigned columns using the upper option.

  • File Charset: We recommend you to import an utf-8 file but if you import another format, you can let AcyMailing handle the conversion in which case you should specify the encoding format of your imported file/text area data.

  • Import the user as confirmed: you can decide if you want your users to be imported as confirmed users (so you will be able to send them an e-mail) or if you want the users to be imported as unconfirmed, in which case you could then send a confirmation e-mail to your unconfirmed users.

  • Overwrite existing user's information: if the user already exists in AcyMailing, doyou want to replace his information by the one imported?

  • Auto-generate User's name: if you only import emails, you can ask AcyMailing to create a name from the email (adrien@acyba.com will set adrien as name).

Once you selected the options and assigned the columns as you want, click on the "Import users" button to import your users.

Joomla! / WordPress Users

Using this option, AcyMailing will not only add the users that have an account on your website in the list of AcyMailing users, it will also synchronize its data based on the CMS data.

Database

Using this option, you will be able to import your contacts from any other table in your database.

  • Table Name : You should specify in this field the name of the table you want to import.

  • Name : If the other table contains the name of the user, you can import it as well. This field is optional

  • Email : This field is the only required field for the import process. You should specify the name of the column which contains e-mail addresses in the other table.

  • Creation_date: Date the user was created at. If left empty, the date of the import will be used. The format of the date field should be "yyyy-mm-dd hh:mm:ss".

  • Active: Is the user enabled or not. The column you use for this data should contains 0 (disabled) or 1 (enabled).

  • Cms_id: If the user is also a user of your website (Joomla! or WordPress user), you can set here the field containing his ID on the site.

  • Source: Where the user was created. If left empty, the default value will be "import_<timestamp>" (for example: import_1561541446).

  • Confirmed: is the user confirmed or not. The column you use for this data should contains 0 (not confirmed) or 1 (confirmed).

  • Confirmation_date: Date when the user was confirmed. The format of the date field should be "yyyy-mm-dd hh:mm:ss".

  • Confirmation_ip: IP address where the user confirmed.

  • Import the user as confirmed: only displayed if you require confirmation (can be set in AcyMailing configuration). Should the user be created as confirmed or not.

Lists

When importing users in AcyMailing, you can directly subscribe them to one or more lists.

AcyMailing keeps track of the unsubscription status of the user so that even if you import twice the same users on your lists, AcyMailing won't subscribe users who already unsubscribed.

No welcome message, nor confirmation message will be sent during this import.

You can also create a new list from this interface and subscribe the imported users to it.