Question

Upload excel file and read it without creating a work object in 7.1.8, MSOFileTransferButtons control doesn't work in 7.1.8

Hi,

I have a requirement where I need to upload a excel spreadsheet (from local system) and read it's data in page list.

When I am using MSOFileTransferButtons control, it doesn't work in Chrome or IE browsers, not sure where the problem is. I referred SA-12659 from PDN for the solution but it doesn't work either, may be I am configuring it wrong.

When I upload file manually on server location and read from there using MSOParseExcelFile activity. It works and reads excel file successfully. But the problem is I am not able to upload excel file using FilePath control, without creating a work object.

Can you please advise me how to do that, If you could provide examples or steps that would be great.

Thanks,

Pratik Goyal

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

Comments

Keep up to date on this post and subscribe to comments

November 27, 2015 - 1:36am

Also I would like to add here, I am operating from Data layer in PRPC and I don't intend to create any work object to acheive this. Can you let me know, how can I upload file without creating work object.

December 1, 2015 - 6:24am
Response to sahup1

Thanks Phani. But this approach doesn't work for me. I am able to read uploaded content directly from server. But not able to upload file to server.

Pega
January 11, 2016 - 2:00pm
Response to PratikG9

>>> not able to upload file to server

  • sorry Pratik, no idea. thinking of FSO (file system object) but not sure...

Pega
January 11, 2016 - 2:02pm
Response to sahup1

are you using FilePath control to upload file?

January 18, 2016 - 3:59am
Response to sahup1

Not exactly, I am using pzFilePath control. Whenever I try to upload excel file using pzMultiFilePath control it fails and gives me following error. "File Filename.xlsx doesn't exist." Control used is pzMultiFilePath RSPega-EndUserUI:07-10-17. Could you please help me in this.

Pega
February 13, 2016 - 10:04am
Response to PratikG9
  • on upload is there any refresh event configured?
  • can we quick test with FilePath control, please.

Thank you!

Pega
February 14, 2016 - 11:30am

Hi Pratik,

1.    I have the similar requirement , I used the MSOFileTransferButtons in a flow for testing and it works except that it call the upload activity twice. We haven't got the requirement

but the control could be used on Portal and it will work. Also you can check the temp object check box if you don't want to create work object.

2. I tried using the file path control and it works fine , Please see the screen shot. I am calling the activity in the flow action but you can configured to control to call the activity.

Capture.PNG

3. Please let me know if this helps.

Thanks

Vivek

March 21, 2016 - 7:22am
Response to KHOCV

Hello Vivek,

when I use the MSOFileTransferButtons, the upload activity is also called twice. Is there a fix for this "twice".

Thanks Ingo

February 29, 2016 - 3:01pm

I am facing similar problem and not able to upload file to service export directory even after using the control which is used in import/export wizard.

Also this approach works only for excel files. Is there any other approach if we need to upload csv file through portal?