Bulk update custom field values on weekly basis

[Vidhya Mohan]

My requirement - 

I've a field deliverable code (drop down) which needs to be updated on a weekly basis. The values are obtained from another system and I need to import in JIRA.

The catch here is, some of the values of the previous week list might not appear in this week's list. So my field 'Deliverable ID' should only have the values of this week and not any of the past week values. 

The old issues that are tagged to past values, should still be tagged to the old value but the drop down should contain only new values.

any idea to achieve this? 

P.S - the number of values would be 500 or more each time

Regards,

Vidhya

[Hernan Halabi - Elite IT Consulting Group]

Hello @Vidhya Mohan I would consider one of these apps to achieve this.

https://marketplace.atlassian.com/apps/23337/elements-connect-external-data-fields?hosting=server&tab=overview

https://marketplace.atlassian.com/apps/1212096/customfield-editor-for-jira?hosting=server&tab=overview

First one would allow you to pull the information from another source and show it in Jira. Would be very useful if your information is on a database or similar.

Second option requires some extra development I suppose but you could update the information via REST API

[Vidhya Mohan]

Thanks @Hernan Halabi - Elite IT Consulting Group , is there any other way to do it without these apps? 

[Hernan Halabi - Elite IT Consulting Group]

No, without apps you would have to edit the field and add the options manually each week