Export reports to excel automatically

[Francesc Arbo]

Hello,

I have JIRA version 4.4. I need to export one filter result automatically to an excel.

Is there a way to do it such as an automated task from Windows or similar?

[Mizan · Accepted solution]

Hi ,

There is a similar question here

[Francesc Arbo]

Thank you. I didn't find the subscription option... I think that's what i need.

[tousifs]

Hi,

I think your working on Report plugin .

the Action or class we are defining for business logic there we have to add a single method as

public boolean isExcelViewSupported()
{
return true;
}

addition to that you can defined your excel export logic fro another method ExcelView you will be able to export data to excel.

not all data first you couldb be able to view the excel icon on your report then you have to defined business logic.

[Francesc Arbo]

What do you mean with Report plugin? There are several plugin for report but i'm not using a plguin for this.

[Midori]

With more recent developments, use Excel Automation Plugin and it will work on any operating system. Also, it will work within and be controlled by JIRA, not the hosting OS.

How it works: it will run a JIRA saved filter and export it to an XLS file periodically (very flexible, using CRON expressions) or when some event occurs (like creating an issue).

See the Excel automation tutorial for details.

jira-excel-automation-config.png

[Renjith Pillai]

I would say the easiest way is to have a windows scheduled job with wget with the filter url.

[Francesc Arbo]

Creating a .bat file?

[Renjith Pillai]

Yeah or directly type in the wget command into the Schedule Task window with the appropriate command line arguments.

[tousifs]

if you have any doubt can reply me. i had tried at my end and its working fine.

[Francesc Arbo]

Thank you. I hadn't too much time to try it but I'll try it today.

By the way, i've read in the net that another way is to extract it with wget. Which would be the "cleanest" way?

[tousifs]

plugin means when we add entry in atlassian-plugin.xml file then it is plugin if entry is of type report then its report plugin.