Telerik Forums
Kendo UI for jQuery Forum
1 answer
156 views
Is it possible to connect kendo ui pivotgrid to our SSAS service in SQL 2012 Ent ? I configured HTTP XMLA on IIS and it works with Excel, Visual Studio or Management studio. I am sure in my configurations. your demo example works but it is obviously SSAS 2008R2.

 

$("#pivotgrid").kendoPivotGrid({
            configurator: "#pivotconfigurator",
            height: 550,
            dataSource: {
                type: "xmla",
                transport: {
                    connection: {
                         
                       catalog: "AdventureWorksDW2012Multidimensional-EE",
                       cube: "Adventure Works"
                    },
                    read: {
                        url: "http://test.cz/olap/msmdpump.dll",
                    }
                },
                error: function (e) {
                    alert("error: " + kendo.stringify(e));
                },
                schema: {
                    type: "xmla"
                }
            }
        });

Stefan
Telerik team
 answered on 07 Sep 2016
5 answers
493 views
Hey everyone,

i'm facing a problem with the scheduler. I've made a sample with two events, one in timezone "Europe/Berlin" and one in "America/Los Angeles". Both events are starting at 09:00 AM and end at 12:00 AM on 28.05.2014. Both are shown correctly in the scheduler overview (the LA event -9 hours prior to the Berlin event which is correct).

But when I open the LA event for editing, the time gets messed up (9 hours are substracted from the start and end time which moves the event to 27.05.2014). Editing the Berlin event shows the correct time in the edit dialog.

My local timezone is Europe/Berlin and i'm using KendoUI Q1 2014.

Here's the example code which reproduces the problem for me:

<div id="scheduler"></div>
 
    <script src="javaSources/js/jquery.min.js"></script>
    <script src="javaSources/js/kendo.all.js"></script>
    <script src="javaSources/js/kendo.timezones.js"></script>
    <script src="javasources/js/cultures/kendo.culture.de-DE.js"></script>
    <script type="text/javascript">
        kendo.culture("de-DE");
    </script>
 
    <script>
        $(function () {
            "use strict";
 
            var dsScheduler = new kendo.data.SchedulerDataSource({
                data: [
                    { "Description": "", "End": "\/Date(1401271200000)\/", "IsAllDay": false, "PublicEvent": false, "Start": "\/Date(1401260400000)\/", "StartTimezone": "Europe\/Berlin", "TaskId": 30, "Title": "No title" },
                    { "Description": "", "End": "\/Date(1401271200000)\/", "IsAllDay": false, "PublicEvent": false, "Start": "\/Date(1401260400000)\/", "StartTimezone": "America\/Los_Angeles", "TaskId": 32, "Title": "No title" }
                ],
                schema: {
                    //timezone: "Europe/Berlin", // nicht setzen, damit Termin aus verschiedenen Zeitzonen auch korrekt angezeigt werden!!
                    model: {
                        id: "taskId",
                        fields: {
                            taskId: { from: "TaskID", type: "number", defaultValue: -1 },
                            title: { from: "Title", defaultValue: "No title", validation: { required: true } },
                            start: { type: "date", from: "Start" },
                            end: { type: "date", from: "End" },
                            startTimezone: { from: "StartTimezone", defaultValue: "Europe/Berlin" },
                            endTimezone: { from: "EndTimezone" },
                            description: { from: "Description" },
                            recurrenceId: { from: "RecurrenceID" },
                            recurrenceRule: { from: "RecurrenceRule" },
                            recurrenceException: { from: "RecurrenceException" },
                            isAllDay: { type: "boolean", from: "IsAllDay", defaultValue: false }
                        }
                    }
                }
            });
 
            var kScheduler = new kendo.ui.Scheduler($("#scheduler"), {
                dataSource: dsScheduler,
                //timezone: "Europe/Berlin", // nicht setzen, damit Termin aus verschiedenen Zeitzonen auch korrekt angezeigt werden!!
                height: 500,
                views: [
                    "day",
                    "week",
                    { type: "month", selected: true },
                    "agenda"
                ]
            });
 
        });
    </script>

Any ideas whats wrong?

Regards,
Michael
Vladimir Iliev
Telerik team
 answered on 07 Sep 2016
3 answers
310 views

Hi, 

Is it possible to highlight (set background colour of) a specific date regardless of the view the user is looking at?

I've tried to combine Set Slot Background Color Using Slot Templates and views.dayTemplate however I havent been very successful.

Note that Im trying to set the background colour of a day NOT the colour of an event.

Thanks and Kind Regards, 
Grant

Plamen
Telerik team
 answered on 07 Sep 2016
4 answers
519 views

I have a grid and I've created a custom compare routine for one of the columns. When I click the header (sorting ascending) the data is sorted and the UI reflects the newly sorted ordering. I can tell that my compare method is being called and since the sort order is correct, that it is correct. When I click the header again, while I see that the compare method is called, and it is returning the correct values, the UI does not update to reflect the descending sort ordering. There are no javascript errors reported, so I am at a loss - it seems that all the parts are working except that the UI is not updating properly.

If anyone has any ideas on things I can check and/or try, I'd appreciate your help.

Mark
Top achievements
Rank 1
 answered on 06 Sep 2016
1 answer
102 views

For autoComplete dataItem takes only number, but valid parameter is also JQuery.

select: (e) =>
            {
                let di = e.sender.dataItem(e.item);

Rumen
Telerik team
 answered on 06 Sep 2016
3 answers
166 views

Hi,

we are using Kendo Professional in an SPA application (only JS and WebApi) and we have a couple use cases of localization that we cannot achieve using documented methods and practices, so we are turning to this forum for help.

What we have now

We use mainly MVVM and already have a setup that allows us to load the correct culture/messages files and replace data-attributes that contain text with the updated strings; sometimes we have non-mvvm widgets that we call setOptions on manually.

We also have about a dozen custom widgets with texts in options like:

options: {
    name: "...",
    windowTitle: null,
    windowHeight: "50%",
    windowWidth: "50%",
    placeholder: null,
    inputPlaceholder: null,
    resultsPlaceholder: "Type something in the above field",
    ...
}

First use-case: complete app-localization

  1. What is the right approach to localize widget options? Like input placeholders, windows titles, etc ...
  2.  Is there a way to refresh widgets' data-attributes? (could calling setOptions for every widget, with the new parsed options from the element, be a solution?)

We have looked at stackoverflow, general blogs and this forum but no one seems to have a proposed solution. Only this thread was heading in the right way but it died years ago.

We don't want to put resources in viewmodels because we'd have to refactor many views and because a viewmodel should not be aware of what widget is currently rendered.

Second use-case: single view layout change

We have a custom view (with a single viewmodel) that should have different layout based on a user-selection, currently we are doing this:

  1. calling kendo.destroy/unbind on the #view
  2. replacing the innerHTML of the #view
  3. calling kendo.bind(#view, viewmodel)

This is leading to big memory leaks and general bad performances after 3/4 executions.

What is the correct way of doing this?

Third use-case: single view/widget localization

Additionally, we have a single view that should be localized independently from the rest of the application; currently we are doing as indicated in theuse case nr 2 (destroy, update data-attributes, bind again); we know that this won't localize dates/currencies but we have only custom widgets in this view so it is not a problem for now.

This is causing the same memory leak as above that leads to several Megabytes (if not a Gigabyte) if used ram for the single chrome page if this function is called more than 6-10 times in a row, and the browsed becomes unusable after less than 10 times.

This could be replaced with a setOptions on all the fields if was implemented something like a kendo.refresh($element) that re-parses all data-attributes and calls setOptions.

 

Thank you in advance.

Fabio
Top achievements
Rank 1
 answered on 06 Sep 2016
1 answer
98 views

Hello

There is a bug in vertical gauge margins we have come across when assigning margins which have different vertical and horizontal lengths.

On line 1079 of kendo.dataviz.gauge.js there is the following:

var bbox2d = new dataviz.Box2D(bboxX, bboxX,

This should be

var bbox2d = new dataviz.Box2D(bboxX, bboxy,

Thanks,

Ben

Rumen
Telerik team
 answered on 06 Sep 2016
1 answer
127 views

I am trying to set menu (ul element) z-index bellow the window and all children (on root item hover - .k-animation-container) greater then window z-index.

I try to set .k-animation-container z-index higher then window, but it doesn't work.

How can I display menu root items bellow window and all non-root items (everything that opens, including popup menu) above window?

Dojo.

Dimiter Topalov
Telerik team
 answered on 06 Sep 2016
1 answer
170 views

My spreadsheet loads fine, but the order in which it loads the columns is odd based on the datasource I'm pulling from. I'd like to specify the order they're in, as well as the name of said columns.

 

I have the following code:

///////////////
                        $("#spreadsheet").kendoSpreadsheet({
                            columns: 17,
                            columnWidth: 100,
                            rows: 100,
                            
                            toolbar: true,
                            sheetsbar: true,
                            excel: {                
                                // Required to enable Excel Export in some browsers
                                proxyURL: "//demos.telerik.com/kendo-ui/service/export"
                            },
                            sheets: [{
                                name: "Summary",
                                dataSource: summaryDS
                                
                            },{
                                name: "Customers",
                                dataSource: customersDS,
                                    columns: [
                                        {
                                            field: "nummer",
                                            title: "Number"
                                        },
                                        {
                                            field: "ans",
                                            title: "Customer"
                                    }]
                                
                            },{
                                name: "Prospects",
                                dataSource: prospectsDS
                            },{
                                name: "Leads",
                                dataSource: leadsDS
                            }]
                        });
                    ///////////////

 

 

Boyan Dimitrov
Telerik team
 answered on 06 Sep 2016
3 answers
317 views

I have a grid with custom editors (kendo datepicker, kendo numericTextBox) and one field that does not have a custom editor defined

When I am in edit mode, and change the value in either of columns using custom editor templates, the dataItem.dirty flag is not changed. It is only correctly tracked in the default editor.

 

columns: [
{
    field: "amount",
title: "Amount (bps)",
//editor: function(container, options){
// container.append(amountTemplate);
//}
},
{
field: "startDate",
title: "Start Date",
template: startDateTemplate,
editor: function(container, options){
container.append(startDateTemplate);
}
},
{
field: "endDate",
title: "End Date (months)",
template: '<span ng-if="!dataItem.isBeingEdited">{{!!dataItem.endDate ? dataItem.endDate : "&boxh;"}}</span>',
editor: function(container, options){
container.append(endDateTemplate);
}
}​

Plamen
Telerik team
 answered on 06 Sep 2016
Narrow your results
Selected tags
Tags
Grid
General Discussions
Charts
Data Source
Scheduler
DropDownList
TreeView
MVVM
Editor
Window
DatePicker
Spreadsheet
Upload
ListView (Mobile)
ComboBox
TabStrip
MultiSelect
AutoComplete
ListView
Menu
Templates
Gantt
Validation
TreeList
Diagram
NumericTextBox
Splitter
PanelBar
Application
Map
Drag and Drop
ToolTip
Calendar
PivotGrid
ScrollView (Mobile)
Toolbar
TabStrip (Mobile)
Slider
Button (Mobile)
Filter
SPA
Drawing API
Drawer (Mobile)
Globalization
LinearGauge
Sortable
ModalView
Hierarchical Data Source
Button
FileManager
MaskedTextBox
View
Form
NavBar
Notification
Switch (Mobile)
SplitView
ListBox
DropDownTree
PDFViewer
Sparkline
ActionSheet
TileLayout
PopOver (Mobile)
TreeMap
ButtonGroup
ColorPicker
Pager
Styling
Chat
MultiColumnComboBox
Dialog
DateRangePicker
Checkbox
Timeline
Drawer
DateInput
ProgressBar
MediaPlayer
ImageEditor
TextBox
OrgChart
Accessibility
Effects
PivotGridV2
Licensing
ScrollView
Switch
TextArea
BulletChart
QRCode
ResponsivePanel
Wizard
CheckBoxGroup
Localization
Barcode
Breadcrumb
Collapsible
MultiViewCalendar
Touch
RadioButton
Stepper
Card
ExpansionPanel
Rating
RadioGroup
Badge
Captcha
Heatmap
AppBar
Loader
Security
TaskBoard
Popover
DockManager
TimePicker
FloatingActionButton
CircularGauge
ColorGradient
ColorPalette
DropDownButton
TimeDurationPicker
ToggleButton
BottomNavigation
Ripple
SkeletonContainer
Avatar
Circular ProgressBar
FlatColorPicker
SplitButton
Signature
Chip
ChipList
VS Code Extension
AIPrompt
PropertyGrid
Sankey
Chart Wizard
OTP Input
SpeechToTextButton
InlineAIPrompt
StockChart
ContextMenu
DateTimePicker
RadialGauge
ArcGauge
AICodingAssistant
SmartPasteButton
PromptBox
SegmentedControl
+? more
Top users last month
Miljana
Top achievements
Rank 2
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Bronze
Cynthia
Top achievements
Rank 1
John
Top achievements
Rank 1
Iron
Mozart
Top achievements
Rank 1
Iron
Veteran
Want to show your ninja superpower to fellow developers?
Top users last month
Miljana
Top achievements
Rank 2
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Bronze
Cynthia
Top achievements
Rank 1
John
Top achievements
Rank 1
Iron
Mozart
Top achievements
Rank 1
Iron
Veteran
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?