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)
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***