...
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 Fields that can be left blank for simplicity are marked with a |
Field descriptions for organizations
Number | Name | Description |
|---|---|---|
| 1 |
| |
| 2 |
| |
| 3 |
| Legal form code in Hydra: Master Data → Reference Data → Business entity types. For example: LLC, Inc., Corp. |
| 4 |
| Taxpayer identification number.
|
| 5 |
| Supplementary tax registration code used in some jurisdictions in addition to the Tax ID (field #4) — for example, to identify a branch office or a separate registration of the same legal entity. Leave blank if not used in your country. |
| 6 |
| In the current version, organization addresses are not parsed and are stored as-is as Non-standard address entries of the respective purpose. |
| 7 |
| |
| 8 |
| |
| 9 |
| Digits only — no # sign, spaces, or hyphens.
|
| 10 |
| Name and SWIFT/BIC code of the bank where the bank account (field #9) is held.
|
| 11 |
| |
| 12 |
| Business contact phone number in E.164 format: digits only, with no spaces, hyphens, plus sign, or parentheses. For example: 15551234567. |
| 13 |
| Primary contact email address. |
| 14 |
| If at least the last name is specified, an employee with the General Manager position will be added to the organization. |
| 15 |
| |
| 16 |
| |
| 17 |
| Unique short name that identifies the customer. It is the default login for the Customer Self-Care Portal and network services.
|
| 18 |
| Customer group code in Hydra: Master Data → Groups → Subject group type: Customer. |
| 19 |
| Unique billing account number for the customer.
|
| 20 |
| Unique service contract numbers and signature dates in DD.MM.YYYY format.
Contracts are created in the In force status with an open validity period starting on the signature date.
|
| 21 |
| |
| 22 |
| |
| 23 |
| |
| 24 |
| |
| 25 |
| |
| 26 |
| |
| 27 |
| |
| 28 |
| Brief note on the customer's basic subject. |
| 29 |
| Brief note on the customer itself. |
...
Field descriptions for individuals
Number | НаименованиеName | Описание Description |
|---|---|---|
| 1 |
| |
| 2 |
| |
| 3 |
| |
| 4 |
| Legal form code in Hydra: Master Data → Reference Data → Business entity types → Subject type: Individual. For example: Sole Proprietor, Notary. |
| 5 |
| Taxpayer identification number.
|
| 6 |
| Country region code of the Country type in Hydra: Master Data → Regions. |
| 7 |
| Date of birth in DD.MM.YYYY format. |
| 8 |
| |
| 9 |
| Identity document type in Hydra: Master Data → Reference Data → ID types. For example: Driving licence, Passport. |
| 10 |
| The value must match the template configured in Hydra for this ID type, if any. |
| 11 |
| The value must match the template configured in Hydra for this ID type, if any. |
| 12 |
| Identity document issue date in DD.MM.YYYY format. |
| 13 |
| Issuing authority. |
| 14 |
| Regular address of the respective purpose in the following format:
|
| 15 |
| |
| 16 |
| Mobile contact phone number in E.164 format: digits only, with no spaces, hyphens, plus sign, or parentheses. For example: 15554567890. |
| 17 |
| Primary contact email address. |
| 18 |
| Unique short name that identifies the customer. It is the default login for the Customer Self-Care Portal and network services.
|
| 19 |
| Customer group code in Hydra: Master Data → Groups → Subject group type: Customer. |
| 20 |
| Unique billing account number for the customer.
|
| 21 |
| Unique service contract numbers and signature dates in DD.MM.YYYY format.
Contracts are created in the In force status with an open validity period starting on the signature date.
|
| 22 |
| |
| 23 |
| |
| 24 |
| |
| 25 |
| |
| 26 |
| |
| 27 |
| |
| 28 |
| |
| 29 |
| Brief note on the customer's basic subject. |
| 30 |
| Brief note on the customer itself. |
...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
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;;;;;;;;;;; |