Import Contacts
Contact importing is possible through the User Interface in Mautic. For larger imports it’s recommended to complete the import in the background via a cron job.
Since Mautic 2.9, Mautic shows in a Contact’s event history when an import job creates or updates a Contact.
Import file requirements
The CSV file must use UTF8 encoding. Other encodings may cause failures while importing. Read the documentation of your spreadsheet program on how to export a spreadsheet to UTF8. Google Sheets encodes to UTF8 automatically, Libre/Open Office lets you choose before export.
For boolean values like
doNotEmail
or custom boolean field, use valuestrue
,1
,on
oryes
as TRUE values. Mautic considers anything elsefalse
.To import multiple Tags for a Contact separate them with
|
liketag-a|tag-b|tag-c
For date/time values, use ISO8601 notation
i.e. YYYY-MM-DD hh:mm:ss
. Other formats may work too, but they could be problematic.Example:
2019-01-02 19:08:42
.Other formats may work too, but they could be problematic.
Tips
Use a header row with the column names matching the Mautic Contact Custom Field names. This way Mautic automatically pre-selects the mapping for you. For example, if you name the first name column as
firstname
, Mautic maps this automatically to{contactfield=firstname}
.When you set up your mapping, you have an option to skip the import on fields where a value already exists on the Contact record. This setting allows you to avoid erasing data which already exists in your Mautic Contacts.
If your CSV contains more than a few thousand Contacts, divide the file into several smaller CSV files to avoid memory issues and slow import speeds.
Dica
If using a Linux system, see the GNU
parallel command sudo apt install parallel
.
cat big_contact_list.csv | parallel --header : --pipe -N 1000 'cat > split_list_part{#}.csv'
This generates files: split_list_part1.csv ...split_list_part9.csv, split_list_part10.csv
.
Types of import
Browser import
You must import larger CSV files in batches to avoid hitting server (PHP) memory and execution time limits. When importing in the browser, your browser is controlling the batches. When one finishes, the JavaScript starts a new one. This means the browser window has to stay opened and connected to the internet the whole time.
Use the browser import method only if you don’t have any other choice. You should default to using the background import.
Background import
Background import jobs - triggered manually or via a cron job - have the advantage of benevolent time limits. A CSV background import isn’t restarted every batch - 1 batch = 100 rows by default - Mautic saves the last row imported, and the next batch continues from that point. Background imports are always faster and more reliable than browser imports.
Aviso
Background import requires the command php /path/to/mautic/bin/console mautic:import
to run periodically. Add it to your cron jobs.
Successful results of the background job look like this:
$ bin/console mautic:import
48/48 [============================] 100%
48 lines were processed, 0 items created, 48 items updated, 0 items ignored in 4.78 s
If there is no import waiting in the queue, there won’t be any messages. You can also use --quiet
to prevent messages showing.
Automatic import type configuration
There is an option in the Global Mautic Configuration > Contact settings to define the optimal limit of browser import vs background import.
If you enter 500, that means that if there’s less than 500
rows, the browser imports it. If there’s more than 500 rows, Mautic queues it for processing when the background import cron job next runs.
The default value is zero, which means it shows two import buttons instead of one, and you have to decide what import option to use during every import.
Parallel imports
The import can take several minutes. One import might be running when you start another. There is the parallel_import_limit
configurable option to prevent running out of server resources. By default, only 1 import runs at a time. You can change this option by adding it to your app/config/local.php
file.
Import job list
You can access the list of imports by going to the Contacts area, clicking the Action menu at the top right of the Contacts table, and then selecting the Import History option.
Dica
The direct URL is https://example.com/s/contacts/import/1
The table shows you:
basic statistics about all imports
their current status
original CSV file names
who created the import
Created date
when the background job last updated the statistics
There is also a toggle switch which enables you to stop and start queued or In Progress imports.
Import job status
There are several potential statuses for import jobs:
Queued - Mautic has queued the import for background processing. It’s waiting for the background job to start the import.
In Progress - The background job started the import and hasn’t finished yet. You can see the progress in the list of imports.
Imported - The import has been successfully processed.
Failed - The import failed for some reason. The most common cause may be that the uploaded CSV file no longer exists, Mautic doesn’t have permission to read it, or the import was unresponsive for more than 2 hours.
Stopped - The User stopped the import when it was in the Queued or In Progress states.
Manual - The User selected to import in the browser
manually
. It’s similar to In Progress.Delayed - The background job wanted to start the import, but the import process couldn’t. So it’s delayed for later. The reason when this could happen is when it hits the parallel import limit. The import starts as soon as it’s able to do so.
Import job detail
Clicking on a filename opens the import job detail page.
The main content area displays information about ignored rows - if any. The table tells you what row in the CSV file it was and what was the reason, so you can fix those rows and start the import again.
There are two charts:
The pie chart shows the ratio between created, updated and failed rows.
The line chart shows the Contacts added per minute.
More detailed statistics and the import job configuration are available if you click Details. This includes import speed, field mappings, and job timestamps.
Starting and stopping imports
How to start an import
Go to Contacts.
In the top right corner of the Contacts page, open the sub menu of actions and select the Import option.
Dica
The direct URL is https://example.com/s/contacts/import/new
Select the CSV file with Contacts you want to import.
Adjust the CSV settings if your file uses a non-standard delimiter or encoding and so on.
Upload your CSV file.
The field mapping page should show up. The first set of options lets you select owner, Segment and tags to assign globally to all imported Contacts. The second set of options lets you map the columns from your CSV file to Mautic Contact Custom Fields. The third set of options lets you map columns from your CSV file to special Contact attributes like Date Created and so on.
When your field mapping is ready, click one of the Import buttons described previously.
How to stop a background import
Go to Contacts.
In the top right corner of the Contacts page, open the sub menu of actions and select the Import History option.
Deactivate the import job you want to stop. The import changes status to Stopped. It finishes importing the current batch and then stops.
To start the import again, activate it, and the background job continues with the next cron job execution.
When the background job finishes, either successfully or if it fails, you’ll get a notification in Mautic’s notification area about it.
FAQ
The import times out, what should you do?
Either use the background job to import, or change the batch limit to smaller number than 100.
What happens with imported Do Not Contact values? Are they stored as a bounce or a
unsubscription
?
It’s stored as a
Manual Unsubscription
. It’s the same as marking the Contact Do Not Contact from the Contact’s page.