Question

5
Replies
413
Views
 Sudheer YLN (SudheerY1191)
wipro

wipro
IN
SudheerY1191 Member since 2017 5 posts
wipro
Posted: December 9, 2019
Last activity: December 9, 2019
Posted: 9 Dec 2019 0:16 EST
Last activity: 9 Dec 2019 20:25 EST
Closed

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.

Case Management Data Integration
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: 1 year ago
Posted: 9 Dec 2019 3:08 EST
Vikash Ranjan Karn (Vikash Karn)
PEGA
Senior Technical Solutions Engineer
Pegasystems Inc.
IN

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
Posted: 1 year ago
Posted: 9 Dec 2019 4:04 EST
Sudheer YLN (SudheerY1191)
wipro

wipro
IN

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..