Resetting and resending data

You can use the ETL Administration Tool to restore lost Power Monitoring Expert (PME) data from Power Operation (PO).

Position counters

Position counters keep track of the data that is extracted from the source system and then loaded into PME. Each PO Source tag specified in ETL has a position counter associated with it. The position counter represents a timestamp of the most recent data point loaded for each source tag. When an ETL job is run, only data after this timestamp value is extracted from the source system's Trend log.

After you run an ETL job you can check the position counters to verify that the job ran as expected. If the position counter value for a given source-quantity pair continues to increase after each job run, then you can be confident that the job picked up new data for that pair on the most recent run.

If you need to re-extract previously extracted data, or if you want to load data after a specific date, you can manually update the position counter and then run the ETL job.

Prerequisites

  • The name of the mapped PO device. (If you are editing a PO device name or measurement in the ETL job.)

To reset or resend data for mapped Trend logs:

  1. Open PO to PME ETL.
  2. From the list of jobs, select the job that you want to edit and then click Edit.

    NOTE: To restore lost data, you can either edit or clone the existing PO to PME ETL job.

    TIP: Editing the original PO to PME ETL job might be easier to manage when working with only a few source tags. You can also save a copy of your job and work with that.

  3. Click the Positions tab.
  4. For each device whose data you want to recover, enter a specific value in Initial Value to set all position counters. Use the same format as shown in the existing records/rows on the positions tab, or in the "Initial Value" text box.
  5. Click Initialize. Mapped Trend logs appear with associated timestamp data for each.

    You should see a row for each pair selected in the Mappings tab. The Key is a long string that represents the pair.

    Now, the next time you run ETL, only data after the given timestamp is loaded.

  6. Run the ETL job.

    The Target Device value is the PME source under which the PO data will be loaded.

  7. (Optional) Verify the data transfer. See Verifying PO data transfer to PME for details.