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

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

January 24, 2014
5:43 pm

turgo

Gold

Members

Forum Posts: 77

Member Since:
June 16, 2013

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

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

ntallari

New Member

Members

Forum Posts: 1

Member Since:
September 5, 2014

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

turgo

Gold

Members

Forum Posts: 77

Member Since:
June 16, 2013

Offline

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

December 26, 2014
10:53 am

geo3geo

Silver

Members

Forum Posts: 9

Member Since:
October 8, 2014

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

turgo

Gold

Members

Forum Posts: 77

Member Since:
June 16, 2013

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

gabrielb

Silver

Members

Forum Posts: 8

Member Since:
July 20, 2015

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

vorms

Silver

Members

Forum Posts: 7

Member Since:
November 5, 2014

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

easydoor

New Member

Members

Forum Posts: 4

Member Since:
June 7, 2019

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

cstapels

Moderator

Members

Moderators

Forum Posts: 754

Member Since:
March 7, 2017

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

easydoor

New Member

Members

Forum Posts: 4

Member Since:
June 7, 2019

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

easydoor

New Member

Members

Forum Posts: 4

Member Since:
June 7, 2019

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

cstapels

Moderator

Members

Moderators

Forum Posts: 754

Member Since:
March 7, 2017

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)