How to import addresses? [Service wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== How to import addresses? ======

Address data can be added to promio.connect using the address import. After a successful import, this address data is available in promio.connect as a target group. 

<WRAP round important>
Only upload addresses from which you have an “opt-in”. This means that the owners of the addresses have actively and knowingly allowed you to store and use the address and further personal data to contact them! In the event of complaints and in cases of doubt, you must be able to prove where and when you obtained the address.
</WRAP>

Go to //Addresses > Lists// and select //import addresses// after clicking on the button on the bottom right. You may either upload the data directly from your PC, or you can store it at the SFTP server of your client and then upload it from there. 

{{:en:addresses_lists_start_import.png?nolink&200|}}


===== Import directly from PC =====

Click on //Choose file from PC//.

Pay attention to only uploading an error-free .csv file. If you want to personalize your address data, you can assign the data fields of promio.connect to the file’s columns. Your file should look like this or similar. Doublets will be filtered out, which means every address will only be uploaded once. 

{{:en:upload_adresses.png?nolink|}}

==== Import settings ====

{{:en:addresses_import_pc_menue.png?nolink&600|}}

=== Preview address data ===

You can preview the address data to check the selected settings:  \\

{{:en:addresses_import_pc_preview.png?nolink&550|}}

=== Automatic column assignment  ===

When the column names exactly match the data field names, an automated assignment can be activated. \\

=== Configuration ===

{{:en:addresses_import_pc_settings.png?nolink&500|}}

  * Charset: select between Latin or UTF-8
  * Delimiter: select between semicolon, comma, and tab
  * Write mode: „Update existing addresses, create new ones“, „Only new addresses“ or „Update only existing addresses“

==== Checklist ====

The checklist allows you to make sure that delimiters are selected, that at least one column of fields is assigned, and whether the correct write mode is configured. Afterwards, you can either start the import or discard it.

{{:en:addresses_import_pc_checklist.png?nolink&300|}}

===== Choose a file from SFTP =====

==== Preparation ====

Before address data can be imported to promio.connect a .csv or .txt file that has to be placed in the client’s SFTP folder incoming/upload/manual.

In order to import addresses, **you need an SFTP client** from where you can upload the data securely. FileZilla, e.g., is a free and uncomplicated client that allows you to do so. The access data to the SFTP folder for your promio.connect client can be found at //Settings > SSH-Keys//.

The following procedure is similar to when you import from your PC.

The import process itself can take a few minutes. The status of the import job can be tracked at //Settings > Job queue//. When the import is successfully finished, the newly imported addresses are available as a new target group at //Addresses > Lists//. The list can be adjusted or used for a campaign.  \\ \\

<WRAP round important>
Please note that e-mail addresses with **syntax errors will automatically be sorted out** during the import process. 

The process also detects **doublets** within an address file. This means, depending on the data management settings for the client (default: e-mail; alternative: cust ID), only the first one of these doublets will be imported when the same e-mail address (or cust ID) is included more than one time in the .csv file.

Email addresses which are already on the **email blacklist** will also be sorted out automatically.
</WRAP>


{{tag>addresses duplicates imports blacklist opt_ins SFTP target_groups }}
User Tools

Site Tools

Page Tools
