Category Archives: Web Tech

Formatting JIRA Issues List with XSL

I use JIRA allot but I don’t like how it formats it’s Issues List, and I’d rather provide my own formatting.

Now I believe you can apply templates to the actual JIRA website if you are an administrator, or if you know one, but in many occasions you might be out on a client site where you can’t do this.

However all is not lost you can simply Export the List as XML and work on it independently with XSL.

Jira Export to XML


I’ve created some XSL that will transform the XML into a nice webpage with comments included in the list.

Before you can apply the XSL you need to remove the top 11 line of the XML as this contains stuff you don’t need and that interferes with the XSLT process.

 more +11 %recent% > MyJiraReport.xml

Then you use msxsl.exe to transform you xml into a html file.

 msxsl.exe MyJiraReport.xml JiraIssues.xsl -o MyJiraReport.html 

You can download msxsl.exe from here

I’ve created a small DOS batch file that will do all this for you, it even picks up the most recent xml file in your download area. The xsl is there too.

Once opened in Chrome you can Print -> Save to PDF, and your report comes out really nice.

Patently, as this is html you can add all sorts of nice CSS to it. At the moment it’s quite plain but I’ve left a comment in the XSL,  so you can put the CCS reference in, if you want.


Ruby on Rails (RoR) and Mysql 5.5

I’ve been trying to install RoR and get it connected to my installation of MySQL 5.5.
To get started I downloaded the intsaller kit from here
I then followed this tutorial

As per the instructions I created my first project

rails new blog

And I updated my database.yml file to make a connection to MySQL in C:\Sites\blog\config\database.yml

 development:   adapter: mysql2   encoding: utf8   database: blog_development   pool: 5   username: root   password:   socket: /tmp/mysql.sock 

and I updated my Gemfile in the project’s root directory

 gem 'mysql2' 

So now all I have to do is to create a database with “rake”…

 rake db:create --trace 

But I get a horrible message!

rake aborted!
uninitialized constant Mysql2

This is an issue with the installation of the MySQL Gem adaptor so lets install it properly
Download and install the C mysql connector
Now run this

gem install mysql2 -- '--with-mysql-lib="c:\Program Files\MySQL\MySQL Connector C 6.0.2\lib\opt" --with-mysql-include="c:\Program Files\MySQL\MySQL Connector C 6.0.2\include"

Notice we make a reference to the newly installed C connector library.

copy libmysql.dll from above to the Ruby bin dir C:\RailsInstaller\Ruby1.9.2\bin

Now we can create our database….

 rake db:create --trace 

We should now have a database using the name from database.yml above.

Savings GMail’s to local PC

The latest Gmail web client comes with a plethora of add-ons. One of the most useful is the “Create a document” feature, which essentially turns your email into a Google Document and lets you download it to a local directory (in several formats). You can access and enable this function from the Settings “Labs” tab.

It is enabled by hitting “g” then “w”. Simply select an email and from “More” Create a document…

Now we have the email opened as a Google Document, which we can download to a local directory (in pdf format).

Now our email is stored away as a document and it cannot be tampered with as it’s a pdf.

Lastly, it’s worth noting that the document itself is also stored on-line in your Google Docs screen, which you can keep or bin.