shong wrote:

In the job, Using a tFileFetch or tFTPGet component to get the file and put it to a directory first. and then using a tFileInputExcel to read this file and insert data into db.

This still does not resolve the problem of calling the Talend job when the file upload is complete. One way I can think about it is as follows: Suppose the file is uploaded by a java servlet. The servlet could then call the Talend job as a web service, passing it the file path as a parameter. The Talend job could have a tFileInputExcel component which uses the passed in file path. Is this a reasonable solution? Is there an example or tutorial somewhere that explains how this is done?

Last edited by Paul- (2009-09-24 16:12:03)

Thomas Cook wrote:

There are several ways to invoke the exported Talend job.  Either way you choose, you would most likely set the filename up as a context variable, or use a tFileList to process all the files in a given directory.

- invoke it as a standalone java executable with the provided shell or batch scripts.  This would allow you call it from a java system() call
- invoke the jobs main() method from some java code
- invoke it as a web service as you described above see: http://www.talendforge.org/wiki/doku.php?id=doc:export_as_webservice

Thanks, I think options 1 or 2 should work for me.

Regards,
Paul