Export to CSV

Please use template to report bugs and problems. Post here your questions when not sure where else to post
Only for bugs in the Domoticz application! other problems go in different subforums!
Forum rules
Before posting here, make sure you are on the latest Beta or Stable version.
If you have problems related to the web gui, clear your browser cache + appcache first.

Use the following template when posting here:

Version: xxxx
Platform: xxxx
Plugin/Hardware: xxxx
Description:
.....

If you are having problems with scripts/blockly, always post the script (in a spoiler or code tag) or screenshots of your blockly

If you are replying, please do not quote images/code from the first post
Post Reply
qqlapraline
Posts: 59
Joined: Saturday 11 January 2014 17:09
Target OS: Raspberry Pi
Domoticz version:
Contact:

Export to CSV

Post by qqlapraline » Saturday 22 April 2017 13:39

Hello all,

Version: 3.7376 (update 5 minutes ago)
Platform: Raspberry PI / Arm
Plugin/Hardware: RFXCOM, MySensors Gateway
Description:
I am used to export some Voltage graphs to csv every week during the weekend. Today, it does not work anymore. Instead of downloading the resulting "charts.csv" file, the page is redirected there: https://www.highcharts.com/studies/csv-export/csv.php

Is Anyone able to reproduce this bug ?
Regards,

QQ.
3 Raspberry PI (Raspbian + Rfxcom, teleinfo or mysensors gateway)
Bunch of OS THGR810n (5)
Some THN122
1 WGR800 and PCR800
Some BMP085
Bunch of TS34C (4)
Bunch of DIO plugs (3)
Teleinfo
Various mysensors devices (Temp, Hygro, ...)

qqlapraline
Posts: 59
Joined: Saturday 11 January 2014 17:09
Target OS: Raspberry Pi
Domoticz version:
Contact:

Re: Export to CSV

Post by qqlapraline » Saturday 22 April 2017 16:42

I have done some tests. Experts are probably aware of what I'm going to say but it appears that the "export-csv.js" file (in www/js/) is in charge of:
- Extending the export options of highcharts (for CSV)
- Running the export itself (for CSV)

I have tried to upgrade the export-csv.js file using the official one.
The latest version is not OK (because it uses the latest version of Highcharts) but version 1.4.5 is OK !
Here is the link.
Regards,

QQ.
3 Raspberry PI (Raspbian + Rfxcom, teleinfo or mysensors gateway)
Bunch of OS THGR810n (5)
Some THN122
1 WGR800 and PCR800
Some BMP085
Bunch of TS34C (4)
Bunch of DIO plugs (3)
Teleinfo
Various mysensors devices (Temp, Hygro, ...)

gerardvs
Posts: 111
Joined: Sunday 04 January 2015 1:01
Target OS: Raspberry Pi
Domoticz version: latest-1
Location: /dev/null
Contact:

Re: Export to CSV

Post by gerardvs » Saturday 22 April 2017 20:15

In my opinion it would be better to switch to another chart-engine. I think it is wrong for a nice opensource project like Domoticz to use a charting system with, at least from a legal point of view, semi-closed source software.

qqlapraline
Posts: 59
Joined: Saturday 11 January 2014 17:09
Target OS: Raspberry Pi
Domoticz version:
Contact:

Re: Export to CSV

Post by qqlapraline » Sunday 23 April 2017 20:24

Well, thank you for your opinion but it won't help fixing this issue on a short term basis.

:roll:

QQ.
3 Raspberry PI (Raspbian + Rfxcom, teleinfo or mysensors gateway)
Bunch of OS THGR810n (5)
Some THN122
1 WGR800 and PCR800
Some BMP085
Bunch of TS34C (4)
Bunch of DIO plugs (3)
Teleinfo
Various mysensors devices (Temp, Hygro, ...)

Antori91
Posts: 42
Joined: Sunday 12 February 2017 18:12
Target OS: NAS (Synology & others)
Domoticz version: 3.5877
Contact:

Re: Export to CSV

Post by Antori91 » Wednesday 26 April 2017 8:42

Hello,

I have the same problem with version 3.5877 at a Synology Platform (instead of a csv file download, I get a blank page at https://www.highcharts.com/studies/csv-export/csv.php). I tried to replace the default installed export-csv.js file with the 1.4.5 version but it doesn't work also (same wrong behavior).

What else can I do?

Thanks in advance for your support.

PS : On Synology platform the /domoticz/www/js/*.js files are /domoticz/www/js/*.js.gz files.

eddiecharette
Posts: 4
Joined: Tuesday 31 January 2017 8:27
Target OS: -
Domoticz version:
Contact:

Re: Export to CSV

Post by eddiecharette » Wednesday 26 April 2017 12:47

Highcharts plugin to export the chart data to CSV, XLS or HTML table. Two methods, getCSV and getTable, are added to the chart object for programmatic access, and menu items is added to the export menu for GUI access. A boolean variable, useLocalDecimalPoint, is added to the methods getCSV and getTable for choosing whether to use the local decimal point or not.

iso101
Posts: 3
Joined: Wednesday 26 April 2017 21:08
Target OS: -
Domoticz version:
Contact:

Re: RE: Re: Export to CSV

Post by iso101 » Wednesday 26 April 2017 21:10

Antori91 wrote:Hello,

I have the same problem with version 3.5877 at a Synology Platform (instead of a csv file download, I get a blank page at https://www.highcharts.com/studies/csv-export/csv.php). I tried to replace the default installed export-csv.js file with the 1.4.5 version but it doesn't work also (same wrong behavior).

What else can I do?

Thanks in advance for your support.

PS : On Synology platform the /domoticz/www/js/*.js files are /domoticz/www/js/*.js.gz files.
I have the same problem. I also changed the .js to version 1.4.5, but same behaviour, no way of exporting data.


Enviado desde mi Nexus 5 mediante Tapatalk
Last edited by iso101 on Wednesday 26 April 2017 21:10, edited 1 time in total.

iso101
Posts: 3
Joined: Wednesday 26 April 2017 21:08
Target OS: -
Domoticz version:
Contact:

Re: RE: Re: Export to CSV

Post by iso101 » Wednesday 26 April 2017 21:12

eddiecharette wrote:Highcharts plugin to export the chart data to CSV, XLS or HTML table. Two methods, getCSV and getTable, are added to the chart object for programmatic access, and menu items is added to the export menu for GUI access. A boolean variable, useLocalDecimalPoint, is added to the methods getCSV and getTable for choosing whether to use the local decimal point or not.
Sorry, I didn't understand what to do to solve the problem...
Thanks!

Enviado desde mi Nexus 5 mediante Tapatalk

qqlapraline
Posts: 59
Joined: Saturday 11 January 2014 17:09
Target OS: Raspberry Pi
Domoticz version:
Contact:

Re: Export to CSV

Post by qqlapraline » Wednesday 26 April 2017 21:32

If you face the problem, after having replaced the .js ( or .js.gz) file by version 1.4.5, you may have to clean the cache and reload domoticz.
Actually, I had to do that a couple of times to make it work.
Tell me if it gets better after that.
Regards,

QQ.
3 Raspberry PI (Raspbian + Rfxcom, teleinfo or mysensors gateway)
Bunch of OS THGR810n (5)
Some THN122
1 WGR800 and PCR800
Some BMP085
Bunch of TS34C (4)
Bunch of DIO plugs (3)
Teleinfo
Various mysensors devices (Temp, Hygro, ...)

Antori91
Posts: 42
Joined: Sunday 12 February 2017 18:12
Target OS: NAS (Synology & others)
Domoticz version: 3.5877
Contact:

Re: Export to CSV

Post by Antori91 » Thursday 27 April 2017 15:24

A workaround is to use DB Browser for SQLite to export the data and get the Excel file. To avoid any issue don't open the actual Domoticz database but a database backup clone (Setup/Settings/Backup-Restore).
ExportwithDBrowser.GIF
ExportwithDBrowser.GIF (276.03 KiB) Viewed 1920 times

iso101
Posts: 3
Joined: Wednesday 26 April 2017 21:08
Target OS: -
Domoticz version:
Contact:

Re: RE: Re: Export to CSV

Post by iso101 » Thursday 27 April 2017 23:44

qqlapraline wrote:If you face the problem, after having replaced the .js ( or .js.gz) file by version 1.4.5, you may have to clean the cache and reload domoticz.
Actually, I had to do that a couple of times to make it work.
Tell me if it gets better after that.
Regards,

QQ.
Thanks a lot QQ!

After cleaning cache, exporting to csv is working again! And it is also available a 'new' option to export to xls.



Enviado desde mi Nexus 5 mediante Tapatalk

Antori91
Posts: 42
Joined: Sunday 12 February 2017 18:12
Target OS: NAS (Synology & others)
Domoticz version: 3.5877
Contact:

Re: Export to CSV

Post by Antori91 » Friday 28 April 2017 11:14

Hello,
Even if I restart Domoticz and clear the browser cache, it doesn't work for my Domoticz platform.

qqlapraline
Posts: 59
Joined: Saturday 11 January 2014 17:09
Target OS: Raspberry Pi
Domoticz version:
Contact:

Re: Export to CSV

Post by qqlapraline » Friday 28 April 2017 23:27

Antori91 wrote:Hello,
Even if I restart Domoticz and clear the browser cache, it doesn't work for my Domoticz platform.
Clearing the cache might be really tricky at some point. You can find a documentation for that in this forum.
Regards,

QQ.
3 Raspberry PI (Raspbian + Rfxcom, teleinfo or mysensors gateway)
Bunch of OS THGR810n (5)
Some THN122
1 WGR800 and PCR800
Some BMP085
Bunch of TS34C (4)
Bunch of DIO plugs (3)
Teleinfo
Various mysensors devices (Temp, Hygro, ...)

User avatar
gizmocuz
Posts: 8529
Joined: Thursday 11 July 2013 18:59
Target OS: Raspberry Pi
Domoticz version: beta
Location: Top of the world
Contact:

Re: Export to CSV

Post by gizmocuz » Wednesday 03 May 2017 2:49

gerardvs wrote:In my opinion it would be better to switch to another chart-engine. I think it is wrong for a nice opensource project like Domoticz to use a charting system with, at least from a legal point of view, semi-closed source software.
What do you mean closed source ? its open ?
And this is (one of) the best chart engines currently available that we can use. (do not come with flot and so.. you can not compare it)
Quality outlives Quantity!

User avatar
gizmocuz
Posts: 8529
Joined: Thursday 11 July 2013 18:59
Target OS: Raspberry Pi
Domoticz version: beta
Location: Top of the world
Contact:

Re: Export to CSV

Post by gizmocuz » Wednesday 03 May 2017 2:59

In the latest beta version the latest Highcharts library is included, including the export files.
Hope all is working again
Quality outlives Quantity!

qqlapraline
Posts: 59
Joined: Saturday 11 January 2014 17:09
Target OS: Raspberry Pi
Domoticz version:
Contact:

Re: Export to CSV

Post by qqlapraline » Wednesday 03 May 2017 21:38

gizmocuz wrote:In the latest beta version the latest Highcharts library is included, including the export files.
Hope all is working again
I have updated to latest beta version (3.7412). Cache reset and...it works like a charm !
To me, this bug is fixed.

QQ.
3 Raspberry PI (Raspbian + Rfxcom, teleinfo or mysensors gateway)
Bunch of OS THGR810n (5)
Some THN122
1 WGR800 and PCR800
Some BMP085
Bunch of TS34C (4)
Bunch of DIO plugs (3)
Teleinfo
Various mysensors devices (Temp, Hygro, ...)

gerardvs
Posts: 111
Joined: Sunday 04 January 2015 1:01
Target OS: Raspberry Pi
Domoticz version: latest-1
Location: /dev/null
Contact:

Re: Export to CSV

Post by gerardvs » Tuesday 16 May 2017 16:05

gizmocuz wrote:
gerardvs wrote:In my opinion it would be better to switch to another chart-engine. I think it is wrong for a nice opensource project like Domoticz to use a charting system with, at least from a legal point of view, semi-closed source software.
What do you mean closed source ? its open ?
And this is (one of) the best chart engines currently available that we can use. (do not come with flot and so.. you can not compare it)
I meant from a legal (license) point of view. Although the source is open, it is only under a very limited use with a lot of restrictions free to use. For Domoticz this implies that it never can be used other than personally without paying license fees at Highsoft. Also you (developers) have to inform users that this product is used and what the restrictions are. I 've not seen anyone do this so far.

More than enough reason for me to abandon this option. It would be nice to have an option to safely remove this library.

--Gerard

Post Reply

Who is online

Users browsing this forum: joto and 5 guests