Csv import with multi select field fails

Ulrik Nilsson
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 4, 2024

Hi

I want to use csv import to create issues. I fail to import some of the multi select fields.

The fields in the csv file is seperated by semi-colon.

 

The field Labels is working with two alternatives:

  1. Adding multiple values in one Excel cell, seperated by comma
  2. Adding multiple columns for field Labels with one value in each column

But none of the above works when I try to import the custom fields:

  • Definition Of Ready
  • Definition Of Done
  • To Do List

Validating the import returns the error:
"Issue can't be created due to the error/s [ Not a valid JSON object ]"

Any ideas very much appreciated.

Could it be something about specifying an array of multi property items as JSON?

This is the fields specs:

Name : Definition of Ready
ID : customfield_34898
ClauseNames : {cf[34898], Definition of Ready}
Schema : @{type=array; items=checklist-item; custom=com.okapya.jira.checklist:checklist; customId=34898}
Custom : True
Orderable : True
Navigable : True
Searchable : True

Name : Definition of Done
ID : customfield_34900
ClauseNames : {cf[34900], Definition of Done}
Schema : @{type=array; items=checklist-item; custom=com.okapya.jira.checklist:checklist; customId=34900}
Custom : True
Orderable : True
Navigable : True
Searchable : True

Name : To Do List
ID : customfield_34899
ClauseNames : {cf[34899], To Do List}
Schema : @{type=array; items=checklist-item; custom=com.okapya.jira.checklist:checklist; customId=34899}
Custom : True
Orderable : True
Navigable : True
Searchable : True

1 answer

1 accepted

1 vote
Answer accepted
Radek Dostál
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 4, 2024

See, that's the issue - these fields you mention here are custom from a plugin: com.okapya.jira.checklist:checklist

 

As such the values they accept is pretty much entirely plugin dependent and does not have much to do with Jira per se (some fields for instance do not even allow you to set a value directly and rather rely on other mechanisms to populate the values).

 

If I found the right page then they describe what values are supported in CSV imports here: https://doc.okapya.com/checklist-for-jira/exporting-importing-checklist-csv-data

Maxime Lefebvre _Okapya_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 4, 2024

Hi!

I am a developer on Checklist for Jira | Entreprise.

This is correct! Please take a look at our CSV documentation to know which type of values should be present in the field.

What kind of CSV you are importing? If you exported the CSV from the issue search screen in Jira, it should have already exported in the right data structure.

Regards

Like Dick likes this
Ulrik Nilsson
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 7, 2024

Thanks, you pointed me in the right direction.

Suggest an answer

Log in or Sign up to answer