CSV import fails to create reference objects when multiple objects are present in CSV import file separated with "||"

XMLWordPrintable

    • 2
    • Severity 3 - Minor

      Issue Summary

      CSV import fails to create reference objects when multiple objects are present in CSV import file separated with "||".

      Note- If the reference objects are present already then the Objects gets created fine with the correct reference attribute mapping.

      This is reproducible on Data Center: yes

      Steps to Reproduce

      • Create Object types for eg "Users" and "Groups". "Users" has a reference Attribute to "Groups" object type. 
      • Create one Object "Group1" under Group Object Type

      • Create a CSV Import file Like below. Notice that "user2" is mapped with "Group2" which does not exist and also "user3" is mapped with multiple Groups that are "Group2" and "Group3".

      • When we run an import of the CSV, below is our observation
        • As Group2 is passed as single value with User2 in the csv and since Group2 was not existing before, Group2 got created fine and User2 Object was created with mapping to Group2.
        • However, as User3 is mapped with multiple groups Group2 and Group3, but since Group3 does not exist, a new Group with the name Group2-Group3 is created.
        • Below is how the User Objects are created. User3 is only mapped with Group2.

       

      Expected Results

      If multiple reference object is passed in the import file separated by "||" does not exist already, those objects should be created separately.

      Actual Results

      If multiple reference object separated by "||" are not present in the system then importer considers them as one entity and created a single object, by replacing "||" with "-".

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available

            Assignee:
            Luke Ellis
            Reporter:
            Karan Ahuja
            Votes:
            9 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: