Exporting and Importing DAServer Item Data

The Export and Import commands on the shortcut menu enable you to export and import the DAServer item data to and from a CSV file, after the configuration of the Device Items has been completed. These commands 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.

The Export and Import features on the shortcut menu of the Device Items dialog box enable you to export and import the DAServer device item data to and from a CSV file, after the configuration of the Device Items has been completed. These features provide you with the following capabilities:

• Archive lists of device items.

• Bring an archived list of device items into the Device Items dialog box when you need to utilize or reconfigure any of the device items on the archived list.

• Perform an off-line, large-scale edit on the item data configured for a PLC.

• Import what has been edited back into the PLC configuration.

To export device items

1. Right-click anywhere in the Device Items dialog box.

2. Select the Export command from the shortcut menu.

   • The standard Save As dialog box appears.

   • The file name has defaulted into "PLC Hierarchyname.csv," within the current-system-configured default directory.

3. Accept the defaults to save the file.

   • The file is saved as New_PLC5_TCPIP_000.csv.

   • It is editable in Microsoft Excel.

     However, if you prefer to save the list someplace else and rename it, perform the following steps after step 2.

4. Select the folder into which the list is to be saved.

5. Name the list to be archived.

6. Click the Save button.

   • The whole list will be saved as a .csv file in Excel.

     

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

To import device items

7. To import the list, right-click anywhere in the Device Items dialog box.

8. Select the Import command from the shortcut menu.

9. Select the archived list (.csv file) to be imported from the folder in which it is saved.

10. Click the Open button.

    • The whole list will be brought into the Device Items dialog box.

Note: When the list to be imported contains duplicate names as found in the current list but the Item References are different, a dialog box will appear to prompt you to make a selection.

To import device item data that has been edited off-line

11. Right-click anywhere in the Device Items dialog box.

12. Clear all the item data you wish to replace with the edited .csv file by selecting the Clear All command.

    • The data will be cleared after you click on Yes to confirm the deletion.

13. Select the Import command from the shortcut menu.

    • The standard Open dialog box appears.

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

14. Browse for the specific CSV file you want to import, select it, then click on the Open button.

    • The DAServer Manager will import the edited file and deposit it in the Device Items dialog box.

• During the imported file processing:

• New item references will be added based on unique names.

• If there are duplicate names, you will be provided with the ability to replace the existing entry with the new entry, or ignore the new entry.

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