Data import

Data import is performed always for so-called Selected object. Object selection is performed by double-click on the particular line in the list. Information about the current selected object are in the part Archiving parameters, that displays:

• Archive object - name of selected object of Historical value type
• Archive type
  • Primary
  • Statistical
• Archiving method
  • Period
  • Filter
  • External
• Period - in case of periodical, or statistical archiving
• Offset - in case of periodical, or statistical archiving

The parameters in the part Import parameters define the mode of import execution:

- all data of the selected object, that is contained in the depository database, will be inserted into the selected area of the sheet. Other options are not available.

• there will be imported the data within the given time interval.

If the option is checked, the function Import will oversample the data from the given time interval with the given time steps (days and hours).

The function Import inserts data into the selected area of the sheet. It is appropriate to select the area with the required number of whole columns. For example: Selection of the columns A up to C in the sheet Sheet1.

Each value in the depository database contains additional information:

• Time - value archiving time
• Value - value of the archive object
• Status - state of the archive object value
• Limits - limits of the  archive object value
• Flags - user flags of the archive object value
• Archive flags - flags of the value, that are generated by the archiving process

This information is imported (displayed) into the columns so that each line consists one value and the required information about the historical value are displayed in the columns. Column order is adjusted using the list and two narrow buttons, that move the selected item up or down.

Number of displayed columns is adjusted using the spin button . The number of columns must be the same as the number of columns in selected area.

After performing the settings, the import is started clicking the button . This operation may take a long time (according to the adjusted parameters). In the bottom part of the dialog box, there is therefore displayed information about the execution:

S - reading the data from the depository database,
W - writing the data into the selected area.