Import Procedure

  1. Log in and start up a command shell in the project where you want to import data.

  2. At the system prompt, invoke the following command:

$ clie import <file> [-D <device_id>] [-R <resource_id>]
   [-Pa <prefix>] [-y]

Where

<file> is a required argument, and is the full path of import file to be read. The file may be in any directory, but the project's Data subdirectory is recommended. You should always use the .csv extension with this filename.

Important: Option names are case sensitive and must be entered as defined.

For CIMPLICITY versions 6.0 and higher

If imported points contain references to other points, it may be necessary to run the import procedure more than once.

The optional arguments for the import command are:

Argument

Description

-D <device_id>

A valid Device ID in the CIMPLICITY database.

For each device point in the import file that does not have a Device ID, add the Device ID indicated by this argument.

If no Device IDs are specified in the import file, this option will set all device points in the import file to the specified Device ID.

This option will not override Device IDs already present in the import file. Those IDs will remain unchanged.

R <resource_id>

A valid Resource ID in the CIMPLICITY database.

For each Point ID in the import file that does not have a Resource ID, add the Resource ID indicated by this argument.

If no Resource IDs are specified in the import file, this option will set all points in the import file to the specified Resource ID.

This option will not override Resource IDs already present in the import file. Those IDs will remain unchanged.

Pa <prefix>

Add prefix_ to the start of each Point ID in the input file.

y

Perform the import in dynamic mode if the project is running. Allows you to import point information without restarting the project.

Example

clie import myfile.csv -R RESOURCE1

imports the point data from MYFILE.CSV and use RESOURCE1 as the Resource ID for any records that do not have a Resource ID defined.

More information

Configuration data imported.