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

Avatar

Please consider registering
Guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —






— Match —





— Forum Options —





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

sp_Feed sp_TopicIcon
ThingSpeak Live Chart, multi channel, second axis, historical data, csv export
No permission to create posts
January 24, 2014
5:43 pm
Avatar
turgo

Gold
Members
Forum Posts: 77
Member Since:
June 16, 2013
sp_UserOfflineSmall Offline

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. "

September 5, 2014
4:06 am
Avatar
ntallari
New Member
Members
Forum Posts: 1
Member Since:
September 5, 2014
sp_UserOfflineSmall Offline

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.

September 22, 2014
10:35 pm
Avatar
turgo

Gold
Members
Forum Posts: 77
Member Since:
June 16, 2013
sp_UserOfflineSmall Offline

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

December 26, 2014
10:53 am
Avatar
geo3geo

Silver
Members
Forum Posts: 9
Member Since:
October 8, 2014
sp_UserOfflineSmall Offline

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

April 14, 2015
8:14 pm
Avatar
turgo

Gold
Members
Forum Posts: 77
Member Since:
June 16, 2013
sp_UserOfflineSmall Offline

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?

January 10, 2016
11:19 am
Avatar
gabrielb

Silver
Members
Forum Posts: 8
Member Since:
July 20, 2015
sp_UserOfflineSmall Offline

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.

February 5, 2016
10:19 am
Avatar
vorms

Silver
Members
Forum Posts: 7
Member Since:
November 5, 2014
sp_UserOfflineSmall Offline

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

June 7, 2019
10:13 pm
Avatar
easydoor
New Member
Members
Forum Posts: 4
Member Since:
June 7, 2019
sp_UserOfflineSmall Offline

Aprox 3-4 months this script do not update automaticly, just if I reload a browser. I tried Chrome, Firefox..but same.
In developer option of browser I see that it really updateing every 15second but I got error code:

Request URL:https://www.thingspeak.com/channels/579443/feed/last.json?callback=jQuery31105319498312513714_1559958872281&offset=0&location=false;key=xxxxxxxxxxxxxxxxx&_=xxxxxxxxxxxxxxx
Request method:GET
Remote address:52.2.102.156:443
Status code:
301
Version:HTTP/1.1

So error code 301 Moved Permanently. I read on google that it means that some links are not accessable any more.
Can someone fix this?
Thx

June 10, 2019
4:03 pm
Avatar
cstapels
Moderator
Members


Moderators
Forum Posts: 754
Member Since:
March 7, 2017
sp_UserOfflineSmall Offline

The callback parameter was recently deprecated. Have a look at the may release notes, I think it describes what you can do:
https://www.mathworks.com/help/thingspeak/release-notes.html

June 15, 2019
7:45 pm
Avatar
easydoor
New Member
Members
Forum Posts: 4
Member Since:
June 7, 2019
sp_UserOfflineSmall Offline

cstapels said

The callback parameter was recently deprecated. Have a look at the may release notes, I think it describes what you can do:
https://www.mathworks.com/help/thingspeak/release-notes.html  

Thx for replay..
I have not enough knowledge to do the modification on this script, to be able to do the auto update.
Can someone help me which lines need to be modified?

June 16, 2019
5:04 am
Avatar
easydoor
New Member
Members
Forum Posts: 4
Member Since:
June 7, 2019
sp_UserOfflineSmall Offline

Ok, it seams to be that I have enough knowledge to fix. 🙂
I realised with help of:
https://ch.mathworks.com/help/thingspeak/release-notes.html
with R2019a and their explanation:
Callback Parameter Deprecated

JSONP is no longer supported by the ThingSpeak API.

If your code uses the callback parameter in a request to api.thingspeak.com, remove callback=? from the URL.

For private channels, provide the read API key as part of the URL (for example ?api_key=READ_API_KEY). Public channels do not require an API key.

For more information, see https://community.thingspeak.com/forum/announcements/jsonp-requests-callback-parameter-are-deprecated/#p8653.

that u need to modify next lines in this script from top of page:
line: 93,149 and 378
and to remove callback=? from line as to replace www with api.
Example:
Before (line 93): $.getJSON('https://www.thingspeak.com/channels/'+channelNumber+'/feed.json?callback=?&offset=0&results=2500;key='+key, function(data)
After (line 93): $.getJSON('https://api.thingspeak.com/channels/'+channelNumber+'/feed.json?&offset=0&results=2500;key='+key, function(data)

Repeat for all of three line. I realised that second line giving the error 301 and first 422

Thx for @cstapels for helping me to understand..

June 17, 2019
8:53 am
Avatar
cstapels
Moderator
Members


Moderators
Forum Posts: 754
Member Since:
March 7, 2017
sp_UserOfflineSmall Offline

Happy to hear you've got it working! Can you tell us more about your project? We are always looking for interesting ThingSpeak projects.

Forum Timezone: America/New_York

Most Users Ever Online: 166

Currently Online:
29 Guest(s)

Currently Browsing this Page:
3 Guest(s)

Top Posters:

rw950431: 272

Vinod: 240

piajola: 95

turgo: 70

vespapierre: 63

Adarsh_Murthy: 62

Member Stats:

Guest Posters: 1

Members: 8665

Moderators: 1

Admins: 2

Forum Stats:

Groups: 3

Forums: 14

Topics: 1600

Posts: 5760

Newest Members:

Fathima22, jefflam1994, harrydawson, markpaul7931, sgarsvk2rdx, Win Win

Moderators: cstapels: 460

Administrators: Hans: 405, lee: 457