Question
Virtusa
Virtusa
IN
Virtusa
Posted: Dec 12, 2018
Last activity: Dec 27, 2018
Last activity: 27 Dec 2018 12:56 EST
Closed
Excel file name displaying junk values for Russia and Greek language when generating Excel file using ExportToExcel OOTB Activity.
In our project we have a requirement to generate Excel file for searched results.We have using ExportToExcel OOTB Activity to generate the excel file and also defined the Excel file name manually.But for Russian and Greek languages we are getting junk values for Excel File name.For other languages the Excel File Name displaying correctly.
We are using Pega 7.3.1.
We have changed the Java codes slightly for our need which as follows:
String strFileName = getParameterValue("FileName");
String strFileData = getParameterValue("pyFileData");//getPrimaryPage().getValue("pySrc");
Page objHeadersPage = getProperty("pxRequestor.pyHTTPResponseHeaders").getAsPage();
if (objHeadersPage.isBound())
{
objHeadersPage.setValue("contentType" ,"application/vnd.ms-excel");
objHeadersPage.setValue("ContentDisposition",
"attachment; filename=\"" +strFileName+"\"");
sendData("", strFileData);
}
else
{
sendData("","Error. Can't get \"pxRequestor.pyHTTPResponseHeaders\" page");
}
In my analysis maybe it need slight change in java codes.
Posted: 5 years ago
Pegasystems Inc.
US
Hi Rakesh
Check out this link.
You may have to muck with language for non-unicode in your system as described in the post.
Thanks,
Bhuvana.