topic Re: How to Load Excel files which is in other server? in QlikView

How to Load Excel files which is in other server?

kavita25 — Fri, 23 Jan 2015 10:25:55 GMT

Hi,

I want to load excel files which is in other server.

Is it through FTP server or if there is any other solution, please mention it.

Thanks in Advance!

Re: How to Load Excel files which is in other server?

cesaraccardi — Fri, 23 Jan 2015 10:36:28 GMT

Hi,

If the server where your excel files reside is on the local network all you have to do is create a shared folder and then you can easily access it from other machines using UNC path, you will also have to make sure that the user reloading the application has reading previleges for that folder:

\\ComputerName\SharedFolder\MyExcelFile.xls

Regards,

Cesar

Re: How to Load Excel files which is in other server?

Peter_Cammaert — Fri, 23 Jan 2015 10:38:39 GMT

If your server containing Excel files is inside your company network, share the directory and do a classical LOAD with an UNC path (e.g. LOAD....FROM [\\servername\serverpath\MySharedExcel.xlsx]...)

If your server is outside your company network, see if you can use either straight http: or ftp (when a username and password are required)

Re: How to Load Excel files which is in other server?

kavita25 — Fri, 23 Jan 2015 11:18:09 GMT

Thank You for your reply!!!

The server is outside the company network. How can I do it through ftp server or http, as solution provided by you.

Can you please explain me in detail, as I am doing it for the first time.

Re: How to Load Excel files which is in other server?

Peter_Cammaert — Fri, 23 Jan 2015 11:38:16 GMT

In your script, navigate to the spot where you want to load the Excel file over ftp. Enable the ftp-switch next to the Table Files... button, and then press the Table Files... button. A dialog appears that lets you specify login credentials, and navigate the ftp site. Enter the items the dialog asks for. Check the generated LOAD statement for any errors (the syntax should be obvious) and test.

Best,

Peter

Re: How to Load Excel files which is in other server?

kavita25 — Tue, 27 Jan 2015 05:34:15 GMT

Hi,

Thanks for the reply.

Is FTP Server connection is the only solution?

I have a question

While using FTP, one excel file is loaded at a time in qlikview. And to load the next excel file, again I have to apply all the login credentials of FTP Server. I want to avoid this, is there any other solution for it?

Re: How to Load Excel files which is in other server?

Peter_Cammaert — Tue, 27 Jan 2015 09:03:58 GMT

No it isn't. You can also transfer a file using HTTP, which is way faster than FTP (ftp is very old and very inefficient). However, AFAIK QlikView doesn't support authentication for those connections. See the Web Files... button in the script editor.
Unlike a database connection in QlikView script, an FTP transfer in your script doesn't support sessions (where you open a connection, do various tasks and finally close the connection). You'll need a real FTP-client to perform batch-transfers, or a connector. Check the Qlik Market.

Best,

Peter