Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-15128

CSV Import Object Mapping follow Case Sensitive

XMLWordPrintable

      Issue Summary

      Object Mapping in CSV Import using LIKE and IN is Case Sensitive - should be case insensitive as per AQL Documentation

      This is reproducible on Data Center: (yes) / (no)

      Steps to Reproduce

      1. Create an Object Type: Superheroes with following Attributes
      2. Create an Object Type: AvengerGroup with following Attributes. Set the cardinality of 'Email-ID' and 'Contact-ID' to unlimited
      1. Create a CSV Import to import Object to Object Type: Superheroes. File: Superheroes.csv
      2. Create a CSV Import to import Object to Object Type: AvengerGroup. File: AvengerGroup.csv
      3. Set the Object Mapping as shown in the screenshot
      1. Import the Objects

      Expected Results

      Objects are imported with all Attributes updates irrecpective of Case Senstive

      Actual Results

      Object are imported but only those attributes are updated which has same Case Sensitive

      Workaround

      Make sure the Case Sensitivity is followed with the content in CSV

        1. Superheroes.csv
          0.2 kB
        2. Superhero-attribute.png
          Superhero-attribute.png
          91 kB
        3. Object-Mapping.png
          Object-Mapping.png
          91 kB
        4. Import-Superhero.mov
          31.25 MB
        5. Final-Import-Result.mov
          9.75 MB
        6. AvengerGroup-attribute.png
          AvengerGroup-attribute.png
          122 kB
        7. AvengerGroup.csv
          0.2 kB

              c8bcca445054 Benjamin Suess
              072fabfd41a3 Shreekesh Mohan
              Votes:
              2 Vote for this issue
              Watchers:
              6 Start watching this issue

                Created:
                Updated:
                Resolved: