Export and import data items

After configuring the device items, you can export and import the Communication Driver item data to and from a CSV file. This will allow you to perform an off-line, large-scale edit on the item data configured for a controller, and import what has been edited back into the controller configuration.

Export Communication Driver item data to a CSV file

1. Right-click anywhere in the Device Items configuration view.

2. Select the Export command from the shortcut menu.

   • The Save As dialog box appears.

   • The file name defaults to NEW_SOAP_000.csv or NEW_REST_000.csv based on the current node.

3. Accept the defaults to save the file or rename the file if appropriate.

The file can now be edited off-line in Microsoft Excel. It contains one row for each item configured with two columns - Name and Item Reference.

Import Communication Driver item data from a CSV file

4. Right-click in the Device Items configuration view.

5. Select the Import command from the shortcut menu.

   • The Open dialog box appears.

   • It defaults to the .csv file extension within the current-system-configured default directory.

6. Browse and select the specific CSV file you want to import, and select OK for confirmation.

   The OI Server Manager will import the file and deposit it in the Device Items box.

During the imported file processing:

• New item references are added based on unique names.

• If there are duplicate names, you can either replace the existing entry with the new entry, or ignore the new entry.

When the Communication Driver is running and an OPC client requests item information, the imported configured items will show up under the controller hierarchy node.