Import Rooms

Owned by Hannah Petty
Last updated: Aug 11, 2015Version comment
2 min read

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 NameDescription
Campus-NameThe 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-NameThe 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-NameThe name to be given to the room. This appears in the ESS interface and is the room selected for device and schedule assignment.
OrganizationSee 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:

screenshot of a sample room import CSV file open in Excel

Â