topic Re: XML file generation in Talend Studio

XML file generation

stan1609735726 — Sat, 16 Nov 2024 00:42:40 GMT

Could you please help me with this issue:

As per the XML schema, Location, CountryCode, Number and Extension are all mandatory fields when the Phone block is use. But I don't have Extension information is not available. How to make the extension tag to always even when it is blank. like sample below.

<Phone>

<Extension></Extension>

</Phone>

Re: XML file generation

stan1609735726 — Tue, 02 Feb 2021 04:32:15 GMT

My flow is built in Talend to extract the data and convert to XML. I am using tmap and tAdvancedFileoutputXML. How will I be able to use this tool?

Re: XML file generation

David_Beaty — Tue, 02 Feb 2021 11:22:00 GMT

On the tAdvancedFileOutputXML properties, Advanced Settings tab, ensure the tick box "Create empty element if needed" is ticked.

Thanks

David

Re: XML file generation

stan1609735726 — Tue, 02 Feb 2021 16:01:16 GMT

I did try this and it is turning on for all the elements. I only want this <Extension></Extension> to show empty, for the rest I don't want them showing when null

Re: XML file generation

Anonymous — Wed, 03 Feb 2021 08:27:00 GMT

Try to convert null value of extension column to empty string on tMap before tAdvancedFileOutputXML.

row1.extension==null?"":row1.extension

and uncheck the 'Create empty element if needed' box.

Regards

Shong

Re: XML file generation

stan1609735726 — Thu, 04 Feb 2021 03:28:16 GMT

Thank you for your help. This is working

Re: XML file generation

stan1609735726 — Thu, 04 Feb 2021 03:29:12 GMT

Thanks you for your help. This is working.