Questions about imports
- Mapping – the part of the import process where you configure how to import each column from your file. This process tells the Synerise platform about the relationships between the fields in your file with the fields in our database. Thanks to this, you don't need to change the field names in your own database.
- Template - Jinja expressions to combine several columns and/or mix them with strings, math operations, and so on.
Can I add additional columns to my file while mapping?
Yes. If you find out that your source file doesn't have all the necessary data while mapping, you can add a column with a tag, plain text, or currency in case of transactional imports, or even create a new column by using templates to combine columns you already have in your file. You can find more information here
Can I update a customer by importing data?
Yes. If an imported customer already exists in Synerise, their data will be updated - new attributes will be added, existing ones will be changed.
Can I import new and existing customers in one file?
Yes - a customer who already exists in CRM will be updated, and a new customer will be created.
Can I import transactions with multiple currencies in one import?
No. When you import transactions, you have to separate the files for transactions with each currency and prepare a separate import for each file. The currency has to be added while mapping with the “add column” function.
What is the valid date format?
In Synerise, if you want to import an attribute and treat it as a date, it must be in the YYYY-MM-DD format. If you have a different date format in the file, you can transform it while mapping.
Can I add new attributes while mapping?
Yes, if you want to map a column with an attribute that doesn't exist in your Business Profile yet, you can add a new attribute while mapping. You can find more information about CRM imports here
Can I map the same column with two or more attributes?
Yes, the same column can be imported as different attributes - simply map it several times.
How many rows should the sample mapping file have?
The file needed for data mapping should be a representative sample of the data you intend to import. Take up to 50 rows from the final file.
Can I merge two or more columns while mapping?
Yes, if you want to merge separate columns from your file you can use templates - Jinja expressions to combine several columns and/or mix them with strings, math operations and so on. Depending on your expression complexity, to obtain a desired result, you may need some programing skills. If you have trouble with merging columns, contact your Synerise representative.
How long will my import take?
The time needed to import data depends on the size of the file. You can check the status of your import in the progress bar.
What values should the marketing agreement fields in my file have?
To import marketing agreements such as email, sms or push, your fields must have one of the following formats: 0/1, true/false, True/False, TRUE/FALSE. If you use different values, you can use templates to transform them.
Can I switch off an import?
Yes. If you're importing data from an FTP server, go to
Settings → Import - this is the place where you will find all your imports and this is where you can switch an import off or on.
What type of files can I import?
You must use one of the file types supported by the application:
- Comma-separated file (CSV or txt),
- XML (used only for a product feed).
Can I edit an existing mapping?
No. When you save the mapping it cannot be changed, you need to prepare a new mapping.
Can I add two imports with the same name?
No. Each import must have a unique name.
Are there any restrictions to column names in my file?
The column names shouldn't contain spaces or any special characters (only basic letters, digits, hyphens, and underscores) - this is especially important if you want to use templates.
What is the maximum allowed size of an imported file?