DSXchange

Posted: **Mon Apr 07, 2008 6:41 am**

Hi, I am extracting an XML file into a table. I have got the XML file to have one recor, two fields, but still get this warning

Code: Select all

MultiDataConvertXMLDatatest..XML_Input: XSLT Processor: Unknown element on the output. Element Name = "AccountNumberLedgerCode"

I am using a folder stage to an xml stage to the transformer to the table.

the XML fil looks like this

Code: Select all

  <?xml version="1.0" encoding="ISO-8859-1" ?> 
- <ExtractPayment>
-      <Record>
          <OwnerNumber>0155105</OwnerNumber> 
          <AccountNumberLedgerCode>one</AccountNumberLedgerCode> 
        </Record>
  </ExtractPayment>

The real XML a lot more fields and i am getting the warning with quite a few.

ANy ideas?

Thanks[/code]

Posted: **Mon Apr 07, 2008 6:45 am**

What do your XPath Expressions look like for your example? And what are your XML Input settings?

Posted: **Mon Apr 07, 2008 7:00 am**

Ahha, thanks Craig.
the definitions were looking like this:

Code: Select all

/ExtractPayment/Record/AccountNumberLedgerCode

changed to look like this

Code: Select all

/ExtractPayment/Record/AccountNumberLedgerCode/text()

no more warnings.
Thanks

Posted: **Mon Apr 07, 2008 7:02 am**

Ahha, thanks Craig.
the definitions were looking like this:

Code: Select all

/ExtractPayment/Record/AccountNumberLedgerCode

changed to look like this

Code: Select all

/ExtractPayment/Record/AccountNumberLedgerCode/text()

no more warnings.
Thanks

Posted: **Mon Apr 07, 2008 9:31 am**

There you go. Time to mark the thread as Resolved, it seems.

Posted: **Mon Apr 07, 2008 3:22 pm**

Moderator: please move to server forum

DSXchange

Unknown element on the output warning

Unknown element on the output warning