Data Rows

Missing Values

A data row contains values for the fields defined in the header row. If an item does not have a value for the corresponding field, it can be left blank. This should appear in the CSV text file as a repeated delimiter. Trailing commas are needed for missing values at the end of a row.

Note: Since empty fields are allowed, it is not possible to remove a specific attribute value from an item using the update action. Use the replace action to remove attributes values.

For example, the following CSV text file does not have a value for the first ITEM.ORIGIN_COUNTRY field. The missing value is accounted for by the repeating commas.

ITEM.IDENTIFIER,ITEM.IDENTIFIER_TYPE,ITEM.PRODUCT,ITEM.DESCRIPTION,
ITEM.ORIGIN_COUNTRY,ITEM.ORIGIN_COUNTRY

123456789012,UP,JEANS,DESIGNER BLUE,,MEX

Quoted Values

If a value needs to contain the delimiter character (for example: DESIGNER, BLUE), the corresponding field in the CSV text file needs to be surrounded by double quotes ("DESIGNER, BLUE"). If the value contains a quote character, the quote character must be proceeded by another quote character.

For example, DESIGNER, "BLUE" needs to appear in the CSV text file as "DESIGNER, ""BLUE""".

ITEM.IDENTIFIER,ITEM.IDENTIFIER_TYPE,ITEM.PRODUCT,ITEM.DESCRIPTION,ITEM.ORIGIN_COUNTRY,ITEM.ORIGIN_COUNTRY

123456789012,UP,JEANS,"DESIGNER, ""BLUE""",,MEX

Excess Data Values

A data row cannot contain more data values than you have defined in the header row. If it does, the line will generate an error and be ignored.

Action Field

You can use a field to specify the action of a row (insert, update, replace, or delete). The following rules apply:

If you use a field to specify an action, and you specify insert for an existing item, the system will generate an error.

If you use a field to specify an action, and you specify update or replace for an non-existent item, the system will generate an error.

If you do not use a field to specify an action, the system uses the appropriate action to load the data into Catalogue (it inserts an item if there is no existing item and updates an item if it already exists).

If you specify replace for an existing item, the item is updated only with the attributes specified in that data row. Attributes for the item that are omitted from the data row are removed from the existing item. The item has a new delta time stamp but its create time stamp is preserved. All of the item attributes have a new delta time stamp.

Selection Code, Selection Code description, Product, and Product description can only be created using text file upload; you cannot update these fields using text file upload.

Text file upload supports implied Product delete; that is, if you use a CSV text file to delete the last item in a Product, the Product will be deleted.

Hierarchy Creation

Catalogue will automatically create a Selection Code/Product hierarchy from the values provided in the CSV text file as long as all the necessary values are present.

For Catalogue to create the hierarchy, the CSV text file must contain values for the Selection Code (selcode), Selection Code description (hierarchy.node_description), Product (product), and Product description (hierarchy.product_description).

If the hierarchy does not yet exist, Catalogue will create the hierarchy.

Note: If the hierarchy already exists, Catalogue will not update the existing values with the values in the CSV text file.

21.2 release. Online Help last updated March 6, 2021 OpenText Active Catalogue Browser Interface User Guide for Vendors PDF

Copyright © 2021 Open Text. All rights reserved. Trademarks owned by Open Text.