CDFGenerator utility

Product and content classification requires a Category Definition File (CDF). The CDFGenerator utility, cm_cdfgen.sh, generates a CSV file in the IBM Digital Analytics defined CDF format.

Parameter values

-dbtype

Database type, DB2 or Oracle.

-dbname

Name of the target database.

-dbuser

Name of the user connecting to the database.

-dbpw

Password for the user connecting to the database.

-clientid

The client ID assigned by IBM Digital Analytics.

-langid

The ID of the language to use (from the LANGUAGE_ID column in the LANGUAGE table).

-catalogid

The ID of the catalog to use (from the CATALOG_ID column in the CATALOG table).

Note: If the catalogid value specified is for a sales catalog, there might be more than one record in the CDF file with the same category ID. In a sales catalog, a unique category ID can have multiple parent categories, as shown in the last two lines of this CDF file excerpt:

99999999,101,MENS, 
99999999,102,SALE, 
99999999,123,MENS SALE,101 
99999999,123,MENS SALE,102

In the CDF file, however, a unique category ID can have only one parent category. When you upload a CDF file that contains records with duplicate category IDs, IBM Digital Analytics, formerly known as Coremetrics Analytics will issue warnings and reject the additional duplicate records. You have three options:

• Ignore the warnings from IBM Digital Analytics, formerly known as Coremetrics Analytics; the additional duplicate records will be rejected by IBM Digital Analytics, formerly known as Coremetrics Analytics automatically.

• Remove the additional duplicate records manually from the CDF file before uploading.

• Consult IBM Digital Analytics, formerly known as Coremetrics Analytics for other implementation alternatives.

-output

Name of the file in which to save the output. We can specify either a full path, or a relative path by using this parameter if you would like to save the file to a different directory.

Example

The following examples command generates a CDF file to send to IBM Digital Analytics.

• cm_cdfgen.bat -dbtype DB2 -dbname mall -dbuser wcsuser -dbpw passw0rd -clientid 12345 -langid -1 -catalogid 10001 -output catalogCDF.csv

• cm_cdfgen.bat -dbtype oracle -dbname oracle_hostname:port:orcl -dbuser wcsuser -dbpw passw0rd -clientid 12345 -langid -1 -catalogid 10001 -output catalogCDF.csv

Related tasks
Generating a file that captures your catalog hierarchy