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
Capgemini
US
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.
Pegasystems Inc.
IN
Capgemini
US
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.
Capgemini
US
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.
Pegasystems Inc.
US
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.
3. Please let me know if this helps.
Thanks
Vivek
Infosys
US
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?