Question

How to upload Excel file data to Clipboard

Hi All,
How to upload/extract Excel file data to Clipboard so that i can repeat that using page list.

Comments

Keep up to date on this post and subscribe to comments

Pega
December 9, 2019 - 1:03am

Pega
December 9, 2019 - 2:02am

December 9, 2019 - 3:08am

Hi Sudheer,

 

Not sure what your exact requirement is but below is one of the suggestions that can be used if you want to have the excel data in the clipboard (not uploading the excel data at runtime) :

 - Create a Data Type with the properties that you want to be populated with the excel.

 - Import the data from the excel (you will get the option to map the properties with the columns in excel while importing).

 - Once you have created a Data  Page and imported the data you will be having the data in the local and a Data Page of type Page List (which gets created by default). This data page can be used in your use case.

 

Regards,

Vikash

December 9, 2019 - 4:04am
Response to Vikash Karn

Hi Vikas,
Thanks for the suggested approach,  I can achieve with your solution, I am mostly trying to get this work using "pxUploadCSVResults" Flow action.

I'm getting Null Pointer Exception inspite passing the Page name dynamically to the Activity(pxUploadCSVResults) after customizing. But the results are negative. Any suggestions please..

December 9, 2019 - 8:25pm
Response to SudheerY1191

Could you please add the screen-shots showing what modification you have done and also provide the complete stacktrace from Pega-RULES log file.