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

[Dipti Ranjan Behera]

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

[Dipti Ranjan Behera · Accepted solution]

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

[Boris Georgiev [Appfire]]

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]

@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]]

So no solution in that case :(

[Dipti Ranjan Behera]

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]

Hi @Dipti,

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

Thank you.

[Dipti Ranjan Behera]

@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]

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

[Dipti Ranjan Behera]

@Andriy:

u rock :)

[Andriy Zhdanov]

Version 2.7.9 with the fix is released.

[Dipti Ranjan Behera]

@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]]

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