Import buildings
This guide provides step-by-step instructions for importing buildings into the system.
You can import buildings to multiple organization units in the same import file.
Fill template
- First, download the Microsoft Excel import buildings template
- Fill in the building properties in the template:
- Organization Unit ID or Customer ID: Required, must match an existing organization unit.
- Go to the left menu and click on "Organization".
- Select the desired organization unit.
- In the General tab, locate the "Info" section.
- The ID and Customer ID will be displayed there.
- Address: Required, the building's address.
- Postal Code: Required, the building's postal code.
- Post Office: Required, the building's post office.
- Building Name (optional): A logical name for the building.
- Building Customer ID: Required, an identifier to help import keys to the building from a third-party system
- Save the file in CSV format, using a comma (,) or semicolon (;) as the separator.
Do not alter the column headers in the template; otherwise, validation will not succeed.
To find the Organization Unit ID or Customer ID:
Import operation
- Log in to the system and navigate to the Buildings page.
- From the Actions drop-down menu, select Import.
- Upload the CSV file.
- Press validate
- Confirm the import details and click Import.
- Once the import is complete, a confirmation screen with the results will appear.
Validation Guidelines
- Column headers must match the template.
- Each CSV file must contain a maximum of 200 buildings.
- Required fields: Organization unit ID or Customer ID, Address, Postal code, Post office, Building Customer ID
- Building Customer ID must be unique within the Organization. Otherwise, the building will be skipped.
- All rows must contain data, including those at the beginning and end, to pass validation. No empty rows are allowed.
On this page