📖 Home Back
Several methods exist in the Historic aggregate class for importing data into point and accumulator histories.
LoadDataValue
LoadDataValue( Value{Variant},
Timestamp{Time},
Quality{Long},
Reason{Byte} )
Values for Quality parameter (ClearSCADA uses standard OPC HDA quality definitions), e.g.:
Values for Reason parameter (Reason For Logging field available in the historic database):
LoadDataValues
LoadDataValues( Value{Array of Variant},
Timestamp{Array of Time},
Quality{Array of Long},
Reason{Array of Byte} )
Same as LoadDataValue except the parameters passed in are arrays instead of single values. A maximum of 5,165 elements are allowed in the arrays otherwise an error will be raised.
The Reason argument is optional - when omitted defaults to 0 (Current Data).
LoadDataValuesEx
LoadDataValuesEx( Value{Array of Variant},
Timestamp{Array of Time},
Quality{Array of Long},
Status{Array of Long},
State{Array of Byte},
Reason{Array of Byte},
MSState{Array of Byte} )
Extended version of LoadDataValues that allows all of the properties of the historic data record to be specified.
The Status, State, Reason and MSState paramaters are all optional.
The Status parameter is a bit mask of flags that varies between drivers.
To calculate the State from the Value specify the state as 255 (or omit the parameter).
If there is no master-station state (or feature is disabled) then specifiy the MSState as 255 (or omit the parameter).
LoadSuppressionValues
LoadSuppressionValues( Type{Array of Short},
Timestamp{Array of Time} )
Values for Type parameter (consequential alarm type):
LoadDataFile
LoadDataFile( FileName{String} )
The LoadDataFile method takes a filename as its single parameter. This is the name of a local CSV on the main server. Some points to note about the files to be imported:
- Each line of the CSV file specifies a single record and has the format: YYYY,MM,DD,HH,MM,SS,Value
- The file must be in ANSI format.
- To insert comments into the file start the line with a semi-colon.
- Reason is set to 0 (Current Data) on import.
Performance
LoadDataFile is much faster at importing records than LoadDataValues.
Go: Home Back
