Skip to main content
Contact a Moderator

Question

3
Replies
519
Views
 Lakshmi C (Lakshmi) Cognizant
Cognizant
IN
Lakshmi Member since 2018 3 posts
Cognizant
Posted: April 9, 2018
Last activity: April 30, 2018
Posted: 9 Apr 2018 10:07 EDT
Last activity: 30 Apr 2018 4:26 EDT
Closed
Solved

how to export data to excel using RDB list method

Hello Team,

I am connecting to Cloud SQL database and getting data using RDB list method and able to get results on clipboard i.e LolRepeatsPage.pxResults and same reference i have used to show data on Repeating grid shown in the attached document.

I have an requirement to show the data and export the same in excel format. Since i am not storing the results in local pega database what is the best way to export the data in excel format.?

i have used 'pxConvertResultsToCSV' OOTB activity and able to export the data in the csv format but the last 3 digits chaging to zeros.

Please refer the attached file for more details and kindly let me know if any other OOTB activity can be used?

Thanks.

Data Integration Java and Activities
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 4 years ago
Posted: 10 Apr 2018 23:27 EDT
Vikash Ranjan Karn (Vikash Karn) PEGA Senior Technical Solutions Engineer
Pegasystems Inc.
IN

Hi Lakshmi,

 

There are 2 approaches that you can try:

1. Use pxResultsConvertCSV activity and make use of LolRepeatsPage.pxResults which is available on the clipboard.

2. Use MSOGenerateExcelFile OOTB activity instead of pxResultsConvertCSV activity and add the Excel Template and pass the parameter.

Please try one of the above approach and let me know if it works fine.

 

Regards,

Vikash

 
Posted: 4 years ago
Posted: 11 Apr 2018 4:07 EDT
Lakshmi C (Lakshmi) Cognizant
Cognizant
IN

Hi Vikas,

Thanks for replying.I am using 'pxResultsConvertCSV' OOTB activity and using parameters from 'LolRepeatsPage.pxResults' page,but the last 3 digits in 'MersMin' changing to zeros as mentioned in the attachment.

Thanks,

Lakshmi

Accepted Solution

Posted: 4 years ago
Posted: 13 Apr 2018 9:13 EDT
Lakshmi C (Lakshmi) Cognizant
Cognizant
IN

Hi Vikas,

Get it done by using  binary file creation and calling GenerateMSOExcel OOTB activity approach.

Thanks,

Lakshmi

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice