How to extract the Data from CSV file using Activity when it is uploaded on real time sceneraio

User Experience
, , ,
1

When I upload a CSV file I need to extract the data in that file using Activity and stores in clipboard

How to configure that one? Please help me

Advance in thank you

2

@AVINASHL4108 you can carry out a PSC search on ‘extract data from CSV’

Our AI bot found the following based on our documentation:

To configure an Activity to extract data from a CSV file and store it in the clipboard in real-time, follow these steps:

  1. Create a File data set record for the uploaded CSV file. Follow the steps in reference 3 to configure the File data set rule.
  2. Create an Activity to process the CSV file. In the Activity, use the following methods:
  • a. Use the ‘Page-New’ method to create a new page for storing the extracted data.
  • b. Use the ‘Obj-Browse’ method to read the records from the File data set.
  • c. Iterate through the records using a loop (For Each Embedded Page) and map the CSV columns to the corresponding properties on the clipboard page.
  1. To process the CSV file in real-time, you can call this Activity from a flow action or another rule that is triggered when the file is uploaded.

Remember to save and test your Activity to ensure it works as expected.

Creating a File data set record for embedded files

3

@AVINASHL4108

The information is not correct. In the Activity to process the CSV file you need to:

  • Use a ‘Page-New’ method to create a page of class Code-Pega-List
  • Use ‘DataSet-Execute’ method and point it to the File data set. (not an Obj-Browse)

Robert