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 KeyIssue IDRequirement ProposalSpec DiscussionSystems ReviewMSADCC-33934281411/21/20193/4/20193/11/2019MSADCC-34274281752/25/20194/15/20194/22/2019MSADCC-34284281762/25/20194/15/20194/22/2019MSADCC-34314281791/21/20193/4/20193/11/2019MSADCC-34324281801/21/20193/4/20193/11/2019MSADCC-34334281813/18/20194/15/20194/22/2019MSADCC-34344281823/11/20194/8/20194/15/2019MSADCC-34354281831/0/19001/0/19001/0/1900MSADCC-34644282122/13/20193/18/20193/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

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Bulk Update Script?

tueda_2v25s2

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

Accepted answers

Ravi Varma

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

All comments

Ravi Varma

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.

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_2v25s2

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

Screen Shot 2019-03-07 at 6.46.15 PM.png

tueda_2v25s2

Got it !

Thanks, Teru

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-service-desk