In this article, you will find out how to write a script which that will loop through all existing projects and save all project name names and project keys to a .csv file. . This script is compatible with Power Scripts for Jira for Server/DC/Cloud.
First, you have to assign allProjects() to a string which you will use to access all projects you have in Jira.
Code Block |
---|
string allpro = allProjects();
|
Then, you have to create a file where all project keys will be saved. You can also add columns “Project name” and “Project key” for clarification.
Code Block |
---|
//create a file with columns first
printInFile("sheet1.csv", + "Project Name " + " Project Key ");
|
Now, you have to loop through all existing projects. For this, we use the admProjectProperties(pkey) method.
Code Block |
---|
//loop through all existing projects here for(int x = 0; x < size(allpro); x++){ JProject prj = admProjectProperties(allpro.getElement(allpro, x)); // get project Key printInFile("sheet1.csv", prj.name + " " + prj.key ); // save data to a file runnerLog("Project Name : " + prj.name + " Project Key : " + prj.key); } |
...
After
...
you create the above script and run it, you should see
...
all project names and keys in the Editor console. Additionally, a .csv file will be created with the name “sheet1.csv” on the left in your Files.
...
You can also edit this script and adjust it to your needs using other data that is available to return when using admProjectProperties
. You can find more details here: projectObject
The final code should look like this :
Code Block |
---|
string allpro = allProjects();
//create a file with columns first
printInFile("sheet1.csv", + "Project Name " + " Project Key ");
//loop through all existing projects here
for(int x = 0; x < size(allpro); x++){
JProject prj = admProjectProperties(allpro.getElement(allpro, x)); // get project Key
printInFile("sheet1.csv", prj.name + " " + prj.key ); // save data to a file
runnerLog("Project Name : " + prj.name + " Project Key : " + prj.key);
} |