For Each File in Filelist - FTP load not working in QV12?
up until recently I used the following script successfully to pull data from xlsx-files into my QV app (taken from the thread Re: For Each File in Filelist - FTP load is not working?). This worked fine with QV11, and also with the first edition of QV12, but for some reason it doesn't work with QlikView November 2017 SR5, Version 12.20.20600.0. I always get the error mesage "Unknown LOAD statment error" for the first LOAD statement (see below). Does anybody know what needs to be changed so it works again?
////////////Connectig only Directory listing through WebFiles Button, ///////////then split Directory listing into 4 Section Date = F1, Time = F2, Type of File/Directory = F3, Name of File or Directory = F4 LOADER: LOADF1, F2, F3, F4 FROM [ftp://username:firstname.lastname@example.org] (html, codepageis 1252, embeddedlabels, tableis @1, filters( ColSplit(1, IntArray(11, 24, 34)) )) Whereright(F4,4)='xlsx';
letvRow = NoOfRows('LOADER'); ////// Checking No of Rows for xlsx files
Fori = 0 to$(vRow)-1 letvFile = peek('F4',-1+$(i),'LOADER'); ////// Remember if All file structures are same then you can execute this script and Last Row started with ‘-1’
LOADCOMPANY, CEO_NAME, ADDRESS1, CITY, PIN, EMAIL FROM [ftp://username:email@example.com/$(vFile)] /////Now Concatenating File with Connection Bec’z for each file transfer FTP require new connection (ooxml, embeddedlabels, tableis Sheet1);
Just for testings and before assuming any new bug I would apply a process of elimination and commenting the loop-part and then removing the filters() statement and the where-clause of the first load. If there is further this error I would create the load-statement again with the file-wizard to check if the fileformat, charset and/or the table has changed or if you maybe get another error-message or further hints what might be wrong.
I am not saying the it's a "bug", but I did try to connect with the web file wizard (no loop, no filters, no other pre-conditions whatsover) which works great with QV11, but not with the latest edition of QV12 - Only with QV12 I get the message "Login denied". Any ideas why this is?
I think you are one step further with this new error-message and "Login denied" seems not directly related to the load-statement itself else it hints to an access-rights issue. Are you sure that the used User+Password is really correct? Could you access this file with the used credentials from the same machine per windows-explorer?
Thanks for link, however, this doest seem to be the issue. I did delete the settings.ini as dicussed in the threads but it didn't make a difference. In addition not tmep files are redirected to a network folder as indidcated in threads.