I fully understand your frustation. I have to update more than 1300 projects and it takes us a couple of hours. This week I was again facing th problem and yesterday I decided to create an automated way to change the workflow scheme of projects. I'm mostly confronted with this problem when I want to introduce a new issue type with a dedicated workflow, which is not the default one. So I assumed in my solution that the workflow change doesn't affect existing issues, or in other words no statuses have to mapped between the workflows. It might be that you can extend the solution that is also remaps the statuses, but I haven't looked into it.
How does it work?
Selenium is capable of executing test scripts in a Firefox. A test script will simulate user clicks in the browser and I've written a piece of C# code that will generate the necessary test scripts which will simulate the necessary clicks for changing the workflow scheme for all the required projects. The scripts works with the project name and link (and doesn't assume a certain position in the browser), so projects that you don't want to convert will remain unchanged.
What do you need?
- Firefox
- Selenium IDE plugin for firefox
- Visual Studio Express C# (free edition)
- Jira 4.1 The solution was developed and tested on Jira 4.1. Solution might work on higher versions as long as the admin URLs in Jira remain unchanged compared to Jira 4.1
How to run the automation?
- Install Firefox
- Install Selenium IDE in Firefox
- Install Visual Studio Express for C#
- Make a text file containing per line the projects that you want to change
- ProjectA
- ProjectB
- ProjectC
- Make a visual studio console project and copy paste the attached code in Program.cs
- Adapt the first variable in the code public static string server = "http://myjira.mydomain.com/"; with the servername of your Jira instance
- Open the project properties and edit the debug properties. The command line argument property should contain the path to your text file with projects
- Run the program
- The test scripts will be generated in the same directory as your project text file.
- Open firefox
- Go to Jira and log in as administrator
- Go to the workflow scheme page
- In the Firefox Tool menu, select Selenium IDE
- In Selenium,in the File menu select Open test suite...
- Look for the 'Test suite.html' file and open it
- Press on play and enjoy!
The test script can fail when the project name contains special characters. On 1300 project I had only 8 faillures so I didn't adapt the code to deal with it.
If the solution doesn't fully work then I at least hope that it will help you in developing your own solution.
The piece of code:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
using System.Text.RegularExpressions;
namespace ConsoleApplication1
{
class Program
{
//Fill in the name of your server
public static string server = "http://myjira.mydomain.com/";
public static string BeginTestcase = "<html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\"><head profile=\"http://selenium-ide.openqa.org/profiles/test-case\"><meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" />" +
"<link rel=\"selenium.base\" href=\"" + server + "\" /><title>template script</title></head><body><table cellpadding=\"1\" cellspacing=\"1\" border=\"1\"><thead><tr><td rowspan=\"1\" colspan=\"3\">template script</td></tr>" +
"</thead><tbody><tr><td>open</td><td>/secure/admin/ViewWorkflowSchemes.jspa</td><td></td></tr><tr><td>clickAndWait</td><td>link=";
public static string EndTestcase = "</td><td></td></tr><tr><td>clickAndWait</td><td>id=select_workflow_scheme</td><td></td></tr><tr><td>select</td><td>id=schemeId_select</td><td>label=Barco Standard Workflow Scheme V3</td>" +
"</tr><tr><td>clickAndWait</td><td>id=associate_submit</td><td></td></tr><tr><td>clickAndWait</td><td>id=associate_submit</td><td></td></tr></tbody></table></body></html>";
public static string BeginTestSuite = "<html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\"><head><meta content=\"text/html; charset=UTF-8\" http-equiv=\"content-type\" />" +
" <title>Test Suite</title></head><body><table id=\"suiteTable\" cellpadding=\"1\" cellspacing=\"1\" border=\"1\" class=\"selenium\"><tbody>" +
"<tr><td><b>Test Suite</b></td></tr>";
public static string EndTestSuite = "</tbody></table></body></html>";
static void Main(string[] args)
{
if (args.Length == 1)
{
string filepath = args[0];
if (File.Exists(filepath) == true)
{
string path = Path.GetDirectoryName(filepath);
StreamReader projects = new StreamReader(filepath);
StreamWriter testsuite = new StreamWriter(path+"\\"+"testsuite.html");
testsuite.Write(BeginTestSuite);
string project = projects.ReadLine();
while (!String.IsNullOrEmpty(project))
{
//Remove illegal characters to get a correct file name
string testcasePath = createValidFilePath(path, project);
//Create a new test case for the project
StreamWriter testcaseFile = new StreamWriter(testcasePath);
testcaseFile.Write(BeginTestcase);
testcaseFile.Write(project);
testcaseFile.Write(EndTestcase);
testcaseFile.Close();
//Add the new test case to the test suite file
string newtestcase = "<tr><td><a href=\"" + Path.GetFileName(testcasePath) + "\">" + project + "</a>/td></tr>";
testsuite.WriteLine(newtestcase);
//Read the next project
project = projects.ReadLine();
}
testsuite.Write(EndTestSuite);
testsuite.Close();
}
else
{
Console.WriteLine("File not found:" + args[0]);
}
}
}
static string createValidFilePath(string path, string project)
{
string regexSearch = new string(Path.GetInvalidFileNameChars());
Regex r = new Regex(string.Format("[{0}]", Regex.Escape(regexSearch)));
string validProject = r.Replace(project, "-");
return path + "\\" + validProject + ".html";
}
}
}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.