topic Re: Convert TXT files to XML in Talend Studio

Convert TXT files to XML

NNot_defined1679394540 — Fri, 15 Nov 2024 21:27:55 GMT

Hi, I am a beginner on Talend, I would like to build a job that automatically retrieves TXT files in a folder, transforms them into XML and stores them in another folder. So I thought that the TfileList would help me and I associated it with the TfixedFlowInput and I checked the box use aligned content (delimited) I even defined a schema so it didn't get me the schema files, and I realized that I was on the wrong voice, can anyone help me?

THANKS

Re: Convert TXT files to XML

Anonymous — Wed, 20 Sep 2023 01:41:39 GMT

Hello,

Are your all TXT files same schema structure or not?

You could use a set of tFileList components, configure its file name pattern according to each schema and connect them to the corresponding tFileInput* using the Iterate connection.

Best regards

Sabrina

Re: Convert TXT files to XML

jlolling — Wed, 20 Sep 2023 06:27:18 GMT

Following flow would be helpful:

Build a job (let us call it transformer) which takes the full file path via contact variable and convert this file into an XML file.

Build another job iterating through the files from tFileList and start for every file the transformer job.

Now to the transformer job:

tFileInputDelimited --> tFileOutputXML (define in this component the transformation)

There are plenty of help pages for tFileOutputXML (hit F1 when component is selected)

Re: Convert TXT files to XML

NNot_defined1679394540 — Wed, 20 Sep 2023 13:53:40 GMT

Oui mes TXT et XML ont la meme structure

Re: Convert TXT files to XML

NNot_defined1679394540 — Fri, 29 Sep 2023 11:29:27 GMT

okay but tell me is it possible to read files from a folder with a talend element?