Questions on Kendo UI for jQuery Forum

13 answers

1.5K+ views

Good way to populate entire hierarchical datasource with one data call

Starting with the idea that there was a data query that returned multiple levels of a hierarchy in one query, what is the best way to populate a hierarchical data source with it?

For instance, take a table that has Continent, Country, Region, City as four separate columns.
How could we avoid the inefficiency of populating the hierarchy with a few thousand queries and subqueries, and instead parse the single recordset and populate the hierarchy.

Example Data:
North America, United States, Virginia, Richmond
North America, United States, Virginia, Charlottesville
North America, United States, Alaska, Anchorage
North America, Canada, Ontario, Windsor
Europe, England, Essex, Rochford

Example Hierarchy:
--- North America
--- North America --- Canada
--- North America --- Canada --- Ontario
--- North America --- Canada --- Ontario --- Windsor
--- North America --- United States
--- North America --- United States --- Alaska
--- North America --- United States --- Alaska --- Anchorage
--- North America --- United States --- Virginia
--- North America --- United States --- Virginia --- Richmond
--- North America --- United States --- Virginia --- Charlottesville
--- Europe
--- Europe --- England
--- Europe --- England --- Essex
--- Europe --- England --- Essex --- Rochford

Hierarchical Data Source

answered on 06 Nov 2017

3 answers

2.3K+ views

Hide column from export Excel (Grid MVVM)

<div id="GridIdt" data-role="grid"

data-toolbar="['excel']"

data-excel='{fileName: "doc.xlsx", proxyURL: "http://demos.telerik.com/kendo-ui/service/export",filterable: true}'

data-columns="[

{ 'field': 'name','title':'Nome',width:200},

{ 'field': 'surname','title':'Cognome',excel:false},

{ 'field': 'empty','title':'Stato',width:140}

]"

data-bind="source: GridSource">

I'd like to remove 'Cognome' from excel file. How hide this column in the excel file?

And ,also, i'd like to remove 'Nome' from the view of grid.

excel: name and empty.

grid: surname and empty.

datasource: name,surname and empty.

How I can do this? 'excel:false' doesn't work!

Grid

answered on 06 Nov 2017

30 answers

1.1K+ views

Memory leak on create and destroy grid

Hi,

I am building a single page application an i am noticing memoryleaks in Kendo Grid

I i create a grid and then destroy the grid it seems it is not cleaning up correctly.

I have created a fiddle that demonstrates this.
I have also included a html file.

If you look in the chrome developer tools in the timeline tab after creating and destroying a grid you will see that the dom node count is growing.
Am i doing something wrong?

Grid

answered on 06 Nov 2017

1 answer

151 views

How to set '/n' in the field of grid

I would like to set the '/ n' in the response string and display it in the column without using the template.

What should I write in ajax's response?

'/n' doesn't work!

Grid

answered on 06 Nov 2017

5 answers

223 views

Move Shape(group) to reduce distance

Haven't had much luck with a support ticket so will try here instead.

After creating a diagram object, the distance between the shapes (group) is too big.

Now I can reduce this manually on screen.

How do I go about selecting the group and moving the object a certain amount of pixels to the left?

Diagram

answered on 06 Nov 2017

1 answer

1.5K+ views

HammerJS error

I get the error below when trying to use a Kendo Chart in a Angular application.

I have installed hammerjs via npm and also loaded the library by using

import "hammerjs";

in my component typescript file.

Not sure what I've missed ?

core.es5.js:1020 ERROR Error: Hammerjs is not loaded.Solution: http://www.telerik.com/kendo-angular-ui/components/charts/troubleshooting/#toc-hammerjs-is-not-loaded

at Function.webpackJsonp.../../../../@progress/kendo-angular-charts/dist/es/events/dom-events-builder.js.DomEventsBuilder.create (dom-events-builder.js:16)
at Function.create (dom-events-builder.js:11)
at Chart._attachEvents (chart.js:613)
at chart.js:69
at Function.loadFonts (font-loader.js:45)
at Function.preloadFonts (font-loader.js:53)
at new Chart (chart.js:65)
at ChartComponent.webpackJsonp.../../../../@progress/kendo-angular-charts/dist/es/chart.component.js.ChartComponent.createInstance (chart.component.js:127)
at chart.component.js:245
at ZoneDelegate.webpackJsonp.../../../../zone.js/dist/zone.js.ZoneDelegate.invoke (zone.js:392)

Charts

answered on 03 Nov 2017

2 answers

1.2K+ views

How to set width of columns in the excel?

How to set width of columns in the excel with mvvm grid?

I have this function in the viewmodel:

$("#gridall").data("kendoGrid").bind("excelExport", function (e) {

var sheet = e.workbook.sheets[0].columns;

});

I'd like to set autoWidth property for all columns;

Grid

answered on 03 Nov 2017

1 answer

145 views

Bug or configuration issue? (work hours)

I am having trouble with time zones and scheduled work hours. When I select "Show Full Day", it shows events correctly, however, when the scheduler is limited to the business hours, the visibility cutoff seems to be mid-day. Even though my start time is earlier.

Here is an example: http://dojo.telerik.com/IdoNec/12

Switch between "Show Full Day" and "Show Business Hours" to see the issue.

Do I just have a configuration problem or is this a bug?

Scheduler

answered on 03 Nov 2017

5 answers

1.3K+ views

Bulk delete of selected items

I'm brand new to MVC and Kendo. Is there a way to allow for the bulk delete of selected items from a grid. I have the grid populating with items from the database. I have a button control on the page that I'd like to be able to click and delete all the currently selected items from the grid. Is this possible by either passing the list of items to the controller or somehow getting access to the selected items from the controller method?

I understand the functionality exists to handle this on an item by item basis with a delete button in the row itself, but hoping there is a way to do this in bulk.

Thanks,
Jason

Grid