Location Information
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 |
|
Type | limited list of values which symbolize the level within a hierarchical location structure |
References
column name | description |
---|---|
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 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
Related articles
-
Page:
-
Page:
-
Page:
-
Page:
-
Page: