Header Row

Header Fields

The first non-blank row is the header row. The fields in the header row are Active Catalogue attribute names. These names are case-insensitive and are in one of the following formats:

The attribute name listed in the OpenText Active Catalogue Attributes Guide (for example, ITEM.COLOR_DESCRIPTION or ITEM.NRF_SIZE_CODE).

The attribute name displayed on the Edit GTIN Details screen in the OpenText Active Catalogue application (for example, Color Description or Size Description)

Use the attribute name up to, but not including, the first comma that is displayed. Include parentheses when it is part of the name. See the examples in the following table.

Attribute Name Displayed on Edit GTIN Details Screen	Attribute Name Used in CSV Text File
Booking Date (Item Effective Date)	Booking Date (Item Effective Date)
Dangerous Goods Item, Y/N:	Dangerous Goods Item

Qualifying an Attribute Value

When an attribute requires a qualifier (either a UOM or Private Account ID), the field immediately following the attribute must contain the qualifier. The qualifier is identified as a colon followed by the qualifier (UOM or Private_Account_id).

UOM Example

In the CSV fragment below (the ellipses indicate that only part of the CSV text file is shown), Consumer Package Length has a UOM of inches (IN) and Consumer Package Gross Weight has a UOM of ounces (OZ).

...Consumer Package Length,:uom,Consumer Package Width,:uom,Consumer Package Height,:uom,Consumer Package Gross Weight,:uom,Consumer Package Volume (Cube),:uom

...10,IN,5,IN,2,IN,16,OZ,1.3,CF

 

Private Account ID Example

In the CSV fragment below, Unit Cost is an attribute that has a UOM qualifier of U.S. dollars (USD) as well as a Private Account ID qualifier of 123456789012. These qualifiers are followed by fields for the Unit Cost Effective Date and Unit Cost Expiration Date which are associated with the private cost values.

...Unit Cost,:uom,:Private_Account_id,Unit Cost Effective Date,Unit Cost Expiration Date

...80,USD,1234567890,1/1/2005,1/1/2006

 

Optionally, to clearly identify the attribute that is being qualified, you can repeat the name of the attribute before the colon of the qualifier, as shown in the CSV fragment below:

...Unit Cost,Unit Cost:uom,Unit Cost:Private_Account_id,Unit Cost Effective Date,Unit Cost Expiration Date

...80,USD,1234567890,1/1/2005,1/1/2006

Multiline Attributes

For each row in the CSV text file, multi-line attributes must appear as consecutive fields. In the following example, ITEM.ORIGIN_COUNTRY is the multi-line attribute and appears twice, one field next to the other.

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

123456789012,UP,JEANS,DESIGNER BLUE,USA,MEX

123456789012,UP,JEANS,DESIGNER BLUE,USA,CAN

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.