How specify multiple flags in CSV import?

[_mwk]

Imagine that I have a Jira project with three flags: A, B, C. I want to assign and remove flags to existing issues using the CSV update mechanism. How do I specify multiple flags per issue row in a CSV import?

I tried using a "Flagged" column and delimiting the flags with commas (per export), e.g.

Key,Flagged
JIRA-123,A
JIRA-456,B
JIRA-789,"A,C"

but got a new flag instead (e.g. now I have four flags: A, B, C, "A,C").

What I would expect for that last row is that flag A and C would be set in JIRA-789 and flag B would be unset (even if, previous to import, it was set, i.e. its non-inclusion would signal Jira to unset that flag).

[Charlie Misonne · Accepted solution]

You will have to create multiple columns with the same name in your CSV.

Every column should get 1 value only. So in your case:

Key,Flagged,Flagged
JIRA-123,A,
JIRA-456,B,
JIRA-789,A,C

You can read about this on Import data from a CSV file 

[_mwk]

But then how do you specify removal of a flag?

[Charlie Misonne]

If you upload this CSV, is flag A not removed from JIRA-123?

Key,Flagged,Flagged
JIRA-123,,
JIRA-456,B,
JIRA-789,A,C

[_mwk]

Ah... duh, yes, you're right. So if you specify any Flagged columns, you have to specify all the flags for each issue. Thank you for your time and effort @Charlie Misonne.