Share this link

    Home / Tradeshift Documentation / Tradeshift Partner Apps / Babelway / Chapter 4. Channels

    Automatic Population of your Partners List

    1724 0 Created on 2021-01-19 09:59:35; Last updated on 2022-07-01 13:01:37

    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. 

    

    0 people found this helpful.

    Related Articles