Can't Create more than one object when importing CSV file to Jira Insight

[Helen]

When I import a csv file of 30 some new objects to an object type in Jira Insight, the import only created one new object at each try. I can't find any wrong delimiter in the csv file. Anyone knows where I should look to solve this problem?

[Helen]

I recreated import configurations and mappings from scratch, somehow the import started working. Still don't know what caused the problem before, I guess my repeated tweaking of an existing configuration might generated some system confusion.

Also a lesson is not to mix importing existing objects' update with new object addition, since the new object has the "Key" column empty.

@Ismael Jimoh , @Humashankar VJ , thank you both for your great help!

[Ismael Jimoh]

You are welcome Helen.

Glad to hear that this has been resolved.

Regards

[Ismael Jimoh]

Hi @Helen 

As you are on data centre, I’ll recommend generating a support zip that includes asset and reviewing what it says.

 Also, Check your mapping of what is the unique entry on import.

[Helen]

Thanks! Not sure what is a support zip?

And, all entries are new and unique.

[Ismael Jimoh]

Hi @Helen 

This is a support zip: https://confluence.atlassian.com/support/create-a-support-zip-790796819.html.

I suspect you aren’t the administrator of the instance so I’ll recommend asking your administrator to help with this.

 Secondly, I’ll emphasise checking the mapping of your import. when new entries aren’t being created, this will be what I’ll first check to ensure that it matches what is in your CSV.

Make sure the name of the mapped data columns in your CSV match what is in the data field in the import configuration.

Let me know what happens when you have reviewed this

[Humashankar VJ]

Hi - I hope that you are Doing good !!

-Double check that you have correctly mapped the columns in the CSV file to the corresponding fields
-Could be constraints or validation rules defined within Jira Insight and cause this issue.
-If the data in the CSV file violates any of these constraints, will turn outcome in one object creation

One other try is all about new subset - may be smaller
-Try importing smaller subsets of the data to see if the issue persists
Hope this helps

Thank you very much and have a fantastic day!
Warm regards

[Helen]

Thanks a lot for such a quick help. 

The csv file was an exported csv. So its mapping seems fine. When importing that csv with object update and new entries, the update worked fine. The new entries got one created only.

Then I dropped all existing objects from the csv, only kept the new ones without the key column, still could only create one.

Then I dropped all columns for the new objects, only kept the name column, still could only create one.

[Ismael Jimoh]

That’s such a weird behaviour. Could you do me a favour and do the following:

1. Create a new CSV file with a single columns test name

 2. enter 3 random entries

 3. confirm a new import and map the name column to the name/title attribute (make sure it’s the only attribute and it is set as the unique identifier)

4. Attempt the import of the said file.

 Let us know the result of this as it gives us all a little to work with.

 Also let us know your exact version of JSM and insight

[Helen]

Below are the test csv file and import result. The result said there were three duplicated objects based on external id. But none of the names existed in the type. Only the last one, dag-4, got imported.

In other tests with more than one columns, the object created got wrong values from other rows also. 

Not sure where to find the Insight version, Jira version is below. Also I'm waiting for a Jira admin to give me the support.zip or jira log.

Jira v9.6.0  

[Ismael Jimoh]

Could you share a screenshot of your configured mapping for the importer?

Something like the below where the checked identifier entry is the : 

Also, share the importer configuration and also open the csv in a text editor(not excel) so we can ensure that the delimiter for separation matches the configuration.

Thanks.