Wiki

Options

New Case Case Status
Log In

Wiki

Options

 
Knowledge Base Articles»KB100030 - EPArchive Editor
  • RSS Feed

Last modified on 10/17/2019 1:47 PM by User.

KB100030 - EPArchive Editor

Introduction

The EPArchive Data Editor is a tool that that allows users to make changes to their underlying EPArchive historical data. To access the EPArchive Editor, navigate to Start | All Programs | EtaPRO 10 | Tools | EPArchive.  

Important Notes:

  1. This utility can be used to edit historical values in EPArchive. 
  2. When a value is edited for a given timestamp, the original value(s) is retained (for auditing purposes) but not used.
  3. When a timestamp value is deleted, it is not permiantly removed. It is marked as deleted (for auditing purposes) and not used.
  4. The EPArchive Editor is only available on the EtaPRO server. It is not distributed with the EtaPRO Client.
  5. There is no "undo" feature in this utility. Use caution when editing or deleting data.

To look at or edit the data for a given tag, right click on the row and select Get Historical Data.

To get data using Floating Time, check the Floating Time radio button, make the necessary time changes and then click Get Data. Use the time scope drop down to change the scope from Hours to Days, Weeks or Months. 

To use a fixed time, check the Fixed Time radio button, enter the start and end time and then click Get Data.

All the pulled data will be shown in the grid below the settings box.

To go back and select a different tag, click on the Tag tab to return to the Tag Selection Grid.

Editing Data Values

The value and quality of each EPArchive data value can be edited. Click on any Value or Quality cell to make a change. Once a change is made, the status is automatically modified and the row is marked visually.

 

In the above picture, the value at 5:41:42 AM was changed to 302.25. The EPArchive Editor updated the status to 1 and highlighted the row with green for easy identification.

The Status codes correspond to the the origin of the data, as well as if that data should be used in functions.

Status Code Description
0 Original
1 User Entered
128 Replaced

The status codes are added to one another which allows for auditors to see a difference between user entered data that had been replaced and original data that had been replaced. For example, an original data value that was replaced by a user entered data value will have a status of '0' for the original value, the status code of '128' would be added to the original status code to say that it had been replaced. The result is '0 + 128 = 128'.  However a user entered value will have the status code '1', if that value gets replaced, the status code of '128' will be added to the original code resulting in '1 + 128 = 129'. Therefore there is no argument over which values are original and which are user entered even if those values have been replaced.

Multiple changes during the same session are allowed.

In the above picture, the values at 5:56:42 AM and 6:01:42 AM were changed to 299.5 and 299.25 respectively.

To send these changes to EPArchive, click the Submit Changes button.

After changes are submitted, the edited rows will return to a normal (no highlight) color to signify that the changes have been committed to EPArchive.

EPArchive always keeps a record of any changes of historical data.  Next to the updated values, the plus box is now enabled. This shows that there are more than one value present inside of EPArchive for that timestamp and tag. Click the checkbox to show the value(s) that were replaced. 

All previous values are always retained for auditing purposes however they will not be used in any EtaPRO functions or trends. For example, the value at 5:41:42 AM was changed from 303.8613 to 302.25. All EtaPRO functions or trends will ignore the value 303.8613 and use the value 302.25

Timestamps cannot be edited directly. To "change" the timestamp of a data value, add a new data value with the proper time and then delete the old offending value.

Deleting Data Values

To delete a data value from EPArchive, simple select the row or rows and click Delete on the keyboard. 

 

The rows will be greyed out and text inside will stricken-out. To submit the changes click the Submit Changes button. The data will still appear in the grid however it will show as above, greyed and stricken-out and will not be included in any trends or summary functions within EtaPRO. 

Add New Data Value

To add or insert new data values, click the top row of the data grid.

Enter the appropriate values and then hit Enter on the keyboard to insert the value into the data grid.

Once the value is in the data grid click the Submit Changes button to commit the changes to EPArchive.

Import Data

To import larger numbers of data values for a given tag into EPArchive, click on the Import Data button.

This tool is not designed to import thousands upon thousands of data values for a specific tag. Additionally this tool is only designed to import data for one tag at a time. If there is a need to import large quantities of data for a large number of tags, please contact:

EtaPRO Support at EtaPROSupport@gpstrategies.com

The first step is to specify a file containing the data. The file should be a 'csv' or 'txt' file with one timestamp, value and quality per row. Click the button next to the File Path text box to specify a file with the data values. 

Once the file is specified, the EPArchive Editor requires some information regarding the characteristics of the data file. Select one of the options within the Item Separator group box that describes how the data is separated. Use the Item Positions group box to set the column position of the various required data items. 

If the data being imported does not use OPC quality then uncheck the Quality checkbox. 

Click the Load File button to attempt to load the data from the file into the EPArchive Editor. Any values found will be shown in the grid. 

Click OK to bring the data into the main Historical Data editor grid. 

Upon returning to the main editor grid, EPArchve will pull the existing historical data surrounding the imported data. Once any necessary changes are made, click Submit Changes to send all of the changes, including the additional imported values to EPArchive.

Depending on the number of values entered as well as the number of changes, it may take considerable time for all the changes to be committed to the archive.