topic Re: Possible to use tFileList with tFileInputExcel ? in Talend Studio

Possible to use tFileList with tFileInputExcel ?

YVES1 — Sat, 16 Nov 2024 12:56:57 GMT

Hi ,
I am looking at the tFileList as input of the tFileInputExcel but it doesn't work.
I have attached the job scheme , here below the observed errors :

connecting to socket on port 3355
connected
Debug: format string is 0" Jours"
Exception in component tFileInputExcel_1
jxl.read.biff.BiffException: Unable to recognize OLE stream
at jxl.read.biff.CompoundFile.<init>(CompoundFile.java:116)
at jxl.read.biff.File.<init>(File.java:127)
at jxl.Workbook.getWorkbook(Workbook.java:268)
at changements_clos_dans_le_mois.fichiersource_2_0.fichierSource.tFileList_1Process(fichierSource.java:2000)
at changements_clos_dans_le_mois.fichiersource_2_0.fichierSource.runJobInTOS(fichierSource.java:4402)
at changements_clos_dans_le_mois.fichiersource_2_0.fichierSource.main(fichierSource.java:4276)
disconnected
Job fichierSource terminé à 17:29 02/05/2011.

With best regards,
YVES.

Re: Possible to use tFileList with tFileInputExcel ?

Anonymous — Mon, 02 May 2011 17:27:43 GMT

hi
Have u give excel file name as ((String)globalMap.get("tFileList_1_CURRENT_FILE")) in tFileInputExcel

Re: Possible to use tFileList with tFileInputExcel ?

YVES1 — Tue, 03 May 2011 11:24:51 GMT

Hi Lijo Lawrance,
According your advice I have introduced your modification but still errors displayedas follows :
Démarrage du job fichierSource a 16:58 03/05/2011.
connecting to socket on port 3404
connected
Debug: format string is 0" Jours"
Exception in component tFileInputExcel_1
java.io.FileNotFoundException: MSCTreportingJupiterMars2011.xls (The system cannot find the file specified)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at java.io.FileInputStream.<init>(Unknown Source)
at changements_clos_dans_le_mois.fichiersource_2_0.fichierSource.tFileList_1Process(fichierSource.java:2006)
at changements_clos_dans_le_mois.fichiersource_2_0.fichierSource.runJobInTOS(fichierSource.java:4406)
disconnected
at changements_clos_dans_le_mois.fichiersource_2_0.fichierSource.main(fichierSource.java:4280)
Job fichierSource terminé à 16:58 03/05/2011.
Observation : file MSCTreportingJupiterMars2011.xls is the one I try to use.

Here enclosed screenshots of tFileList and tFileInputExcel.

Re: Possible to use tFileList with tFileInputExcel ?

Anonymous — Tue, 03 May 2011 16:50:29 GMT

Hi
Can you try
tFileList------iterate---->tJava
in tJava type
System.out.println(((String)globalMap.get("tFileList_1_CURRENT_FILE")));
check if your file name with path is printed correctly

Re: Possible to use tFileList with tFileInputExcel ?

alevy — Wed, 04 May 2011 02:42:20 GMT

I think you should use ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))

Re: Possible to use tFileList with tFileInputExcel ?

YVES1 — Wed, 04 May 2011 09:00:45 GMT

Hi ,
I tried with ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH")) in tFileInputExcel and it's working fine.
Thank you .
With best regards,
YVES.