1 of 5

Import data

Import CRM users

Import users

You can send us your users data in 2 ways :

API
Files importer (Get in touch with your Account Manager)

Users file importer

File structure

One line per user
Header on the file is needed for the matching
Encoding: utf8
The variable can not be calculated. It must be one line, one variable
PGP or GPG key encryption are not supported. Files must be unencrypted before import.

Variables :

it must be the same name of data variable (Variables are in uppercase, they will transcribe automatically in lowercase)
You can add new variables. Don't forget to define them in DataCommander variable interface
The CRM variables should be prefixed with "person." and custom variables by "person.custom."

File example

Import conversions

You can send us your conversions data in 2 ways :

Files importer
API

Conversions files importer

CSV import through FTP

If you wish to share your data via flat file feed integration, please use a CSV feed format, following the structure below.

The CSV format is based on the comma-separated value. The header must be declared in the first row of the file, it is recommended that headers are provided in the lower case and don't contain spaces.

Files can be uploaded to the Commandersact FTP or downloaded from your own FTP by CommandersAct. Get in touch with your Account Manager to agree the integration method that is best for you.

Use our CSV conversion importer connector to configure the FTP import.

Structure of the file:

1 file with 1 line per product (conversion item)

Each line in the file should be a distinct product (conversion item) with their unit price and quantity. Transactions that include several products should be split into multiple lines, sharing the same conversion_id.

Example: conversion_ID_1, conversion_item_1, conversion_ID_1, conversion_item_2, conversion_ID_1, conversion_item_3,

Be sure you are using exactly the same headers as in this example CSV file:

Some columns are required, please check https://community.commandersact.com/datacommander/api/conversions-and-product-catalog-v2.0#tocs_conversion to see which fields are required or not.

Please sort your file and group it by conversion ID (all conversion items related to conversion_ID_1 then all conversion items related to conversion_ID_2 etc...)