topic Re: tFileInputExcel one Excel file after the other in Talend Studio

tFileInputExcel one Excel file after the other

Anonymous — Sat, 16 Nov 2024 12:59:19 GMT

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

Re: tFileInputExcel one Excel file after the other

Anonymous — Mon, 11 Apr 2011 15:18:57 GMT

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.

Re: tFileInputExcel one Excel file after the other

Anonymous — Tue, 12 Apr 2011 09:07:19 GMT

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

Re: tFileInputExcel one Excel file after the other

Anonymous — Tue, 12 Apr 2011 09:30:17 GMT

Hi
Remove the double quote in the file name field.
Best regards
Shong

Re: tFileInputExcel one Excel file after the other

Anonymous — Tue, 12 Apr 2011 10:08:27 GMT

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.

Re: tFileInputExcel one Excel file after the other

Anonymous — Tue, 12 Apr 2011 10:33:43 GMT

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