Excel file in Jira Timesheet plugin is not getting downloaded in right way ?

Dipti Ranjan Behera
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 17, 2014

Hi ,

In Jira Timesheet gadget and report plugin , excel downloaded from report is carrying the name "ConfigureReport!excelView.jspa" instead of excel file name.

Is it fixed or the bug is still there ?

Regards,

Dipti Ranjan Behera

3 answers

1 accepted

0 votes
Answer accepted
Dipti Ranjan Behera
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 17, 2014

This is just a 4 LOC thing and it is taking so much time to fix .

Boris Georgiev _Appfire_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 17, 2014

You can always try fixing it yourself if you know where the problem is - probably /jira/secure/views/browser/report-excel.jsp

Dipti Ranjan Behera
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 17, 2014

@Boris,

The problem is not in the report-excel.jsp but in timesheetreport java class.

In method : 'generateReportExcel()' of above report class , the excel file name can be set.

Boris Georgiev _Appfire_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 17, 2014

So no solution in that case :(

Dipti Ranjan Behera
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 17, 2014

in that method , the report response we can set 'content-disposition' header parameter with the excel file name.

Content-Disposition: attachment; filename="fname.ext"

Andriy Zhdanov
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 17, 2014

Hi @Dipti,

How do you think excel file name can be set in generateReportExcel()? I will do this.

Thank you.

Dipti Ranjan Behera
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 17, 2014

@andriy,

Please use this method :

public String generateReportExcel(ProjectActionSupport action, Map params) throws Exception {
		validate(action, params);
		
		//call to process the report logic with selected paramters
		Map velocityParams = processRequest(action, params);
		StringBuilder contentDispositionValue = new StringBuilder(50);
		
		//Appending xls file extension with the report name
		contentDispositionValue.append("attachment;filename=\"");
		contentDispositionValue.append(getDescriptor().getName()).append(".xls\";");
		
		HttpServletResponse response = ActionContext.getResponse();
		response.addHeader("content-disposition", contentDispositionValue.toString());
		
		//Associating processed report data with excel VM context
		return descriptor.getHtml("excel", velocityParams);
	}
Andriy Zhdanov
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 17, 2014

Cool, thank you a lot from me and many others missing this, I've commited the fix for next update: 8366f85

Dipti Ranjan Behera
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 17, 2014

@Andriy:

u rock :)

Andriy Zhdanov
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 30, 2014

Version 2.7.9 with the fix is released.

0 votes
Dipti Ranjan Behera
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 17, 2014

@Boris,

The problem is not in the report-excel.jsp but in timesheetreport java class.

In method : 'generateReportExcel()' of above report class , the excel file name can be set.

0 votes
Boris Georgiev _Appfire_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 17, 2014

This bug seems to be still open https://jira.atlassian.com/browse/JRA-29687

Suggest an answer

Log in or Sign up to answer