Migrate dates from user created field to system date field

[philipf]

Hello,

I have a custom field "Due Date", which shouldnt have been used but was.

I would like to update all of the tickets that use 'Due Date', to use the system field 'Due date'

---

Is there a way for me to take all of the dates in 'Due Date' and transpose them to the system field 'Due date'?

[Avinash Bhagawati _Appfire_ · Accepted solution]

Hi @philipf Good day!

Please try below approach for your requirements.

1. Create a self transition in the workflow ( Self transition will transition the issue to any status to itself and this ensures there no change in the status).

2. Add a post function to copy the field from Custom field to system field. Here you can make use of any workflow app like JSU, JMWE to add a post function.

3. Publish the workflow.

4. Construct a JQL with required issues where you would like to migrate the data 

5. Perform bulk transition on the issues.

Note as bulk transition limited to 1000 issue for single iteration, you may need to do multiple iteration based on number of issues.

I hope this helps you !

Thanks,

Avinash 

[Trudy Claspill · Accepted solution]

Hello @philipf 

Another option is to create an Automation rule to gather the issues you want to update and use the Edit Issue action to copy the data from one field to the other.

You could use a Schedule trigger with a JQL statement that selects the issues where your field contains data and the system field is empty.

There are limits on how many issues can be processed in an automation rule, so you may have to run the rule multiple times.

https://support.atlassian.com/cloud-automation/docs/automation-service-limits/

[philipf]

thank you so much