V2/CMS Tutorial/User Tools/Creating Content/Import/CSV

Importing CSV

Senfi allows you to create Assets by importing necessary information from a CSV file. The following section will detail the process to do so, and the specifications of the CSV file.

How to Import CSV

TODO: add step by step screenshots

CSV File Specifications

The supported CSV format is RFC 4180, UTF-8. Saving as CSV from Excel should be compatible for most Excel versions. For the purposes of this guide, we will be using Excel as the CSV editor.

Headers

The first row of the CSV file is the header row. The header row identifies the data contained within each column.

Required Columns

The following headers must be in every imported CSV file. They are information which is required to create an Asset.

• Name
• Is Virtual
• Site ID

Optional Columns

The following headers are optional. They provide more information about the Assets to be imported.

• Description
• Location X
• Location Y
• Location Z
• Building ID
• Block ID
• Level ID
• Is Movable
• Is Lift

Lift related Columns

If there are Lift assets, the following headers must exist to provide lift related information.

• Stop
  • a comma separated list of Level ID, enclosed in square brackets [ ]