Could we generate a report into excel/scv based on client code, with all the related issues?

[Yi Voon Phan]

Hi, 

Could we generate a report (excel/csv) based on client code, with all the related issues? And these issues are listed with each of the progress and worklog details / description (can be without worklog time) so that we can report the progress and client know exactly what has been done for every issues, who is the assignee, when is the target completion date, remaining estimate and etc. Thank you.

[Tarun Sapra]

Hello @Yi Voon Phan

We use Better excel (paid plugin) to generate some pretty advance report. Including worklog details( time spent in each status etc).

Plenty of templates available here 

http://www.midori-global.com/products/better-excel-exporter-for-jira/template-gallery

[Deleted user]

Hi @Yi Voon Phan,

Yes, you can generate a CSV file for the JIRA issues. 

For exporting issues you can export to .csv by following these steps:

1. Go to the issues and click on search for issues.
2. Write a JQL depends upon on the requirement. 
3. On the top right of your screen, click on the "Export" drop down.
4. You can export via Printable, Full Content, RSS, CSV, XML, Word or Dashboard Charts.
5. If you want with the all the field values then please select the CSV(All fields).

Please see below screenshot for reference.

Regards,

Gangavath Kishore kumar.

[Yi Voon Phan]

@[deleted] Hi Gangavath, noted on your proposed solution. But are we able to have this jira issues with JQL extension, by incorporating the "worklog details/description" for each of the issues the programmer worked on? Because when the client look at the issues, they would want to know what has been done for the particular issue as well, apart from the estimated completion time, due date and etc. Basically it is a worklog report + jira issues (JQL). 

[Deleted user]

Hi @Yi Voon Phan, 

Yes, it will include all the field details like the due date, work logs, Remaining time and description. I am providing one sample screenshot for the description, work logs, due date and Remaining time. 

 

If you are looking for a more advanced future then you can go for Better Excel Exporter for Jira (XLSX) add-on. 

Regards,

Gangavath Kishore Kumar.