|
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
|