topic FTP connection problem in QlikView

FTP connection problem

Tue, 30 Nov 2010 13:35:45 GMT

Hi all, I need help with this.

FTP wizard allows QlikView not enter a directory, only displays the file attributes.

Unlike any FTP client that, if I can see the directories.

He added that this was done using the same user, FTP is also the Unix machine.

if I am writing connection command is the same.

Greetings and thanks for the help.

FTP connection problem

Wed, 01 Dec 2010 13:12:30 GMT

Have a batch file, with FTP commands to change directory and download the files to local disk. There is plenty information on Google.

QlikView will load from these files.

-Alex

FTP connection problem

Wed, 01 Dec 2010 14:26:12 GMT

Hello, unfortunately this customer requested that this be done via FTP and not copying the directories.

Greetings and thanks

FTP connection problem

Wed, 01 Dec 2010 16:31:25 GMT

You have a two solutions:

a) mount the ftp storage via shared folder

b) generte a bash process for copy files before load

And other solution: KILL THE CUSTOMERS

Best regards

FTP connection problem

Thu, 02 Dec 2010 07:14:59 GMT

Kindly explain them that "finer FTP clients" have options to "fetch only newer files". This is quite useful during temporary network problems. So have a batch script that synchs files + QlikView loading local files + deleting local files. And during processing, store those files in a folder with tight security.

The alternative is to have QlikView processing FTP files for several hours, that a network glitch, than start QlikView reload from beginning. Delta load is no cure for recovering broken FTP errors during QlikView reload.

-Alex

FTP connection problem

Thu, 02 Dec 2010 08:44:01 GMT

Generally this is faster as well. Depending on how large the data is you can also implement something like zip from the source, then copy locally, then unzip, process/load the files to QV and then delete the files. Though sometimes request from the customer stick so good luck 🙂

FTP connection problem

Thu, 02 Dec 2010 13:39:30 GMT

Hi thanks for the comments, but did not solve my problem, by definition of the business, I can not copy the source to local disk. I need to know is that this happens with QlikView to FTP and how to solve? for now does not evaluate the processing speed.

Thanks again to everyone.