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.

Field descriptions for organizations

Number

Name

Description

1

(green star) Organization full name


2

(warning) Organization short name


3

(warning) Legal form

Legal form code in Hydra: Master Data → Reference Data → Business entity types.

For example: LLC, Inc., Corp.

4

(green star) Tax ID

Taxpayer identification number.

(lightbulb) The field is optional, but recommended: together with the short name (field #2) it is used to verify uniqueness during import.

5

(green star) Tax registration reason code

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

(green star) Registered office address

In the current version, organization addresses are not parsed and are stored as-is as Non-standard address entries of the respective purpose.

7

(green star) Actual address

8

(green star) Postal address

9

(green star) Bank account number

Digits only — no # sign, spaces, or hyphens.

(warning) To link the account, bank details must be specified (fields #10 and, preferably, #11).

(lightbulb) In Hydra, this is stored as a Current account linked to the bank.

10

(green star) Bank

Name and SWIFT/BIC code of the bank where the bank account (field #9) is held.

(lightbulb) If a bank with the specified SWIFT code, full name, or short name is not yet registered in Hydra, it will be created during import.

11

(green star) Bank SWIFT code

12

(green star) Phone number

Business contact phone number in E.164 format: digits only, with no spaces, hyphens, plus sign, or parentheses.

For example: 15551234567.

13

(green star) Email address

Primary contact email address.

14

(green star) General Manager last name

If at least the last name is specified, an employee with the General Manager position will be added to the organization.

15

(green star) General Manager first name

16

(green star) General Manager middle name

17

(green star) Customer code

Unique short name that identifies the customer. It is the default login for the Customer Self-Care Portal and network services.

(lightbulb) If the code is not specified, the organization short name (field #2) will be used as the customer code.

18

(warning) Customer group

Customer group code in Hydra: Master Data → Groups → Subject group type: Customer.

19

(green star) Customer account number

Unique billing account number for the customer.

(lightbulb) If not specified, a number will be assigned by Hydra according to the auto-numbering rules for the specified customer group (field #18).


20

(green star) First service contract number

Unique service contract numbers and signature dates in DD.MM.YYYY format.

(lightbulb) If a contract number is not specified, the contract is not created. If the signature date is not specified, the current date is used.

Contracts are created in the In force status with an open validity period starting on the signature date.

(lightbulb) If the customer group (field #18) has exactly one active basic contract in Hydra at the time of import, service contracts will be linked to it.

21

(green star) First service contract date

22

(green star) Second service contract number

23

(green star) Second service contract date

24

(green star) Third service contract number

25

(green star) Third service contract date

26

(green star) Fourth service contract number

27

(green star) Fourth service contract date

28

(green star) Organization remark

Brief note on the customer's basic subject.

29

(green star) Customer remark

Brief note on the customer itself.

...

Field descriptions for individuals

Номер

Number

НаименованиеName

Описание

Description

1

(warning) Last name


2

(warning) First name


3

(green star) Middle name


4

(green star) Legal form

Legal form code in Hydra: Master Data → Reference Data → Business entity types → Subject type: Individual.

For example: Sole Proprietor, Notary.

5

(green star) Tax ID

Taxpayer identification number.

(lightbulb) The field is optional, but is usually specified at least for entrepreneurs and notaries (field #4).

6

(green star) Citizenship

Country region code of the Country type in Hydra: Master Data → Regions.

7

(green star) Date of birth

Date of birth in DD.MM.YYYY format.

8

(green star) Place of birth


9

(green star) Document type

Identity document type in Hydra: Master Data → Reference Data → ID types.

For example: Driving licence, Passport.

10

(green star) Document serial number

The value must match the template configured in Hydra for this ID type, if any.
11

(green star) Document number

The value must match the template configured in Hydra for this ID type, if any.
12

(green star) Document issue date

Identity document issue date in DD.MM.YYYY format.
13

(green star) Document issuing authority

Issuing authority.
14

(green star) Permanent residency address

Regular address of the respective purpose in the following format: <locality name>,<locality type>,<street name>,<street type>,<building>,<entrance>,<floor>,<apartment>.

  1. Locality name. Region's code in Hydra registry of regions. For example: "San Francisco".
  2. Full or short name of the type of locality. For example: "City", "Town", "Set." or "Settlement".
    (warning) All variants must be configured in Hydra: Master Data → Reference Data → Region types.
    (green star) If not specified, the City type is used by default.
  3. Street name. Region's code in Hydra registry of regions. For example: "Line Wall".
  4. Full or short name of the type of street. For example: "Street" or "St.", "Road" or "Rd.", "Square" or "Sq.".
    (warning) All variants must be configured in Hydra: Master Data → Reference Data → Region types.
    (green star) If not specified, the Street type is used by default.
  5. Building can be represented in two ways:
    • Extended — Bldg. <house> Corpus <pavilion> Annex <structure> Ownership <property>
      (info) Specify only the necessary details of the building, keeping respective abbreviated designations. For example: "Bldg. 25 Annex A".
    • Basic — only the house number (if it starts with a digit) or only the pavilion (if it starts with a letter).
  6. Entrance number.
  7. Floor number, numeric value.
  8. The number of the office, apartment or other premises.

(lightbulb) If some details are missing, leave only commas. If the address is not needed at all, leave the field blank.

15

(green star) Actual address

16

(green star) Phone number

Mobile contact phone number in E.164 format: digits only, with no spaces, hyphens, plus sign, or parentheses.

For example: 15554567890.

17

(green star) Email address

Primary contact email address.
18

(green star) Customer code

Unique short name that identifies the customer. It is the default login for the Customer Self-Care Portal and network services.

(lightbulb) If the code is not specified, it will be generated from the person's name (fields #1–3) according to the Format of individual's code configured for the division.

19

(warning) Customer group

Customer group code in Hydra: Master Data → Groups → Subject group type: Customer.

20

(green star) Customer account number

Unique billing account number for the customer.

(lightbulb) If not specified, a number will be assigned by Hydra according to the auto-numbering rules for the specified customer group (field #18#19).


21

(green star) First service contract number

Unique service contract numbers and signature dates in DD.MM.YYYY format.

(lightbulb) If a contract number is not specified, the contract is not created. If the signature date is not specified, the current date is used.

Contracts are created in the In force status with an open validity period starting on the signature date.

(lightbulb) If the customer group (field #18#19) has exactly one active basic contract in Hydra at the time of import, service contracts will be linked to it.

22

(green star) First service contract date


23

(green star) Second service contract number


24

(green star) Second service contract date


25

(green star) Third service contract number


26

(green star) Third service contract date


27

(green star) Fourth service contract number


28

(green star) Fourth service contract date


29

(green star) Organization Person remark

Brief note on the customer's basic subject.

30

(green star) Customer remark

Brief note on the customer itself.

...

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;;;;;;;;;;;