Bulk Update Script?

[tueda]

Hi,

Is it possible to execute bulk update using excel file like this?
(Assumption: requirement proposal date, spec discussion date, systems review date are defined in Jira already.)

Issue Key	Issue ID	Requirement Proposal	Spec Discussion	Systems Review
MSADCC-3393	428141	1/21/2019	3/4/2019	3/11/2019
MSADCC-3427	428175	2/25/2019	4/15/2019	4/22/2019
MSADCC-3428	428176	2/25/2019	4/15/2019	4/22/2019
MSADCC-3431	428179	1/21/2019	3/4/2019	3/11/2019
MSADCC-3432	428180	1/21/2019	3/4/2019	3/11/2019
MSADCC-3433	428181	3/18/2019	4/15/2019	4/22/2019
MSADCC-3434	428182	3/11/2019	4/8/2019	4/15/2019
MSADCC-3435	428183	1/0/1900	1/0/1900	1/0/1900
MSADCC-3464	428212	2/13/2019	3/18/2019	3/20/2019
...	...	...	...	...

I know it can't be done using bulk update screen.
I was trying scripting, but can't find appropriate template yet.

Thanks, Teru

[Ravi Varma · Accepted solution]

Hi @tueda ,

It is possible. You should be using CSV import feature. You need to provide Issue Key  (OR) Issue ID ( you don't need both), similar to what you have documented above.

As part of the import process, you will navigate through a set of four screens which allows you to provide the necessary input details like CSV file location, pre-existing mapping file if available, date format etc.

Please refer the following Atlasssian documentation for further details - https://confluence.atlassian.com/adminjiracloud/importing-data-from-csv-776636762.html

Hope this helps.

Regards,

Ravi Varma

[tueda]

Thanks, Ravi !

Yes, the article helps very much !

One question, if I include issue key in csv file, then I should map it to issue key (jira field) in import mapping screen, right? Actually, our import screen doesn't show issue key. I think it is our environment setting probably, so will ask admin to change it.

Regards,
Teru

[Ravi Varma]

Hi @tueda ,

Yes, it should be mapped as Issue Key option under Issue Fields.  The Issue Fields options are available out of the box and you should be able to see it anyways. Please refer to the below screenshot for further reference

[tueda]

Got it !

Thanks, Teru