{"id":9176,"date":"2017-11-23T16:54:41","date_gmt":"2017-11-23T15:54:41","guid":{"rendered":"http:\/\/www.wjst.de\/blog\/?p=9176"},"modified":"2017-12-18T12:55:09","modified_gmt":"2017-12-18T11:55:09","slug":"keep-your-excelsheet-updated-or-binding-to-websocket","status":"publish","type":"post","link":"https:\/\/www.wjst.de\/blog\/sciencesurf\/2017\/11\/keep-your-excelsheet-updated-or-binding-to-websocket\/","title":{"rendered":"Keep your Excelsheet updated ;-) or how to bind Kendo UI for jquery on a Synology to websocket"},"content":{"rendered":"

This is not really about Excel but about Kendo Grid’s ability to update grid data in the browser. \u00a0This is already my second attempt as a Mosquitto based MQTT solution did not work properly.<\/p>\n

\"\"<\/a>
Demo Grid<\/figcaption><\/figure>\n

Installing node.js on the Synology is straightforward – just use the package manager. We also need some local packages. Change into the target directory and type<\/p>\n

\r\nnpm install express\r\nnpm install typescript\r\nnpm install ws\r\n<\/pre>\n
Copy also app.js from https:\/\/github.com\/telerik\/kendoui-ws-demo<\/a> into that directory. Unfortunately app.js breaks in line 5 (we need another port as 5000 is already occupied in the Synology). It also crashes in line 6, as the node.js V4 version needs full extension. So use the following lines<\/p>\n
\r\nvar WebSocketServer = require("ws").Server;\r\nvar http = require("http");\r\nvar express = require("express");\r\nvar app = express();\r\nvar port = process.env.PORT || 5050;\r\nvar products = require(".\/products.js");\r\n<\/pre>\n
Then start the server by<\/p>\n
\r\n\/usr\/local\/bin\/node \/volume1\/web\/kendoui-ws-demo-master\/app.js &\r\n<\/pre>\n
Get the client script in kendoui.for.jquery.2017.3.1018.trial\/examples\/grid\/web-socket.html and change the host. Take care to use ws (Websocket), not wss (Websocket secure) unless you know what you are doing<\/a>.<\/p>\n
\r\n\/\/var host = "wss:\/\/kendoui-ws-demo.herokuapp.com";\r\nvar host = "ws:\/\/myserver:5050";\r\n<\/pre>\n
That’s it.<\/p>\n\n
 <\/p>\n
\n  CC-BY-NC Science Surf , accessed 15.04.2026<\/span>\n <\/div>","protected":false},"excerpt":{"rendered":"
This is not really about Excel but about Kendo Grid’s ability to update grid data in the browser. \u00a0This is already my second attempt as a Mosquitto based MQTT solution did not work properly. Installing node.js on the Synology is straightforward – just use the package manager. We also need some local packages. Change into … Continue reading Keep your Excelsheet updated ;-) or how to bind Kendo UI for jquery on a Synology to websocket<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-9176","post","type-post","status-publish","format-standard","hentry","category-computer-software"],"_links":{"self":[{"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/posts\/9176","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/comments?post=9176"}],"version-history":[{"count":7,"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/posts\/9176\/revisions"}],"predecessor-version":[{"id":9239,"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/posts\/9176\/revisions\/9239"}],"wp:attachment":[{"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/media?parent=9176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/categories?post=9176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/tags?post=9176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}