Recipe overview

This recipe provides step-by-step instructions on how the opening of a Blocker highest priority ticket can trigger the automatic creation of a HipChat room in order to communicate about that ticket. This facilitates quick resolution to critically important tickets and ensures effective communication to all interested parties occurs. This recipe assumes that either the usernames or display names of your JIRA users matches that of your HipChat users.

You will need JIRA Administrator permissions to your JIRA instance in order to complete this recipe.

It will take you approximately 12-13 minutes to complete this recipe.

Recipe level

Table plus
border 0 heading 0 multiple false enableHeadingAttributes false columnAttributes style="border:0;width=5%;",style="border:0;width=65%;",style="border:0;width=30%;max-width=30% !important;" enableSorting false class ingredients_table enableHighlighting false

Ingredients

Table plus
border 0 heading 0 multiple false enableHeadingAttributes false columnAttributes style="border:0;width=5%;",style="border:0;width=65%;",style="border:0;width=30%;max-width=30% !important;" enableSorting false class ingredients_table enableHighlighting false
JIRA HipChat Run CLI Actions in JIRA Div class more_info Try it Free Div class more_info Documentation

Preparation

• N/A

Steps

.*\b(?:acquire|acquisition||acquisitions|merger|mergers|aquire|aquisition|aquisitions)\b.*

hipchat --action runFromRoomList --common "--action getRoomHistoryList --room \"@room@\" --file chatreferences.csv --append --regex \".*\b(?:acquire|acquisition|acquisitions|merger|mergers|aquire|aquisition|aquisitions)\b.*\" " 

Execute HipChat CLI command

In your command window, type the command from the previous step and press Enter.

The command will run, showing the result of executing the GetRunHistoryList action against each public HipChat room (3 rooms in our example).

Per the HipChat CLI instructions, your hipchat.bat or .sh file contains a --token parameter which supplies the API Access token of a HipChat user. Be sure to use the token of a user who has access to all of the public rooms you wish to monitor.

Run: --action getRoomHistoryList --room "ExampleGear Engineering" --file chatreferences.csv --append --regex ".*\b(?:acquire|acquisition|acquisitions|merger|mergers|aquire|aquisition|aquisitions)\b.*" 
2 history entries in list appended to file: chatreferences.csv
Run: --action getRoomHistoryList --room "ExampleGear HR" --file chatreferences.csv --append --regex ".*\b(?:acquire|acquisition|acquisitions|merger|mergers|aquire|aquisition|aquisitions)\b.*" 
1 history entries in list appended to file: chatreferences.csv
Run: --action getRoomHistoryList --room "ExampleGear Marketing" --file chatreferences.csv --append --regex ".*\b(?:acquire|acquisition|acquisitions|merger|mergers|aquire|aquisition|aquisitions)\b.*" 
0 history entries in list
Run completed successfully. 3 actions were successful 

Example CSV file:

"Room","Message Id","Date","Type","Message Format","Message Color","Message","From Id","From Name","From Mention Name","Link Name","Link URL","Link Type"
"ExampleGear Engineering","d75f884d-f5b0-4aa4-ba2c-d273d9da682b","2015-03-25T10:54:04.082-0400","message","","","That'll look great to Acme's auditors as they try to decide whether to follow-thru on the acquisition!","1928057","Hank Johnson","hjohnson","","",""
"ExampleGear Engineering","218e7533-b2b5-40da-91f4-6ff1f9534940","2015-03-25T12:29:59.647-0400","message","","","Whoops, @hjohnson! Everything is hush hush about that subject. There can be absolutely no talk about mergers or acquisitions in public rooms.","1915328","Jasmine Stone","JasmineStone","","",""
"ExampleGear HR","ed202752-f46f-40a9-85a8-ea6c09accda0","2015-03-25T10:42:10.755-0400","message","","","When the acquisition goes through, will HR provide training and guidance to managers on how to communicate the details to their staff?","1915328","Jasmine Stone","JasmineStone","","",""

Create Confluence page

Create a Confluence page that will display the chatreferences.csv file in a table so others can easily review what your language monitoring revealed.

The page consists of 2 items:

1. An introductory paragraph that describes the purpose of the page or anything else the viewer ought to know.
2. The CSV macro, which is part of the Advanced Tables for Confluence add-on, configured with the parameters shown on the right.

Save the page, and take note of the space key and the page title.

The space key appears in the URL of the page after you've saved, immediately after "display/". For instance, in the URL http://wiki.examplegear.com/display/EGM/HipChat+Monitoring, the space key is EGM.

Edit view of the page:

Image Removed

Create Confluence CLI command

Use the command shown on the right to attach the chatreferences.csv to the Confluence page you just created,

• confluence indicates to invoke the Confluence CLI client.
• The addAttachment action indicates to attach a file to a Confluence page.
• The --title parameter provides the Confluence page's title.
• The --file parameter provides the name of the file to be attached. (This will generally match what you used on the previous HipChat CLI command.)

To do this, log on to your JIRA instance as a JIRA Administrator and do the following:

1. From the Cog menu (Image Added), choose Add-ons.
2. In the Run CLI Actions in JIRA section of the left navbar, click Configure. The Configure RUN CLI Actions in JIRA screen will be displayed.
3. Define a new entry with the parameters set as shown to the right.
   1. The Name parameter defines the name of the entry, which you will later reference when running a CLI action from a workflow (as in this recipe) or the Run CLI Actions screen.
   2. The Value parameter defines how to access your HipChat instance.
      
      1. Replace <URL> with the URL to your HiipChat instance.
      2. Replace <TOKEN> with the token of the HipChat user you want to "own" the HipChat room that will be created when a Blocker ticket is opened.
4. Click Save to save the user defined substitution variable.

Configure Run CLI Actions in JIRA screen, after defining new variable:

Image Added

Create a JIRA project to use with this recipe

In this step, you are going to create a project you will use when making and testing the workflow change that creates a HipChat room.

1. From the Projects menu, choose Create Project.
2. In the Select Project Type screen, select Simple Issue Tracking and click Next.
3. The second screen shows the Issue Types that will be used (Task and Sub-task). Click Select.
4. The third screen prompts you to supply a Name and Key for your new JIRA project.
   1. Use Run CLI Actions in JIRA as the Name.
   2. Use RCAIJ as the Key.
   3. Click Submit to create the project, with you set as its Project Lead.
5. If you click Create and choose Run CLI Actions in JIRA as the Project and Task as the Issue Type, you will see a Create Issue screen like the one shown to the right. Only 3 fields (Project, Issue Type, and Summary) are required, as indicated by the red asterisk next to their field labels. There are 2 optional fields: Priority and Description. Click Cancel to close this screen.

Image Added

Create a draft workflow

In this step, you will edit the workflow used by the Run CLI Actions in JIRA project so you can begin the process of adding the Run CLI Actions post function that will create a HipChat room when a Blocker ticket is opened.

1. From the Cog menu (Image Added), choose Projects.
2. Click the Run CLI Actions in JIRA
   link to display the Project Summary page which shows how the project is configured.
3. In the Workflows section of the page, click the pencil icon (Image Added) next to the RACIJ: Simple Issue Tracking Workflow link to edit that workflow.
4. Click the Image Added button so that the workflow is shown in Text mode rather than Diagram mode.
5. Click the To Do link in the Step Name column. The Step: To Do screen is displayed.
6. Click the Create link shown to the left of the To Do step to open the Transition: Create screen.

Image Added

Transition: Create screen:

Image Added

Add a post function on the Create transition

In this step, you will add a post function on the Create transition. In a later step, you will configure this post function.

From the Transition: Crreate screen, do the following:

1. Click the Post Functions tab to display the post functions. Your screen
2. Click the Add post function link to display the Add Post Function To Transition screen.
3. Select CLI action and then click Add.
4. The Add Parameters To Function screen will be displayed.

Image Added

Add Post Function To Transition screen:

Image Added

Configure the post function, part 1

In this step, you will begin configuring the post function you just added to the Create transition so that tickets of the highest priority will trigger the creation of a HipChat room.

From the Add Parameters To Function screen, do the following:

1. Set the parameters as shown to the right.

   1. Condition 1 indicates that the post function should be executed only when the ticket being created as a Priority = Highest.
      

      Note
      title Highest vs. Blocker priorities
      Beginning with JIRA 6.4, the highest priority is now named Highest. In earlier versions, it was named Blocker. If you are using a version of JIRA earlier than 6.4, please substitute "Blocker" wherever you see "Highest" in this recipe. You might want to view the priority values defined in your instance to ensure you are specifying the correct and exact name. Please note that this name is case sensitive when supplying it in the post function parameters.

       

   2. Product indicates that HipChat CLI commands will be executed.
   3. Action indicates that the run action will executed so multiple commands (as defined in the Data parameter) can be invoked. The %variable_hipchat% indicates to substitute the Value you provided for the hipchat variable defined on the User Defined Substitution Variables screen in step 1.
   4. Data defines the commands to be invoked, with each appearing on their own line.
      1. Line 1 creates a new HipChat room with a name that contains the key of the Blocker issue and a description that indicates it is to be used to discuss the ticket.
      2. Line 2 adds the reporter as a member to the new HipChat room.
      3. Line 3 adds the assignee as a member to the new HipChat room.
      4. Line 4 writes an initial message to the room to reiterate its purpose to the members and ask that they invite others to join this room as appropriate.
   5. Notes is an internal comment that serves to document what the post function does.
2. Click Add to save your changes to the parameters and add the Create Issue post function. You will be returned to the Transition: Create screen.
3. Your screen should now look like the screenshot shown to the right.

Condition 1	Image Added
Product	HipChat
Action	--action run %variable_hipchat%
Data	Line 1: --action createRoom --room "%original_key% Room" --topic "Discussion of %original_summary%" Line 2: --action addRoomMembers --room "%original_key% Room" --name "%original_reporter%" Line 3: --action addRoomMembers --room "%original_key% Room" --name "%original_assignee%" Line 4: --action sendMessage --room "%original_key% Room" --message "This room is to discuss this Highest priority issue created on %original_created%: %original_key%. Please invite others to join this room as appropriate."
Notes	This post function creates a new HipChat room for any new Highest priority ticket so that any conversation about it can be centralized and communicated to interested parties.

Transition: Create screen, after adding the Create Issue post function:

Image Added

Configure the post function, part 2

In your command window, type the command from the previous step and press Enter.

The command will run, showing the result of executing the addAttachment action.

Per the Confluence CLI instructions, your confluence.bat or .sh file contains credentials for a Confluence user. Be sure to use credentials of a user who has read/write access to your Confluence page.

this step, you will move the new Create Issue post function so it is executed after the Blocker issue is created and then you will publish the workflow so you can test it.

From the Transition: Create screen, do the following:

1. Repeatedly click the Down Arrow icon (Image Added) next to the CLI Action post functoin until the post function is below the "Creates the issue originally" post function. This will ensure the Blocker issue is created before the CLI Action post function is executed.
2. Your screen should now look like the screenshot shown to the right.
3. Publish your draft workflow by clicking the Publish Draft button at the top of the screen. The Publish Draft Workflow screen will appear.
4. When prompted whether to save a backup copy, click Yes and then click Publish.

Image Added

Test the post function

In Confluence, navigate to the page you created to verify the chatreferences.csv file is now attached to the page and it reflects the contents of that file.lIf this page was already open in your browser, you may need to refresh the pagethis step, you will verify the post function is working as intended.

1. Click the Create button to create a new issue. The Create Issue screen will appear.
2. Fill in the fields as shown on te right and click Create. A popup window similar to the one shown on the right will appear to confirm the issue was created.

Image Removed

Create a reusable CLI script

Div
class time
Status title Optional Estimated Time: 2 min

If you'd like to save your CLI commands for later reuse, you can save them as a CLI script file.

Using an editor capable of producing a plain text file, such as Notepad (Windows) or TextEdit (Mac), create a script file named:

• For Windows: monitorRooms.bat
• For OS X/Linux: monitorRooms

Save it in the same folder to which you installed the HipChat and Confluence CLI clients and make sure it has permissions so that you can read, write and execute it.

Follow these steps in your command window to execute the script file you just created:

1. Navigate to the folder to which you installed the HipChat and Confluence CLI clients.

2. Type the name of the script file as shown on the right and press Enter.

The script will run, showing the result of executing each action.

hipchat --action runFromRoomList --common "--action getRoomHistoryList --room \"@room@\" --file chatreferences.csv --append --regex \".*\b(?:acquire|acquisition|acquisitions|merger|mergers|aquire|aquisition|aquisitions)\b.*\" " 
confluence --action addAttachment --space "EGM" --title "HipChat Monitoring" --file chatreferences.csv 

Command to execute reusable script file:

monitorRooms