Using Jira's csv importer, how do I clear a date (e.g. Due Date)?

Question

Upon import I would like to clear out a date field on an existing issue. The field I'm using for testing is Due Date. I've tried "<>", "EMPTY", "NULL", "", "1970-01-01 00:00:00" and tried to manually map <> to a blank value with no success.

Brad Korber · Answer

Thanks.  I ended up doing exactly this last night, transition to itself that ran a post function and cleared resolution which also clears the resolution date.  ran bulk transition update and cleared all the issues I needed.  works like a charm.  crazy it is this convoluted.  thanks for the reply!

Matthew Mallard_stxny4 · Answer

IIRC, I used a groovy script I ran from the console.

There is an easier way to do it though by using a post-function in the issueType's workflow that goes from all steps to all steps. In the diagram it'll basically just look like it's pointing to itself. This still assumes you have an add-on capable of executing a clear field post function such as Jira Misc. Workflow Extension (JMWE), Jira Suite Utilities (JSU), Scriptrunner, etc.

The attached screenshots show an example using JSU.

Brad Korber · Answer

Did you find a solution?