Page Comparison

...

(S)FTP-based data synchronization is a way to Data Sync FTP synchronization is a system to put MailUp in communication with customer systems based on file exchange. This exchange takes place using the sFTP protocol (port 22) and the file have to be in csv format.

Once the synchronization has been set up, every time you will upload a file in the common space (on the MailUp FTP space)  the automatic file exchange process will be executed (Data Sync Import). On request, you can use your FTP space and decide how often and at what time the automatic file import process will be executed.

You can decide how often and at what time the automatic file export process will be executed (Data Sync Export).

As this synchronization can go in both directions (i.e. from your system to MailUp and vice versa), it can be set up in one direction only or both, depending on your needs.

What it is used for

Data Sync synchronization allows to automate the following processes:

1. Moving to MailUp the recipient's list is taken from a file provided by the customer and importing it to a MailUp list
2. Extracting from MailUp a list of unsubscribes and saving it in a file stored in a repository shared with the customer
3. Extracting from MailUp statistics down to the user and the message level (opens and clicks) and saving them in a file stored in a repository shared with the customer
4. Extracting the data at (2) and (3) in a single file
5. Extracting statistics on SMS (text messages) delivery and saving them in a file stored in a repository shared with the customer
6. Extracting a list of subscribers in MailUp and saving it in a file stored in a repository shared with the customer

An example:

• every day at 4 am, the customer's system exports a .csv file containing the latest update for the recipients' data, to be moved to MailUp. 
• Once the file has been stored in the common space, MailUp accesses the file via FTP protocol and imports its content to a predefined list. 
• The columns in the CSV file match MailUp's personal data fields, so that they can update the MailUp database. 
• At 5 am a procedure extracts unsubscribers and statistics and saves them in separate files stored in a repository shared with the customer

Please note that this example refers to synchronization in both directions, but as explained above it can be set up in one direction only too.

Enabling FTP-based data synchronization on your account

FTP-based data synchronization is not available by default, but our technicians can set it up for you upon request, contact your account manager to get a quote.

To have a data synchronization set up, you need to have an active MailUp account (not a free trial) and define the details with our Support Team.

Import and export

...

What it is used for

(S)FTP-based data synchronization can be used:

• To import recipients and related demographic data into your MailUp account by uploading a .csv file onto an SFTP server.
  In this case the service is called (S)FTP import datasync and using this service you decide when running the file exchange that leads to importing data in the account's database.
• To export various types of data from MailUp reported in csv reports.
  In this case the service is called (S)FTP export datasync and will deliver all data in one single csv file. This service can be configured to export data from one or more MailUp Lists and referring to either one between email or SMS generated traffic.

Import and export