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)?

[Sandy Greenberg]

Hi Bill. 
Company Managed (I'm an admin), Software, and it's an out of the box custom field.  

To your second question, no.  That was the first thing I checked.  Here's the raw data:

STP Requirements,Description,Summary,Issue Type,STP Requirement Source,STP Requirement Type,STP Release,STP Associated Page/Component,STP Platform,STP Platform,STP Platform
CP_CCB_010,A Container - Banner which features Autoplay Clips / Trailers must feature basic playback controls ie play/pause and mute/unmute.,CP_CCB_010 - A Container - Banner which features Autoplay Clips / Trailers must feature basic playback controls ie play/pause and mute/unmute.,Requirement,Component,Accessibility,Release 2,Container - Banner,Android Mobile / Tablet,iOS / iPadOS,Web
CP_CCR_025,"The image ratios in a Content Rail (ie 16:9, or Portrait) must be maintained if a user invokes the 'View all' overlay.","CP_CCR_025 - The image ratios in a Content Rail (ie 16:9, or Portrait) must be maintained if a user invokes the 'View all' overlay.",Requirement,Component,Product,Release 1,Container - Content Rail,Android Mobile / Tablet,iOS / iPadOS,Web
CP_BDG_003,A Content - Brand item must support displaying a 'Live' badge'. This badge can show only on homepage hero and brand page hero,CP_BDG_003 - A Content - Brand item must support displaying a 'Live' badge'. This badge can show only on homepage hero and brand page hero,Requirement,Component,Product,Release 1,Attributes - Badges,All Major Platforms,,

[Bill Sheboy]

@Sandy Greenberg -- Sorry for the delay in responding as I was offline for a bit.

If the sample file you show has that error /symptom and all of the choices are valid options (including "All Major Platforms"), I do not know what would cause this.

If you are on a paid license level, I recommend working with your Jira Product Admin to submit a ticket to Atlassian Support at the link below.  (Only Product Admins and Org Admins can submit tickets.)

https://support.atlassian.com/contact#/

When you hear back from them, please post what you learn to benefit the community.  Thanks!