Data form DataSource XML won't display on the grid

Hi everyOne,

The framework need the Xml structur like below

<data> <item id="1"> <Name><![CDATA[Dammann]]></Name> <Department><![CDATA[Legal Department]]></Department> <Gender><![CDATA[Male]]></Gender> </item> <item id="2"> <Name><![CDATA[Barby]]></Name> <Department><![CDATA[Human Resources]]></Department> <Gender><![CDATA[Female]]></Gender> </item> </data>

and the XML returned by the dataSource is like:

<?xml version='1.0' encoding='utf-8' ?>
<rows>
<row id='3'>
<cell><![CDATA[value]]></cell>
<cell><![CDATA[value]]></cell>
<cell><![CDATA[value]]></cell>
</row>
</rows>

I use latest version of phpConnector and 5.0.2 pro evaluation for DhtmlxSuite

When i use JSONDataConnector on server side, the date format is wrong, and when I select one row on the grid, the form can’t render the date and display “Invalide Date”.
On client side form Json I have:
[{
type:“calendar”… dateformat:“%d/%m/%Y”…
}]
the format the records on the DB is like 2016-05-25
Questions:
how I can fix that problem?
is there some method for the dataSource to convert the structure?

Thanks for intension

the date format is wrong

You can use beforeRender server side event to format data before output to a client side

THANKS A LOT! IT’WORK FINE