How to create 2 or more insight objects of the same object type during Import
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
This article explains on how to create 2 or more insight objects of the same object type from each record in the insight import file.
Insight has options to combine two cells into one object. But when the requirement is exactly the opposite, where the user needs multiple objects (of the same object type) to be created for every single record from the import file, there is no standard approach for this as the import configuration does not allow multiple entries for the same object type.
Solution
Workaround
Though the import configuration does not allow it, the workaround to achieve this is by the creation of multiple import configurations for the same import file. And include different objectType configurations for the same object.
For example, imagine we want 6 objects to be created in this case.
Username | Monitor1 | Monitor2 |
|---|---|---|
user1 | MON-1-TypeA | MON-4-TypeB |
user2 | MON-2-TypeA | MON-5-TypeB |
user3 | MON-3-TypeA | MON-6-TypeB |
In this case, we want to create multiple monitor objects via a CSV file.
Create a new ObjectType 'Monitors' with attributes for the objectType Monitors as below.
2. Go to ObjectSchema > Configure > Import > and create 2 import configurations one after the other, by providing the required details.
Do NOT create pre-defined structures or predefined configurations.
3. Add the ObjectTypeMapping for the first Import where we create objects for Monitor1 as below.
4. Add ObjectTypeMapping for the second Import where we create objects for Monitor2 is as below.
5. Enable the mappings and Import configurations for both.
6. Perform synchronization for both imports. After the completion of sync, we will have 6 objects created in total as below from a 3 record CSV file.
NOTE:
Though the above approach works and helps you create multiple objects from one record, However, the recommended approach is to fix the CSV file or source data to include the records for each of the desired objects in insight.
There are known impacts from using this workaround, Which is that the missing objects will be ignored.
Was this helpful?