Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • The file content format is CSV.

  • UTF-8 encoding is used for text.

  • No text separator (quotation marks around values) is used.

  • Fields (columns) are separated by semicolons — ;
    Field separators are not allowed in values. If a semicolon is required in values, another printable character can be used as a field separator.

  • A header row with field names is recommended to simplify file verification by external tools, but is not required.


Note

The header row with field names is not used during import (it can be omitted) — the order of the fields is crucial.


Info

Mandatory fields are marked with a (warning) icon.

Fields that can be left blank for simplicity are marked with a (green star) icon.

...

Code Block
languagetext
titleSample file for individuals
linenumberstrue
LastName;FirstName;MiddleName;LegalFormCode;TaxId;Citizenship;BirthDate;BirthPlace;AuthDocType;AuthDocSerial;AuthDocNumber;AuthDocDate;AuthDocIssuingAuthority;PermanentResidencyAddress;ActualAddress;PhoneNumber;Email;CustomerCode;CustomerGroup;CustomerAccount;ContractNumber1;ContractDate1;ContractNumber2;ContractDate2;ContractNumber3;ContractDate3;ContractNumber4;ContractDate4;PersonRemark;CustomerRemark
McFly;Marty;Seamus;;123456789;USA;12.04.1961;Hill Valley;Driving licence;D;9876543;23.08.1988;California DMV, Los Angeles Office;San Francisco,City,Market,Rd.,8,,2,5,;London,City,Baker,Street,221B,2,,;15554567890;;fulcrum;Individual customers;12345;12345/1;29.07.1951;12345/2;01.12.1960;12345/3;24.04.1967;12345/4;30.06.1971;Great Scott!;Just because you are a character doesn't mean you have character.
Brown;Emmett;Lathrop;;;;;;;;;;;;;;;Doc;Employees;;;;;;;;;;;