Excel refusing to open files? Blame the KB 3115322, 3115262 security updates in your Windows… (see this) As always, Excel is causing a lot of problems… Microsoft Excel is not trustworthy… ( see this ) Then, the solution to open the HTML exported JIRA files (Excel files) in your computer is this: Open Excel Go…
Read MoreHow to change the issue creation date in JIRA
You have two options: Change it using CSV Import (more info) Change it using a database Update (more info, depends on the version of JIRA)
Read More7 useful add-ons for JIRA administrators
Awesome add-ons for JIRA administrators Are you a JIRA administrator and feel that your tasks are getting repetitive? If you wish there were tools to make your admin easier, you’ve come to the right place – in this blog I’ll be highlighting a number of add-ons for JIRA administrators that can help you with daily admin…
Read MoreHow to remove the Clone Issue option in JIRA
Very easy! First, go to the Project Administration of your target project to remove the option. Then, go to the Field Configuration ( all of them if there are more than one). Edit the “description” of the “description” field ( or some customfield that is visible in the project screens). Add this “javascript” code in…
Read MoreHow to get the required team hours from JIRA Tempo plugin with groovy
As many of you know, to get the “required” & “reported” hours of a Tempo Timesheet Team (in JIRA), don’t exists a REST Web Service interface to get these values… But, exist and “old” “hack”-trick to do this using the mystical “CURL” (in this example case calling cull in the bash shell, running the process inside…
Read MoreCalculate the SLA with Scripted Field in ScriptRunner for JIRA
Very easy! Create the required TimeStamps custom fields to fill with a Listener or a PostFunction with Groovy Scriptrunner with a CODE like this Then create a Groovy Scripted Field in JIRA to calculate the SLA (ANS in spanish). You can follow this instructions to create the HTML field Put a code like THIS: That’s…
Read MorePermissions based on Workflow Status in JIRA
In the Workflow transition properties you can set diverse permissions restrictions like this: jira.permission.comment.group=group jira.permission.comment.denied=true/false jira.permission.edit.group.1=group1 jira.permission.edit.group.2=group2 jira.permission.modifyreporter.user=username jira.permission.delete.projectrole=10000 jira.permission.subtasks.delete.projectrole=10000 jira.permission.close.user=username jira.issue.editable=false … You can see more permissions and terminology in this link
Read MoreHow to restrict resolution options in JIRA
Very easy! Edit the Workflow transition to “CLOSED“ Click on “Properties“ Add this pair “key – value” jira.field.resolution.include = id_resolution_1, id_resolution_1023, .. That’s all!
Read More
My first Magazine
I’m trying to do a “Magazine” … ^^ it’s hard… and tedious :S LINK: https://madmagz.com/magazine/783896
Read MoreExport More than 1000 Issues to Excel from Issue Navigator in JIRA
Symptoms By default both JIRA issue navigator and REST API return a maximum of 1000 search results. Hence when exporting to Excel, JIRA will only export the first 1000 issues. Cause The maximum allowable value is dictated by the JIRA property ‘jira.search.view.default.max’ which is set to 1000 by default. Unfortunately it is not possible to…
Read MoreSet a countdown to your Banner Announcements for maintenances in JIRA
Set in the Announcement banner of jira a code like this:
Read More
Jirasupport Toolkit for Awesome JIRA Admins
Hi people, My new plugin is coming! If your JIRA is a large instance, you probably use & abuse of the Web browser functionality : “search”… for customfields, workflows, workflow schemes, permissions schemes, views, DVCS repos … with this plugin, this functionality is added in the top buttons of each view of the project administration artifacts…
Read More
www.MrAddon.com ®: Jira & Confluence Administration Support Blog 