Downstream Device Assistant functions

This section describes different functions you can perform using the Downstream Device Assistant.

 

Renaming the assigned source

One of the primary reasons for using the Downstream Device Assistant is to change the default name assigned to a downstream device by the Log Inserter. For instance, instead of “Modbus.34”, you may want to rename that device to something more meaningful such as “SM_Bldg2_Boiler7”.

Renaming an Assigned Source typically only applies to downstream devices.

Renaming the assigned source for all its measurements

1. Switch to Basic view.

2. Find the source you want to rename. Enter the new name in the Updated Assigned Source column. All rows with measurements associated with the renamed source are automatically updated.

   If you do not want to assign the existing data in the database to the new source name, switch to Advanced View first, then clear the Update Historical Database check box for all appropriate rows.

3. Click File > Save.
4. A dialog opens showing a summary of the changes. Click Yes to continue. or No to cancel.
5. When the operation completes, click OK, then Close.

Renaming the assigned source for one or more measurements

1. Switch to Advanced View.
2. Select the row(s) you want to rename. To select a row, click the area just to the left of the first column. The row is highlighted to indicate that it is selected.
3. Click Edit > Rename Source.

4. In the Source Rename box, type the new name for the downstream source. Click OK.

   NOTE: By default, the Update Historical Database check box is selected for all affected rows — this applies the change to existing data in the database. To make the change only to data going into the database from this point forward, clear the Update Historical Database check box for the affected rows.

5. Click File > Save. A dialog open showing a summary of the changes.
6. Click Yes to continue or No to cancel.
7. When the operation has completed, click OK, then click Close.

Cancelling changes

1. To undo all unsaved changes:
   • Click Edit > Reset, or
   • Click View > Refresh.
2. Click Yes to confirm.

Changing the measurement mapping

Log Inserter automatically associates logged data with a measurement by searching for a mapping between the label and the measurement. However, in cases where no mapping exists, Log Inserter creates a “measurement” that is based on the register label. To manually change this measurement mapping:

1. Switch to Advanced View.
2. Click the Updated Measurement cell that you want to change, then select the new measurement you want to map from the list.
3. Select the Manual check box.
4. By default, the Update Historical Database check box is selected — this applies the change to existing data in the database (if, for example, the source and measurement mapping you are adding already exists). To make the change only to data going into the database from this point forward, clear the Update Historical Database check box.
5. Click File > Save. A dialog opens showing a summary of the changes. Click Yes.
6. If prompted, select which database to update. Click OK.

Adding a new downstream device mapping

To add a new address mapping that associates the source and measurement to a specific logged quantity in the database:

1. Scroll down to the end of the table and click the last row (the one with the asterisk beside it).
2. Fill in the Updated Assigned Source and Physical Source columns. If the source is a physical device (i.e., not downstream), the same name must be entered exactly in both columns.
3. Click the Updated Measurement cell, then select the measurement from the list.
4. In the Handle cell, type the register handle for this measurement.
5. By default, the Update Historical Database check box is selected — this applies the change to existing data in the database (if, for example the source and measurement mapping you are adding already exists). To make the change only to data going into the database from this point forward, clear the Update Historical Database check box.
6. Click File > Save. A dialog opens showing a summary of the changes. Click Yes.
7. If prompted, select which database to update. Click OK.

Updating the historical data at a later time

When you save your changes using the Downstream Device Assistant, a record of changes to the source-measurement definitions is saved in the folder:

...\Power Monitoring Expert\config\Diagnostic\Downstream Device Assistant\

with the following filename:

“Downstream Device DefinitionsYYYY-MM-DD_hh.mm.ss.csv”

where “YYYY-MM-DD_hh.mm.ss” means current YEAR-MONTH-DAY_hour.minute.second.

If you cleared the Update Historical Database check box when you saved your changes the first time, you can update the existing data in the database at a later time, through the use of this csv file.

How to use the Downstream Device Assistant .csv file

To update the existing data in the database with the source-measurement changes contained in the csv file:

1. Click Edit > Historical Data. The Update Historical Data window appears.
2. Click File > Import CSV.
3. Downstream Device Assistant opens the folder that contains the csv files. Select the Downstream Device Definitions file you want to use, then click Open.
4. Click File > Update Historical Data.
5. The Historical Data Update prompt displays how many source-measurement pairs will be updated. Click Yes.
6. Click Yes at the Historical Data Update prompt.
7. After the operation has completed, click OK, then Close.

You can update only one ION database at a time. To select a different database, first make sure the show connection dialog check box is selected under View > Options. You can then use the database connection dialog to specify which database you want to update.

NOTE: If you update address definitions that affect multiple historical databases, only the first historical database you select is automatically updated. To update the remaining historical databases, you must import the address definitions to each one, using Edit > Update Historical Data.

Activity log

The saved changes in the Downstream Device Assistant are stored in a log file named “Downstream Device Historical UpdatesYYYY-MM-DD_hh.mm.ss.txt”, that contains a description of the activities carried out when Downstream Device Assistant was updating the source-measurement definitions.