Description

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.

 

 

How to access this screen

Import access

 

From the users listing page, click on the "Import" button on the top of the screen

 

 

 

Source

Source

 

  • 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

Import File

 

You can browse a CSV file to import it.

The first line of your CSV file can indicate AcyMailing the name of the fields to import (column names of the xxx_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 righ 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).

Example:

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.


Example:
name,email,listids
Adrien,This email address is being protected from spambots. You need JavaScript enabled to view it.,3
John,This email address is being protected from spambots. You need JavaScript enabled to view it.,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.


Example:
name,email,listname
Adrien,This email address is being protected from spambots. You need JavaScript enabled to view it.,My list A
John,This email address is being protected from spambots. You need JavaScript enabled to view it.,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

Textarea import

This option enables you to directly write a series of e-mail 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.

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 page

Assign columns

 

You will first have to assign (if it's not automatically done) the columns of your data taken from the imported file / text field.

You can assign a column to an Acy field/custom field or ignore some columns. You can ignore all the unassigned columns using the option on the left.

 

  • 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.

 

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

Import Joomla 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.

Database import

  • Table Name : You should specify in this field the name of the table you want to import. In this example, the Joomla user table is selected
  • 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 required for the import process, you should specify the name of the column which contains e-mail addresses in the other table.

 

Example: the Joomla extension HikaShop

If you use HikaShop without using the Joomla registration process, then the user won't have an account and won't be added to your Joomla User table... so he won't be automatically added to AcyMailing.

You can nevertheless use this AcyMailing database import to import all your HikaShop user to AcyMailing regardless of the fact they have an account on Joomla or not.

  • Table Name : #__hikashop_user
  • email: user_email
  • name : column name of the custom user field in hikashop (not required)

 

Example: import from Prestashop

If Joomla and Prestahop are installed on the same database, you can import your Prestashop users using the parameters:

  • Table Name: ps_customer
  • email: email
  • name: firstname

 

Example: Import from phpFox

If Joomla and phpFox are installed on the same database, you can import your phpFox users using the parameters:

  • Table Name: phpfox_user
  • email: email
  • name: user_name

 

Example: import from phpBB

If Joomla and phpBB are installed on the same database, you can import your phpBB users using the parameters:

  • Table Name: phpbb_users
  • email: user_email
  • name: username

 

Lists

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.

 
Send Feedback