Proper Formating of XML for Grid display

Suite and Optimus Suite 5
#1

I have XML files produced by another app that I would like to display in a grid, but the format of these files is not compatible with the grid. Where can I find info about the proper format of an XML file for displaying in the grid? Here is the syntax used in these XML files:

<?xml version=“1.0” standalone=“yes”?>
<Results>
<Fields ID=“144”>
<dDate>4/19/2016</dDate>
<Unit>901</Unit>
<Mileage>1234</Mileage>
<VIN>TEST</VIN>
<Comments>testing</Comments>
</Fields>
<Fields ID=“301”>
<dDate>5/1/2016</dDate>
<Unit>M8</Unit>
<Mileage>63412</Mileage>
<VIN>1234</VIN>
<Comments>
</Comments>
</Fields>
<Fields ID=“305”>
<dDate>5/1/2016</dDate>
<Unit>M7</Unit>
<Mileage>43424</Mileage>
<VIN>1234</VIN>
<Comments>
</Comments>
</Fields>
<Fields ID=“306”>
<dDate>5/1/2016</dDate>
<Unit>S3</Unit>
<Mileage>169206</Mileage>
<VIN>1234</VIN>
<Comments>
</Comments>
</Fields>
… etc.

Why won’t this XML syntax display? What needs to be changed above so that the XML displays in the grid?

Thank you!

#2

Here you can find the supported format of xml for the dhtmlxGrid:
https://docs.dhtmlx.com/grid__data_formats.html#xmlformat
you can also use the custom loading data format but you need to configure it. Here you can find a tutorial:
https://docs.dhtmlx.com/grid__data_formats.html#customdataformat