Importing profiles

November 11, 2022
Note: Marketing Factory is renamed to jExperience in version 1.11 and Apache Unomi is renamed to jCustomer. The 1.10 documentation has been updated to reflect the product name change.

The easiest way to import or export jExperience profiles is by using CSV (comma-separated value) files. 

CSV files may be generated by different tools, but the most common one is Microsoft Excel. However Microsoft Excel generates many different types of CSV files. In the latest versions, you should use the following procedure to generate a CSV file:

  1. Choose File>Save As.
  2. Select File Format : CSV UTF-8

Depending on the platform of Microsoft Excel (Macintosh, Windows) and its version, it may generate different types of CSV files. The easiest way to determine the type of a CSV file is to use the following command on MacOS or Linux : 

file myfile.csv

This should generate an output such as the following:

myfile.csv: UTF-8 Unicode (with BOM) text, with CR line terminators

You can use this information to select the proper settings in the profile import settings.

If you're not on MacOS or Linux, you could use an online service such as CheckFileType to determine the type of the CSV file.

Profiles exports and imports ease this process with built-in features to configure and save one-time and recurrent exports and imports. 

This section will describe one-time imports and exports. To know more about recurrent (to ftp / network disk) exports and imports, please refer to jExperience integration guide.

Creating and editing a profile import

To create and edit a profile import:

  1. In Site Settings, navigate to jExperience>Integrations>Profiles import.
    profiles-import-home.png
  2. Click New import configuration, give a name and a description to your export.
    profiles-import-new.png

Import type

profiles-imports-type-oneshot.png

Upload your CSV file here or select  the "recurrent" option if you want to configure an export to an ftp or network disk on a regular basis (i.e. export all profiles once a day to another server). Configuration of the filepath should be made by the technical team. More information can be found in the integration guide.

profiles-imports-type-recurrent.png

Executions

profiles-imports-executions.png

Last 5 executions of the import are displayed, with the date of execution, the number of failures (1 per line) and the total number of profiles that were exported. For a failed import, it is possible to click on the import and see the details of the errors. 

Configuration

profiles-imports-configuration-1.png

Merging property : the property that will be used to check if a new profile should be created or if there is an existing one. If there is an existing profile, data overwrite options will apply.

Data overwrite  

  • Overwrite existing profiles
    If this option is unchecked, profiles being improted through csv will be  skipped if there is an existing profile.
  • Overwrite all properties
    This option is only available if "overwrite existing profiles" is selected. It means that every profile properties will be overwritten.
  • Properties to overwrite
    This option is only available if "overwrite existing profiles" is selected. Select each property that you want to overwrite in the existing profile.

Options 

  • File has a header
    Select this option if your file has a header line so that the import will skip it.
  • File has a "To delete" column
    If this option is selected, the last column of the file will be used to delete profile . For each line, if the content is "TRUE",  the profile will be deleted. 
  • Line separator
    The line separator of your file.
  • Column separatorThe column separator of your file.

Mapping

Map the columns numbers of the CSV file to the profile properties.

profiles-imports-mapping.png