628492_en-US

liliconcom

JMP Live 17: refreshable multiple file import from folder via ODBC

Hi everyone,

one of our customers (Bundesdruckerei) previously used the windows task sheduler to publish data into JMP Live 16 regularly.

They upgraded to JMP Live 17 and know want to do that using ODBC to import multiple files from a folder on the server.

Here is an old script they provided us for reference:

 

current_day = Short Date( Today() );

current_week = Week of Year( Today(), 3 );

last_week = current_week - 1;

current_year = Year( Today() );

 

start_date = Informat( current_day ) - ( In Days (28));

start_date_pentaho = start_date - ( In Days (10));

end_date = Informat( current_day );

 

//daten import with only csv files

//create a dynamic request for the year folder

dt_stationlogs = Multiple File Import(

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

        <

) << Import Data;

 

Has someone experience how to set this up with the JMP Live 17 sheduler? The set folder command does not work for them so far. 

 

Many thanks,

Jonas