Questions on Kendo UI for jQuery Forum

0 answers

3 views

Adding the data written to the cell to the validation with the changelistiner

Hello,

const processesList: string[] = ["Process 1","Process 2","Process 3"];

I want to add the word I wrote in the cell to the "list of validation" if it is not in the current list.

  SpreadValidation() {
    var spreadsheet = kendo.jQuery(this.spreadsheetEl.nativeElement).data("kendoSpreadsheet");
    var sheet = spreadsheet.activeSheet();
    const processesMerge = '"'+processesList.toString()+'"';
   
    sheet.range("B:AX").validation({
      dataType: "list",
      showButton: true,
      comparerType: "list",
      from: processesMerge,
      allowNulls: true,
      type: "warning"
    }); 
  }

change listener code

   var spreadsheet = kendo.jQuery(this.spreadsheetEl.nativeElement).data("kendoSpreadsheet");
    spreadsheet.bind("changing", this.changeListener);

  changeListener(e) {
    console.log("The netered value is: "+e.data);
    processesList.push(e.data);
    var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
    var sheet = spreadsheet.activeSheet();
    const progressMerge = '"'+processesList.toString()+'"';
   
    sheet.range("B:AX").validation({
      dataType: "list",
      showButton: true,
      comparerType: "list",
      from: progressMerge,
      allowNulls: true,
      type: "warning"
    });    
}

I can capture the data I entered in the cell, but I could not add this word to the current validation list. how can I do it ?

My goal is that if the added word is not in the validation list, it will be added, and if there is, it will not repeat the data. in this way, it is always to increase the list and to be able to make a selection from the existing ones.

Spreadsheet

updated question on 01 Jul 2022

3 answers

16 views

Kendo filter field dropdown not loading.

I have a filter on a datasource which in return updates a grid. The following are the code to filter and its' template handler.

The problem with this is that, I can load the categories at first when I'm creating the filters. But when I save and reload the filter from local storage, the category dropdown does not load. Please help me with this. It loads up only on a fresh filter.

Thanks in advance.

@(Html.Kendo().Filter<Lovely>()
                                .Name("OrgFilter")
                                .ApplyButton(true)
                                .ExpressionPreview(true)
                                .DataSource("DataSource")
                                .Fields(f =>
                                {
                                    f.Add(p=>p.OrgName).Label("Organization");
                                    f.Add(p=>p.CategoryId).Label("Category").EditorTemplateHandler("CategoryDropdown");
                                    f.Add(p=>p.AsAtDate).Label("As At Date");
                                }))

<script>
function CategoryDropdown(container, options) {
        $('<input data-bind="value: value" name="' + options.field + '"/>')
            .appendTo(container)
            .kendoDropDownList({
                dataTextField: "CategoryId",
                dataValueField: "CategoryId",
                dataSource: @Json.Serialize(ViewData["Catogories"])
            });
    }
</script>

answered on 30 Jun 2022

0 answers

6 views

Kendo UI Scheduler Timezone

Hi All,

Can we pass Sql server timezone names like 'Pacific Standard Time (Mexico)' etc to Kendo Scheduler timezone option instead of passing like below. Or can we use any other option to meet this. Please help.

 timezone: "Etc/UTC",

Scheduler

asked on 30 Jun 2022

0 answers

3 views

Using FileManager as file manager for TinyMCE 5/6

Hello,

I am trying to use FileManager as the file manger for TinyMCE 6. I have been able to successfully get it to load in TinyMCE's windowManager dialog. All of the features of the FileManager work, except for uploading files. When I click on the Upload button, or drag and drop a file into the FileManager, nothing happens. When I view the browser console, I see a warning that says: The uploadDialog dialog is not available!

What will cause the uploadDialog to not be able to show?

I am using the FileManager in a plain .html file like so:

<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<title></title>
<link rel="stylesheet" href="https://kendo.cdn.telerik.com/2022.2.621/styles/kendo.common-bootstrap.min.css" />
<link rel="stylesheet" href="https://kendo.cdn.telerik.com/2022.2.621/styles/kendo.bootstrap.min.css" />
<link href="https://cdn.kendostatic.com/2022.2.621/styles/kendo.bootstrap-main.min.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" href="telerik-file-manager.min.css" />

<script src="https://kendo.cdn.telerik.com/2022.2.621/js/jquery.min.js"></script>
<script src="https://kendo.cdn.telerik.com/2022.2.621/js/kendo.all.min.js"></script>
</head>
<body>
<div id="filemanager"></div>
<script src="telerik-file-manager.min.js"></script>
</body>
</html>

The jQuery code that I'm using to initialize the FileManager is:

$('#filemanager').kendoFileManager({
initialView: 'grid',
draggable: 'true',
resizeable: 'false',
dataSource: {
schema: kendo.data.schemas.filemanager,
uploadUrl: '/api/telerik-file-manager/upload',
transport: {
read: {
url: `/api/telerik-file-manager/read?filter=${filter}`,
method: 'GET'
},
create: {
url: '/api/telerik-file-manager/create',
method: 'GET'
},
update: {
url: '/api/telerik-file-manager/update',
method: 'GET'
},
destroy: {
url: '/api/telerik-file-manager/delete',
method: 'GET'
}
}
},
contextMenu: {
items: [
{ name: "select", text: "Select File", command: "SelectFile", spriteCssClass: "k-icon k-i-hyperlink-open" },
{ name: "rename" },
{ name: "delete" },
]
}
});

I am using ASP.NET Core 6 and I have the FileManager completely working great on a Razor Page, but I can't get the Upload feature to work when loading it into a TinyMCE windowManager dialog.

Any suggestions would be appreciated.

FileManager

updated question on 29 Jun 2022

1 answer

19 views

Export to pdf grid body font size

we can set diff font sizes for page, header, footer, but is it possible to set for exported grid body (table)?

Grid

answered on 29 Jun 2022

7 answers

15 views

Sort on Command column

Problem I'm having is first column with commands does not sort. Is this not supported?

$("#statusGrid").kendoGrid({
dataSource: {
transport: {
read: async function (options) {
KendoData_Read(
options,
BaseAbs3ApiUrl + "api/CustomerDetail/GetCustomerStatusDetail",
{ customerId: customerId }
);
}
},
sort: [{ field: "CreatedDate", dir: "desc" }]
},
dataBound: function (e) {
$(".k-grid-addDischarge").attr("title", "Add");
$(".k-grid-editDischarge").attr("title", "Edit");
$(".k-grid-viewDischarge").attr("title", "View");
},
toolbar: kendo.template($("#statusGridToolbarTemplate").html()),
scrollable: false,
excel: {
allPages: true,
fileName: "CustomerStatus.xlsx",
proxyURL: "/save",
filterable: true
},
excelExport: absKendoAutoWidthExcelExport,
sortable: true,
pageable: absKendoGridPageableDefault,
noRecords: { template: "No records to display." },
columns: [
{
command: [
{
name: "addDischarge",
text: "",
title: "Add",
visible: function (item) { return item.CanCreateDischargeDocument },
iconClass: "fas fa-plus fa-border",
click: function (e) {
e.preventDefault(); // prevent page scroll position change
var tr = $(e.target).closest("tr");
var data = this.dataItem(tr);
var url = "/Customer/Discharge/Create/" + data.CustomerStatusChangeId;
window.open(url, "_blank");
}
},
{
name: "editDischarge",
text: "",
title: "Edit",
visible: function (item) { return item.CanEditDischargeDocument },
iconClass: "fa fa-pencil-alt fa-border",
click: function (e) {
e.preventDefault(); // prevent page scroll position change
var tr = $(e.target).closest("tr");
var data = this.dataItem(tr);
var url = "/Customer/Discharge/EditByStatusChangeId/" + data.CustomerStatusChangeId;
window.open(url, "_blank");
}
},
{
name: "viewDischarge",
text: "",
title: "View",
visible: function (item) { return item.CanViewDischargeDocument },
iconClass: "fas fa-eye fa-border",
click: function (e) {
e.preventDefault(); // prevent page scroll position change
var tr = $(e.target).closest("tr");
var data = this.dataItem(tr);
var url = BaseAbs2Url + "SSRSReports/Report.aspx?report=DischargeandTransferSummary&cuCustomerStatusChangeId=" + data.CustomerStatusChangeId;
window.open(url, "_blank");
}
}
]
, headerTemplate: "Document<br />Actions", title: "Document Actions", width: "10em", sortable: true, field: "DocumentActions"
},
{ field: "Id", hidden: true },
{ title: "Status", field: "CurrentStatusTypeName", width: "20em", sortable: true },
{ headerTemplate: "Status Change<br />Reason", title: "Status Change Reason", field: "CustomerStatusChangeReasonName", width: "20em", sortable: true },
{ headerTemplate: "Admit/Start<br />of Care Date", title: "Admit/Start of Care Date", field: "AdmitStartCareDateText", width: "12em", sortable: true, template: function (item) { return formatKDate(item.AdmitStartCareDate); } },
{ title: "Service Hold/End of Care Date", field: "ServiceHoldEndCareDateText", width: "12em", sortable: true, template: function (item) { return formatKDate(item.ServiceHoldEndCareDate); } },
{ headerTemplate: "Resumption of<br />Care Date", title: "Resumption of Care Date", field: "ResumptionCareDateText", width: "12em", sortable: true, template: function (item) { return formatKDate(item.ResumptionCareDate); } },
{ headerTemplate: "Discharged<br />Closed Date", title: "Discharged Closed Date", field: "DischaredClosedDateText", width: "12em", sortable: true, template: function (item) { return formatKDate(item.DischaredClosedDate); } },
{ headerTemplate: "Status<br />Comments", title: "Status Comments", field: "StatusChangeComment", width: "20em", sortable: true },
{ headerTemplate: "Status<br />Change Date", title: "Status Change Date", field: "CreatedDateText", width: "12em", sortable: true, template: function (item) { return formatKDate(item.CreatedDate); } },
{ headerTemplate: "Status<br />Changed By", title: "Status Changed By", field: "CreatedByName", width: "15em", sortable: true },
{ title: "Discharge/Transfer Document Status", field: "DischargeDocumentStatus", width: "12em", sortable: true }
]
});

Grid

answered on 29 Jun 2022

0 answers

4 views

Spreadsheet data import/export in Angular

hello,

I want to access the spreadshet object in Angular, export and import data.

Example

(A completely imaginary example. I don't know how.)

 dataExport() {
    kendo.jQuery(this.spreadsheetEl.nativeElement).kendoSpreadsheet({
        function() {
            var sheet = $("#spreadsheet").data('kendoSpreadsheet').activeSheet();
            var range = sheet.selection();
            console.log(sheet.toJSON());
        }
    });
  }

how can I do it ?

thanks in advance

SPA

Spreadsheet

updated question on 29 Jun 2022

1 answer

11 views

Pagination in ImageBrowser of Kendo Editor

Hello,

I am working with application where I have thousands of images to load on ImageBrowser of Kendo Editor.

ImageBrowser is getting stuck as having too many images to load, Can we have any option to add pagination or lazy loading in ImageBrowser?

So, I can load only 20 images at a time and other based on request.

Please note that I am fetching images from controller method which returns list of FileBrowserEntry as below.

Thanks,

Trusha

answered on 29 Jun 2022

1 answer

9 views

filemanager: Drag and drop validation

Hi Team,

I would like to fire a validation post drag but pre-drop, this should allow me to cancel the drop and show a message to enduser explaining the cause.

the drop event only allows to modify the rendered alert dialog but it doesnt allow me to cancel the event altogether.

any help is appriciated.

Regards,

Ashutosh

FileManager

answered on 29 Jun 2022

0 answers

3 views

Scheduler/ParseDate - Developer timezone specific?

Hi,

I'm not sure if the issue I have is related to kendo ui, but seeing an issue where code I run on my local computer on central time works fine, but when I deploy to the server (eastern time), some of my dates are shifting in the Scheduler control when I iterate through it.

I'm using the kendo.parseDate function on start/end dates

return kendo.parseDate(kendo.toString(input, 'd')).toLocaleDateString("en-US");

That works fine locally, but deployed to the server shifts an hour, which then saves the wrong date in my database.

Is there a timezone saved anywhere in the configs for developer machine that might be getting pushed to server? Switching my computer timezone to eastern and then deploying seems to work fine.

Thanks

Scheduler

asked on 28 Jun 2022