This page explains how to change some properties (capacity,...) of rooms from an Excel file.

Export rooms properties in a file

Go to Space Planning & Management / Space Inventory & Performance / Room Inventory

Open page EXPORT / View rooms (last item in the left menu).

Click on transfer TXFR button (top right) :

Select Transfer Out and click on button Continue:

Select XLS and click on button Begin Transfer:

At the end of the transfer you can

This file is like this:

Keep a copy of this file for backup.

Import a file to change data

It's important to keep the too first lines and 3 first columns.. With this data Archibus is able to determine which table to update and which rooms to update.

You can delete some other columns. Data will be kept.

Keep only rooms you want to update.

Example of file to be imported:

When the file is ready you can import it in Archibus.

Go to page View Rooms.

Click on TXFR button:

Select Transfer In and click on Continue button:

Select the Excel file in Local File field and click on Begin Transfer:

Check if there is some errors:

Page tree

EN - ARCHIBUS: mass update of rooms

Export rooms properties in a file

Import a file to change data