Skip to main content
Contact a Moderator

Question

1
Replies
645
Views
 Mahipal Gaddam (MahipalG) Virtusa
Virtusa
AU
MahipalG Member since 2015 7 posts
Virtusa
Posted: April 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***

Data Integration Java and Activities User Experience
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 2 years ago
Posted: 27 May 2019 6:58 EDT
k.hrishikesh varma (Hrishikesh.K) Tech Mahindra k.hrishikesh varma
Tech Mahindra
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

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