Possible to use tFileList with tFileInputExcel ?

One Star

Possible to use tFileList with tFileInputExcel ?

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.
One Star

Re: Possible to use tFileList with tFileInputExcel ?

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

Re: Possible to use tFileList with tFileInputExcel ?

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.
One Star

Re: Possible to use tFileList with tFileInputExcel ?

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
Seven Stars

Re: Possible to use tFileList with tFileInputExcel ?

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

Re: Possible to use tFileList with tFileInputExcel ?

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