How to populate data to a Pagelist , whenever a CSV File is Uploaded through UI ?
Business Requirement:
1 .User will be manually Uploading a CSV File through UI.
2. CSV File would contain 20 columns with "n" number of rows with distinct headers.
3.Once the user selects the CSV File using an Upload Button , the data in CSV File should parse and should be populate in Repeat Grid in the same UI with similar rows and columns as uploaded.
I actually saved as the pxUploadFilePath , FileData(ValueList), filepath(text input) properties and created Parse Delimited Rule with 19 rows with Appropriate Description. Created a Data Transform to store the File Name I had already created a class A-B-C-Data-Transactions and created the Parse Delimited rule in this class.
Could somebody help me on the Activity Part ? I am not, in which page should I receive the CSV Data and in which page should I store the data. How will I check the parsed data. Should I create any service rule / Service Package for this ?
Please help me on this.
***Edited by Moderator Marissa to update platform capability tags****
Pegasystems Inc.
US
Please check below pdn link:
Pegasystems Inc.
US
Also please check below rules:
FlowAction: @baseclass. pxUploadCSVResults: A generic flow action that can be used in your flow as a local action to populate records from CSV file onto a pagelist property. UI has a simple filepath control. Post activity is pxUploadCSVResults (see next) API activity.
Activity: @baseclass. pxUploadCSVResults: This API activity reads a CSV file and populates the values onto a pagelist property. Execute this activity in any context, but pass the pagename and pagelist property name as parameters. This activity assumes that the file is already uploaded to the server and the filepath on the server is held in pxRequestor.pyFileUpload(Include a filePath control in your section which does both eg: See FlowAction @baseclass .pxUploadCSVResults implementation).
