Revision as of 14:38, 14 September 2021

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

@@ Line 8: / Line 8: @@
 === 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

Difference between revisions of "V2/CMS Tutorial/User Tools/Creating Content/Import/CSV"