ThingSpeak Live Chart, multi channel, second axis, historical data, csv export | Announcements | Forum

Avatar

Please consider registering
Guest

Search

— Forum Scope —






— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

Register Lost password?
sp_Feed sp_TopicIcon
ThingSpeak Live Chart, multi channel, second axis, historical data, csv export
Avatar
turgo

Gold
Forum Posts: 54
sp_UserOfflineSmall Offline
1
January 24, 2014 - 5:43 pm
sp_Permalink sp_Print sp_EditHistory

Here is a HTML JavaScript web page to display multiple series and channels in real time.
http://forum.arduino.cc/index.php?action=dlattach;topic=213058.0;attach=66726
http://forum.arduino.cc/index.php?action=dlattach;topic=213058.0;attach=66752Image Enlarger

You must edit the page source/ JavaScript to enter your channel information.

If you have lots of series, it is helpful to click the "Hide All" button, and then click on the series names you are interested in to show them. Clicking and dragging vertically on the chart will select a range to zoom in to.

Check the "Update Chart" checkbox to enable realtime charting. With more than about 8 channels, this causes ThingSpeak to cache and delay the data, so I have it unchecked.

It also features buttons to load historical data 8000 points at a time. Select which channel you want to load, and how many sequential loads to try. Then click the "Load More Historical Data" button. Loading too much data causes ThingSpeak to first delay the data, and then (error 404) refuse to return data. After ten loads or so, I often cannot load any more data.

The three bars export button at the top right has an option to download a .csv file containing the data from the chart.

This is public domain. Please post upgrades on the Arduino forum thread. (too bad this forum doesn't support posting files)
http://forum.arduino.cc/index.php?topic=213058.0

The navigator could be dramatically upgraded to provide complete access to your historical data with smaller data downloads if ioBridge were to change the Average function so it would return 8000 points, instead of averaging 8000 points. http://community.thingspeak.com/forum/thingspeak-api/daily-average1440-parameter-purpose-defeated-by-results-limits/

The charting library is called HighStock. It is awesome! HighSoft, the owners say, "Do you want to use Highstock for a personal or non-profit project? Then you can use Highchcarts for free under the Creative Commons Attribution-NonCommercial 3.0 License. "

Avatar
ntallari
New Member
Forum Posts: 1
sp_UserOfflineSmall Offline
2
September 5, 2014 - 4:06 am
sp_Permalink sp_Print

Holy Crap! This is absolutely wonderful! It's exactly what i've been looking for! I'm using it for my student lab webpage. I hope that's alright. Thank you thank you.

Avatar
turgo

Gold
Forum Posts: 54
sp_UserOfflineSmall Offline
3
September 22, 2014 - 10:35 pm
sp_Permalink sp_Print

My pleasure. If you make upgrades, please share them.

Avatar
geo3geo

Silver
Forum Posts: 9
sp_UserOfflineSmall Offline
4
December 26, 2014 - 10:53 am
sp_Permalink sp_Print

Many thanks turgo for sharing your work.
I've just used it for my composite BeeBug monitor display
- see http://www.mecol.co.uk/P11.php
Cheers!
Geo

Avatar
turgo

Gold
Forum Posts: 54
sp_UserOfflineSmall Offline
5
April 14, 2015 - 8:14 pm
sp_Permalink sp_Print

Cool, Geo.

I'm most interested in the weight stat. It's interesting to consider how it measures when the bees are home or out working. What is the Brood measure?

Avatar
gabrielb

Silver
Forum Posts: 8
sp_UserOfflineSmall Offline
6
January 10, 2016 - 11:19 am
sp_Permalink sp_Print

I think i have discovered a problem with this FANTASTIC viewer.
First off, I absolutely love it...

The problem I've found is that it does not handle channels higher than 65535.
That number does look familiar doesn't it? (Hint: hFFFF)

If i keep my viewed channels low, it works fine, but if i have a channels starting with 7 it mixes up the graphs, things fail.. etc.

I think i Know what the problem is but i have no idea about HTML and JAVA, so I havent been able to fix it.
Variable "channelNumber" seems to be the problem but i cant find where its initialized on the code...

A fix for this would be GREATLY appreciated.

regards,
G.

Avatar
vorms

Silver
Forum Posts: 7
sp_UserOfflineSmall Offline
7
February 5, 2016 - 10:19 am
sp_Permalink sp_Print sp_EditHistory

Hello
I use the turgo script for 2 applications.
For the first one it work very well.
For the second, depending the lengh of historic, data is not displayed.
If you display the last week the display is right.
If you try to display the last day there is no data.
Every days, ther is no data from 23 PM to 6 AM, that just normal.
May be it is a problem on Thingspeak ?
The data on thingspeak is ok
Thie link for the dispay is here:
http://thili.net/ruches/Blaise/index.html

what is very stange is if I dowlload data or create csv file, data seasm to be good ...

Many thanks for your help and thanks again for your very nice script !!!

Thierry Vorms

Forum Timezone: America/New_York

Most Users Ever Online: 114

Currently Online:
24 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

rw950431: 218

Vinod: 95

vespapierre: 63

piajola: 58

chrisjmears: 54

turgo: 54

Newest Members:

Hiluxman

forumtest1

ioioioiohans

ioioiohans

luckyluck

vcTest

Forum Stats:

Groups: 4

Forums: 17

Topics: 1074

Posts: 3837

 

Member Stats:

Guest Posters: 1

Members: 5165

Moderators: 0

Admins: 2

Administrators: Hans, lee