Export and import CSV Files

To help you manage item references (tags) and device item names outside the OI Server Manager, the Communication Driver supports importing and exporting device item data in a comma-separated values (CSV) file. The CSV functions are only available when a device items tab is selected.

Each row in the CSV file represents an item, and each row contains two elements. The first element must be the item name; the second element must be the item reference string. The item name can be the same as the reference string or it can be an alias. If either the item name or reference string element contains a comma, use quotation marks around the element to avoid a collision with the comma delimiters.

Item names are not case-sensitive.

Export or import a device item list

1. In the OI Server Manager, navigate to the device.

   1. Expand Operations Integration Server Manager, expand the node group, and then expand Local.

   2. Expand the Communication Driver, expand Configuration, and then expand the channel, port, or bridge.

2. Select the device. The device's parameters are displayed in the details pane on the right.

3. In the details pane, select the Device Items tab.

4. To export a device item list:

   1. Right-click anywhere in the table, and then select Export.

   2. In the Save As dialog box, type a file name, select a directory, and then select Save.

   Items list in the Device Items tab are exported to the CSV file.

5. To import a device item list:

   1. Right-click anywhere in the table, and then select Import.

   2. In the Open dialog box, find the file containing the items to be imported, and then select Open.

   Items contained in the file are now listed on the Device Items tab.