I have a requirement to produce a regular excel report from Jira. I see how I can manually export to excel from a filter and I see how I can schedule a filter to run regularly and email a text report to selected users. Is there a way to automate the filter to generate an excel report daily or weekly?
@Philipp Suchan Just out of curiosity: did you go ahead and accepted your own answer at every question you posted this new information to?
Also, is this not against the Community Guidelines of "No necroposting", aka In general, avoid posting on old threads (six months or more old) simply to promote your products?
It's something community members like me used to get called out, so we try not to do it. The guidelines articles does say that it's for Marketplace Vendors and Solution Partners, so I just would like to understand if there is a double-standard here and how seriously Atlassian takes its own guidelines.
Something like this should work:
wget -O <friendly_name>.xls --ignore-length=on "http://<jira_server>/sr/jira.issueviews:searchrequest-excel-all-fields/<filter_id>/SearchRequest-<filter_id>.xls?tempMax=1000&os_username=<username>&os_password=<password>"
@justindowning Can you please help me replace the command with proper details:
like my jira url is : http://ontrack-internal-uat.com
I have made below command with my details:
wget -O <friendly_name>.xls --ignore-length=on
but unfortunately it is not working.
you need to do some replacements as per valid syntaxes.
like "wget -O <Output Filename>" is the actual syntax for wget -O<frienldly_name>.xls
so, with this URL it'll be written as:
wget -O Output.xls --ignore-length=on "http://jira.xyz.com/sr/jira.issueviews:searchrequest-excel-all-fields/..... and so on.
Excel Automation Plugin for JIRA makes automatically generating Excel exports from JIRA easy.
The idea is that it integrates the super-awesome Automation Plugin (a visual automation framework) and Better Excel Plugin (a customizable Excel generator for JIRA), enabling to define simple if-this-happens-then-generate-email-or-save-an-Excel-spreadsheet type of rules. (See the screenshot below about configuring a rule.)
See this article for a tutorial.
You can use eazyBI reporting application with JIRA integration which will perform regular JIRA import into eazyBI and then you can create reports, charts and dashboards from JIRA issues data. eazyBI provides also results export in Excel format.
When i execute this from command prompt in wget, i get this error message :
'os_username' is not recognized as an internal or external command,
operable program or batch file.
'os_password' is not recognized as an internal or external command,
operable program or batch file.
ANY HELP PLEASE ?
You could consider using Google Spreadsheets, that could also allow you to do the emailing automatically.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events