Edit a ​.csv file

For a .csv file, the first row is a comma-separated header (or other separator depending on the cultural setting) where each column name identifies the value represented in the column.

• The data listed in each column must correspond to the header row.

• Column order is not important.

• Extra columns are ignored.

• New rows are added and existing ones are modified. Import does not remove rows.

• It is recommended that strings are in quotation marks to avoid processing errors.

• If the current cultural decimal value is the same as the regional list separator (e.g. a comma is used for both), the value and limits for the data type Double must be also in quotes.

The following is an example of a .csv file containing Equipment parameters in a valid format:

Capability,Name,DataType,UseDefault,MaxValue,MinValue,UOM

Capability001,Parameter1,boolean,Yes,null,null,kg

Capability002,Parameter2,integer,Yes,20,7,kg

NOTE: If you have upgraded from an earlier version of AVEVA Recipe Management, make sure that you are using the latest version of CSV file while importing Equipment, Capability parameters, Formula parameters and so on.