About the CSV File Format

Note the following characteristics of the CSV files that are created for this integration:

• The name of each CSV file is as follows:

  • For bulk load, the CSV file name is the category name followed by the batch ID.

  • For incremental load, the CSV file name is the Category Name followed by INCREMENTAL and a timestamp (in the format YYYYMMDDHHMISS, including the year, month, day, hour, minute, and second).

• The first row in the CSV file contains the field names. All the data records are written to the file starting from the second row onwards.

• The fields in the CSV file are the same as the fields added in the Category Fields applet in the Data Export Category Definition view, along with system fields, visibility fields, and the isDeleted field (which denotes Delete operations). The system fields and visibility fields, which are identified later in this list, do not need to be added explicitly.

• If the record is deleted from the Siebel application, then isDeleted has the value Y. Otherwise, it is set to N. The deleted record has data only for the fields Row Id and isDeleted (set to Y). All other fields are blank.

• If any of the field data in the CSV file contains a carriage return, line feed, or double-quote character, then the data is enclosed with double-quotes, as per the RFC 4180 standard.

• The system fields are as follows: RowID, Created, Created By, Updated, and Updated By.

• The visibility fields are as follows: PersonalId, PositionId, OrganizationId, Group_Hier_Search, Group_Hier_Org_Member_Search, Group_Private_Field, Catalog_Hier_Search, Catalog_Hier_Org_Member_Search, and Catalog_Private_Search.