CSV Import Object Mapping follow Case Sensitive

XMLWordPrintable

    • 5
    • Severity 3 - Minor

      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. AvengerGroup.csv
          0.2 kB
        2. AvengerGroup-attribute.png
          AvengerGroup-attribute.png
          122 kB
        3. Final-Import-Result.mov
          9.75 MB
        4. Import-Superhero.mov
          31.25 MB
        5. Object-Mapping.png
          Object-Mapping.png
          91 kB
        6. Superhero-attribute.png
          Superhero-attribute.png
          91 kB
        7. Superheroes.csv
          0.2 kB

            Assignee:
            Benjamin Suess
            Reporter:
            Shreekesh Mohan
            Votes:
            2 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: