Big problem with tAdvancedFileOutputXML

Highlighted
One Star

Big problem with tAdvancedFileOutputXML

Hello,
I have a big problem with tAdvancedFileOutputXML.
I want to generate an XML file where atributes are mapped in 2 differents way. Here is an example :
  <body>
    <p1:items>
      <p1:item>
        <p1:itemName>name1</p1:itemName>
        <p1:itemNumber>number1</p1:itemNumber>
        <p1Smiley Tongueroperties>
          <property>
            <key>key1</key>
            <value>value1</value>
          </property>
          <property>
            <key>key2</key>
            <value>value2</value>
          </property>
        </p1Smiley Tongueroperties>
      </p1:item>
      <p1:item>
        <p1:itemName>name2</p1:itemName>
        <p1:itemNumber>number2</p1:itemNumber>
        <p1Smiley Tongueroperties>
          <property>
            <key>key3</key>
            <value>value3</value>
          </property>
        </p1Smiley Tongueroperties>
      </p1:item>
    </p1:items>
  </body>
As you can see, attributes of each item are on 2 types :
- specific tags (itemName, itemNumber)
- generic tags (property, key, value)
I don't have any problem with the specific tags but I cannot add generic tags
I tried to do it with 2 tAdvancedFileOutputXML : the first create the XML file and writes the specific attributes, the second update the XML fil adding generic attributes. I import an XML tree from a XSD file.
It doesn't work, I always have the same message :
WARN : the root tag is not same when appending
Exception in component tAdvancedFileOutputXML_3
java.lang.NullPointerException
I don't know how to do.
Can someone help me ? Is the way I am following is the good ? Or is there another better way to do what I want ? Which components may I use ?
It is very urgent, thank you for your help
One Star

Re: Big problem with tAdvancedFileOutputXML

Nobody can help me ?!!!
One Star

Re: Big problem with tAdvancedFileOutputXML

That is the error message you get when trying to append to a non-existing file. Uncheck tAdbancedFileOutputXML's "Append the source xml file" checkbox (at least for the first time you run it) or point "File Name" to an existing XML.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads