Question
EY
ES
Last activity: 14 Apr 2020 2:03 EDT
Pega Cloud: Export data to CSV using a report definition to get info from different tables and store the file in SFTP folder
Hi,
This is a Pega Cloud environment, and the requirement is to export in a csv file data from different tables and store it in a server folder that is syncronized with SFTP folder.
I believe that I need to create a Report definition to get the data from the different tables (using association classes to join them) .
To export the data into a csv file I've read different approaches, maybe the best is to copy pxConvertResultsToCSV activity and customize it.
But all the questions were related to UI, and this has to be a batch thing that stores the generated csv file into a folder in the server that is syncrhonized with SFTP folder.
I'd like to know if there's any way in activity's step 5 of using the path that I need to write into the server folder.
Can anyone give me a little advice on this? Is there any better approach to implement this?
Thanks in advace
Updated: 14 Jun 2021 7:38 EDT
Pegasystems Inc.
IN
I think we can try using Connect-File method in Activity.
Please find the below article which might be helpful.
https://collaborate.pega.com/question/connect-file-method-unable-write-data-file-server-path
EY
ES
Hi all,
As my report takes columns from different tables, in the parameter CSVProperties I had to define the properties from other tables (joined by an association class) as follows:
.pxPages(IHChannelDimension).pyChannel
I've been able to create the file in the SFTP folder by removing 2nd java step copied from pxConvertResultsToCSV and replace it by using D_pxNewFile from Repository API.
I've set the Local.CSVString generated by first java step as .pyContents of the Data Page and then save it.
Here you have attached images of my final activity just in case it can help someone else