Managed Devices: Transpose Device Values

The Transpose Device Values page is used to either copy or import the values from one source to the destination field(s) to the devices meters.

Source Selection:
Three options exist for selecting the source data for the import:

1)	From Field:	this drop-down contains a list of existing field names and their data-type which can be used as source fields. The values of the From Field will be copied to the To Field. See Choose Destination below.

2)	Import From Excel File:	this option lets you configure multiple field transpositions. For more information on this option see the section Importing From Excel below.

3)	Specify Value:	This option can be used to copy a specific value to the To Field. See Choose Destination below. An error message is displayed if the value supplied cannot be converted to the destination field data-type.

Choose Destination:
The To Field selection is made available when using either the From Field or Specify Value options above.

The To Field drop-down contains a list of existing field names and their data-types which can be used as destination fields for the value transposition.

The data-type of the source must be compatible with the data-type of the destination. An error message is displayed if no conversion between the two is possible.

Importing From Excel:
To import the source/destination field selections from an excel file, the export template file must first be downloaded by clicking the Export Template button. This template file is an excel spreadsheet made up of five worksheets representing the five data-types: Integer, Double, String, Bool, and DateTime.

Each of the five worksheets contains Source and Destination columns preloaded with all of their appropriate fields.

Two options exist for defining the data transposition:

1)	Field to Field:	Simply edit the Source and/or Destination fields to reflect the changes you intend. This is similar to the Source Selection Option 1 above.

2)	Value to Field:	If a Source value is entered that is not a valid Field name, its literal value will be applied to the Destination field. This is similar to the Source Selection Option 3 above.

If a Destination value is entered that is not a valid Field name, the entry is ignored.

Filters:
Three options are available for filtering the the devices to be included in the transposition.

1)	Only managed devices:	when selected, only managed devices will be modified. when deselected, all devices will be modified.

2)	Overwrite values:	when selected, existing destination field values will be overwritten with the source field values. when deselected, existing destination field values will be preserved.

3)	Advanced Filters:	Advanced Filters can be added or removed by clicking the + and - buttons respectively. An Advanced Filter is created by assigning values for the Field, Operator, and Value. Only devices matching any one of the Advanced Filters will be included in the data transposition.

Preview:
To preview the transposition (highly recommended) simply click the Preview button. A table will appear below the Filters section showing the proposed changes.

Perform Action:
To perform the data transposition, simply click the Perform Action button.

There is undo's once the changes are written to the database.