Add multiple devices to a project using a CSV file

To use a CSV file to add multiple devices to a project, you need to be on the same computer as the Power Operation server, and you must have created and exported your project from the Profile Editor. You also need the CSV file that you previously created. Do not have your project running in runtime. You will need access to the following files:

  • INI file for your project
  • Equipment.Profile file for your project
  • CSV file from which you want to add/update/remove data

The Automation Process

To run batch changes related to a specific CSV file:

  1. Open Manage I/O Devices tool: From the Power Operation Studio, click Topology > I/O Devices.

    On the new screen, the Project Name field displays your project name. If there are multiple projects, it displays the first one in alphabetic order.

  2. Choose the correct project.

    The Citect INI file and Equipment profile are automatically selected, based on the project.

  3. Input CSV defaults to the current directory. If you stored the CSV elsewhere, browse to the location where it is saved.
  4. Choose the action you want to perform:

Action

Description

Adding Devices

Use to add devices that you have defined in the CSV file.

Removing Devices

Use to remove devices from the project You only need the ProfileName and Equip columns for this action.

Updating Devices

Use to update tag associations for a device if the device profile has changed. You only need the ProfileName and Equip columns for this action.

NOTE: This action does not update the IP address or other device information. If these attributes are not correct, you need to remove, and then re-add, the device.

Updating Profiles

Use to update the tag associations for all the devices in the specified profile(s). You only need the ProfileName and Equip columns for this action.

In this case, the action chosen is Adding Devices.

  1. Click Validate.
  2. On the new screen, in the right-hand pane, note that the data is valid.
  3. If there are errors or warnings, they display in the Messages pane, and a specific line number is indicated.
  4. After you validate, you can perform the action that you just validated. The following steps use adding devices as an example.
  5. Do not change the project name or file locations. Click the appropriate action (in this case, Add Devices).

    NOTE: Before any action is performed, a validate is performed. If issues are detected, you will be prompted to choose whether you want to continue the action. If you continue, lines with issues will not be processed.

    After the action is processed, you see a screen that indicates that you successfully added two devices.

    If you are unable to validate or perform the desired action, read the right-hand pane. Errors and warnings will help you troubleshoot the issue.

  1. Compile and then run your project. Verify communication for all the devices listed in the spreadsheet.

Exporting CSV Files

You can export information from the project file such as variable tags, clusters, and equipment.

To export information from the project file:

  1. At the bottom left part of the window click Export.
  2. Choose the location at which you want to store the files, and then click OK.