• Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Low Low
    • None
    • 4.22.7
    • Assets - Import

      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

      1. Create a CSV file with one of the fields having a value like "<html" or "abc<html"
      2. Try to configure CSV Import and upload the file
      3. Click on "Test Configuration"

      For Existing CSV Import Configuration,

      1. Create a CSV file with one of the fields having a value like "<html" or "abc<html"
      2. 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.

            [JSDSERVER-11985] Insight CSV Import file containing "<html" fails to synchronize

            Marc Dacanay made changes -
            Labels New: ril
            Marc Dacanay made changes -
            Remote Link New: This issue links to "Internal ticket (Web Link)" [ 955657 ]
            SET Analytics Bot made changes -
            UIS Original: 1 New: 0
            SET Analytics Bot made changes -
            UIS New: 1
            SET Analytics Bot made changes -
            Support reference count Original: 5 New: 6
            SET Analytics Bot made changes -
            Support reference count Original: 4 New: 5
            SET Analytics Bot made changes -
            Support reference count Original: 2 New: 4
            Alec Bignell made changes -
            Assignee Original: Alec Bignell [ 344ed8f58f8f ]
            SET Analytics Bot made changes -
            Support reference count Original: 1 New: 2
            Alec Bignell made changes -
            Status Original: Needs Triage [ 10030 ] New: Gathering Impact [ 12072 ]

              Unassigned Unassigned
              f75285566e0c Prabhu Subramaniyan
              Affected customers:
              3 This affects my team
              Watchers:
              3 Start watching this issue

                Created:
                Updated: