Question

1
Replies
1112
Views
CloeW938 Member since 2018 143 posts
IT Solution Service
Posted: September 30, 2018
Last activity: October 3, 2018
Closed

How to populate page list from CSV file

Hi,

I need to populate a page list from CSV file. I found an OOTB activity in @baseclass called "pxUploadCSVResults" but I am unable to figure how to use this for my requirements. Let me describe the requirements in detail as below:

I have a page list, in a work type. Let's say, work type is PurchaseRequest and page list is ItemList, with class of MyCo-MyApp-Data-Item. In this data class, we have ItemID, ItemName, and ItemHowMany, and ItemPrice. And we have a CSV file that will look like:

1001, Pen, 2, 1.0
1010, Eraser, 1, 0.5
1022, Keyboard, 1, 12.0
1030, Mouse, 2, 8.5

I want to have a button on Section where user clicks to upload above CSV file into page list of specific PurchaseRequest work type. So after upload, my expectation is to have below data structure:

pyWorkPage.ItemList(1)
pyWorkPage.ItemList(2)
pyWorkPage.ItemList(3)
pyWorkPage.ItemList(4)

and each page list has all data from CSV file. In this case, what exactly should I put for parameter?
Also, how should I configure the button? When I simply use Refresh Section, Pega gives me below weird output.

Thanks,

***Updated by moderator: Lochan to update platform capability***

Data Integration User Interface
Moderation Team has archived post
Share this page LinkedIn