http://galore.co.za/blog/feed/rdf/ http://galore.co.za/blog/feed/rss/ http://galore.co.za/blog/feed/ http://galore.co.za/blog/feed/atom/ http://galore.co.za/blog/comments/feed/
Print Shortlink

How to import users from a CSV file in acyMailing component

How to import users from a CSV file (comma-separated values):
Step 1:

The first line of your CSV file should indicate to AcyMailing the name of the fields to import. For example, if your file contains a list of users with the format “email,name,listids”, the first line of your file should be : email,name,listids (always in English). So if you have a file with only e-mail addresses the first line of your file will be : email
remember to always edit your file’s first line so that AcyMailing knows how to import the new users. The following phrases can be used to import to their relevant fields:

  • email- The email adress of the new user in the file
  • name- The name of the new user (AcyMailing can automatically generate a name using the email address)
  • listids- the id number of the list you want the new user to be subscribed to.
  • 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).
  • 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).

Step 2:

After you have edited your CSV file you log into the back end of your site (www.yoursite/administrator.co.za) click on “Components” and then “AcyMailing”

navigate to acymailing
Step 3:

Click on “Users”, its the first item under the toolbar

click on users
Step 4:

In the top right toolbar click on “Import” button

import
Step 5:

In this menu you can select if you would like to Import the users as confirmed etc, and also which list you would like the new users to be imported to. (note: you can do this instead now of doing it in step 1, But the CSV file “MUST” be edited on its first line)
Click on “browse” button

browse

Browse to the location that the edited CSV file is saved and open it. Then click on “Import” button in top right

browse to
Step 6:

A notification will appear informing you of the new users that have been imported from the CSV file.

confirm

Leave a Reply

You must be logged in to post a comment.