Load column settings from xml in kendo grid

[Sag]

Hi,

 

Is there any way that I can load the column settings of kendo grid using an XML. I will have the columns settings such as Column Name, width, visibility,order of display saved in a form of an XML some where in the configuration. User can manipulate the XML based on how he want to view the columns, so he has the complete command on which columns to display and in what order. There is always an option of reading the XML, form a Array of objects and assign it to "columns" property in the grid.

But is there any way that I can read that XML directly from a source and load or assign it to property so that my job gets easier?

 

Thanks,

Sag

[Konstantin Dikov]

Hello Sag,

Parsing the XML data and passing the "columns" collection to the Grid (on initialization or within the setOptions method) is what could be used for achieving the desired behavior. The following article shows how to parse XML data to JavaScript array, which could be then used in the Grid's initialization:

• https://andrew.stwrt.ca/posts/js-xml-parsing/

And here is a link to the "setOptions" method of the Grid, which allows the settings of the Grid to be changed dynamically:

• https://docs.telerik.com/kendo-ui/api/javascript/ui/grid/methods/setoptions

Hope this helps.


Regards,
Konstantin Dikov
Progress Telerik

[Sag]

Hi Dikov,

Thanks for your inputs and pointer for parsing xml to js objects.

Regards,

Sag

[Sag]

Hi,

I implemented an autocomplete column in the grid with grouping enabled. Demo provided in the below

http://dojo.telerik.com/AkiDoheZ/3

When I try to group the grid by Product Name(which is an autocomplete column), after I drop the column header, UI is getting struck with busy indicator. Any ideas on how to enable grouping on columns that has autocomplete control?

Thanks in advance.

[Konstantin Dikov]

Hi Sag,

The column in question is bound to a complex object and grouping complex objects is not supported. In order for the grouping (sorting, filtering, etc.) to work you need to set the column to be bound to a property of the complex object:

{field:"Product.Name",title:"Product Name",editor: ProductNameAutoCompleteEditor, width: "130px", template: "#=Product.ProductName#"}],

Hope this helps.


Regards,
Konstantin Dikov
Progress Telerik

[Sag]

Hi Dikov,

Thanks for the reply. I thought to bind the column to a property of complex object as a work around but didn't think that that's the only solution. Anyway thanks for the help. I have another question though.

I tried to implement kendoSortable for one of the requirement. I am able to re-arrange the rows but I found an issue when I tried to include this feature. Please refer to below example.

http://dojo.telerik.com/aQIjuGAT

Issue repro steps:

1. Change "Unit Price" of any row.

2. Do not press Tab or do not click on the other column of same row. Instead directly click on any other row.

3. Previously changed value is gone.

If we Remove the kendoSortable functionality, everything works fine. So is this some kind of a product bug or is this a limitation of using kendoSortable feature?

[Konstantin Dikov]

Hello Sag,

The Batch editing relies on the blur event of the INPUT elements to apply the changes to the underlying dataItem, but when the Sortable widget is initialized over the Grid, the reordering of the DOM elements breaks the internal editing logic of the Grid. In order to overcome that issue you could follow the approach demonstrated in the following HowTo example:

• https://docs.telerik.com/kendo-ui/controls/interactivity/sortable/how-to/use-sortable-grid#editable-grid-mode

Best Regards,
Konstantin Dikov
Progress Telerik