• Index
  •  » Talend Enterprise Data Integration » General questions
  •  » Load multiple XML Files into a mySQL DataBase

#1 2012-06-07 10:57:06

cnawfal
New member
Registered: 2012-05-03
Posts: 5

Load multiple XML Files into a mySQL DataBase

Tags: [database, mysql]

Hi,
I have a foder where I have 3 xml Files CDR01--CDR03 which have the same format. I want to select these three files, process them (extract only some information from) and then put the extracted data into a DataBase.

I used the
Tfilefilter : where I gave the link of the folder where I have my xml files,
tFilelinputXml: and here is where I have the problem : it when I need to give the "file name/Stream" and here I have just one option is to give the link for one xml file.
So when I run the Job I have in my Database the selected file 3 times.

So my question is how to tell to the tFileInputXML to have as input a different files.

Thank you I hope I am clear.



[img]

Offline

#2 2012-06-07 11:07:00

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: Load multiple XML Files into a mySQL DataBase

Hi

Type this expression in the "file name/Steam" text field on tFileList.
((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))

Regards,
Pedro


Only Paranoid Survive.

Offline

#3 2012-06-07 11:33:08

cnawfal
New member
Registered: 2012-05-03
Posts: 5

Re: Load multiple XML Files into a mySQL DataBase

Thanks a Lot It worked smile

Offline

  • Index
  •  » Talend Enterprise Data Integration » General questions
  •  » Load multiple XML Files into a mySQL DataBase

Board footer

Powered by FluxBB