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:
