Question about telldus live connection

[norpan]

How do I set up a connection to Telldus Live? In fuTelldus there was a setting on the profile page, but I can't find anything in MSH.

[dico]

Under your user in upper right corner, and settings->bindings->telldus from there.

[norpan]

Yes, I saw that one. It says:
"No installed bindings found... Install some bindings to get started with your smarthome!"
And a button with "Upload binding", but I'm not sure what file to upload.

[dico]

Oh, looks like the bindings wasn't added with the commit. I would probably add these as own repositories though.

But in the meantime, here is the telldus binding: https://www.dropbox.com/sh/xq8tz8uj2128raw/AADCJPvapYbIV3ws4-iC7AVPa?dl=0

If you upload this .zip files under /bindings (you probably need to create the bindings-folder in the root). You should be able to install it from the MSH-GUI (not tested enough and depends on read/write to the bindings-folder).

If you can't install it, just unzip the files to /bindings/telldus.live.
You have to add the db-table from the db.sql in the telldus.live binding.

Other bindings i have or I'm working on:
Netatmo - Finish
Carwings Nissan Leaf - In progress
Intesishome - Planned
Heatmiser - Planned

[norpan]

Ok! That explains that.
Next hurdle. There seem to be a mismatch in the DB, the telldus binding referers to a column type in the table msh_devices which is not there.

[dico]

I see that the column device_alias is missing from the db.sql in MSH. I have updated this now, but it looks like the telldus binding is still trying to write data to columns that should be deprecated.

Quick fix:

• 1. Remove refrence to the deprecated columns in the telldus binding.

/binding/telldus.live/sync.php
Lines:
#206-217
#238-248
#335
#631

...or...

• 2. (SAFEST WAY) Just add the deprecated columns to the db. I have exported my columns below.

The deprecated columns should have no impact on the web-application, other that I just haven't cleaned up the code in the telldus binding.

Here is an direct export of mine:

CREATE TABLE IF NOT EXISTS msh_devices (
device_int_id int(11) NOT NULL,
user_id int(11) NOT NULL,
module varchar(64) NOT NULL COMMENT 'DEPRECATED',
binding varchar(64) NOT NULL,
device_ext_id varchar(256) NOT NULL,
device_name varchar(128) NOT NULL,
device_alias varchar(128) NOT NULL,
type varchar(64) NOT NULL COMMENT 'DEPRECATED',
type_desc varchar(32) NOT NULL COMMENT 'DEPRECATED',
category varchar(64) NOT NULL COMMENT 'DEPRECATED',
description varchar(256) NOT NULL,
description2 varchar(256) NOT NULL COMMENT 'DEPRECATED',
icon varchar(128) NOT NULL,
url varchar(256) NOT NULL,
latitude double NOT NULL,
longitude double NOT NULL,
value_unit tinyint(4) NOT NULL COMMENT 'DEPRECATED',
value2_unit tinyint(4) NOT NULL COMMENT 'DEPRECATED',
value3_unit tinyint(4) NOT NULL COMMENT 'DEPRECATED',
battery double NOT NULL,
state float NOT NULL COMMENT 'Device current state. Use when not log.',
dashboard tinyint(4) NOT NULL COMMENT 'view on dashboard',
dashboard_size varchar(32) NOT NULL COMMENT 'small, wide, big',
monitor tinyint(4) NOT NULL,
public tinyint(4) NOT NULL,
deactive tinyint(4) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=736 DEFAULT CHARSET=latin1;

ALTER TABLE msh_devices
ADD PRIMARY KEY (device_int_id), ADD KEY device_ext_id (device_ext_id);

ALTER TABLE msh_devices
MODIFY device_int_id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=736;