Unable to import CSV with a multi-select field.

[Sandy Greenberg]

I am trying to bulk import via CSV.  One of my fields is a custom multi-select field with mapped values.  Every line of the CSV that has multiple values for the multi-select field errors with:  [ You cannot specify 'None' as an option together with other options ]

The documentation says: 


And my CSV looks like this:

I've spent a half a day now trawling Google and these community pages with no luck on a solution.  I cannot see a fix unless in frustration I change the field type to a 'labels' type but I'd rather not.  Any ideas?

[Bill Sheboy]

Hi @Sandy Greenberg -- Welcome to the Atlassian Community!

I just tried a CSV import with both partially selected and no selected options for a multiple-select option field and that worked for a Company-managed, Software project where the field was global / company-managed.

Perhaps you have a different configuration impacting the behavior...

What type of project are you using?

• Company-managed or team-managed
• Business, Software, JPD, JSM, etc.

And, for any team-managed or JPD projects, what type of field are you using?

• a global, company-managed one, or...
• a project-specific, team-managed one

Kind regards,
Bill

[Bill Sheboy]

One more thing to check...

You show an image of your CSV file in some spreadsheet tool.  When you view the plain text of the actual CSV file, does it contain None values for the empty ones, or nothing (i.e., just the comma separators)?