Question

How to Export Excel file into Export Service Export Directory on windows Server

Hello All,

I have a requirement to place a excel file in Service Export path on windows server. I created a section in data-portal class and added Choose file button with file path control. On click of upload button I'm invoking OOTB activity MSOParseExcelFile activity to parse the Excel uploaded from local. The OOTB activity is looking for the file on the Server side in Service Export Folder. I tried to use OOTB activity pyUploadFile which takes file name as parameter. I gave file name as XYZ but the activity is failing with error saying cannot find file with name" file://web:/StaticContent/.......xyz.xlsm" Is there any way to place the folder on server side ?

Thanks in Advance

Comments

Keep up to date on this post and subscribe to comments

April 30, 2019 - 1:25pm

Anyone got any solution for this?

Pega
June 4, 2019 - 12:10pm
Response to santosh0115

Hi Santosh,

You are create a folder a 'ServiceExport' folder in server and provide the path in context.xml.

Excel will be uploaded to that folder.

 

June 10, 2019 - 8:23am
Response to nayar2

Hi nayar,

Thanks for the response, we already have the folder on the server side. where do i give the context.xml as im using activity on the upload button.

 

 

Thanks,

Santosh