Question

Virtusa
LK
Last activity: 16 Oct 2018 12:03 EDT
Unable to download the CSV file from server path and open blank in excel format
This issue is available in Pega 7.2.2 version and works as expected in Pega 7.1.7 version.
The CSV file is created using the Connect-File method and saved in Remote Server location (file://web:/Reports/). When the generated csv file is opened in remote location, data is available as expected. But when try to download the generated CSV file from the application, the content is not available. Here the file is downloaded with the correct file name that need to be downloaded. But the data is missing.
The Java code which is used to download the CSV file from the server path is given below.
String fileName = tools.getParamValue("FileName");
if (fileName == null || fileName.length() == 0) {
return true; // Nothing to download
}
boolean bDeletefile = Boolean.valueOf(tools.getParamValue("DeleteFile")).booleanValue();
String filePath="file://web:/Reports/";
pega_rules_default.downloadFile(com.pega.pegarules.pub.util.StringUtils.concat(com.pega.pegarules.pub.util.StringUtils.ASIS, filePath, fileName), tools, bDeletefile);
For further details and screen shots please refer the attached document.
Thanks!
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.