Adding manually collected measurement data

Manually add data logs to the database that were collected from data sources that do not have a communication link with the software.

To add manually collected measurement data:

  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 add data.
    • Select the Measurement for which you want to add data. If the measurement does not exist, click Create new Measurement to create a new measurement.

      NOTE: Check the list of available measurements to see if one exists for your application before creating a new measurement.

    • Click Add Data to Selection to add the source/measurement to the list of items to be opened in the 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 data you want to add in the data editor.
  5. (Optional) In Load Data, set the following data 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.
  6. Click Load Data to open the source/measurement data entry fields in the data editor.
  7. (Optional) In the data editor, click Load New Data to change which data is loaded, the time range, or the editor options.
  8. In the data editor enter the measurement data using any of the following tools or methods:
    • 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. That means that the last data log for a day has a timestamp of midnight (or 12 AM) of the following day. For example, the last data log timestamp for January 31 has a timestamp of February 1, 00:00 hrs (or 12 AM).

    • Smart Gap Fill - Automatically fill missing data values in a selected time range, or the entire time range of the loaded data set. You can choose between different interpolation algorithms to fill the missing data. See Smart Gap Fill UI for more details.
    • 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.
    • Copy one or more data values and paste them into an external editor, such as Microsoft Excel, for bulk editing. Paste the modified data values back into Manual Data Editor. 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.

  9. Click Apply Changes to write the new data log entries to the database.

    NOTE: The Apply Changes command permanently writes the data log changes to the database. There is no undo option for this command. See Reverting previous data edits for more information.

  10. (Optional) Click View Log to see a historical audit log of all the data log changes.
  11. Close Manual Data Editor.

 

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

For reference information see: