Import Users

Description

This screen enables you to import users from different sources.

AcyMailing keeps track of the subscription of your users and of their 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! You can still remove some users in mass based on their subscription status using the screen "Subscribe Users" from the Lists management.

If you want to subscribe users in mass to your Mailing Lists using filters, you should go to the screen "Subscribe Users" from the Lists Management.

How to access this screen

• Go on the AcyMailing users management
• Click on the button "Import"

Toolbar

• Import : If you click on this button, the users will be imported based on the options you chose.
• Cancel : Return to the Users management listing.
• Help : This button enables you to turn ON/OFF the help section, this screen will appear or disappear.

Source

• File : Import your users from a CSV or a text file.
• Text Area : Instead of uploading a file, you can directly copy/paste your contacts in an input box and let AcyMailing import them.
• Joomla Users : Synchronise/Import your Joomla Users.
• com_contact : Import your users from com_contact. AcyMailing will import each contact using the name and e-mail specified in the contact manager.
• Database : If you have a table in your database with a list of users you would like to use, you can import them in AcyMailing
• Acajoom : Import your users from Acajoom, you also have the possibility to import the Acajoom Mailing Lists in order to keep the subscription of your Acajoom users.
• ccNewsletter : Import your ccNewsletter Users
• Communicator : Import your Communicator Users
• jNewsletter : Import your users from jNewsletter
• Vemod News Mailer: Import your users from Vemod News Mailer
• Letterman : Import your Letterman Users
• Yanc : Import your users from Yanc. You also have the possibility to import the Yanc Mailing Lists in order to keep the subscription of your Yanc users.

You won't see all those options on your interface but only the components you already installed.
So if you start with AcyMailing and didn't install any other component, the available choices will be to import data from a file, a textarea or your Joomla Users.

Lists

AcyMailing will import users... Those imported users will be subscribed to the selected 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.

Also, you cannot trigger follow-up autoresponder campaigns using this import.

File

You can browse a CSV file to import.

The first line of your CSV file should indicates to AcyMailing the name of the fields to import (column names of the #__acymailing_subscriber table from the database).
For example, if your file contains a list of users with the format "email,name,confirmed", this first line of your file should be : "email,name,confirmed" (always in English).

If your file contains a list of e-mails (one per line!) and no extra information, simply add the string "email" at the top of your file and import it.

If you are not sure about your column names, simply try to upload your file and AcyMailing will display clear error messages in case of your first line is not correct.

AcyMailing does not impose any CSV format and is able to import files with any kind of separator.

Please specify your file charset, if you know it, so that AcyMailing will encode your data in UTF-8 in order to import it properly.
If you don't know your file charset, simply leave it as "Unknown" and AcyMailing won't encode your data.

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).
For the field html, the values should be 0 (receive Text) or 1 (receive HTML). If you don't specify this column in your file, the default value is 1 (receive HTML).

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

• Import the user as confirmed: If you require a confirmation in AcyMailing, then this option will be displayed if you try to import a file so 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.
• Auto-generate user's name: If you import a file and the name field is empty, AcyMailing can automatically generate a name for each user (based on its e-mail address).
• File Charset: We recommend you to import an utf-8 file but if you import an other format, you can let AcyMailing handle the conversion in which case you should specify the encoding format of your imported file.

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,adrien@acyba.com,3
John,john@acyba.com,8-4

So Adrien will be subscribed to list ID 3 and John will be subscribed to lists ID 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!

Text Area

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

• Import the user as confirmed: If you require a confirmation in AcyMailing, then this option will be displayed if you try to import a file so 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.
• Auto-generate user's name: If you import a file and the name field is empty, AcyMailing can automatically generate a name for each user (based on its e-mail address).

Joomla Users

Using this option, AcyMailing will not only add your Joomla Users in the list of AcyMailing users, it will also synchronize its data based on the Joomla Users data.

This operation is already done during the install so you should not have to do it again. If you want your users to be automatically added in AcyMailing and subscribed to one or several lists during their Joomla registration process, please configure the Joomla User Synchronization plugin.

com_contact

You can import your contacts from the default Joomla contact component in AcyMailing.

The name and e-mail of the contact specified in the com_contact component will be added in AcyMailing as a new user.

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
• email : This fields is a required field for the import process, you should specify the name of the column which contains e-mail addresses in your other table.
• name : If the other table contains the name of the user, you can import it as well. This field is not mandatory.
• .... you will be able to specify an equivalent for all your other fields but they are not mandatory.

Import from HikaShop

HikaShop uses the standard Joomla User table so you can use our default user plugin to display the lists on the HikaShop registration page and the user will be automatically subscribed to AcyMailing.

Nevertheless, if you use HikaShop without using the Joomla registration process, then the user won't have 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 users from HikaShop 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)

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

If Prestashop is not installed on the same database but your Joomla website is able to access this database, you can specify the table name: prestashopdatabase.ps_customer

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

Acajoom

Acajoom, like AcyMailing, handles multiple Mailing List management. So, in order to not loose the subscription state of your Acajoom Users, we created a process enabling you to import your Acajoom lists in AcyMailing and keep the subscription state of each user. This way, you can safely move from Acajoom to AcyMailing without loosing data.

If you select the option "Import the Acajoom Lists too", AcyMailing will re-create your Acajoom Mailing Lists in AcyMailing.

Outlook

You can export your contacts from Outlook and import them in AcyMailing as a CSV file.

• Select File -> Import and Export... from the menu.

• Select Export to a file and click Next.

• Select Comma Separated Values (Windows) and click Next.

• Select the Contacts folder and click Next

• Use the Browse... button to specify a location and file name for the exported contacts ("Outlook.csv" on our example) and click Next.

• Click on the Map Custom Fields ... button to export only the email and name field.
  You can export more fields if you added extra fields using AcyMailing Enterprise.

• Click on the button Clear Map and then drag and drop only the necessary information: name and e-mail of the user.
  Be careful, the field e-mail must be the sub-category of the group e-mail, not the whole group of fields.



• Click Ok and then Finish to export your contacts.
• Open the exported file with a text editor (notepad) and make sure you exported the right information and the first line of your file is "name","email" (if not, modify it and save your file).
• Import the file in AcyMailing.