Reverting previous data edits

It is not possible to directly and automatically revert previous data edits with Manual Data Editor. However, you can use the information available in the audit log to manually revert previous edits.

To revert previous data edits:

  1. In Manual Data Editor, click Load New Data to open the Load Data dialog box.

    NOTE: Load Data opens automatically when you start Manual Data Editor.

  2. In Load Data:
    • Select the Source for which you want to revert previous edits.
    • Select the Measurement for which you want to revert previous edits.
    • Click Add Data to Selection to add the source/measurement to the list of items to be opened in the data editor.
  3. (Optional) Repeat step 2 to add additional sources and measurements to the selection list.
  4. In Load Data, select the Time Range for the logged data you want to open in the data editor.
  5. (Optional) In Load Data, set the following editor options:
    • Timezone - Set the timezone for the display of the configurable timestamp in the data editor. The data editor shows two timestamps for each data record, one timestamp in UTC and one in a configurable timezone.
    • Timestamp Format - Set the format for the timestamp display in the data editor.
    • Number Format - Set the number of decimals that are displayed for the logged data in the data editor.
    • Is Interval Data - Select the check box to enable this property. Set the expected logging interval for the data.

      This setting ensures that there is a data row in the editor for every expected log entry. If there is no data record for an expected entry in the database, then the Manual Data Editor inserts a timestamped row with a null value in the editor. This makes it easier to identify missing records and correct them.

      NOTE: The data editor shows all logged records in the selected time range, regardless of the Interval Data settings. No records are hidden or filtered out.

  6. Click Load Data to open the source/measurement data in the data editor.
  7. (Optional) Click Load New Data to change which data is loaded, the time range, or the editor options.
  8. Click View Log to open the audit log for these sources/measurements.
  9. Find the log entries that you want to revert. Using the information provided in the Original Value and New Value columns, identify the values you want the logs to be reset to.

    TIP: You can copy the values from the audit log and paste them into the data editor or an external editor such as Microsoft Excel.

  10. Close the Audit Log.
  11. In the data editor, locate data records that you want to edit and use any of the following tools or methods to reset the data:
    • Click a data record and edit the data value.
    • Insert Timestamp - Insert a new data record with a timestamp that you specify. The timestamp must be in the time range of the data that is loaded into the editor. The new record has <no data> data values.

      NOTE: A historical data log timestamp marks the end of the logging interval. For example, a data log with a 15 minute logging interval and timestamp of 17:00 represents data for the time interval of 16:45 - 17:00.

    • Delete a data record or data value. These options are available in the right-click context menu.
    • Set a data value to <null>. This option is available in the right-click context menu.
    • Paste the data values from the audit log into the data records. The copy and paste options are available in the right-click context menu.

      NOTE: Only select the data values for copy/paste, not the timestamps.

    TIP: Modified data values are shown in bold font in the Manual Data Editor.

  12. (Optional) In the data editor, use Locate Changes to find and step through the edited data records.
  13. (Optional) Revert edited data values back to their original value. This option is available in the right-click context menu. Use Undo all Changes to revert all edits in the loaded data set.
  14. Click Apply Changes to write the data log changes to the database.
  15. Close Manual Data Editor.

 

For information on how to use the Manual Data Editor , see:

For reference information see: