Talend community forum / [resolved] export Excel file and load it in MySQL DB

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

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

Announcement

Unanswered posts

#1 2012-05-04 11:12:31

[resolved] export Excel file and load it in MySQL DB

#2 2012-05-04 11:17:31

Re: [resolved] export Excel file and load it in MySQL DB

#3 2012-05-07 11:27:21

Re: [resolved] export Excel file and load it in MySQL DB

#4 2012-05-07 11:34:26

Re: [resolved] export Excel file and load it in MySQL DB

#5 2012-05-08 13:05:32

Re: [resolved] export Excel file and load it in MySQL DB

Board footer