AcyMailing
Our siteForumBlog
Latest version
Latest version
  • AcyMailing documentation
  • How to renew AcyMailing license?
  • How to switch AcyMailing license plan?
  • Setup AcyMailing
    • Update from AcyMailing 5
    • Installation
      • Download AcyMailing
      • Install AcyMailing
      • Update AcyMailing
      • Switching from Starter to a paid version
      • Uninstall AcyMailing
    • Move AcyMailing between websites
      • Migrate between Joomla! and WordPress
      • Move between two WordPress websites
      • Switch from Joomla 3 to Joomla 4/5
    • Configuration
      • License
      • Mail settings
        • Set up your DKIM : DomainKeys Identified Mail
        • Set up Oauth 2.0
      • Queue process
      • Configure your send process
      • Subscription
      • Bounce handling
      • Data collection
      • Security
      • Languages
    • Step by step guide
    • Multilingual websites
      • Translate AcyMailing
      • Custom translation
    • Subscription to your lists
      • Subscription form - Joomla
      • Subscription form - WordPress
      • Other subscription methods
      • RSForm!Pro integration
  • External sending methods
    • AcyMailing Sending Service
    • Amazon SES
    • ElasticEmail
    • Mailgun
    • Postmark
    • SendGrid
    • Brevo SMTP Relay
    • Brevo / Sendinblue (Legacy)
  • Main pages
    • Dashboard
    • Subscription forms
      • Subscription Form
      • Header
      • Footer
      • Popup
      • Shortcode (Wordpress)
    • Subscribers
      • Create a subscriber
      • Import subscribers
      • Export subscribers
    • Custom fields
      • Create Custom Field
      • Examples
    • Lists
      • Create a list
    • Segment
      • Edition
    • Emails
      • Creation of a campaign
        • Choose a template
        • Edit email
        • Recipients
        • Segment
        • Send settings
        • Tests
        • Summary
      • A/B testing
      • Automatic campaigns
      • Follow-up
        • Trigger
        • Condition
        • Emails
        • Summary
      • Special mails
    • The email editor
      • Tenor integration
      • Unsplash integration
    • Templates
      • Create a template
      • Import a template
    • Email overrides
      • Edition
    • Automations
      • Information
      • Conditions
      • Actions
      • Action targets
      • Summary
    • Scenario
      • Create a new Scenario
      • Performances
    • Queue
    • Statistics
      • Overview
      • Detailed Statistics
      • Click map
      • Links details
      • User click details
      • Statistics per list
    • Add-ons
    • Mailbox actions
      • Mailbox actions
        • Edition
      • Bounce rules
        • Configuration
        • Listing
        • Create bounce rules
  • Advanced
    • Send follow-up messages based on subscription
    • Let site users use AcyMailing
      • List management
      • User management
      • Campaigns management
    • Show an archive of the sent newsletters
    • Show a profile edition form on your site
    • Partner platform
      • Log in
      • Dashboard
      • Single domain details
  • Integrations
    • Settings
    • Joomla add-ons
      • Joomla articles
      • CB Subscriptions
      • Community Builder
      • Community Quiz
      • Community Surveys
      • Contacts
      • Dashboard Quick icon
      • Docman
      • DPCalendar
      • EasyBlog
      • EasyProfile
      • EasySocial
      • Event Booking
      • FLEXIcontent
      • HikaShop
      • iCagenda
      • JCal Pro
      • jDownloads
      • JEvents
      • JSW CRM
      • JTicketing
      • K2 Content
      • Membership Pro
      • Module
      • PayPlans
      • Phoca Download
      • RSEvents!Pro
      • Seblod
      • Shika
      • VirtueMart
      • Zoo
    • WordPress add-ons
      • WordPress posts and pages
      • Advanced Custom Fields (ACF)
      • Business Directory
      • Contact Form 7
      • Easy Digital Downloads
      • EventON
      • Events Manager
      • Gravity Forms
      • Learndash
      • MemberPress
      • Modern Events Calendar
      • The events calendar
      • Ultimate Member
      • Uncanny Automator
      • WooCommerce
    • All websites add-ons
      • Articles, posts and pages from WordPress and Joomla
      • Automation - export action
      • Create user
      • Custom headers
      • RSS and Atom feeds
      • Table of contents generator
      • Universal filter
    • Zapier
  • Developers
    • Developer Documentation
    • Making a custom add-on
      • Execute custom script on specific AcyMailing actions
      • Insert a dynamic text in an email for Joomla
      • Insert a custom block in an email for Joomla
      • Insert a dynamic text in an email for WordPress
      • Insert a custom block in an email for WordPress
    • Custom script using our code
    • Create a page override
    • Joomla quickstart package with AcyMailing
    • Customise inserted content
  • FAQ
    • Could not instantiate mail function - AcyMailing
    • Spam issue
    • Your send process is slow?
    • Compatibility issues
    • Mail archive not displaying special characters
Powered by GitBook
On this page
  • Source
  • Lists
  1. Main pages
  2. Subscribers

Import subscribers

This screen enables you to import users from different sources.

PreviousCreate a subscriberNextExport subscribers

Last updated 2 years ago

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.

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 : Synchronize / 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

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.

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.

When importing data for a custom field of "Date" type, such as a birthday field, the data must follow this format to work in AcyMailing: YYYY-MM-DD. For example, 1993-03-20

name,email,birthday
Adrien,adrien@acyba.com,1986-01-03
John,john@acyba.com,2009-09-11

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.

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.

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

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

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

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.

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.

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

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

Once you selected the options and assigned the columns as you want, click on the "Import users" button to import your 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 synchronise its data based on the CMS data.

You can also choose to only import users of a specific user group.

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 lists or you can directly create new list via the button Create new list.

AcyMailing keeps track of the unsubscribe 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.

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 you want the user to be subscribed to during the import.

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

next import page
the ids of the AcyMailing lists