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:

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: