It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

CSV-Import: How to import NULL-Value ?

I want to update some issues using the CSV-import in JIRA. Some custom fields shall be NULL.

JIRA-Version: 6.2.6

Type of custom field: simple text field

I tried this:

"issuekey", "summary", "customfield1"
"MYISSUE-2001","My Summary", ""

and also

"issuekey", "summary", "customfield1"
"MYISSUE-2001","My Summary",

But the value of my customfield don't want to change to NULL/"". What I have to do?

Thanks!

2 answers

1 accepted

0 votes
Answer accepted

Hi Mathias,

To clear existing values you can put <<!clear!>>, which is a "magic singal" to clear existing value of the field. You can read more about it under https://confluence.atlassian.com/display/JIRA/Importing+Data+from+CSV- "Updating existing issues" section.

Cheers,

Przemek

Thank you! Works perfectly...

Hello, Thanks but it doesn't work for me.

0 votes
Nic Brough Community Leader Jun 10, 2014

What type of field is it?

It is a simple text field.

Nic Brough Community Leader Jun 10, 2014

Ok, well, you don't want to import a null. "" is an empty string, and that should import nothing (an empty custom field in Jira doesn't have an entry at all in the database - there's no lines to put a null into)

Yes, you are right, Nic.

Hm, but how can I set the value to an empty string? It seems that JIRA ignores this values and do nothing...

Nic Brough Community Leader Jun 10, 2014

Sorry, I'm lost. Using "" should leave the field empty when you import the issue. Not sure what else you are looking for?

"" doesn't work. The field is not empty...

Nic Brough Community Leader Jun 10, 2014

So what does the import put in the field when you use ""?

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Off-topic

Friday Fun: Virtual dance party!

Do dance parties help you relieve stress? How about *virtual dance parties*? My team holds virtual dance parties to brighten the mood of a tough day or celebrate an upcoming weekend.  Want t...

147 views 21 8
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you