Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hello, unfortunately this customer requested that this be done via FTP and not copying the directories.
Greetings and thanks
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
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
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 🙂
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.