How to parse CSV into page list
Hi,
We need to take in CSV file (see below), and create a work. One CSV file becomes a single work object, and I want to make a page list from a number of multiple lines inside a CSV file. For example, CSV looks something like this:
ProductID, ProductName, Price
004, Eraser, 1.5
010, Pen, 1.2
002, Note, 2.0
050, Pencil, 0.5
File Listener finds this file and start an activity pyStartCase under MyCo-MyApp-Work-PurchaseRequest class. I konw how to create a file service and service package using a Service Wizard.
What I do not know is, how to parse CSV into Page List. I searched PDN and found some related articles like below but not quite.
https://community.pega.com/knowledgebase/articles/how-parse-comma-separated-values-csv-file-using-file-service
I believe I need to use Parse Delimited rule and Parse XML rule but I am not sure how. What is the simplest and easiest way to achieve this? Could someone describe the detail?
Thanks,
CollabPartnerz
IN
Hi,
below link might help you.
https://collaborate.pega.com/question/how-convert-comma-separated-string-pagelist-activity
PEG
PL
Hi,
You can follow the below screenshot to have a parse delimited rule. I also assume you need to create case for every record.
sample request in the csv file could be like :
1,P1,product1,12
2,P22,product2,15
hope this helps.
Adaps
IN
Use Apply Parse delimted activity method on a page reference (you can check any out of box parse delimeted references to find out how to configure) to parse the string data in to clipboard. This will map the data in to whatever the properties you mentioned in the delimeted rule.