Import parameters and format

First row: account name, customer name and Avistaplace

Andra raden: name of hierarchy levels and room data

Other rows: import data

Import can be made from an Excel-file containing with data.on first tab (Import can also be made from a CSV-file, if the file’s character set is utf8 and the data is separated with semicolon.)

There are six different import needs and functions:

Create new room directory

The Avistaplace in the import file head is the same as the Avistaplace in the top hierarchy level in the new room directory. The Avistaplace is created manually.

Data for the new directory needs to be included in the import file.

The hierarchy in the import file is later used as foundation when adding or editing information.

Update complete room directory

The Avistaplace in the import file head is the same as the Avistaplace in the top hierarchy level in the existing room directory.

All existing rooms must be included in the import file, whether they have been changed or not.

The complete hierarchy structure needs to be included in the import file.

Update is to be used as method.

Update part of room directory

The Avistaplace in the import file head is the same as the Avistaplace in the top hierarchy level in the part of the existing room directory that is to be updated.

All existing rooms in the part of the room directory to be updated must be included in the import file, whether they have been changed or not.

The complete hierarchy structure for that part needs to be included in the import file.

Update is to be used as method.

Add part to room directory

The Avistaplace in the import file head is the same as the Avistaplace in the top hierarchy level in the part to be added to the existing room directory. The Avistaplace is created manually.

Data for the new part needs to be included in the import file.

The complete hierarchy structure for that part needs to be included in the import file.

Update is to be used as method.

Replace complete room directory

The Avistaplace in the import file head is the same as the Avistaplace in the top hierarchy level in the existing room directory.

Data for the new directory needs to be included in the import file.

The complete hierarchy structure needs to be included in the import file.

Replace is to be used as method.

Replace part of room directory

The Avistaplace in the import file head is the same as the Avistaplace in the top hierarchy level in the part of the existing room directory that is to be replaced.

Data for the new part needs to be included in the import file.

The complete hierarchy structure for that part needs to be included in the import file.

Replace is to be used as method.