How to get each files in a directory

[#1]

Hello,

Actually, I try to make a script to allow me to convert each XLSX in QVD.

FOR EACH File in FileList([ftp://AAA:VVV@11.111.11.111/DV/])

XLSX:

LOAD

  *

FROM [ftp://AAA:VVV@11.111.11.111/DV/*.xlsx] (txt, codepage is 1252, embedded labels, delimiter is ';', no quotes);

STORE XLSX into $(File).qvd(qvd);

next File

When I made it run there's any error but nothing appears too. I don't know if I use the "FOR EACH" well or not and the "FROM".

Then, if someone can explain my error.

Thanks

Regards

[petter]

Actually the FTP-support is so flimsy that I have used other FTP solutions to implement FTP operations. You have a built-in FTP client in Windows that can be used and can be triggered from a load script with the EXECUTE statement. There are other high-quality open-source clients too that you can use from a load script: wget and especially cURL. Unfortunately this comes at a "price" ... which is time, effort and IT-skills - not license money... But in the end you get a trustworthy FTP-solution. You can download a directory-listing ... parse this to do some FTP-transfers and it works both ways and with full logging.

The LOAD ... FROM [FTP://....] does not work against all types of FTP-servers out there ... I tried it the day before yesterday without any luck against a hosting-provider that runs Microsofts FTP-server - No luck... and then against a UNIX-based FTP-server where it works OK.... but as I said it is not something I use or trust.

[#3]

Hi Kenny,

Yes, I am using filelist.

There is an example on the Community where another contributor has used a two step process to load in data via FTP without using Filelist so this may be an option for you:

Re: For Each File in Filelist - FTP load is not working?

As Petter posted, FTP support is a bit hit and miss and is also dependant on the FTP version/platform you are trying to work with.

Hope this helps.

Kind regards,

Rod