Welcome to the File Import Wizard!

The File Import Wizard is one of the ways you can add Profiles into your Audience. With it you can import a file containing Profile data that you have previously gathered with consent. You may add, update, unsubscribe or delete the Profiles contained in the file.

Make sure that you're on a stable and reliable internet connection when you start the File Import Wizard to prevent your file from exceeding the 29s timeout.

Are you ready to make an import? Make sure you're prepared with our Before an Import checklist!

Once you've made a successful import, head over to File Import Reports in the Import History tab to learn more about the outcome.

Add_Update5.jpg

Have you created a Consent list and Topics yet? This is necessary in order to import Profiles, since they must be imported into a Topic in an existing Consent list. Jump to Consent lists and Topics...

Consentlist12.jpg

To reach the File Import Wizard, head over to Audience and make sure you are in the Profiles tab. Once you're there, click on the Add a New Profile button to begin the File Import Wizard.

shortcuts_02.jpg

Before an Import

The File Import Wizard makes it easy for you to upload files from your existing solutions and create Profiles in your APSIS One Audience. Before you perform an import, it is important that you have all the supporting information to make sure that the data in your file will be successfully imported.

Lock1.jpg

Supported Formats

The File Import Wizard supports CSV files up to 10MB and XLS/XLSX files up to 3MB.

We also support Both Chinese and Cyrillic characters.
If your file is CSV, convert it to a UTF-8 format before import, to ensure that the characters are correctly converted.

For CSV files, we support these delimiters: , \t | ;

When saving your Microsoft Excel file, or exporting data from another system, pay close attention that the file is encoded as one of the following supported formats:

UTF-8

Big5

UTF-16BE

EUC-JP

ISO-8859-1

windows-1250

UTF-16LE

EUC-KR

ISO-8859-2

windows-1251

UTF-32BE

KOI8-R

ISO-8859-5

windows-1252

UTF-32LE

IBM420

ISO-8859-6

windows-1253

ISO-2022-JP

IBM424

ISO-8859-7

windows-1254

ISO-2022-CN

GB18030

ISO-8859-8

windows-1255

ISO-2022-KR

Shift_JIS

ISO-8859-9

windows-1256


File Import Checklist

To ensure a successful File Import, we recommend that you review the file before importing. If you'd like to learn more about data formats, we suggest you take a look at our Supported Data Formats article.

Here are some aspects to consider:


Make sure that your file contains only one sheet, or that the data that you need is in the first sheet of your file.


Use only simple text data. Remove any images, charts or decorative formatting (fonts, colours, etc.).


The File Import Wizard does not support formulas. Remove any existing formulas or adjust the data in the cells to contain the result values.


Review the format of the cells and make sure that there are no combined or split cells. It must look like a table, whenever formatted as columns.


Pay attention that the cells containing dates are set to have "text" as type.


For date-type Attributes, we accept all date formats listed here (Including Unix timestamps). However, we have limitations regarding timezones.

When it comes to Date-type Attributes, like the Default Attribute Date of Birth:

A date value like Tue, 07 Mar 1993 04:22:23 +0300 will be converted to 1993-03-07.

Read more about Attributes...


We support importing and storing Unix timestamps for Timestamp-type Attributes.

When it comes to Timestamp-type Attributes, like a Custom Attribute Member since:

Values like Tue, 07 Mar 2017 04:22:23 +0300 will be converted to 1488844800 (07 Mar 2017 0:00:00 +0000).

Timestamps (1599116184) will me imported without milliseconds.

We also support negative values for dates before 1970 (01-01-1970 is 0).

Read more about Attributes...


Make sure the phone numbers contain the country code and phone number in the same column, with no spaces or zeros at the start. The country code is mandatory. Follow the MSISDN format, for example: 46793699558.


After a successful import, the File Import Wizard requires at least (10) minutes before the Profiles can be used or accessed by any APSIS One activities.


Plan your file import in advance if you intend to send an email newsletter. Profiles take time to be created in your Audience and they may not be available right after an import.

Did this answer your question?