In this article you will find out how to write a script which will loop through all existing projects and save all project name and project keys to a .csv file.
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);
}
After refreshing you should see file sheet1.csv which you can download.
You can also edit this script and adjust it to your needs using other data that is available to return when using admProjectProperties more details here :