What are the rules applied to validate a CDF import file?

Answer

Rules applied that if failed will result in rejection of the CDF for loading

1. Invalid Delimiter:
- If the CDF import file uses a delimiter character that is different from the delimiter character specified when configuring the CDF import solution the file will be rejected and will not sent to the IBM Digital Analytics data loader (e.g. you select comma () as the delimiter for the CDF import solution and then import a file with pipe (|) characters being used as the delimiter).

2. Root Not found:
- If the CDF import file doesn?t have at least one root category (i.e. there is no parent category / parent category is empty) the file will be rejected and will not sent to the IBM Digital Analytics data loader.

3. Invalid Client:
- If the CDF import file uses a Client ID value in its file name that is not valid the file will be rejected and will not sent to the IBM Digital Analytics?data loader.

4. Loose or un-escaped character:
- If the CDF import file does not use double quote characters (?) properly as text qualifiers the file will be rejected and will not be sent to the IBM Digital Analytics?data loader.


Below are rules which will result in a warning message and the rejection of selected records of the import file but other records will be imported by IBM Digital Analytics.

1. Duplicate Category:
- If your CDF import file has two lines with the same category AND parent category id the duplicate record will be rejected.

2. Circular Reference Found:
- If the parent category for one record becomes the child category of the same category in another record the records involving the circular references will be rejected.

3. Category not Found
- If a category is defined as parent category but not defined as a category the validator that record will be rejected.

4. Insufficient Number of Columns:
- A CDF File should have at least 3 Columns of Data in one line (client_id category_id Category_Name). If a line has less than 3 fields a warning will be generated for that record and it will not be loaded.