topic Re: Creating XML using tAdvanceFileOutputXML in Talend Studio

Creating XML using tAdvanceFileOutputXML

AManohar — Wed, 22 Jun 2022 06:31:25 GMT

Hi,

I'm trying to create a job to read a XML file and replace just two fields and copy the remaining fields as such and create another xml.

If I use tFileInputxml -> txmlmap -> tAdvanceFileOutputXML , I'm getting the xml generated but with the "<" replaced by "<".

Is there a way to get the XML nodes without the "<" ">"

Re: Creating XML using tAdvanceFileOutputXML

InfoCraft — Wed, 22 Jun 2022 12:34:42 GMT

why are you using both components at the same time?

***tXMLMap and tAdvancedFileOutputXML do almost the same thing.

do your mapping in tXMLMap--->output as document----> tFileOutputXML
check the box "incoming record is a document"

To better understand the problem take a screenshot of the desired result and the tXMLMap settings

Re: Creating XML using tAdvanceFileOutputXML

AManohar — Thu, 23 Jun 2022 06:13:12 GMT

Hi,

I tried to replace with the tFileOutputXML but that doesn't seems to be working . If I check 'incoming record is a document' , getting invalid getdocument() something.

Tried to replace the txmlMap with normal tmap.

Attaching the input and the output recived.

Input file:

<?xml version="1.0" encoding="utf-8"?>

<Account>TESTACC</Account>

<Type>SAMPLE</Type>

</AccountType>

<field name="Key1">value1</field>

<field name="Key2">value1</field>

</index>

<detail>2680076476|A0648AC252994BEDBFB2B20FADB96E4C</detail>

</docid>

<proc1>column1</proc1>

<proc2>MULTI_column1</proc2>

<Test>test Messages</Test>

</column1>

<Test>test Messages</Test>

</column2>

</mainacc>

</docload>

Output received: <in output the tags are repeated if we use get node.>

<?xml version="1.0" encoding="ISO-8859-15"?>

<AccountType><AccountType>

<Account>TESTACC</Account><Type>SAMPLE</Type></AccountType></AccountType>

<field name="Key1">value1</field><field name="Key1_TimeStamp">2020-09-09T13:53:33+1000</field><field name="Key2">value1</field></index></index>

</docid>

<proc1><proc1>column1</proc1></proc1>

<proc2><proc2>MULTI_column1</proc2></proc2>

<Test>test Messages</Test><attachment shared="true" name="attachment1">a.pdf</attachment><attachment shared="true" name="attachment2">b.pdf</attachment></column1></column1>

<Test>test Messages</Test></column2></column2>

</mainacc>

</docload>

Thanks for your help.

Re: Creating XML using tAdvanceFileOutputXML

AManohar — Thu, 23 Jun 2022 06:14:25 GMT

Our requirement is to copy the whole xml to output, but change the uuid field alone.

mainacc will be the loop element. And we will have mutiple entries of the mainacc. for every record we need to change the uuid alone.