Structure


The file structure is a semicolon separated csv file with “Windows-1252” encoding. The columns are predefined in their names and order. Even if not all attributes are used, they have to be present in the file at the correct position.


Schema


column name

data type

restrictions

column identifier

ID of Location

[ID]

[max. 256 Character]

LocationID

Longname

[Text]

[max. 2GB]

LongName

Reference to a Parent Location by ID

[ID]

[max. 38 Character]

Reference_ParentLocationID

Zip Code

[Zip Code]

[max. 16 Character]

ZIPCode

City

[Text]

[max. 256 Character]

City

Name of Building

[Text]

[max. 64 Character]

Building

Street

[Text]

[max. 2GB]

Street

Room

[Text]

[max. 32 Character]

Room

Remarks about Room

[Text]

[max. 2GB]

RoomRemarks

Telephone

[]

[max. 2GB]

Telephone

Short Telephone Number

[]

[max. 10 Character]

TelephoneShort

Fax

[Text]

[max. 2GB]

Fax

Postal Address

[Text]

[max. 2GB]

PostalAddress

Description

[Text]

[max. 2GB]

Description

Comment

[Text]

[max. 256 Character]

Commentary

Remarks

[Text]

[max. 2GB]

Remarks

Inactive state

[1, 0]


IsInActive

Reference to a Department by ID

[ID]

[max. 38 Character]

Reference_DepartmentID

Reference to a State by national Name 

[ID]

[max. 38 Character]

Reference_NationalStateName

Refrence to a Country by 3 digit Iso3166

[???]

[max. 38 Character]

Reference_CountryIso3166_3

Type


[Country,City,ZipCode,Street, Building,Floor,Room]

Reference_LocationType

Reference to a Manager by Personnel Number

[ID]

[max. 38 Character]

Reference_ManagerPersonnelNumber

Reference to a Deputy by Personnel Number

[ID]

[max. 38 Character]

Reference_ManagerDeputyPersonnelNumber

Reference to a Profitcenter by AccountNumber

[ID]

[max. 38 Character]

Reference_ProfitcenterAccountNumber

Spare date

[DateTime]

[ISO Format]

CustomDatetime1

Spare date

[DateTime]

[ISO Format]

CustomDatetime2

Spare date

[DateTime]

[ISO Format]

CustomDatetime3

Spare field

[Text]

[max. 64 Character]

CustomProperty01

Spare field

[Text]

[max. 64 Character]

CustomProperty02

Spare field

[Text]

[max. 64 Character]

CustomProperty03

Spare field

[Text]

[max. 64 Character]

CustomProperty04

Spare field

[Text]

[max. 64 Character]

CustomProperty05

Spare field

[Text]

[max. 64 Character]

CustomProperty06

Spare field

[Text]

[max. 64 Character]

CustomProperty07

Spare field

[Text]

[max. 64 Character]

CustomProperty08

Spare field

[Text]

[max. 64 Character]

CustomProperty09

Spare field

[Text]

[max. 64 Character]

CustomProperty10

Special properties


column name

speciality

ID of Location

mandatory, unique

Longname

unique within the same parent location

Inactive state

  • 0 means active

  • 1 means inactive

Type

limited list of values which symbolize the level within a hierarchical location structure


References


column namedescription

Reference to a Parent Location by ID

reference to a location within the same file

the parent object does not necessarily have to come before the actual object in the file

Reference to a Department by ID

reference to a department within the file with department information

Department Information

the referenced attribute is the department id

Reference to a State by national Name 

reference to a state

the referenced attribute is the national name, like Sachsen, Nordrhein-Westphalen, Vaude, Steiermark

Refrence to a Country by 3 digit Iso3166

reference to a country

the referenced attribute is the 3 digit Iso3166 country abbreviation (List of ISO 3166 country codes - Wikipedia), like DEU, AUT, CHE

Reference to a Manager by Personnel Number

reference to an identity within the file with identity information

Employee / Identity Information

the referenced attribute is the personnel number

Reference to a Deputy by Personnel Number

reference to an identity within the file with identity information

Employee / Identity Information

the referenced attribute is the personnel number

Reference to a Profitcenter by AccountNumber

reference to a profitcenter / cost center within the file with profitcenter / cost center information

the referenced attribute is the account number


Use Cases


 The flat structure enables a quick and uncomplicated mapping of different locations. For the sake of clarity, however, room and building information should be omitted here. As long as there are not too many different locations in one place, this mapping of reality is suitable.

source-data-example-location-simple-flat-structure.csv



The simple hierarchical structure enables fast and uncomplicated mapping of different locations in different countries. However, for the sake of clarity, room and building information should be omitted here. As long as there are not too many different locations in one place within one country, this mapping of reality is suitable.

source-data-example-location-simple-hierarchical-structure.csv



The complex hierarchical structure allows a detailed mapping of the different locations in different countries. In contrast to the simple variants, it is not necessary to dispense with room and building information. This mapping of reality is particularly suitable for building complexes, campuses and factory sites.

source-data-example-location-extended-hierarchical-structure.csv