Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Mahipal Gaddam (MahipalG)
Virtusa

Virtusa
AU
MahipalG Member since 2015 7 posts
Virtusa
Posted: Apr 1, 2019
Last activity: May 27, 2019
Posted: 1 Apr 2019 6:50 EDT
Last activity: 27 May 2019 6:58 EDT
Closed

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

To see attachments, please log in.
Java and Activities
Data Integration
User Experience

Posted: 5 years ago
Posted: 27 May 2019 6:58 EDT
Hrishikesh Kucherlapati (Hrishikesh.K)
Publicis Sapient
k.hrishikesh varma
Publicis Sapient
IN

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

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice