How to print out all project keys

In this article, you will find out how to write a script that will loop through all existing projects and save all project 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.

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.

//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.

//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 :