Desktop - load JSON data into grid

[michail_w]

Hello,
I'm trying to edit web desktop example.
I want to display standard Desktop grid, but i want to display external data. I tried to modyfy this code:

ds: new Ext.data.Store({
       reader: new Ext.data.ArrayReader({}, [
           {name: 'surname'},
           {name: 'name'},
           {name: 'age', type:'number'},
           {name: 'lastVisit', type:'date', dateFormat: 'Y-m-d H:i'}
        ]),
        data: Ext.grid.dummyData
}),

but my changes make desktop only with background and icons. I want to load JSON data from external file. Not from local Array (ext.grid.dummydata). Do you have any ideas?

[Condor]

Have a look at the grid examples (you need to configure a store proxy for your remote data location).

[michail_w]

I tried this code:

ds: new Ext.data.Store({
       proxy: new Ext.data.HttpProxy({url: 'json.php'}),
       reader: new Ext.data.JsonReader({
            totalProperty: 'total',
            successProperty: 'success',
            root: 'database',
            messageProperty: 'message'
       }, [
            {name: 'surname'},
            {name: 'name'},
            {name: 'age'},
            {name: 'lastVisit', type:'date', dateFormat: 'Y-m-d H:i'}
       ])
}),

but it doesn't work. Can someone fix my mistakes?

[Condor]

Are you loading the store (use autoLoad:true if you don't)?

ps. Does json.php match the reader as you defined it?

[CrazyEnigma]

What does json.php return?

Did you configure the grid's columns correctly?

[michail_w]

Is autoLoad corectly implemented?

ds: new Ext.data.Store({
       proxy: new Ext.data.HttpProxy({url: 'json.php'}),
       reader: new Ext.data.JsonReader({
            totalProperty: 'total',
            successProperty: 'success',
            root: 'database',
            messageProperty: 'message'
       }, [
            {name: 'surname'},
            {name: 'name'},
            {name: 'age'},
            {name: 'lastVisit', type:'date', dateFormat: 'Y-m-d H:i'}
       ]),
     autoLoad:true
}),

json.php returns:

{'database':[{'surname':'Wójtowicz','name':'Michał','age':19,'lastVisit':'2010-01-01 12:00'}]}

[Condor]

Correct (although you should remove totalProperty, successProperty and messageProperty).

If you still don't see anything, then you have to debug (use the Firebug Net tab to see if the server request and response are correct).

[michail_w]

Thank you, it works!