Export HDV Values

The export button will send values displayed in the graph or grid to a file type of your choice. What is exported depends on what you are viewing, as per the following note.

Graphed values are not necessarily the same as logged values.
If exporting from the plot, values will be averages of the data values covered by each screen pixel.
If exporting from the grid, values will be averages, minimums, maximums or raw data depending on your choice of data retrieval mode.

If generating a file using the VTScada Anywhere Client, it will be transferred to your browser automatically. Check your browser's download history. (Will vary by browser.)
Only text files can be generated by a thin client, not spreadsheet or database files.
Similarly, Excel templates cannot be used when reporting via a thin client.

This applies to report generation, HDV exports, note exports, ChangeSet creation, and tag exports.
You cannot view a generated file (such as a report) within the Anywhere Client. The client shows only the VTScada user interface.

Adjust the time span to change the range of dates included in the export. Only the values in the current HDV display are exported.

The values can be exported to any of the following formats.

  • Access Database.
  • Excel Spreadsheet.
  • CSV File (Comma separated values in a text file.)
  • ODBC Compliant Data Source.
    Details will depend on the destination.

If exporting more than one tag, you will have the choice of exporting each to separate worksheets / database tables / files, or to merge all together.

If merging several tags to a single file or worksheet, and if exporting raw values from the grid view, the result will be a sparse table. There will be a row for every logged timestamp, but not every tag will have been logged at that exact moment in time.

 

Troubleshooting:

  • Error "General warning. Unable to open registry key 'Temporary (volatile) Jet DSN ..."

VTScada is running in an account that does not have sufficient permissions for the ODBC process. Adjust permissions for this account or use an account with a greater permission level.