I am calling the FileBrowser as follow:

            dataSource: {
                schema: kendo.data.schemas.filemanager,
                transport: {
                    read: {
                        url: "/kendo-fm-reader.php",
                        method: "POST"
                    },
                    create: {
                        url: "/kendo-fm-dir-maker.php",
                        method: "POST"
                    },
                    update: {
                        url: "/kendo-fm-updater.php",
                        method: "POST"
                    },
                    destroy: {
                        url: "/kendo-fm-deleter.php",
                        method: "POST"
                    }
                }
            },
            uploadUrl: "/kendo-fm-file-uploader.php"

But when I rename a folder, the page triggered is "/kendo-fm-dir-maker.php" and not "/kendo-fm-updater.php"...

Is that possible and correct?

I think this behaviour is incorrect, as it creates new folders with the name I want to give to the renamed one.

Is there a way to modify this behaviour or I am doing something wrong?

Thank you.

Alessandro

We are instantiating late bind a new dropdownlist using jquery, making it virtual and reading data from an ajax call on the server

Here is an example of a dropdown initialization

$('#articles-row select:first').kendoDropDownList(
{
    filter: "contains",
    dataTextField: "Name",
    dataValueField: "Id",
    virtual: {
        itemHeight: 35,
        valueMapper: valueMapperArticles
    },
    dataSource: {
        pageSize: 80,
        serverPaging: true,
        serverFiltering: true,
        schema: {
            data: function (response) {
                console.log(response.Data)
                return response.Data;
            }
        },
        transport: {
            read: {
                url: "@Url.Action("Filter_Articoli")"
            }
        }
    }
});

And here is a simplified version of the datasource read method used in our program

public JsonResult Filter_Articoli([DataSourceRequest] DataSourceRequest request)
{
    IQueryable<Articles> art = _db.Articles
            .Where(x => !x.Disabled).AsQueryable();
    return Json(art.ToDataSourceResult(request));
}

When i instantiate the dropdown like so, he makes multiple server request, where the first one is correct i guess (using paging, sorting etc), and the other two are not necessary and badly formatted, making the execution of the page interrupt

Here is a screen of the three server request made by the datasource and the data obtained from the data formatting

Am i missing some configuration on the server or in the kendo dropdownlist instantiation?

Thanks in advance

I want to use Kendo multi column combo box as an auto-complete input. My data source is accessed via an API. The API URL can include filter parameters. All of our data sources are very large (tens of thousands of records), so I need to do server-side filtering by adjusting the parameter portion of the URL.

What properties, events and methods would I use to refresh the data source as the user is typing (with delay)?

pseudo code:

combobox.onchange() {

  ApiUrl = "https://blahblah/getRecords?filterstring=" + combobox.val();

  combobox.datasource.transport.read = ApiUrl

}

I can't seem to figure out how to get something to work. Seems like this should be easy to do.

Any suggestions would be greatly appreciated.

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