Hello,

I've submitted to your query to subject matter expert(s) in the hope we can get you an answer soon. Someone will check back on this post in the next 24-48 hours to see if the SME has responded. Thank you for your patience.

Kind regards,

Bob Lloyd

PDN and Pega Academy Self-study Forums Support Team

Hi Bob\Ankit,

I have similar requirement, Please post the resolution if found? thanks!

Hello Ankit,

Any resolution?

Java code to parse the excel is throwing the exception.

Not yet.. actually requirement was changes.. not excel is not required.

Hi Karran,

Did you implemet ?

Hello Sudheer,

I am facing issues with the java code used in the OOTB activity msoparseexcel...working on it.

Will update you if achieve it successfully.

Hello All,

Did anybody implement this functionality. It was working for us in Pega 6.2 Sp2 and now it is not working properly in Pega 7.1.7.

Let us know if anybody is able to implement it successfully in Pega 7.1.7

Hello Ankit,

Path canbe traced on pxrequestor page on pyFileUpload property. Refresh the section as a onclick event on the button.

if the excel is attached to the case the data is available in pyAttachStream  property which contains the data you might map to clipboard.

Hi,

Here is a small article for parsing excel file

http://vamshikassety.blogspot.in/2015/08/parse-excel-file.html

Vamshi

I read the article.  Keep getting this error: 

• The uploaded file template could not be recognized. Please upload a valid file. Refer to template ImportTemplate for details.

I'm using the right file type and extension.  What should the value be for directory when creating the binary file?

Any thoughts?

Here is what is listed in my template file:

Hello Lewic,

Please validate if the template name given is correct and incase u r passing the sheet name in the excel as part of parameters, please validate that as well.

Regards,

Karan

Done and done.  Everything looks correct based on the information in the blog website listed above.  I'm not using xls so this error should not happen.

Hi Lewic,

Can you specify the parameters you are passing?

I have seen this error occurs, when the path + file name provided as input is not correct.

Vamshi

For the Filename: "/pega/sample_ingredients.xlsx"

For the template: "pega!ExcelImportTemplate!xlsx"

Question:  For the filename, the path should be the location on the web server correct?

Here are the details of the parameters

Thank you.  This worked perfectly with the right FSFFileName.  Now I've got to get this working with a regular attachment and I'm golden.  Any suggestions?

Hi Lewic,

For attachments I havent worked on them, attachments are in base64 encoded format and this activity expects File Name and Location, may be you can think off couple of approaches

First, write a java step in activity to read the pyAttachStream and convert into clipboard pages.

Second, programatically download the attachment into any staging area on your server and then use that location as input to the FSFFileName.

Others, any thoughts or suggestions?

Regards,

-Vamshi

Hi Lewic,

You can try these steps

1. Get attachments from email and pass them into an Param

2. Parse the Param using parse delimited (or other parse) rules.

Regards,

-Vamshi

I may be able to piece it together from this.  Thanks.  If I solve it, I'll let you know and post the details.

-Clarence

There is a requirement to insert data to database from an excel sheet( having multiple rows of data).the data also needs to be shown in an window before inserting it to database.can anyone help me.The excel sheet format is predefined. usr will only fiil up the required data set in excel sheet.click on attach and browse button to browse to the path where excel sheet is kept and then to show whole excel data in an window and then click on submit button to insert data into database.and while doing so it will check whether same data exist in the data base or not.suppose the excel contain 7 rows of data.while inserting it shows Duplicate=1,data Inserted=6

SowmyaTharik, Provide more details on the approach you followed.