FTP data import into script

[felcar2013]

hi

i need to import several zipped CSV files from a FTP Server into the script directly. Do you know how to do this?

there is an option, but i never used it (i also have no FTP Server connection yet, so i never tried)

thanks

felipe

[#2]

File Name Format ? As you mentioned the new file was created every min.

The File name like: FILENAME_2014-2-25 06.01.csv ?

[Anonymous]

csv 's with

Filename_05_30_02_02_12_2014 is like Filename_hh_mm_ss_MM_DD_YYYY

[#4]

The filenames are consistent on the minute like below:

FILENAME_05_30_02_02_12_2014

FILENAME_05_31_02_02_12_2014

FILENAME_05_32_02_02_12_2014

FILENAME_05_33_02_02_12_2014

Then create the multi inner loop on Hour & Minute like below:

LET vToday = Date(Today() , 'MM_DD_YYYY') ;

For vHour = 01 to 24

     For vMin= 1 to 60

          LET vFileName = 'FILENAME_$(vHour)_$(vMin)_02_$(vToday)';

          LOAD * FROM $(vFileName).csv () ;

     Next vMin

Next vHour

If you have any probelem, please open new thread with 5 filenames as reference.

[pandiarajan]

Kindly Share any sample qvw for this example