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:
- Choose File>Save As.
- 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 :
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:
- In Site Settings, navigate to jExperience>Integrations>Profiles import.
- Click New import configuration, give a name and a description to your export.
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.
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.
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.
- 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.
- 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.
Map the columns numbers of the CSV file to the profile properties.