Question
American Express Services Europe Ltd
GB
Last activity: 17 Dec 2018 7:59 EST
Extension missing while exporting data into Excel
Hi,
We are using ExportToExcel ootb activity to export data into excel sheet. The downloaded file has no extension also the file name is coming like "!PS2__TABTHREAD1".
Is there anyway we can set the extension as well as give a file name please?
Before calling this ootb activity we are setting the data into Param.pyFileData using Property-Set-HTML method.
This extension is not working with Chrome and Edge where as in IE 11 we see the extension, but the file name is same in all browsers. Currently our application running on 8.1.1 version (upgraded from 6.3 -> 7.3 -> 8.1.1) .
Issue persists in 7.3 as well.
Thanks,
Veera
Accepted Solution
Pegasystems Inc.
GB
So looking at @baseclass.ExportToExcel (PegaRULES-07-10-23) - on a 7.4 system; the Activity seems responsible for downloading the data - rather than generating it; its a single java Step that contains the following:
String strFileData = tools.getParamValue("pyFileData");//getPrimaryPage().getValue("pySrc");
ClipboardPage objHeadersPage = tools.findPage("pxRequestor").getProperty("pyHTTPResponseHeaders").getPageValue();
if (objHeadersPage != null)
{
objHeadersPage.putString("contentType" ,"application/vnd.ms-excel");
tools.getThread().getThreadPage().putString("pyXMLStream", strFileData);
}
else
{
tools.getThread().getThreadPage().putString("pyXMLStream", "Can't get \"pxRequestor.pyHTTPResponseHeaders\" page");
}
So I haven't tried this myself - but you could look at using the Engine API 'sendFile' (there are a few variations):
https://community.pega.com/sites/default/files/help_v74/javadocs/index.html
I'm not sure what format the 'pyFileData' property is (I guess it must be either base64 encoded for a binary file - or possibly just HTML or XML).
Can you do a SAVE-AS on the OOTB 'ExportToExcel' (its not a 'Final' Activity , so you can customize); and then log the contents of the 'pyFileData' to establish what type of content it is ?
Assuming the content is HTML or XML - held in a String, you could try replacing the Java code with this:
So looking at @baseclass.ExportToExcel (PegaRULES-07-10-23) - on a 7.4 system; the Activity seems responsible for downloading the data - rather than generating it; its a single java Step that contains the following:
String strFileData = tools.getParamValue("pyFileData");//getPrimaryPage().getValue("pySrc");
ClipboardPage objHeadersPage = tools.findPage("pxRequestor").getProperty("pyHTTPResponseHeaders").getPageValue();
if (objHeadersPage != null)
{
objHeadersPage.putString("contentType" ,"application/vnd.ms-excel");
tools.getThread().getThreadPage().putString("pyXMLStream", strFileData);
}
else
{
tools.getThread().getThreadPage().putString("pyXMLStream", "Can't get \"pxRequestor.pyHTTPResponseHeaders\" page");
}
So I haven't tried this myself - but you could look at using the Engine API 'sendFile' (there are a few variations):
https://community.pega.com/sites/default/files/help_v74/javadocs/index.html
I'm not sure what format the 'pyFileData' property is (I guess it must be either base64 encoded for a binary file - or possibly just HTML or XML).
Can you do a SAVE-AS on the OOTB 'ExportToExcel' (its not a 'Final' Activity , so you can customize); and then log the contents of the 'pyFileData' to establish what type of content it is ?
Assuming the content is HTML or XML - held in a String, you could try replacing the Java code with this:
try {
byte[] byteArray=strFileData.getBytes("UTF-8"); //nb. should check this encoding is correct
String result=tools.sendFile(byteArray,"Excel.xls",false,null,true); //hardcoded output name
}
catch(Exception e) { throw new PRRuntimeException(e); }
To test this with fake file data; just set the strFileData to some simple HTML before getting the bytes
String strFileData="<html><table><tr><td>hello</td></tr></table></html>";
For an example of using 'sendFile' API - see CODE-PEGA-PDF.View
Hope this helps,
Thanks,
John
American Express Services Europe Ltd
GB
Hi John,
Thanks for your message.
We are updating Param.pyFileData with an HTML content and calling the ExportToExcel activity.
I did try the code you have given but unable to save the rule due to below error.
Java at step: 1 line: 3
strFileData cannot be resolved
Compile failed.
But i think we should add one more line at the beginning.
String strFileData = tools.getParamValue("pyFileData");
I am able to save the rule in application ruleset and tested. The file downloaded with the name Excel.xls.
It worked. Thank you very much!
Thanks,
Veera