AVEVA™ Historian Administration Guide
Chapter 6 – Importing, Inserting, or Updating History Data
© 2021 AVEVA Group plc and its subsidiaries. All rights reserved. Page 193
The following example shows an insert of original data values for a single tag, identified by a wwTagKey of 777. A
comma ( , ) is used as a delimiter. The file is saved as UNICODE, where every character is represented by two
bytes.
UNICODE
,
MikeA,1,Server Local,11,2
777,0,2004/12/09,12:05:24.000,0,100,192
777,0,2004/12/09,12:48:36.000,0,101,192
777,0,2004/12/09,13:31:48.000,0,102,192
777,0,2004/12/09,14:15:00.000,0,103,192
777,0,2004/12/09,14:58:12.000,0,104,192
777,0,2004/12/09,15:41:24.000,0,105,192
777,0,2004/12/09,16:24:36.000,0,106,192
777,0,2004/12/09,17:07:48.000,0,107,192
777,0,2004/12/09,17:51:00.000,0,108,192
Handling of NULL Values in CSV Files
The value to insert can be a NULL.
If the OPC Quality in the CSV file is between 0 to 63, then:
The NULL value is stored.
The Quality Detail is set to 249 (not a number).
The OPC Quality is what was specified in the CSV file.
If the OPC Quality in the CSV file is greater than 63, then:
The value that was specified in the CSV file is stored.
The Quality Detail is set to 192 (unless the value specified is NULL in the CSV file, in which case the Quality
Detail is set to 249).
The OPC Quality is what was specified in the CSV file (unless the value specified is NULL in the CSV file).
If the value is not NULL, but the OPC Quality is less than 63, then:
A NULL value is stored.
The Quality Detail is set to 249 (not a number).
The OPC Quality is what was specified in the CSV file.
Copying a CSV File into an Import Folder
After you copy one or more CSV files to an import folder, the AVEVA Historian attempts to read the file(s) only
one time. If the read is successful, the data is automatically converted and merged in with the appropriate
history block according to the date range provided in the CSV file. The CSV file is then deleted from the
directory. If an error occurs during the import, the CSV file is moved to the \Support folder. A message is also
posted in the error log.
At any given time, the manual storage service processes either fast load CSV files or normal CSV files; the two
types are not processed concurrently.