topic Re: Loading multiple Excel files using tFileList and tFileInputExcel in Talend Studio

Loading multiple Excel files using tFileList and tFileInputExcel

Anonymous — Mon, 10 Oct 2016 20:13:34 GMT

I set up a job that loads a file using tFileInputExcel to a MySQL database table and it works correctly.
I then added the tFileList component and set up to iterate through tFileInputExcel. The job picks up the three files in my directory that is referenced in tFileList and loads them correctly into the database. But the job ends with an error:
Exception in component tFileInputExcel_1 : Compound file does not contain the specified stream
any ideas on why this might be?

Re: Loading multiple Excel files using tFileList and tFileInputExcel

Anonymous — Mon, 10 Oct 2016 20:30:11 GMT

Here is the export from the job
FileList_delimitedatabase_treplace_date2_0.1.zip.zip

Re: Loading multiple Excel files using tFileList and tFileInputExcel

vapukov — Mon, 10 Oct 2016 23:42:20 GMT

You need to check what difference between first 3 and 4th files
even if You have 3 file, You need run Job in debug mode (may be add tLogRow for display processed file name) and check what happens
for example - hidden files in directory
Check tFileList catchup pattern and exclude pattern to be sure - You work only with proper files

Re: Loading multiple Excel files using tFileList and tFileInputExcel

Anonymous — Tue, 11 Oct 2016 14:20:40 GMT

Thank you. I only have 3 files, I will look for hidden files and/or change the tFileList pattern.