Csv import with multi select field fails

[Ulrik Nilsson]

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

[Radek Dostál · Accepted solution]

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_]

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

[Ulrik Nilsson]

Thanks, you pointed me in the right direction.