Send to Excel loading file from qlikview server instead of webserver

[#1]

Hi, we are using QlikView in a distributed environment. So, the web server (IIS) is on a different machine then the QlikView server.

When users (coming from the internet) click on the "Export to Excel" button the webpage tries to download the Excel file from the QlikView server and not from the web server. The problem is that the Qlikview server is not accessible from the internet.

Urls on Websever:

• http://webserver/qlikview/..
• http://webserver/AjaxZfc/..

Url Export to Excel tries to get the file from:

• http://qlikviewserver/QvPrint/...

Has Anyone an idea?

[Bjorn_Wedbratt]

There are two ways that you can configure your environment to solve this issue:

- Either you create a print-folder on the actual IIS server and add this as a virtual folder in IIS, accessible from client with the URL http://webserver/QvPrint. Share the folder over the network and change the print-folder in QVS to point to the share using an UNC path (i.e \\webserver\QvPrint). Make sure the account running qvs.exe got read/write permissions on the share/folder on IIS

- The second option is to do the opposite. Leave the print-folder on the QVS as a local folder (C:\Documents and settings\All Users...\QvPrint) and have QVS save files to this folder. Create a network share for the folder (i.e. \\qlikviewserver\QvPrint). Add a virtual folder in IIS and use the UNC path to the network share when creating the virtual folder. Provide an account to be used to access the network share and use the same account running qvs.exe.

[deepakk]

Hi,

Would like to know OS of the client through which your trying out send to excel option.

[#4 · Accepted solution]

Thanks, I decided for the second way. Additonally I changed the QvPrint Url in the QVS settings from an absolute Url (http://qvs/QvPrint/) to a relative one (/QvPrint/).

Thanks.

[#5]

The relative path worked for me too... thank you Christian for sharing your solution

Regards

Sangram