Error using XML Loader: XML not well-formed

[Former Member]

Hi all,

I am facing a problem using the XML loader in xMII 12.0 when trying to load the following XML file:

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

<Users>

<User>

<UserID>IMXOO</UserID>

<CWID>IMXOO</CWID>

<Prename>Michael</Prename>

<Surname>Otto</Surname>

<CreatedOn>2001-12-31T12:00:00</CreatedOn>

<CreatedBy>IMXOO</CreatedBy>

</User>

</Users>

I also tried a most basic XML file which shows the same error:

<?xml version="1.0"?>

<ausgabe>

<anzeige>Testausgabe</ausgabe>

</ausgabe>

To my understanding both files are well-formed, however xMII shows the error:

"The markup in the document following the root element must be well-formed."

Do I break any rules concerning the markup? IE loads the files without showing any errors.

Best Regards

Michael

[jcgood25 · Accepted solution]

Michael,

What is the path you are using in the configure dialog of the XMLLoader action block (with 12.0 http://localhost doesn't work the same as it did in 11.5)? Assuming you have the xml files saved in the WEB section of a project, have you tried dragging the XML file from the catalog tree into a transaction. This drag-n-drop should create an xml loader action block for you.

Regards,

Jeremy

[abesh · Accepted solution]

Michael,

Just a note :

Your demo XML is :

<?xml version="1.0"?>

<ausgabe>

<anzeige>Testausgabe<b></ausgabe></b>

</ausgabe>

shouldn't it be

<?xml version="1.0"?>

<ausgabe>

<anzeige>Testausgabe<b></anzeige></b>

</ausgabe>

Can you tell me if this loads in 12.0 ?

[Former Member · Accepted solution]

Jeremy,

again you gave the key to the solution. When the error occured, I have set up the following path within the xMII workbench:

"Catalog-Tab"

<server>

&nbsp;&nbsp;> Sandbox

&nbsp;&nbsp;&nbsp;&nbsp; > XML

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; myFile.xml

When I tried to load the mxFile.xml with the XML Loader, I got the error described above (XML not well-formed). I also cannot drag the file into a transaction in the workbench. I have manually configured the XML Loader with "http://<server:port>/XMII/CM/Sandbox/XML/mxFile".

Now using your hint I have changed to the "Web-Tab":

"Web-Tab"

<server>

&nbsp;&nbsp; > Sandbox

&nbsp;&nbsp;&nbsp;&nbsp; > WEB

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; > XML

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; myFile.xml

Then all works fine, when I now drag the file into the transaction. As you described, an XML Loader action is created with configuration "db://Sandbox/WEB/XML/myFile.xml" and the XML is loaded correctly.

Thanks for your help!

Best regards

Michael

[Former Member]

Michael - I've also seen some very strange behavior with loading XML data in version 12. Some of the transactions that I migrated from version 11.5 I can't open in version 12, with similar errors to what you are seeing. I've reported a bug, but you should also do the same. The more visible, the higher priority a fix will be.

- Rick

[Former Member]

Hi Rick,

thanks for your answer. I have created a sapnet message. Is there any workaround on this? We are storing our data in XML files, so we need to load those files.

Best Regards

MIchael