Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Get all projects schemes in CSV format

Andrew
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 4, 2019

Hi @All here !! 

Extend my previous post https://community.atlassian.com/t5/Enterprise/Get-user-roles-from-all-projects-in-CSV-format/gpm-p/1068800

So what is the problem when you manage a large number of projects? This is a lot of schemes and settings.

I was tasked to change several schemes, but this should not affect the scope (call it projectsA).

Hmm .... for that, I have to check that these schemes are not installed for pojectsA. It's simple, if you have 10 projects and 4 schemes, and not when there are a hundred.

I thought it would be easy if I had one table with all the projects and its schemes.

I wrote a GEB script for this purpose. The script accumulates all the name schemes in a single CSV file. Now everything is in one place and you can do the filtering.

tableProj.PNG

For example, we can now filter 'workflow scheme' and get a list of projects that will be affected. And we can use the Excel function to find duplicates with our 'projects A' and filtered.

Link to source code: https://git.andrewsite.ru/blob/JiraGebAuto.git/master/JiraGebAuto.groovy


I also added project deletion methods to the script, be careful! Use it only if you know groovy.

I hope this post was helpful.

1 comment

Comment

Log in or Sign up to comment
Jonas Fischer
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 9, 2019

Hey @Andrew

Unfortunately the link to the Git does not work. Can you put the code in here? That would be nice ;) 

Andrew
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 10, 2019

Hi @Jonas Fischer ,

Sorry for long time answer. Please use very careful because script has methods to delete items. Check first on test env.

https://github.com/AndrewDvizhok/JiraGebAuto

B.R.

Like Dave Liao likes this
Jonas Fischer
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 10, 2019

That works ! Thank you.

TAGS
AUG Leaders

Atlassian Community Events