-
Bug
-
Resolution: Unresolved
-
Low
-
None
-
4.22.7
-
6
-
Severity 3 - Minor
-
0
-
Issue Summary
CSV import in Insight ends up with an error when one of the field values has the value "<html" or if the value "<html" is part of any other value such as "abc<html".
This is reproducible on Data Center: yes
Steps to Reproduce
- Create a CSV file with one of the fields having a value like "<html" or "abc<html"
- Try to configure CSV Import and upload the file
- Click on "Test Configuration"
For Existing CSV Import Configuration,
- Create a CSV file with one of the fields having a value like "<html" or "abc<html"
- Try to Synchronize the CSV Import
Sample CSV File below:
"Key","Object Type","Label","Employment start date","htmltest" "SHA-7","Manufacturer","Apple",,abc<html
Using the below values didn't cause any errors:
<htm, <ht, <abc
Once we use "<html" anywhere in CSV we start seeing this behavior.
Expected Results
"Test Configuration" (or) Import Synchronization completes successfully
Actual Results
The below exception is thrown in the insight_import.log file:
2022-09-20 20:53:24,338 [http-nio-44221-exec-17] | Error when importing objects with DefaultImportService, Error: ValidationInsightException: Validation errors were found: connectionFailed: ErrorMessage{i18nKey='The file that was selected is not a valid CSV file.', parameters=[], additionalMessage=null};
com.riadalabs.jira.plugins.insight.common.exception.ValidationInsightException: ValidationInsightException: Validation errors were found: connectionFailed: ErrorMessage{i18nKey='The file that was selected is not a valid CSV file.', parameters=[], additionalMessage=null};
at com.riadalabs.jira.plugins.insight.services.imports.common.DefaultImportService.testConnectionWithConfiguration(DefaultImportService.java:367)
at com.riadalabs.jira.plugins.insight.services.imports.common.DefaultImportService.testConnection(DefaultImportService.java:348)
at com.riadalabs.jira.plugins.insight.services.imports.common.DefaultImportService.testConnection(DefaultImportService.java:324)
at com.riadalabs.jira.plugins.insight.services.imports.common.DefaultImportService._startImport(DefaultImportService.java:579)
at com.riadalabs.jira.plugins.insight.services.imports.common.DefaultImportService.startImport(DefaultImportService.java:262)
at com.riadalabs.jira.plugins.insight.channel.web.api.rest.services.imports.ImportResource.startImport(ImportResource.java:104)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
In the UI you will get the error message "The file that was selected is not a valid CSV file."
Workaround
Avoid using "<html" in the CSV file.
- links to
