tFileInputExcel one Excel file after the other

One Star

tFileInputExcel one Excel file after the other

Hallo together,
I have to extract Data from Excel into Access Database. One file ok it works fine. Every Excelfile has the same structure but different name. How can i control that all files will be readed one after the other ?
My idea was to create a file list with all Excelfile names but i don't know how to use the file names in tFileInputExcel as parameter ___FILENAME___.

Thaks for suggestions
One Star

Re: tFileInputExcel one Excel file after the other

Hi
Use TFileList and and check for all excel files in the folder
give the file name as ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH")
This will help you to fetch the files dynamicaly and process it.
One Star

Re: tFileInputExcel one Excel file after the other

Thanks for your help.
Do you mean it like in my picture.
I get an error you can see it in the pic
Community Manager

Re: tFileInputExcel one Excel file after the other

Hi
Remove the double quote in the file name field.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: tFileInputExcel one Excel file after the other

Thanks but now there is another error!
Starte Job Leergutkontrolle am 10:48 12/04/2011.
connecting to socket on port 3811
connected
Firma Tour Datum Artnr EingSt
Exception in component tFileInputExcel_1
java.lang.Exception: The data source should be specified as Inputstream or File Path!
at test_1.leergutkontrolle_0_1.Leergutkontrolle.tFileList_2Process(Leergutkontrolle.java:1013)
at test_1.leergutkontrolle_0_1.Leergutkontrolle.runJobInTOS(Leergutkontrolle.java:1631)
at test_1.leergutkontrolle_0_1.Leergutkontrolle.main(Leergutkontrolle.java:1502)
disconnected
Job Leergutkontrolle endet am 10:48 12/04/2011.
One Star

Re: tFileInputExcel one Excel file after the other

Hi
You have given wrong file path in tFileInputExcel. It should be the name of your tFileList not of the Excel(tFileInputExcel)