To process a CSV file, create a CSV parser. A parser splits the file into lines to create rows and then into tokens to create columns. Finally, the parser converts the newly created array of cells into series, property, and message commands.

Type of data contained in the file: time series, properties, messages.

Write Property

Enable writing data both as series and as properties.

Entity Column

Name of column in CSV file containing the entities. For example: host or node.Multiple columns can be specified in the Entity Column field to concatenate their values into a composite entity name using a dash symbol – as a token.For example:Source CSV file:Year,Source,Destination,Travelers1995,Moscow,Berlin,2000000Entity Columns:Source,DestinationResulting Entity:Moscow-Berlin

Entity Prefix

Prefix added to entity names.

Default Entity

All data written to specific entity.

Replace Entities

Replace entity names in the input file with their aliases from the selected Replacement Table

Process Events

Process incoming data in the Rule Engine in addition to storing it in the database.

Metric Prefix

Prefix added to metric names.

Metric Name Column

Column containing metric names.

Metric Value Column

Column containing metric values.

Message Column

Column containing message text.

Timestamp Columns

Columns containing the Timestamp for each data sample. In some cases, depending on the CSV file, the Timestamp can be split into multiple columns. For example: Date, Time.If there are two columns containing the Timestamp, then they are concatenated with a dash symbol (-) in the Timestamp Pattern field.For example:Source CSV File:Date,Time,Sensor,Power2015.05.15,09:15:00,sensor01,15Timestamp Columns:Date,TimeResult:Date-Time2015.05.15-09:15:00Timestamp Pattern Setting:yyyy.MM.dd-HH:mm:ss

Timestamp Type

Pattern, Seconds (Unix time), Milliseconds (Unix time).

Predefined Pattern

Predefined Timestamp formats.

Timestamp Pattern

Custom timestamp format, specified manually. For example: dd-MMM-yy HH:mm:ssIf there are two columns containing the Timestamp, then in they are divided with a dash (-) in the pattern.