export JIRA to excel

[shaz cv]

Hello I am trying to export a JIRA to Excel regularly using a crontab.I can do it manually using JIRA UI to change the view and export to excel However I want to know is there any way to automate it. I mean can we have a subscription for filter to have a custom view (in mycase subscribe excel view of filter) . I saw a wget command that can do the export using crontab but that did not work If someone can help giving me the proper command that would be great

[dleng]

I'd go with something like

wget -O myfile.xls --ignore-length=on http://localhost:8080/sr/jira.issueviews:searchrequest-excel-all-fields/<filter_id>/SearchRequest-<filter_id>.xls?tempMax=1000&os_username=<username>&os_password=<password>>

Or you can just refer to this link for some cool examples: https://confluence.atlassian.com/display/JIRACOM/Automating+JIRA+operations+via+wget

[Midori]

You can do this totally in JIRA (instead of an external cron job): use the Better Excel Plugin to export your data and then use the Excel Automation Plugin to set up an export automation rule with a cron trigger.

Here is a full tutorial: http://www.midori-global.com/products/jira-better-excel-plugin/documentation/automation

jira-excel-automation-rule.png

jira-excel-automation-rule.png