Servigistics InService Customization > Customizing CSV Validations > Configuring Custom Validations for CSV Files > Default Validations for CSV Files
  
Default Validations for CSV Files
All validations for comma-separated value (CSV) files are included in the default configuration file customizedContext_XX.conf.xml located in the directory <INS_HOME>/ InS_SW/SW/Config/System/Config. In the customizedContext_XX.conf.xml file name, XX corresponds to a numeric value appended by default to the configuration file name.
By default, the file includes the following validations for CSV files:
Validation Type
Validation Criteria (Class)
Validation Criteria Description
Validation Description
Resolution
Validation Code
Error
com.ptc.csvtoinservice.validation.DataEncodingValidator
Verify that all the files in the input bundle are UTF-8 compliant.
CSV file has the wrong encoding.
File $FILE_NAME (such as OptionsChoicesDefinition.csv) must be encoded in UTF8.
101
Error
com.ptc.csvtoinservice.validation.MandatoryColumnValidator
Verify that the input files contain all mandatory columns expected in the structure.
Column is mandatory.
Mandatory column $NAME is missing in $FILE_NAME. For example, column Option_Code is missing in OptionsChoicesDefinition.csv file.
201
Error
com.ptc.csvtoinservice.validation.MandatoryColumnValidator
Verify that all the mandatory columns contain content.
Content is missing for some of the mandatory columns specified on the file header.
Row $ROW_NUMBER content in $FILE_NAME is missing some column information. For example, Row 2 content in hotspot.csv is missing some columns information.
202
Error
com.ptc.csvtoinservice.validation.EmptyLineValidator
Verify that all the files in the input bundle do not contain any empty lines in the middle or end of file.
CSV file contains empty lines.
Remove empty line $LINE_NUMBERs. For example, remove empty line 6 in xml.csv file.
301
Error
com.ptc.csvtoinservice.validation.DuplicateEntryValidator
Verify that all the files in the input bundle do not contain any duplicate entries (entries with the same content across all columns).
CSV file contains duplicate lines.
Lines $LINE_NUMBERS in $FILE_NAME are identical. Remove the duplicate line. For example, lines 24 and 25 in ProductInstance.csv file are identical. Remove the duplicate line.
401
Error
com.ptc.csvtoinservice.validation.ContextValidator
Verify that the context or collection is specified in CSV bundle (either in properties.csv or toc.csv files).
Context is missing in the CSV bundle.
No context or collection ID is specified in CSV bundle (in either properties.csv or toc.csv).
501
Error
com.ptc.csvtoinservice.validation.ContextValidator
Verify that the Context and collection IDs specified in the properties.csv file exists in the pre-defined list of collections.
Context or Collection does not exist in InService.
$CONTEXT_ID or $COLLECTION_ID context or collection ID is not specified in the properties.csv or toc.csv file. All Collections and Contexts must be pre-defined in the system.
502
Error
com.ptc.csvtoinservice.validation.BundleCreationDateValidator
Verify that the creation date specified in the properties.csv file is not older than the previously loaded bundle.
Same bundle is already loaded with later creation date.
Creation Date value in the properties.csv file must be greater or equal to the already loaded bundle Creation Date.
601
Error
com.ptc.csvtoinservice.validation.IEFileValidator
Verify that each one of the file name entries specified in the mapping files (xml/pdf/image/graphics.csv) exists in the respective PDF/XML/GRAPHIC/IMAGE folder in the bundle.
File referenced in the IE mapping file is not found in respective PDF/XML/GRAPHIC/IMAGE folder.
File specified in $COLUMN_NAME column on $FILE_NAME mapping file does not exist and must be added to the bundle. For example, file specified in Name_ja column on pdf.csv mapping file does not exist and must be added to the bundle.
701
Warning
com.ptc.csvtoinservice.validation.ImageCodeValidator
Verify that any Image Code entry that is specified in productheirarchy.csv, toc.csv, assembly.csv, or part.csv exists in Image.csv.
Image code is not found in image.csv.
Image code $IMAGE_CODE in $FILE_NAME does not exist in image.csv. It must be added to the bundle. For example. image code GIGC55 in the toc.csv file does not exist in the image.csv file. It must be added to the bundle.
801
Error
com.ptc.csvtoinservice.validation.ApplicabilitySyntaxValidator
Verify that the Applicability column expression contains valid a closing bracket for every opening bracket.
Invalid APEX brackets syntax in Applicability column.
Brackets are missing in Applicability syntax information in $FILE_NAME. For example, brackets are missing in Applicability syntax information in producthierarchy.csv.
901
Error
com.ptc.csvtoinservice.validation.ApplicabilitySyntaxValidator
Verify that the applicability expression contains valid quote syntax (single quote).
Invalid APEX quote syntax in Applicability column.
The Applicability column syntax in the line $ROW_NUMBER of $FILE_NAME contains single quote. For example, the Applicability column syntax in the line 5 of assembly.csv file contains single quote.
902
Error
com.ptc.csvtoinservice.validation.ApplicabilitySyntaxValidator
Verify that the Applicability column expression contains valid keyword syntax (used in the right position).
Invalid APEX keyword syntax in Applicability column.
Correct the Applicability column keywords syntax in the line $ROW_NUMBER of $FILE_NAME. For example, correct the position of keyword syntax in the line number 5 of assembly.csv file.
903
Error
com.ptc.csvtoinservice.validation.ApplicabilitySyntaxValidator
Verify that the Applicability column expression contains valid keywords.
Invalid APEX keywords syntax in Applicability column.
Correct the Applicability column keywords in the line $ROW_NUMBER of $FILE_NAME. For example, correct the Applicability column keywords in the line number 5 of assembly.csv file.
904
Error
com.ptc.csvtoinservice.validation.ApplicabilityContentValidator
Verify that the Applicability column expression contains valid Date Effectivity syntax.
Invalid Date Effectivity syntax in Applicability column.
Correct the Date Effectivity syntax in the Applicability column in line $ROW_NUMBER of $FILE_NAME. For example, correct the Date Effectivity syntax in the Applicability column in line 4 of assembly.csv file.
1001
Error
com.ptc.csvtoinservice.validation.ApplicabilityContentValidator
Verify that the applicability expression contains valid product values.
The product specified in Applicability column does not exist in the system.
PRODUCT $PRODUCT_VALUE specified in line $ROW_NUMBER in the Applicability column of $FILE_NAME does not exist and needs to be loaded into the product hierarchy. For example, PRODUCT Name specified in the line number 5 in the Applicability column of assembly.csv file does not exist and needs to be loaded into the product hierarchy.
1002
Error
com.ptc.csvtoinservice.validation.OrphanEntryValidator
Verify that every Document Code in the toc.csv file has a respective IE reference in the mapping file loaded in the same bundle.
Document code in toc.csv is not found in the bundle.
Add the Document Code $DOCUMENT_CODE that is specified in the toc.csv file to the bundle, if it is not already loaded.
1401
Error
com.ptc.csvtoinservice.validation.OrphanEntryValidator
Verify that all PartsList line items in the assembly.csv file have the respective part reference in the part.csv file (in the bundle).
Part code specified in assembly.csv is not found in part.csv.
Add Part Code $PART_CODE to the part.csv file.
1402