Automatically convert an Excel table to a checklist for JIRA

3161323938_3bb7be6248_m
JIRA supports a subset of Wiki Markup to add tables and other formatting to fields like Description or Comments. Writing the Wiki Markup manually is a bit time consuming though. To make the process a bit easier I ended up writing a Macro that converts an Excel based task tracker list into JIRA.
From this:
jiraTable
Into that:
jiraWikiMarkup
Running the Macro will copy the Wiki Markup to the clipboard from where it can be pasted into JIRA.
The Macro relies on a mapping between Status values and supported Markup symbols and assumes that the selected cell is within the range that needs to be converted before running the Macro. The VBA project requires the following additional references:

  1. Microsoft Scripting Runtime (for the Dictionary object)
  2. Microsoft Forms 2.0 Object Library (for the DataObject to provide the copy to clipboard functionality)


A Workbook containing the example can also be downloaded from GitHub.

shareThoughts


Photo Credit: chantrybee via Compfight cc

Advertisements

I'd love to hear what you think

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s