Export/Import Virtual Variables

Andres Andresson Updated by Andres Andresson

The Export/Import feature of Virtual Variables allows users to update multiple equations quickly.

The file format needs to be precisely the same as the exported format. It's good practice is to export the virtual variables required, update them and then import again.

  1. Use the filter to find one or more Virtual Variables to Export and click the Export button in the top right corner.
  2. Make a backup of the exported file to use if something goes wrong.
  3. Open the file in a text editor. The file structure is explained below.

    Calculation ID: ID of the calculation in the database. If empty, then a new VV will be created. Do not change the ID if updating the VV.
    Station: Name of the station that the VV belongs to.
    Station ID: ID of the station the VDV belongs to (do not change).
    Variable: The name of the variable.
    Time Variable options
    Time Variable: 0 means it is not a Time Variable, and 1 means it is a Time Variable.
    Starting From: Time Stamp from when the equation should be active (only for Time Variables).
    Time Variable Link ID: All Time Variables are linked to the first equation (only for Time Variables).
    Unit Options
    Unit: Name of the unit.
    Unit ID: ID of the unit.
    Formula
    Formula: The formula. It can be modified as needed.
    RoC Options
    RoC Active: Rate of Change calculations. 1 means it's active.
    RoC Precision: Number of decimal points shown in RoC calculations.
    RoC Interval Value: The value for the interval input field.
    RoC Interval Type: Number of seconds between readings for RoC calculations. 86400 for 1 day, 3600 for 1 hour.
    RoC Unit Value: The value for the unit input field.
    RoC Unit Type: The number of seconds for the unit.
    Datum Options
    Datum Variable ID: ID of the Datum variable.
    Datum Timestamp: Timestamp of the Datum reading.
    Datum Information: Comments about the Datum reading.

    Constants

    Constants: Constants to be used in the equation. Separated with | ( Example:  a=20|b=30|c=40 )

How did we do?

Create Virtual Variables

Contact Support