Create a narrow-format CSV data file

To create a narrow-format CSV data file

1. Open a new file using a spreadsheet.

2. On line 1, define the header with these columns in any order:

   • Operation
     (optional) where only one operation is allowed within the same CSV file. These values are supported (case-insensitive):

     • "original" – Stores the value as non-streamed original data.
       Storing data as original values is the most efficient way of storage. Original values never overwrite each other if stored at the same timestamp and cannot be physically deleted, but only made hidden if a latest value is stored at the same time.

     • "latest" – Stores the value as latest data.
       In this case, the system stores a unique 14-byte version of the value using the current system time of the server. Previous latest values are overwritten by more recent latest values (that is, "operation=latest" is equivalent to "overwrite=true"). If an original value and latest value have the same timestamp, only the latest value will be visible during retrieval running in the "Latest" mode.

       Note: It's best to store values as latest only if you need to override some other previously stored value (original or latest) at the same time.

     • "delete"– Stores a special value (called a tombstone) to override other previously stored values (original or latest) at the same time.

   • TagName
     (required)

   • DateTime
     (required)

   • Format
     (optional) Values can be one of these:

     • "raw"

     • "eu" (The value is provided in engineering units specified for that tag.)

   • Value
     (required for original and latest operations)

   • OpcQuality
     (optional)

3. Beginning on line 2, add values for each record. For best performance, order them by time from the oldest to the newest.

4. Save the file as a CSV file.

Narrow-format CSV data file examples

• Example 1

  This CSV file imports two original values.

  Operation,TagName,DateTime,Format,Value,OpcQuality
  original,Reactor3.Level,2019-05-16T00:13:37.661Z,raw,1.51860072870498,192
  original,Reactor1.Level,2019-05-16T00:14:37.661Z,raw,2.34334345654433,192

• Example 2

  This example shows how to include values with embedded commas or double-quote characters. They must be contained within double-quote characters.

  Operation,TagName,DateTime,Value
  original,Reactor3.OperatorName,2018-05-16T00:13:37.661Z,"Bond, James Bond"

  original,Reactor1.OperatorName,2019-05-16T00:14:37.661Z,"Austin ""Danger"" Powers"

• Example 3

  This file allows the system to store the latest values on top of original values from Example 1. Then, you can use "Latest" retrieval mode to view the latest values or "Original" retrieval mode to see the original ones.

  Note: AVEVA Insight always uses the "Latest" data retrieval. To retrieve original data, you can use the Historian SDK or OData queries.

  Operation,TagName,DateTime,Value
  latest,Reactor3.Level,2019-05-16T00:13:37.661Z,100
  latest,Reactor1.Level,2019-05-16T00:14:37.661Z,200

• Example 4

  This deletes values for specific timestamps from Example 1. Now, if you use "Latest" retrieval mode, you will not see those values. But, when you use "Original" retrieval mode, you will still see the original values. Note that the "delete" operation does not use the Value column, which gets ignored for that operation.

  Operation,TagName,DateTime
  delete,Reactor3.Level,2019-05-16T00:13:37.661Z
  delete,Reactor1.Level,2019-05-16T00:14:37.661Z