Question

5
Replies
1672
Views
IsharaD3 Member since 2016 1 post
Virtusa
Posted: 3 years ago
Last activity: 2 years 9 months ago
Closed

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.

Data Integration Java and Activities
Moderation Team has archived post
Share this page LinkedIn