You are not logged in.
Announcement
Unanswered posts
|
- Index
- » General questions
- » [resolved] export Excel file and load it in MySQL DB
Post a reply
Topic review (newest first)
- spartacus10
- 2012-05-08 13:05:32
Hi
your right i misunderstund tFileFetch
now it's fine i resolve the probleme like you said by using OnSubjobOk to link the two jobs
thinks Pedro
- pedro
- 2012-05-07 11:34:26
Hi
According to your description, I guess you maybe misunderstand the function of tFileFetch.
The function of tFileFetch is to fetch files from Internet through HTTP or FTP.
If you just want to extract data from a local Excel file, tFileInputExcel will help you.
Please let me know your accurate requirement.
Regards,
Pedro
- spartacus10
- 2012-05-07 11:27:21
Hi
thanks Pedro for your help,
in my project i should export an excel file and load it in a Mysql DB and i should use the option in tFileFetch that read data from the excel file without export it .
a can't find a solution to do it , so can you give me please an idea for a job that do this work
- pedro
- 2012-05-04 11:17:31
Hi
Welcome to Talend Community!
tFileFetch should be an independent subjob.
tFileInputExcel-->tMap-->tMysqlOutput is another subjob.
Use OnSubjobOk to link them.
Regards,
Pedro
- spartacus10
- 2012-05-04 11:12:31
Hi all
i'm new with talend and i have a little problem
i found the solution to export an excel file with tFileFetch , and i can load an excel file in tMysqlOutput with tMap
but i found a problem when i combine the two solutions ( i use tFileInputRegex but there is always regex error)
please anyone can help me with the job schema
thx in advence