Native JSON Format with Config

Suite and Optimus Suite 5
#1

I’m attempting to configure my grid using the Native JSON format following the docs from here:
docs.dhtmlx.com/grid__json_configuration.html

My JSON: { "head": [{ "id": "siteCode", "width": 60, "type": "ro", "align": "left", "sort": "int", "value": "Site Code" }, { "id": "originalBudget", "width": 100, "type": "ron", "align": "left", "sort": "str", "format": "$0.00", "value": "Original Budget" }, { "id": "budgetModifications", "width": "100", "type": "ron", "align": "right", "sort": "int", "format": "$0.00", "value": "Budget Modifications" }, { "id": "revisedBudget", "width": 100, "type": "ron", "align": "left", "sort": "str", "format": "$0.00", "value": "Revised Budget" }, { "id": "pendingBudgetChanges", "width": 100, "type": "ron", "align": "left", "sort": "str", "format": "$0.00", "value": "Pending Budget Changes" }, { "id": "projectedBudget", "width": 100, "type": "ron", "align": "left", "sort": "str", "format": "$0.00", "value": "Projected Budget" }, { "id": "committedCosts", "width": 100, "type": "ron", "align": "left", "sort": "str", "format": "$0.00", "value": "Committed Costs" }, { "id": "approvedCos", "width": 100, "type": "ron", "align": "left", "sort": "str", "format": "$0.00", "value": "Approved Changes" }, { "id": "revisedCommitments", "width": 100, "type": "ron", "align": "left", "sort": "str", "format": "$0.00", "value": "Revised Commitments" }, { "id": "pendingCostChanges", "width": 100, "type": "ron", "align": "left", "sort": "str", "format": "$0.00", "value": "Pending Cost Changes" }, { "id": "projectedCosts", "width": 100, "type": "ron", "align": "left", "sort": "str", "format": "$0.00", "value": "Projected Costs" }, { "id": "forecastToComplete", "width": 100, "type": "ron", "align": "left", "sort": "str", "format": "$0.00", "value": "Forecast to Complete" }, { "id": "eac", "width": 100, "type": "ron", "align": "left", "sort": "str", "format": "$0.00", "value": "Estimate at Completion" }], "data": [{ "originalBudget": 18230000, "budgetModifications": 0, "revisedBudget": 18230000, "pendingBudgetChanges": 0, "projectedBudget": 18230000, "committedCosts": 18730000, "approvedCos": 0, "revisedCommitments": 18730000, "pendingCostChanges": 0, "projectedCosts": 18730000, "forecastToComplete": -500000, "eac": 18730000, "siteCode": "000", "id": 1 }] }

I have tried grid.parse(data, 'json'); as well as grid.parse(data,'js'); I get the header configured, but no rows.
Thank you,

Kevin

#2

So the docs might be a bit misleading… Following the Native JSON format instructions on this page http://docs.dhtmlx.com/grid__json_configuration.html does not work for loading data. The header is configured but no data gets loaded. I switched to the data format explained here: http://docs.dhtmlx.com/grid__data_formats.html#jsonformat and the rows render, but the formatting (alignment, col type, and format) works. The widths work, so perhaps I’m missing something? Is there a way to configure that via JSON?

#3

Please, make sure that you’ve specified the ids for your columns using the setColumnIds() method:
docs.dhtmlx.com/api__dhtmlxgrid_ … mnids.html
Here you can find a working example of loading the header+data from the plain json to the grid:
dhtmlx.com/docs/products/dhtmlxG … ig_js.html

#4

Is this functionality available on standard version (5.0 or 5.1)?
I have empty grid and error in javascript console

If call setHeader() and init() methods for initialization grid object, then all data load correct (not header). I’m expecting initialization grid header from json, but i don’t understand how it’s work properly.

P.S. For my tests i get json files from dhtmlx samples (gridConifg.json, gridConfig2.json).

#5

Unfortunately the initialization from json is available in PRO version only.