In this exercise of the eazyBI training we want to mix the content of an Excel file with our Jira issues using an Account/cube of the one of the most famous plugins for Business Intelligence and Analytics for Atlassian Jira called eazyBI. First we need an Excel file of course, we will use a column…
Read MoreTempo Timesheets for Jira Software SQL worklogs extraction query
We have talked about the Servlet extraction of worklogs: How to extract an Excel report from Tempo Timesheets using an URL We have talked also about the Tempo API REST worklog extraction using groovy: How to list your Jira Tempo Teams and members in a Confluence page Jira Groovy example script to get Tempo Teams…
Read MoreHow to extract an Excel report from Tempo Timesheets using an URL
It’s very easy! Just use an URL like this: https://yourserver.yourdomain/plugins/servlet/tempo-getWorklog/?dateFrom=2019-01-01&dateTo=2019-01-31&format=excel&diffOnly=false&tempoApiToken=my-token (here the documentation of the Servlet) remember to set the dateFrom, dateTo params The ApiToken you can find it in the Apps section of Jira, on Tempo “Access Control” option
Read MoreThe power of eazyBI for Crypto Analysis
What is eazyBI and what it’s for eazyBI is a powerful visualization and analysis add-on for Jira Server and Jira Cloud. With eazyBI you can create custom reports, charts, and dashboards with an easy-to-use drag-and-drop interface. eazyBI can be used no only for Jira but for any other data sources We can import standard or…
Read MoreHow to create a Heat World Map in Jira with eazyBI
In this example, we want to explain how we can create a Heatmap (Worldmap) using eazyBI (in this case for Jira). As prerequisite we need a CSV with at least 3 fields: one for the ID of the row and other two fields for the longitude and geographical latitude. We need a special dimension for the…
Read MoreAutomatically Import Jira Backlog Into Google Spreadsheet
Amazing post of bluemonkey, see here
Read MoreEnlarge your Excel export for JIRA IS BACK!
Good news people! The plugin “Enlarge Your Excel Export” is back for the new JIRA Server 7.4 version! The new JIRA 7.4 has available again the HTML export! (The old Excel Export), and as always, the export is limited. With this plugin, you will export all the result issues of your JQL query! Very easy…
Read MoreHow to create a Gantt report to track/plan Projects with Jira and eazyBI
In this article I want to show you how to track/plan a list of Projects of Jira with the plugin eazyBI. And… it’s very easy! We have two possibilities to track the Start Date of a project: We can create a custom field of type “Date” and show that field in the screen of the…
Read MoreThe new features of JIRA Software Server 7.2
The most important new features of JIRA Software Server 7.2 are these: The WYSWYG Editor!! Very good The “FLAG & COMMENT” option in the Kanban boards. Very useful! The “Attach Screenshot” option now is missing. But you can Paste pictures inside the Description field and in the comments! Great! The “Export Excel” from Issue Search…
Read MoreImportant news in Enlarge Your Excel Export for JIRA plugin
Hi people, Since JIRA 7.2.x the plugin “Enlarge Your Excel Export” is not necessary. Now Atlassian have changed the “Excel export” button for new one called “CSV export”, without exporting limits…. See the JIRA 7.2.x release notes …. I doesn’t agree with Atlassian and how changes the existent functionalities ….. Why change the export format ¿?…
Read MoreYour JIRA Excel export is refused to open by your Excel?
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 MoreEnlarge JIRA Excel Export (new plugin)
In large instances, the list of issues in the search view should be limited by the Administrator, as a consequence, the Excel export is limited too…. With this plugin, a new option is shown to export up to 10000 issues with the current fields of the current view, search or filter. VERY HELPFUL SURE Works in…
Read More