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

 ARULDEVAN T.T (Devan) Virtusa
Virtusa
IN
Devan Member since 2014 34 posts
Virtusa
Posted: Apr 18, 2017
Last activity: Oct 16, 2018
Posted: 18 Apr 2017 8:36 EDT
Last activity: 16 Oct 2018 12:03 EDT
Closed
Solved

The uploaded file template could not be recognized. Please upload a valid file.

Hi All,

I need to parse a Excel which will as a attachemet in the WO. Im using MSOParseExcel for this functionality.

I have placed the file in the service export directory with my logic. Created a binary file template and passed the file path and the template name as parameters for the MSOParseExcel.

While executing it, getting the below error

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

the excel file which im using as attachemnt follows the excel emplate.

Even tried with the file which is uploaded as the binary template and getting the same error.

Could someone help me in resolving this issue.

(PEGA version 7.2.2)

Thanks,

Aruldevan

***Updated by Moderator: Marissa to add SR Details***


**Moderation Team has archived post**


This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

To see attachments, please log in.
Support Case Created

Accepted Solution

Posted: 7 years ago
Posted: 7 May 2017 17:44 EDT
Ashutosh Arya (Aryaa) PEGA Senior Manager, Technical Support - Runtime Engine and Search
Pegasystems Inc.
AU

The issue was with the File name parameter. Instead of using the complete system path, we used as file://web:/StaticContent/global/ServiceExport/MSOData.xlsx and the issue got resolved.

To see attachments, please log in.
Posted: 7 years ago
Posted: 18 Apr 2017 8:50 EDT
Shibani Sahu (ShibaniSahu) Manager, Services Engineering, Case Management
Pegasystems Inc.
IN

Hi Aruldevan,

How are you providing value to the template field in MSOParseExcel parameter.

Can you share snapshot of the parameter setting when calling MSOParseExcel activity.

 

To see attachments, please log in.
Posted: 7 years ago
Posted: 19 Apr 2017 10:20 EDT
Saran Kolla (SaranKolla) PEGA Senior Technical Solutions Engineer
Pegasystems Inc.
IN

Hi Aruldevan,

I couldn't see the configuration screens in the attachment. Could you please share your configuration of calling MSOParseExcel activity .

Regards

Saran Kolla

To see attachments, please log in.
Posted: 7 years ago
Posted: 20 Apr 2017 2:35 EDT
Narasimharao Pelluru (pelln-1) PEGA Principal System Architect - Pega Consulting
Pegasystems Inc.
US

Is this issue resolved, could you please let me know what is the solution, i am facing the same error.

 

  • The uploaded file template could not be recognized. Please upload a valid file. Refer to template PropertyDamage for details.
To see attachments, please log in.
Posted: 7 years ago
Posted: 24 Apr 2017 14:30 EDT
Rett Hean (Rett_Hean_GCS) Principal Software Solutions Engineer
Pegasystems Inc.
US

Please check the logs when you see this error.

Are you seeing any variant of these?

  • Column Header validation failed...
  • Unreadable template: no entries...
  • Error in parsing Excel file...
To see attachments, please log in.
Posted: 7 years ago
Posted: 27 Apr 2017 9:28 EDT
Rett Hean (Rett_Hean_GCS) Principal Software Solutions Engineer
Pegasystems Inc.
US

That's very interesting. Because if you see that message, the code I reviewed should be generating some errors in the log to correspond with it.

To see attachments, please log in.
Posted: 6 years ago
Posted: 24 Oct 2017 4:45 EDT
Aditya Viswanatha (Aditya Viswanatha) Accenture Lead System Architect
Accenture
SG

I'm seeing error "Column Header validation failed..." when passing ValidateSheet name param. Even though i'm downloading same template and uploading i'm getting same error. Please help on this

To see attachments, please log in.
Posted: 7 years ago
Posted: 26 Apr 2017 7:57 EDT
Santanu Bhattacherjee (Santanu) Senior Manager, Cloud Engineering, Management Plane Services
Pegasystems Inc.
IN

This might require a more in depth research by GCS team.

However, before I recommend you to reach out to GCS team via SR, I would suggest you to run the same use case for any of the OOTB template that is available and see whether that works or no.

This will help us to isolate whether the issue is with the template or process.

To see attachments, please log in.
Posted: 7 years ago
Posted: 26 Apr 2017 9:53 EDT
Lochana Durgada Vijayakumar (Lochan_DV) PEGA Senior Manager, Knowledge Management
Pegasystems Inc.
IN

Hi Aruldevan,

Do let us know the SR number if you create an SR with Pega Support for this. We will tag it to this post and track it until resolution.

Thanks!

To see attachments, please log in.

Accepted Solution

Posted: 7 years ago
Posted: 7 May 2017 17:44 EDT
Ashutosh Arya (Aryaa) PEGA Senior Manager, Technical Support - Runtime Engine and Search
Pegasystems Inc.
AU

The issue was with the File name parameter. Instead of using the complete system path, we used as file://web:/StaticContent/global/ServiceExport/MSOData.xlsx and the issue got resolved.

To see attachments, please log in.
Posted: 7 years ago
Posted: 23 Sep 2017 13:39 EDT
Ponnurangam Nagaraj (PonnurangamN1990) Ernst & Young Pega Developer
Ernst & Young
LU
Hi Arya, I used the file name as mentioned by you. But still issue persist(upload file could not be recognized). It should be within "file location.xlsx" right.. i m using 7.1.9. Kindly advise
To see attachments, please log in.
Posted: 6 years ago
Posted: 27 Nov 2017 16:29 EST
Remya Peethambaran (RemyaPeethambaran) Tata Consultancy Services Architect
Tata Consultancy Services
US

Hi Marissa,

We are using the filepath mentioned above ' file://web:/StaticContent/global/ServiceExport/DVBProducts1.xlsx'. But still we are getting the same error '**** The uploaded file template could not be recognized.'

Could you please help with this?

Thank you.

To see attachments, please log in.
Posted: 6 years ago
Posted: 27 Nov 2017 16:53 EST
Marissa Rogers (MarissaRogers) MOD Principal Knowledge Management Specialist
Pegasystems Inc.
US
Hello!
 
Thank you for posting your query on PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write a Post button that’s available on the top right pane of this page.
Show More
Hello!
 
Thank you for posting your query on PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write a Post button that’s available on the top right pane of this page. Once created, please reply back here with the URL of the new post.
 
We have also sent you a private message opening up a communication channel in case you have any further questions.
 
Thanks,

Show Less
To see attachments, please log in.
Posted: 6 years ago
Posted: 26 Jun 2018 20:41 EDT
SUBHAJIT CHATTOPADHYAY (SubhajitC16577932) Commonwealth Bank of Australia Lead System Architect
Commonwealth Bank of Australia
AU

Hi Team,

I am facing the similar issue. I am using Pega 7.31. Please help if anyone got the solution

To see attachments, please log in.
Posted: 6 years ago
Posted: 27 Jun 2018 5:24 EDT
Lochana Durgada Vijayakumar (Lochan_DV) PEGA Senior Manager, Knowledge Management
Pegasystems Inc.
IN
Hello!
 
Thank you for posting your query on PSC. This looks like an inactive post and hence, we suggest you create a new post for your query.
Show More
Hello!
 
Thank you for posting your query on PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write a Post button that’s at the top of our Pega Support Community homepage.  Once created, please reply back here with the URL of the new post.
 
We have also sent you a private message opening up a communication channel in case you have any further questions.

Thanks!


Show Less
To see attachments, please log in.
Posted: 6 years ago
Posted: 28 Jun 2018 20:55 EDT
SUBHAJIT CHATTOPADHYAY (SubhajitC16577932) Commonwealth Bank of Australia Lead System Architect
Commonwealth Bank of Australia
AU

Hi Aruldevan,

I have tried that also. It is not working. 

Regards,

Subhajit

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