I am trying to get my Line Chart to dynamically assert the field text rather than having to explicitly put the field in my remote datasource objects and then state that property as the field in the Line chart series.  

so instead of doing it like 

data = [

{Date: 09/10/2020, English: 88, Math: 99, Science: 45},

{Date: 08/22/2020, English: 76, Math: 90, Science: 95},

{Date: 08/01/2020, English: 70, Math: 80, Science: 75}

]

and LineSeries = [

]

like in the Line Chart its done in the JQuery Line Chart example to get a seperate line for each subject and a data point for each distinct date. 

Is it possible to instead do

data = [

{Date: 09/10/2020, Subject: "Math", Value: "78" },

{Date: 09/10/2020, Subject: "English", Value: "80" },

{Date: 09/10/2020, Subject: "Science", Value: "65" }

{Date: 08/22/2020, Subject: "Math", Value: "87"},

{Date: 08/22/2020, Subject: "English", Value: "97"},

{Date: 08/22/2020, Subject: "Science", Value: "57"},

]

and something like LineSeries = [ {
        field: "Subject",
        categoryField: "date",
        name: "Subject",
    },
] ? if not is there a seperate way to configure the series to get a seperate line for each subject and a data point for each distinct date?

Currently I am trying to create a kendo UI Line chart based on a nested data model that looks like

{

key: "Kelly"

DateValue: [

{Date: 08/07/2020, Grade: 100}

{Date: 09/10/2020, Grade: 82}

] is this possible to create where for each date there is a data point and for each object with a distinct key there is a distinct line that represents that key? 

Hi,

Am having difficulty importing data, into a kendo UI spreadsheet, specifically date data as text. Is there a way to bypass the whole OLE date format from the Excell file so I just get a string? and Not that float value in OLE date format? In fact, importing every cell as just a string and not a formatted value (with a format property and a value property)...and just a value would be awesome. 

Thanks again for your help and patience!

George

I have defined following jQuery datagrid column. Users is assoc array of text and value fields.

Without template field, column is correctly displaying users's fullname from values field.

Now I need to change only displayed fullname into the link and therefore, I added template field. Problem is, that I don't know and I didn't find it in documentation, how to parse "modified_by" value into the user fullname (with using of text-value array in values field).

            (new Kendo\UI\GridColumn())
                ->field('modified_by')
                ->title($t->translate('card.grid.modified_by'))
                ->values($users)
                ->filterable($filterableMulti)
                ->width(200)
                ->template('#= (modified_by == null) ? \'\' : \'<a href="' . $this->baseURL . 'profile/\'+modified_by+\'">\'+modified_by+\'</a>\' #')
                ->lockable(true)

Thank a lot for any help!

Hi,

We've using a Form component with an Upload component in it. The validation within the Upload works fine but we'd like to check whether a file has been uploaded and / or selected. The "required" part of the Form validation doesn't seem to trigger when no file is selected. Code provided is an item in the Form.

                    {
                        field: "mailingList",
                        label: "Mailing List",
                        colSpan: 2,
                        editor: function (container, options) {
                            $('<input type="file" name="' + options.field + '" id="' + options.field + '"/>').appendTo(container)
                                .kendoUpload({
                                    async: {
                                        saveUrl: "/rates-notices-campaign/save-attach/" + id,
                                        removeUrl: "/rates-notices-campaign/remove-attach/" + id,
                                        autoUpload: true
                                    },
                                    validation: {
                                        allowedExtensions: [".csv", ".xlsx"]
                                    }
                                });
                        },
                        validation: {
                            required: {
                                message: "Mailing List is required"
                            }
                        }
                    }

Thanks

I am able to sort 1st object (orders1) as below example1 but please let me know is it possible to sort 2nd object same as like  1st object in the kendo grid.

Example 1:

var order1 :Country :'US';  Company:' Ship'

var order2 : Country :  (name: 'US'; id :12; items: {id: 13;  itemname: 'item1'}, {id : 14; itemname: item2} ),  Company: ({ id: 20; idealfor:'oil'; name :''company1' }, { id: 22; idealfor:'metal'; name :''company2' });

$(#tablename).kendoGrid({ datasource :order1,

page:6},

sortable:{ mode: 'single', allowunsort:false},

columns:{{ field:'company', title:'company', sortable: { intialditection: 'desc' }, { field:'company', title: 'country'}

}}

})

Hi.

In the Spreadsheet controller when a user imports a spreadsheet into the controller either by cutting and pasting, or by using the import button, was wondering if there was a best practice way to either get all the values even if the value  property is undefined or the cell is blank and does not exist in the array of cells for a given row?

I need to ultimately parse the control for the value (and eventually formulas)  then putting them in a string with tab separated cells separated by an end of line character for the rows,  then send it to an API where it is ultimately placed in the data base as a clob.

The problem is when I am doing this, in certain cases if the cell is empty  then it does not exist in cells array for the given row, so when I get my sample data the cells for the row do not line up with the headers, that is to say the cells are missing. If the cells do exist but the value property does not exist, I usually get a  JavaScript undefined value (because the value parameter doesn't exist), and I have to use an OR (||) operator to remove it and replace it with a blank.


The only thing I could think of was to iterate through the spreadsheet grid of the active sheet I am working with like this, using the range....but the user would have to select the range prior to kicking of the parsing job.


When the function is done I should have a string of the results with cells separated by \t and rows ending with \n:


DATA in stringified form: {"data":"ID\tInternational_ID\tLast Name\tFirst Name\tDescription\tAuth Role\tApp Server Type\tImport Type\tTime Zone Code\tApplication Type\t\n101\t\tHall\tJoe\tAssit and Admin\tAdvUser\t\t\t102\tAccounting\t\n102\t\tCallet\tBob\t\tAdmin\t\t\t102\tZooology\t\n103\t\tBaker\tDenny\t\tUser\tTripple Node\t\t109\tEngineering\t\n104\t\tBrewster\tFred\t\tAdvUser\t\t\t102\tProject Tracker\t\n105\t\tTurner\tDenise\t\tExecAdmin\tRegular\t\t115\t\t\n106\t\tZenni\tBee\t\tUser\t\t\t102\tAccounting\t\n107\t\tCook\tCarry\t\tAdvUser\t\t\t102\tEngineering\t\n108\t\tMathews\tHarry\t\tUser\t\tInternational\t102\t\t\n109\t\tDean\tDonny\t\tUser\tRegular\t\t102\tProject Tracker\t\n110\t\tFuller\tJames\t\tAdvUser\tTripple Node\t\t102\tScientific\t\n111\t\tAhrens\tJack\t\tAdmin\tRegular\t\t115\t\t\n112\t\tMikes\tGeorge\t\tUser\tHi Capacity\tLocal\t114\tProject Management\t\n113\t\tJones\tArnie\t\tAdvUser\tRegular\t\t116\t\t\n"}

If I cut and paste the above string into an excel spreadsheet sheet it will show the blank cells..and everything aligns.

If I didn't do this, then some of the cells would not exist, and I would getcells shifting into the wrong columns.

I need to capture even the blank cells and those with value == undefined.

Right now I am scanning the cells using a range for the first cell (probably A1) and also the last one... the user needs to set this before the parsing is done and this is very annoying. Is there an easy way to get the used range of the spreadsheet without the user having to set this?

Here is a code snippet of some test code:
https://dojo.telerik.com/@georgeg@pipkins.com/ELelOXuH/5   

1) Import the file using the import file button:

2) Click on the Send Data button but I haven't a clue):

 ... a popup dialog will appear

....and select the range of the cells to be parsed into tab separated values (right now I'd like to figure out the used area automatically, but I haven't a clue).

3) Click the Submit button.

4) Go to console and look at the data:

... you should be able to grab/copy the first bit of data and  paste it into a spreadsheet and get it to align with the columns should be no row shifting.

Then the spreadsheet should look like this:

THE BIG-TICKET ITEM IS: I just want to parse through the cells of the Spreadsheet control once, and without having the user select the range... it would be done automatically. I am just wondering if there isn't an easier, cleaner way to do this? I wish I could send you my test excel spreadsheet it would be easier to constrain what is going on... I sent you a tab separated txt file you should be able to convert that easily to an excel file.

Thanks again for your help and patience!

George

Hi,

I am trying to update kendo ui version from 2022.3 to the latest in our old angularJS application.

I followed instructions to build source code as described here:

https://docs.telerik.com/kendo-ui/intro/installation/ecmascript

I am injecting supported version of jquery, order of injections is ok.. there is something else I can't reach.

However, after injecting kendo.all.js (or kendo.all.min.js) and try to run my application, I always get the error shown down.

Any help or suggestion would be helpful.

Thank you and regards,

Vedad

I am running into an issue with allowing copy/paste of dates into the filter and cell input fields. Currently, the date fields have validation to support MM/dd/yyyy, and users of the app may be trying to copy dates in that are MM/dd/yy. I would expect Kendo to auto format the date to MM/dd/yyyy after the paste happens, or at least allow support for that, but it doesn't seem to happen.

In the cell, when putting in MM/dd/yy, a validation message appears saying the date is invalid, and there doesn't appear to be a way to override that. In the filter, when putting in MM/dd/yy and submitting the filter, it doesn't stick and completely ignores the date put in.

Is there any way with the latest version of Kendo (I am on 16) to allow for different date formats in these fields, or is there the possibility that this is something coming in the future?

I use the upload widget in a long-running web app to allow picture upload.

Over the years, the number and size of pictures have increased.

I compress property in the upload widget would be great, however, short of this, has anyone played around with compressing images in the browser in connection with using the upload widget?

/Morten