While trying to process CSV files we get an invalid CSV file error, Fail (INVALID_CSV)
Workaround or Action Plan
-
Check if the files
detectionErrors.csv
PotentialTechnos.csv
technoFound.csv
technoOutOfContext.csv
UnknowTechno.csvare uploaded. They are not meant to be uploaded. They are for internal use.
Only the csv files in the <working Directory>/analysis directory should be uploaded.
Nothing in any of the analysis subdirectories should be uploaded. - This error is because the CSV file has been edited afterward, possibly opened and saved with Excel which changed the data structure.
Header of a working CSV:
#Framework
#uuid;081eef1d-e0db-42b4-b6dc-b0bb3673b3d5;126f9778-c154-4369-ad1d-b2203b696703;8265535d-2e1e-4db1-9a84-6a6fd482c3c8;80353e56-f9df-4244-b864-3f2008892611;182abc7f-6d8f-456d-a0b4-60893aafca1b;4edf9bdc-3ba3-4465-8928-9c4a75a2fcee;b40cba44-51d6-4ffa-8aa4-6f3ba7588a8f;18652d52-bc65-49a7-8bac-22abd05b5c41;cf807cbd-0e24-4b1b-bcbf-8a215fa62526;d9390b03-cce7-43b3-b3f5-54aa202a7937
#start_date;20201112_1153
#version_highlight;5.3.2-RELEASE
name;techno;min;max;module;module_version;type;environment;pattern;description;editor;license;analyzer_status;artifact;
Header of the CSV file shared by the customer:
#Framework,,,,,,,
#uuid;561c4378-e9a0-42a0-8a87-47ffeaa22369;d6afc3ef-d793-4f64-9e33-c5a84ef24732,,,,,,,
#start_date;20201113_1028,,,,,,,
#version_highlight;5.3.2-RELEASE,,,,,,,
name;techno;min;max;module;module_version;type;environment;pattern;description;editor;license;analyzer_status;artifact;,,,,,,,
It is recommended not to edit CSV files (with Excel) prior to uploading it to the portal.
Related Articles
CAST HIGHLIGHT - Results Upload - Manual Upload - Fail TECHNOLOGY_SCAN_NOT_FOUND
https://doc.casthighlight.com/CAST-Highlight-CodeScanBestPractices.pdf
Additional Resources
CAST Highlight Troubleshooting Guides
CAST Highlight Product Documentation
Zendesk Ticket Number
26494, 42116, 42471, 51814
Comments