Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to extract issue history through excel macro?

Naresh
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 26, 2020

Hi, I would like to extract issues history details through excel macro (VBA Script) to know how much time each issue spent in each stage. Please help. 

1 answer

1 accepted

3 votes
Answer accepted
Gökçe Gürsel {Appfire}
Atlassian Partner
July 27, 2020

Hi @Naresh ,

Welcome to the Atlassian Community! Is there a particular reason you want to use a VBA Script? Jira has various ways to extract issue history and time spent in each stage but I've not yet seen a VBA Script do this.

Depending on your hosting type I can point a couple of ways to do this:

  • If you're using Cloud, I suggest using the Script Runner or Cloud REST API to extract issue history. These are powerful tools that offer users versatile solutions.
  • If you're using Server, you can again various scripts but the most convenient way to use is Enhancer Plugin for Jira . It has the Time in Status custom field that is the best fit for your use case. You can also use this custom field for reporting and track a drill-down analysis based on the assignee field.

cf-statustimer-4.pngLet me know if you have further questions.

Cheers,

Gökçe

Naresh
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 27, 2020

Hi @Gökçe Gürsel {Appfire}

Thank you for your response! I need to check with our Admin if we are using Cloud or Server. Meanwhile, could you please share any any screen shot for how to access (where to find if it is there) Script Runner/API for cloud and Enhancer Plugin for server. 

I didn't know there something like these exist, that's why I was thinking of using VBA script. But in case if I have don't have access to these plug ins (sometime companies don't purchase all the plugins), is there any script I can use? 

Best

Gökçe Gürsel {Appfire}
Atlassian Partner
July 27, 2020

Enhancer Plugin is linked here: Link 

You can download it in your instance by navigating to Administrator menu > Manage apps > Find new apps > Type Enhancer Plugin for Jira

You Jira admin can set it up for you, just pass the name of the plugin to her/him.

As for the Cloud instance, Rest API is linked here: Link 

As for the script for Cloud, the community has some answers I'm sure. I'll link it when I come across it.

Cheers,

Gökçe

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events