onXLE not loading data

Suite and Optimus Suite 5
#1

Thanks for you taking the time to review my question.

I am looking for your assistance in troubleshooting why data on grid is not loading. Here is a snippet of my code

[code] grid.setHeader(gridColumns.getHeaders());
grid.setInitWidths(gridColumns.getWidths());
grid.setColAlign(gridColumns.getAlignments());
grid.setColTypes(gridColumns.getColTypes());
grid.setColSorting(gridColumns.getColSortTypes());
grid.attachHeader(gridColumns.getAttachedHeaders());
grid.enableSmartRendering(true,2000,100);
grid.enableMultiselect(true);
…
grid.attachEvent(“onXLE”, function(grid_obj, count1) {
if (!this.getRowsNum()) {
this.addRow(this.uid(), “No records not found”);
}
else {
alert(“I am here”);
}
});

grid.loadXML("some.php", function(){
  alert("done loading data"); 
});

[/code]

Data fetched by the “some.php” is extracted from an oracle database, the xml that is returned is here:

<rows total_count="1">
<row id="2">
<cell />
<cell />
<cell>2</cell>
<cell>12345</cell>
<cell>12345</cell>
<cell>ALL CUSTOMERS</cell>
<cell>9</cell>
<cell>Preferred (9)</cell>
<cell>9891</cell>
<cell>12</cell>
<cell>Andorra - Other (12)</cell>
<cell>IND</cell>
<cell>12345</cell>
<cell>12345</cell>
<cell>ALL CUSTOMERS</cell>
<cell>10</cell>
<cell>0</cell>
<cell />
<cell />
<cell />
<cell />
<cell>0</cell>
<cell>0</cell>
<cell>04-FEB-16</cell>
<cell>04-FEB-16</cell>
<cell>manish</cell>
<cell>manish</cell>
<cell>04-FEB-16</cell>
</row>
</rows>

RAW XML

<?xml version='1.0' encoding='iso-8859-1' ?><rows total_count='1'><row id='2'><cell><![CDATA[]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[2]]></cell><cell><![CDATA[12345]]></cell><cell><![CDATA[12345]]></cell><cell><![CDATA[ALL CUSTOMERS]]></cell><cell><![CDATA[9]]></cell><cell><![CDATA[Preferred (9)]]></cell><cell><![CDATA[9891]]></cell><cell><![CDATA[12]]></cell><cell><![CDATA[Andorra - Other (12)]]></cell><cell><![CDATA[IND]]></cell><cell><![CDATA[12345]]></cell><cell><![CDATA[12345]]></cell><cell><![CDATA[ALL CUSTOMERS]]></cell><cell><![CDATA[10]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[04-FEB-16]]></cell><cell><![CDATA[04-FEB-16]]></cell><cell><![CDATA[manish]]></cell><cell><![CDATA[manish]]></cell><cell><![CDATA[04-FEB-16]]></cell></row>
</rows>

I am not getting an incorrect XML error, and I don’t think there is anything wrong with this XML, I am not sure where/what else to look at, if you can point me in the right direction, that will be a big help.

#2

Please ignore my request. I got this setup to work.

#3

Your help in this regards will be much appreciated. I understand, I am adding my post to a very old thread.

But, as it seems that I am looking for additional help, for me the onDynXLS fires, but not onXLE event .

Let me know if I should provide more code snippets.

    grid.setHeader(gridColumns.getHeaders());
    grid.setInitWidths(gridColumns.getWidths());
    grid.setColAlign(gridColumns.getAlignments());
    grid.setColTypes(gridColumns.getColTypes());
    grid.setColSorting(gridColumns.getColSortTypes());
    grid.attachHeader(gridColumns.getAttachedHeaders());
    grid.enableSmartRendering(true,2000,100);
    grid.enableMultiselect(true);
...
    grid.attachEvent("onXLE", function(grid_obj, count1) {
      if (!this.getRowsNum()) {
        this.addRow(this.uid(), "No records not found");
      }
      else {
        alert("I am here");
      }
    });

    grid.loadXML("some.php", function(){
      alert("done loading data"); 
    });

XML seems to be fetched correctly:

<rows total_count="1">
<row id="1">
<cell>
<![CDATA[ ]]>
</cell>
<cell>
<![CDATA[ ]]>
</cell>
<cell>
<![CDATA[ 1 ]]>
</cell>
<cell>
<![CDATA[ 1 ]]>
</cell>
<cell>
<![CDATA[ ]]>
</cell>
<cell>
<![CDATA[ ]]>
</cell>
<cell>
<![CDATA[ ]]>
</cell>
<cell>
<![CDATA[ ]]>
</cell>
<cell>
<![CDATA[ ]]>
</cell>
<cell>
<![CDATA[ ]]>
</cell>
<cell>
<![CDATA[ ]]>
</cell>
<cell>
<![CDATA[ ]]>
</cell>
<cell>
<![CDATA[ ]]>
</cell>
<cell>
<![CDATA[ ]]>
</cell>
<cell>
<![CDATA[ 22-NOV-16 ]]>
</cell>
<cell>
<![CDATA[ 22-NOV-16 ]]>
</cell>
<cell>
<![CDATA[ ]]>
</cell>
<cell>
<![CDATA[ ]]>
</cell>
<cell>
<![CDATA[ ]]>
</cell>
<cell>
<![CDATA[ ]]>
</cell>
<cell>
<![CDATA[ ]]>
</cell>
<cell>
<![CDATA[ ]]>
</cell>
<cell>
<![CDATA[ ]]>
</cell>
<cell>
<![CDATA[ ]]>
</cell>
<cell>
<![CDATA[ ]]>
</cell>
<cell>
<![CDATA[ ]]>
</cell>
<cell>
<![CDATA[ ]]>
</cell>
<cell>
<![CDATA[ 22-NOV-16 ]]>
</cell>
<cell>
<![CDATA[ manish ]]>
</cell>
</row>
</rows>
#4

onXLE event or the callback function of the loadXML method signals that the data is loaded and rendered successfully.
most probably the problem is with your xml file.
Could you please, provide with the complete demo, where the problem can be reconstructed locally.
Here you can find a tutorial about creating a complete demo:
docs.dhtmlx.com/tutorials__auxil … pport.html