Introduction
Contactly supports .txt or .csv files and requires delimiter specification. Make sure that the first line of the file contains the name of each column.
File type
The file must meet certain conditions in order to be valid:
- Column names must be alphanumeric (A-Z,a-z,0-9) or underscore;
- It must contain at least one line of values in addition to column names;
- The weight of the file, must not exceed 5go;
- file encoding must be in UTF-8 or ANSI;
- Column names must be different from the list of reserved system fields:
- CDE,
- CODE_ENVOI,
- DCALCUL,
- LASTEREACTION,
- DMAJ,
- E,
- ENV,
- I,
- ID_MAILING,
- ID_MAILINGTELMOBILE,
- ID_UE_ENVOI,
- ID_UT_ENVOI,
- ID_TYPECONSENT,
- ID_TYPOLOGY
- ID_VERSION,
- IDCOL,
- IDENVOI,
- IDU_EMAIL,
- IDU_TELMOBILE,
- GRP_TEMOIN,
- M,
- MM_SENDER_DOMAIN,
- ORDRE,
- R,
- SEGMENT,
- SID,
- TELMOBILE,
- UG.
Conclusion
Following the specifications regarding column names and file structure is essential to ensure successful data import into Contactly.