Download CSV file to another folder instead of ExportPath
We have a requirement to create CSV file and save that file to destination folder. We have this code but seems not working Code Snippet:
FileName+=fileNameParam; if(appendTimeStamp){ FileName+="_"; FileName+=dtu.getCurrentTimeStamp(); } FileName+=".csv"; String strSQLfullPath = exportPath+ sep + FileName; PRFile f = new PRFile(strSQLfullPath); try{ // Create file PROutputStream stream = new PROutputStream(f); PRWriter out = new PRWriter(stream, null, false); // Bug with Excel reading a file starting with 'ID' as SYLK file. If CSV starts with ID, prepend an empty space. if(CSVString.startsWith("ID")){ CSVString=" "+CSVString; } out.write(CSVString); //Close the output stream out.close();
Anyone have same scenario? please share solutions. thanks
Saudi azm
SA
Hi Mate,
To download a CSV file to a specific folder in Pega
Step 1: Create Dpage that holds CSV data that you want to download
Step 2: Create Activity >> used to download the CSV file to desired folder
--> Now in the activity, add "CSV-Stream" method step and configure it to stream contents of Dpage created in step 1
--> In the same activity add a Java method step and write the custom java code to save the file to desired folder, java code should take the contents of CSV file as input stream and write it to a file in desired location.
Step 3: Now save the activity and test it by running in a test environment.
Java code :
java.io.InputStream inputStream = tools.getPrimaryPage().getStream(".DataPageName"); java.nio.file.Path filePath = java.nio.file.Paths.get("C:\\FolderName\\FileName.csv"); java.nio.file.Files.copy(inputStream, filePath, java.nio.file.StandardCopyOption.REPLACE_EXISTING);
Note :
Replace :: Dpage name with name of your Dpage (Holds CSV data)
Replace :: ("C:\\FolderName\\FileName.csv") with desired path and name where you want to save your file.
Hope this helps you....! Happy Learning
Thanks,
Hi Mate,
To download a CSV file to a specific folder in Pega
Step 1: Create Dpage that holds CSV data that you want to download
Step 2: Create Activity >> used to download the CSV file to desired folder
--> Now in the activity, add "CSV-Stream" method step and configure it to stream contents of Dpage created in step 1
--> In the same activity add a Java method step and write the custom java code to save the file to desired folder, java code should take the contents of CSV file as input stream and write it to a file in desired location.
Step 3: Now save the activity and test it by running in a test environment.
Java code :
java.io.InputStream inputStream = tools.getPrimaryPage().getStream(".DataPageName"); java.nio.file.Path filePath = java.nio.file.Paths.get("C:\\FolderName\\FileName.csv"); java.nio.file.Files.copy(inputStream, filePath, java.nio.file.StandardCopyOption.REPLACE_EXISTING);
Note :
Replace :: Dpage name with name of your Dpage (Holds CSV data)
Replace :: ("C:\\FolderName\\FileName.csv") with desired path and name where you want to save your file.
Hope this helps you....! Happy Learning
Thanks,
Sudheer