The import partners page allows you to import all your partners from a CSV file.

2020-03-24_15_18_05-Babelway.png

Importing Partners From CSV - General

  SV File  

 The CSV file contains the list of partners you wish to import. 

 The first line must contain the column headers for the values you wish to import. The file must only contain existing columns and may not include system columns such as "Environment", "Creation date", "ID"... Below is a working CSV sample: 

 "PartnerIdentifiers";"Name";"Description" 

 "OTHER:123456";"Julien Inc.";"Supplies" 

 "OTHER:654987";"Bertrand & Co";"Mergers and Acquisitions" 

 "OTHER:123478";"Mathieu Square";"Music Duet" 

 All the other lines in the file represent a partner. If the partner identifier is known, the identified partner will be updated upon import. 

 Values for most columns can be written out in plain text. The following types require a specific format for babelway to interpret them properly: 

  • DateTime: Accepted formats are "dd/MM/yyyy HH:mm:ss" and "yyyyMMddHHmmss" or your preferred user format (see environment preferences). 

  • Date: Dates are expected in the following format: "DD/MM/YYYY" or "YYYY-MM-DD". 

  • Partner Identifiers: These should be presented as a comma separated list of identifiers ("CODE:Value"). For example: "VAT:BE1234567890" or "VAT:BE1234567890,GLN:1234567890123" are valid partner identifiers. 

 

 Delimiter Character 

 The delimiter character separates different values in a given line. 

 Quote Character 

 Text between your "Quote Character"s will be handled as a single value/entry. 

 File Encoding 

 Encoding of your csv file.