-
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
[JSDSERVER-11985] Insight CSV Import file containing "<html" fails to synchronize
Labels | New: ril |
Remote Link | New: This issue links to "Internal ticket (Web Link)" [ 955657 ] |
UIS | Original: 1 | New: 0 |
UIS | New: 1 |
Support reference count | Original: 5 | New: 6 |
Support reference count | Original: 4 | New: 5 |
Support reference count | Original: 2 | New: 4 |
Assignee | Original: Alec Bignell [ 344ed8f58f8f ] |
Support reference count | Original: 1 | New: 2 |
Status | Original: Needs Triage [ 10030 ] | New: Gathering Impact [ 12072 ] |