How to clear existing user field values through an external system import?

[Andrew Zimmerman]

Hi there,

I'm attempting to update a large group of existing issues via an External System Import (CSV). During this import I'd like to empty out/clear out the values of different custom user fields on existing tickets. I'm having trouble with this. Is there a certain format for those I need to adhere to when setting up my CSV to signal Jira to clear out these field values?

Thanks so much!

[Trudy Claspill]

Hello @Andrew Zimmerman 

What have you tried so far that has not worked?

[Andrew Zimmerman]

Hi, @Trudy Claspill !

I've tried importing the values as blanks (no data in cell within CSV) and I've tried importing the values with 

<<!clear!>>

Both to no avail. Thanks for any ideas! 

[Trudy Claspill]

What type of fields are you trying to clear; text, number, selection list, user picker, ...?

And what version of JIRA Server are you using?

[Andrew Zimmerman]

Hi @Trudy Claspill,

I'm trying to clear a user picker field, and I'm on Jira Server 8.14.0

Best,

Andrew 

[Trudy Claspill]

Unfortunately I have not found any additional information about how to clear a user picker field during a csv import. I recommend that you open a support case directly with Atlassian Support.

[Andrew Zimmerman]

No worries. Thanks for looking, Trudy. I'll reach out to Atlassian directly.