Export and import apartment data

With the import function, you can download a list of apartments with the following details:

• The number of apartments.

• The number of keys for each apartment.

• The phone number (IMS) for each apartment.

• One or more user logins to which the keys are bound.

• An apartment SIP account.

• A SIP account password.

• Up to six keys associated with each user.

• Limitations to view Live and Archive.

• Limitations to unlock the door.

The following buttons are provided on the page to work with import/export:

	Upload list. Import data from an XLSX file.
	Download template. Download an XLSX file as a template with prefilled column names.
	Download list. Export an XLSX file with up-to-date data for all apartments.

The template includes a set of columns:

• Apartment #. An apartment number.

• Phone number (IMS). An apartment phone number.

• Is the analog line turned on? Possible values: 0 means off, 1 means on.

• Login. A user login. An existing login of a user to specify.

• SIP account. A user's SIP account.

• Password. A SIP account password.

• Is restricted live. Possible values: 0 means that access to Live isn’t restricted, 1 means that access to Live is restricted.

• Is restricted archive. Possible values: 0 means that access to Archive isn’t restricted, 1 means that access to Archive is restricted.

• Is it possible to open the door with a key? Possible values: 0 means no, 1 means yes.

• Is it possible to open the door with a code? Possible values: 0 means no, 1 means yes.

• Is door opening available in the app? Possible values: 0 means no, 1 means yes.

• Is it possible to open the door using facial recognition? Possible values: 0 means no, 1 means yes.

• Key 1 - Key 6. The values of the keys associated with the user. You must specify values from the list of previously added keys. For quick filling on the List of keys tab, there is a function to export the list of keys.

The details of each user are presented on a distinct line.

Once the template is completed, select Upload list and specify the path to the file.

The file download process is displayed on a progress bar.

Wait for the file to load and Send file.

Once changes are detected, a notification will be displayed:

Select Confirm to import data from the template.

During the import process, all previously entered data will be updated with newly submitted.

If the import is successful, a notification will be displayed at the bottom of the page.

If the template is filled out incorrectly, a notification will appear at the bottom of the page. This notification will include a link to the automatically generated file. Cells containing erroneous data in this file will be highlighted in red.