Repeating first item in XMLP reports

In an XMLP report, I was finding that the first item (first data entry) was being repeated in the report. The remainder of the items in the report were displaying as expected. After some investigation, a colleague pointed out that this was caused by the root element and data tags having the same value:

For example:

<?xml version='1.0'?>
<DATA>
  <DATA>
  </DATA>
</DATA>

The key is that the tag <DATA> is both the root level element and the tag used by the data elements.

The XML format actually required is this:

<?xml version='1.0'?>
<ROOT_ELEMENT>
  <DATA>
  </DATA>
</ROOT_ELEMENT>

What was causing the issue in this case was the XML file layout field tag. This is set in the file layout properties in the use tab. There is a field there called File Definition Tag. This is where you set the root element tag:

file-layout-file-definition-tag.png
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License