Import Rooms
In this section:
Format
Importing rooms into the EchoSystem Server (ESS) requires that you create a CSV or "comma-separated-value" file. The file can have any name you want, as long as it contains a .csv extension. The file format must be as follows:
There is one room record per line of the file
The first line of the file should have the column names, as shown in the table below
Each record value is contained in its own column (if the CSV file is generated by a spreadsheet program, such as Excel) or is separated by a comma in the flat (text) file.
You may want to generate an export of existing rooms (Configuration > Rooms > Export) to provide a formatted CSV file to use as a base.
You can also update room information in the exported file, then reimport the file to apply the changes to the system.
BE ADVISED:
A new campus will be created if there is no pre-existing campus identified by "Campus-Name".
A new building will be created if there is no pre-existing building identified by "Building-Name".
The column headers and field values are as follows; use UTF-8 ascii characters only, and the fields, except Organization, are limited to 50 characters:
Field Name | Description |
Campus-Name | The name of the Campus on which the room resides. If the Campus-Name entered does not already exist, it will be created on import. |
Building-Name | The name of the building in which the room exists. if the Building-Name entered does not already exist, it will be created on import. |
Room-Name | The name to be given to the room. This appears in the ESS interface and is the room selected for device and schedule assignment. |
Organization | See Special Field Descriptions below. |
Special Field Descriptions
Organization names are comprised of two components:
Organization name
Suborganization name (if applicable)
They are separated by a sequence of "<space><forward slash><space>" like this: " / "
A valid organization would look like these examples:
Organization / suborganization
University
University / math-department
University / nursing-school
CSV Example
Following is an example of the format for this file:
