browse a directory to populate a database

[NNot_defined1679394540]

Hi, I would like to create a job which consumes the xml which is a directory and loads them into a mysql database, but I wonder if with TOS we can be able to browse a directory and retrieve the data from the XML found in the directory and load them into the database? If it is possible to browse a directory with component, do we do it?

[Anonymous · Accepted solution]

Hi

You can use tFileList component to iterates a set of files or folders in a given directory based on a filemask pattern, here is a scenario.

https://help.talend.com/r/en-US/8.0/tfilelist/tfilelist-tfileinputdelimited-tlogrow-tlogrow-iterating-on-file-directory-standard-component-the

Regards

Shong

[NNot_defined1679394540]

okay I followed a lot of courses so I took as input a tfileList and a tfileinputXml, a tmap then a toutputDB but the difficulty I currently have is that when I connect the tfileList to the tfileinputxml with an iterate line so that it loops over the entire folder the tfileinputXml disappears

[Anonymous]

Sorry, I don't understand your problem here, tfileinputXml disappears?

A simple job design looks like:

tFileList--iterate--tFileInputXML--main--tDBOutput

[NNot_defined1679394540]

obviously the path is as presented here but when it is necessary to iterate the link between the tfileList and the TfileinputXml, the output component disappears

[NNot_defined1679394540]

by reflex I removed the tfileList that was there and I replaced it with another, everything works correctly. Thank you very much

[NNot_defined1679394540]

in my tfileinputxml I cannot loop the files when I just put the simple directory I get the error access denied but if I put the name of the first file in the hope that it takes the others after it does not loop only on the first file

[Anonymous]

@Not defined Not defined​ If you are using a tFlieList to iterate multiple files one by one, there is a global variable that stores the current file path,

((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))

So, use this global variable in the File name/Stream field on tFileInputXML.

[NNot_defined1679394540]

thank you it works correctly