Create an object list: formatting ​.txt or ​.csv files for import

It is possible to import an object list from a .txt or .csv file. This section outlines the way in which the .txt or .csv file needs to be formatted so that it can be successfully imported into AVEVA Measurement Advisor.

The format of the .csv or .txt file must be "objectName, objectTypeName[,alias, organizationName] ". For example: "METER1, Meter, OMETER1, ORGA". This will add METER1 to the list and creates the OMETER1 alias for the ORGA organization. Valid Object Type names are as follows:

• Meter

• Gas Quality (GQ)

• Measurement Station

• Measurement Site

• Measurement Point

• Line Segment

• Sub Region

• Region

• Company

Other items to consider when formatting your .csv or .txt file:

• The first line should contain column names separated by a comma with no extra spacing.

• Each line in the file defines one object. That is, each object that you would like to import needs to be on a separate line.

• Blank lines are ignored.

• Assumed column ordering when there is no header is objectName, objectTypeName, alias, organizationName.

• Lines starting with a # (number sign) are ignored (can be used for comments).

• If the content provided is invalid (e.g., if there was a misspelling in the name of a column) the parsing tool will ignore the content.

• Quotation marks (" ") may be used when there is an entry containing a comma. For example, if the alias is set to Houston, Texas, you would surround "Houston, Texas" with a pair of quotation marks.

• Alias information is considered optional, but objectName and objectTypeName are mandatory fields and must be specified.

• If the list is not intended for an organization, but the alias is specified, you must also specify the organizationName in the .csv or .txt file. The alias is intended as a secondary name for the organization.

• organizationName is ignored if the list is defined as a Global List and an Organization in the Properties for Object List Import window. The aliases will be added to the new organization.