Structure

The following sections describe the structure of the CSV text file.

Character Conventions

The CSV text file uses one line for each item of data. The lines can be separated by either line feed (ASCII 10) characters or a pair of carriage return (ASCII 13) and line feed characters.

The CSV text file separates fields on a line with a comma character. If a field value needs to contain a comma character, the whole field must be surrounded by double quotes (ASCII 34).

If a field needs to contain a quote character, it must be proceeded by an additional quote character.

Required Attributes

Every CSV text file must include (at the minimum) the following fields:

SELCODE

PRODUCT

ITEM_NUMBER

ITEM_NUMBER_TYPE

These attributes identify the Catalogue item that will be changed. The following example is a simple file that inserts this item into the Catalogue:

ACTION,SELCODE,PRODUCT,ITEM_NUMBER,ITEM_NUMBER_TYPE,ITEM.DESCRIPTION
Insert,001,PID001,123412341551,UP,Item Description

Blank Rows

Catalogue ignores blank rows (all white space and no delimiters) in the CSV text file; however, blank rows are reflected in the line numbers used to report errors (they are counted as a row). In the example below, rows 1, 3, and 5 are blank rows. Rows 2, 4, and 6 are data rows. Row 2 is shown wrapping.

row 1

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

row 3

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

row 5

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

 

File Size

The CSV file can have a maximum number of 1000 data rows (blank rows are not counted).

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.