Difference between revisions of "V2/CMS Tutorial/User Tools/Creating Content/Import/CSV"
| Line 16: | Line 16: | ||
===== Required Columns ===== | ===== Required Columns ===== | ||
| − | The following headers must be in every imported CSV file. They are | + | The following headers must be in every imported CSV file. They are required to create an Asset. |
* Name | * Name | ||
* Is Virtual | * Is Virtual | ||
Revision as of 15:48, 14 September 2021
Contents
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 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 [ ]