Question
Parsing the csv file
Hi Team,
I have one requirement to provide the upload the csv file in user portal and data the data in the tables.
I have created the section and used the filepath control to select the file and submit button . on submit I need to parse the csv file and update the data in the table.
I have created the binary file (csv file template), and called the MSOParseExcelFile(OTB ) activity with passing the file name and template name.
but I am getting the "
- The uploaded file template could not be recognized. Please upload a valid file. Refer to template XXXXX for details.
Could you please help to solve the issue.
Pega Version: 7.4
DB : Oracle 12c
***Edited by Moderator: Pallavi to update platform capability tags***
Hi,
Instead of using MSOParseExcelFile(OTB ) activity you can use Parse delimited rule and set up Map to key values to store data in your data table and then configure a service file to call this delimited parse rule in the parse segments tab