6 Replies Latest reply: Dec 2, 2010 8:39 AM by alimanha RSS

    FTP connection problem

      Hi all, I need help with this.

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

      error loading image

       

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

      error loading image

       

      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

          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

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

              Greetings and thanks

                • FTP connection problem

                  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

                      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

                          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.

                  • FTP connection problem
                    Rodolfo Villarroel

                    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