#pega training/ How to implement FileUpload and Parse Excel file in Pega 8.6?

Thank you for watching.

If you have any questions please comment below.

Please like and subscribe to my channel.
You can follow my most updated knowledge
sharing on my Facebook page.

Please like and subscribe to my channel

Today I would like to show how to implement FileUpload and process the file.

Prerequisites:
1. Data class for storing or displaying the content.
2. Binary file on that file content.
3. pxParseExcelFile activity.
4. Better UI for displaying the data.
For displaying the Choose File use FilePath control.

Don't worry I will show you one by one.

For my scenario I have created button for choose file, user has to upload a Family Details file. When user click on the Upload And Display Family Details button
The system should populate the family details on below.
See I have used FilePath control.

When you use FilePath control, after uploading the file Pega will store that file information into your ServiceExport directory.

And also you can see this information in Clipboard.

If you don't know your temp directory or ServiceExport directory.

Just go to your server context file check for the temp directory.

In my case, I am using personal edition with tomcat server

See here you can see the uploaded file
Now Need to create a binary file.

When you want to create a Binary File
for more records, use the below format.

{.pxResults().Sno input}

all these properties are created already.

Now upload this file to Binary File.
When the user click on the
"Upload And Display Family Details" Button we need to display uploaded details on the screen.

So now see the configurations

When you use the template follow this format.
webwb!FamilyDetails!xlsx

Now I am using Pega 8 OOTB activity called pxParseExcelFile

For this I need to pass two main parameters

TemplateRFB--- webwb!FamilyDetails!xlsx

Let's see the demo.

I have already created some test data.

See whatever data we have uploaded same is populated here.
Thank you.
Thank you for watching my video.

Please like and subscribe my channel.

fileupload Pega
File upload in Pega 8.6
How to upload and parse excel files in Pega

Upload/Parse Excel file into Pega 8.6

Pega OOTB Activity-3 pxparseExcelFile How to read data excel file and copy into page list property
#Pega #fileupload #pegadeveloper #development #pegatraining #pegandomestresolo #pegacode #lowcodeplatform #lowcodenocode

I will show you now.

[mrrajeshdabbara]

Thank You Very Much .Finally, I fixed my bug after watching this video

[abyss]

Hello, how did you loop the results of the file? I'm a newbie, sorry. Thank you.

[javaarchitect]

If you can please slow down the videos they will be very very good. Thanks in advance.

[saikiranbhamidipati]

i have been trying this, but while i upload the file, i am getting error screen and file name is not being displayed. Do u have any solution for this?

[bhabanishankar]

Can we parse the data from a specific row ?

[hassanelmuz]

what are the steps in case you want to download this excel file just uploaded !

[deepikajujjuru]

What if the excel file template is unknown which user is going to upload then how can we parse?
Please help!

[vinodkumarvemula]

Can you pages and classes of the activity and that table source also

[javaarchitect]

pyRequestor.pyFileUpload not supposed to get set unless form submitted. Now sure how you got it to work.