Results for
Hi there,
I have tried to get the data on thingspeak via integrating it on the things Network. but the GPS data I am receiving on the thingspeak is delayed by 2 mins.
is there any way I can code to send JSON file straight on thingspeak from the sensor or the gateway?
Following is the ardiuno sketch
#include <lmic.h> #include <hal/hal.h> #include <SPI.h> #include <SoftwareSerial.h> #include <TinyGPS.h> TinyGPS gps; SoftwareSerial ss(3, 4); // Arduino RX, TX to conenct to GPS module.
static void smartdelay(unsigned long ms);
unsigned int count = 1; //For times count
String datastring1=""; String datastring2=""; String datastring3=""; uint8_t datasend[20]; //Used to store GPS data for uploading
char gps_lon[20]={"\0"}; //Storage GPS info
char gps_lat[20]={"\0"}; //Storage latitude
char gps_alt[20]={"\0"}; //Storage altitude
float flat, flon,falt;
static uint8_t mydata[] = "Hello, world!"; //For test using.
/* LoRaWAN NwkSKey, network session key
This is the default Semtech key, which is used by the prototype TTN
network initially.
ttn*/
static const PROGMEM u1_t NWKSKEY[16] = { 0xE4, 0x2A, 0x93, 0x96, 0xF7, 0xC9, 0x65, 0x9E, 0xF8, 0x90, 0xC6, 0xA0, 0x1A, 0x88, 0xF7, 0x47 };
/* LoRaWAN AppSKey, application session key
This is the default Semtech key, which is used by the prototype TTN
network initially.
ttn*/
static const u1_t PROGMEM APPSKEY[16] = { 0x75, 0x43, 0x26, 0xA1, 0x82, 0x79, 0x7F, 0xCF, 0x3C, 0x1D, 0xBF, 0xF9, 0xBF, 0xCB, 0xC6, 0xD9 };
/* LoRaWAN end-device address (DevAddr) See http://thethingsnetwork.org/wiki/AddressSpace ttn*/ static const u4_t DEVADDR = 0x260111D1;
/* These callbacks are only used in over-the-air activation, so they are
left empty here (we cannot leave them out completely unless
DISABLE_JOIN is set in config.h, otherwise the linker will complain).*/
void os_getArtEui (u1_t* buf) { }
void os_getDevEui (u1_t* buf) { }
void os_getDevKey (u1_t* buf) { }
static osjob_t initjob,sendjob,blinkjob;
/* Schedule TX every this many seconds (might become longer due to duty cycle limitations).*/ const unsigned TX_INTERVAL = 20;
// Pin mapping
const lmic_pinmap lmic_pins = {
.nss = 10,
.rxtx = LMIC_UNUSED_PIN,
.rst = 9,
.dio = {2, 6, 7},
};
void do_send(osjob_t* j){
// Check if there is not a current TX/RX job running
if (LMIC.opmode & OP_TXRXPEND) {
Serial.println("OP_TXRXPEND, not sending");
} else {
GPSRead();
GPSWrite();
// Prepare upstream data transmission at the next possible time.
LMIC_setTxData2(1,datasend,sizeof(datasend)-1,0);
//LMIC_setTxData2(1, mydata, sizeof(mydata)-1, 0);
Serial.println("Packet queued");
Serial.print("LMIC.freq:");
Serial.println(LMIC.freq);
Serial.println("");
Serial.println("");
Serial.println("Receive data:"); }
// Next TX is scheduled after TX_COMPLETE event.
}void onEvent (ev_t ev) {
Serial.print(os_getTime());
Serial.print(": ");
Serial.println(ev);
switch(ev) {
case EV_SCAN_TIMEOUT:
Serial.println("EV_SCAN_TIMEOUT");
break;
case EV_BEACON_FOUND:
Serial.println("EV_BEACON_FOUND");
break;
case EV_BEACON_MISSED:
Serial.println("EV_BEACON_MISSED");
break;
case EV_BEACON_TRACKED:
Serial.println("EV_BEACON_TRACKED");
break;
case EV_JOINING:
Serial.println("EV_JOINING");
break;
case EV_JOINED:
Serial.println("EV_JOINED");
break;
case EV_RFU1:
Serial.println("EV_RFU1");
break;
case EV_JOIN_FAILED:
Serial.println("EV_JOIN_FAILED");
break;
case EV_REJOIN_FAILED:
Serial.println("EV_REJOIN_FAILED");
break;
case EV_TXCOMPLETE:
Serial.println("EV_TXCOMPLETE (includes waiting for RX windows)");
if(LMIC.dataLen) {
// data received in rx slot after tx
Serial.print("Data Received: ");
Serial.write(LMIC.frame+LMIC.dataBeg, LMIC.dataLen);
Serial.println();
}
// Schedule next transmission
os_setTimedCallback(&sendjob, os_getTime()+sec2osticks(TX_INTERVAL), do_send);
break;
case EV_LOST_TSYNC:
Serial.println("EV_LOST_TSYNC");
break;
case EV_RESET:
Serial.println("EV_RESET");
break;
case EV_RXCOMPLETE:
// data received in ping slot
Serial.println("EV_RXCOMPLETE");
break;
case EV_LINK_DEAD:
Serial.println("EV_LINK_DEAD");
break;
case EV_LINK_ALIVE:
Serial.println("EV_LINK_ALIVE");
break;
default:
Serial.println("Unknown event");
break;
}
}
void setup() {
// initialize digital pin as an output.
Serial.begin(9600);
ss.begin(9600);
while(!Serial);
Serial.println("LoRa GPS Example---- ");
Serial.println("Connect to TTN");
#ifdef VCC_ENABLE
// For Pinoccio Scout boards
pinMode(VCC_ENABLE, OUTPUT);
digitalWrite(VCC_ENABLE, HIGH);
delay(1000);
#endif // LMIC init
os_init();
// Reset the MAC state. Session and pending data transfers will be discarded.
LMIC_reset();
/*LMIC_setClockError(MAX_CLOCK_ERROR * 1/100);
Set static session parameters. Instead of dynamically establishing a session
by joining the network, precomputed session parameters are be provided.*/
#ifdef PROGMEM
/* On AVR, these values are stored in flash and only copied to RAM
once. Copy them to a temporary buffer here, LMIC_setSession will
copy them into a buffer of its own again.*/
uint8_t appskey[sizeof(APPSKEY)];
uint8_t nwkskey[sizeof(NWKSKEY)];
memcpy_P(appskey, APPSKEY, sizeof(APPSKEY));
memcpy_P(nwkskey, NWKSKEY, sizeof(NWKSKEY));
LMIC_setSession (0x1, DEVADDR, nwkskey, appskey);
#else
// If not running an AVR with PROGMEM, just use the arrays directly
LMIC_setSession (0x1, DEVADDR, NWKSKEY, APPSKEY);
#endif // Disable link check validation
LMIC_setLinkCheckMode(0); // TTN uses SF9 for its RX2 window.
LMIC.dn2Dr = DR_SF9; // Set data rate and transmit power (note: txpow seems to be ignored by the library)
LMIC_setDrTxpow(DR_SF7,14); // Start job
do_send(&sendjob);
}void GPSRead()
{
unsigned long age;
gps.f_get_position(&flat, &flon, &age);
falt=gps.f_altitude(); //get altitude
flat == TinyGPS::GPS_INVALID_F_ANGLE ? 0.0 : flat, 6;
flon == TinyGPS::GPS_INVALID_F_ANGLE ? 0.0 : flon, 6;//save six decimal places
falt == TinyGPS::GPS_INVALID_F_ANGLE ? 0.0 : falt, 2;//save two decimal places
}
void GPSWrite()
{
/*Convert GPS data to format*/
datastring1 +=dtostrf(flat, 0, 4, gps_lat);
datastring2 +=dtostrf(flon, 0, 4, gps_lon);
//datastring3 +=dtostrf(falt, 0, 2, gps_alt);
if(flon!=1000.000000)
{
strcat(gps_lon,",");
strcat(gps_lon,gps_lat);
//strcat(gps_lon,",");
//strcat(gps_lon,gps_alt);
int i = 0;
for(i = 0; i < 2; i++)
{
//datasend.toFloat();
atof(gps_lon);
//Serial.println((char*)datasend);
Serial.println("Testing converted data:");
Serial.println(gps_lon);
// atof(gps_alt);
// Serial.print(gps_alt);
} strcpy(datasend,gps_lon); //the format of datasend is longtitude,latitude,altitude
Serial.print("########### ");
Serial.print("NO.");
Serial.print(count);
Serial.println(" ###########");
Serial.println("The longtitude and latitude are:");
Serial.print("[");
Serial.print((char*)datasend);
Serial.print("]");
Serial.print("");
/*
for(int k = 0; k < 20;k++)
{
Serial.print("[");
Serial.print(datasend[k], HEX);
Serial.print("]");
}
Serial.println("");
Serial.println("");*/
count++;
} int32_t lng = flat * 10000;
int32_t lat = flon * 10000; datasend[0] = lat;
datasend[1] = lat >> 8;
datasend[2] = lat >> 16; datasend[3] = lng;
datasend[4] = lng >> 8;
datasend[5] = lng >> 16;
smartdelay(1000);
}static void smartdelay(unsigned long ms)
{
unsigned long start = millis();
do
{
while (ss.available())
{
gps.encode(ss.read());
}
} while (millis() - start < ms);
}
void loop() {
os_runloop_once();
}
EDIT
Thank you to everyone who replied to this post! We now have a proper survey with these questions and a few more. If you'd like to provide feedback, please complete the survey at the following link:
https://www.surveymonkey.com/r/GPJTV6C
---
Original Post
I'm a member of the ThingSpeak team. I'd like to learn more about how the ThingSpeak community accesses channel data. Your feedback can help us make ThingSpeak better!
(A) Which of these statements best describes when the data you are interested in typically occurs?
- the last X hours / minutes / seconds
- a specific time window, e.g. "Monday, October 4th, 2021 9:00AM to 10:00PM"
- the last N feeds
- all data in the channel
(B) What is a typical duration of time that you are interested in? (e.g. "3 hours", "a few minutes")
(C) How many data points do you typically expect to read?
In the past 2 months, we had a lot of fun together playing in the two contests. To make future contests better and more appealing to you, we created a 1-minute survey to understand your experience.
Your feedback is critical to us. Thank you in advance and hope to see you in 2022!
Hello everyone! i want to send current sensor data using Arduino and nodeMCU to thingspeak. is there anyone who worked on something before. your responses will be highly appreciatable. thanks in advance
Hello,
I am sending mqtt values from esp8266 devices to different channels - e.g. https://thingspeak.com/channels/1182897
The values are sent correctly and also show up on the channel's page correctly and quickly in time.
But mqtt receivers are getting the data with a varying long delay. Often the delay is 1h, so I first thought, this could be a time zone problem. But that's not the case.
I tried two different mqtt clients: Both get the values at the same (late time): E.g. when I now get a value from channels/1182897/subscribe/fields/field3 and look into the history of values (using "Data Import/Export") then this value can be found 20 minutes up to 1 hour ago. This can also be confirmed when looking into the device's logs.
What could I do to be up-to-date with my values? Thank you very much. Dirk
After 7 weeks of fun, the MATLAB Central community 20th anniversary contests have concluded! Together, we shared the art of MATLAB and contributed to the battle against the global pandemic. See the fantastic stats below.
- 1,700 entries created and 24,000 votes cast in MATLAB Mini Hack
- 6,300 tasks completed in Treasure Hunt
- $17,000 raised for Direct Relief
MATLAB Mini Hack Winners - Week 4
In Week 4, we invited the MATLAB Graphics team to help judge the entries. As the authors of the MATLAB functions used in every entry, they made sure every entry selected used a unique graphics function or technique from the other winners. Here are their choices:
1. Umbrellas by Shanshan Wang
Comment: Cool use of 'swarmchart' to make art from distributions; Only use of one of our newest graphics functions
2. Happy Sheep by Victoria
Comment: Cute!
3. Alien Giant by Jenny Bosten
Comment: Original idea, well textured, and efficient code
4. 3D Ultrasound by Adam Danz
Comment: Replicate source material very well. Effective use of lighting and material. Overall, impressive to produce this image given the limitation
5. Sunset in the Savanna by Sebastian Kraemer
Comment: Looks cool! Nice mix of 'image', 'fill' and 'scatter' commands.
6. Night Flight by Ratul Das
Comment: original; clever use of 'rectangle'
7. Lantern #2 by Tim
Comment: Nice use of 'getframe' to create a texture for 'surf' for a compelling picture
8. Geometric Design (6) by Daniel Pereira
Comment: Looks like some walls at MathWorks
9. Rosette 1313 by Alex P
Comment: Looks cool! Nice use of 'pcolor'
10. Mandelbrot contour by Sumihiro
Comment: Best use of contour!
11. Aim High by Murty PLN
Comment: Largest number of unique graphics objects for the Mini Hack (plot, patch,stairs,stem,text)
In the spirit of Mini Hack, the MATLAB Graphics team also created several cool graphs about the contest. Facing a similar space limit, I have picked only 2.
Bonus Prize Winners - Week 4
Congratulations to our 5 winners for their dual participation in the Treasure Hunt and the MATLAB Mini Hack. Yogiraj Bhagavatula, Pramod Devireddy, Devika U, FruitsLord, and Augusto Mazzei.
Lucky voters - Week 4
Congratulations to the lucky voters who cast the 12000th vote (Gordg Garin), 12500th vote (Eder Esteban Reyes), 13000th vote (Peram Balakrishna), 13500th vote (Emerson Nithiyaraj), 14000th vote(Sekar Naai), 14500th vote (Arika Amasarao), 15000th vote (Nikita Yakovlev), 15500th vote (Kesava Rao), and 16000th vote (Kundi Chandra Sekhar).
Grant Prize Winners
Finally, after validating entries and votes, we have picked the grand prize winners. We appreciate the time and effort you spent and the awesome entries you created. Huge congratulations!
1. Top 10 Authors of most voted entries
Each author will receive 5 customized T-shirts with the winning image and your name on the back of the T-shirts. You can choose the sizes and share them with your family or friends.
- Ciro Bermudez
- Jenny Bosten
- Adam Danz
- Jr
- Maximilian Schönau
- KSSV
- Dr Raveendranathan K C
- taoizm
- Sebastian Kraemer
- Victoria
2. Top 10 Authors with most total votes
Top 10 contestants on the leaderboard will each get an Amazon gift card. The top 3 winners on the leaderboard will also earn special virtual badges.
- Ciro Bermudez
- KSSV
- Juan Villacrés
- Murty PLN
- Pink_panther
- Jenny Bosten
- KARUPPASAMYPANDIYAN M
- Jr
- Adam Danz
- Victoria
On behalf of the MATLAB Central community team, we thank you for joining our celebration of the MATLAB Central community’s 20th anniversary with us in the past 7 weeks. We hope you enjoyed these contests and look forward to seeing you in next year’s contests. Question: “What contests would you like to see next?”
I have a chart of data and need to eliminate the outliers which are making the chart look bad. Is there a configuration for this?
Hello, I try to publish to an already working channel. I have created an device and using the credentials shown in the image. I would like connect via TCP and port 1883 to mqtt3.thingspeak.com My Library always returns "Connection Refused - Bad Username or Password". This means it already has got a CONNACK reply. I have already successfully published an item to another server. So, the Lib basically works and I am using it correctly. I do not have mistyped the credentials. Could there be something on the Thingspeak side? Could you please help me with that? Thank you in advance.
VOTE on your favorite MATLAB images before Oct. 31 and win special edition T-shirts!
In just 2 weeks, 11,000 votes have been cast on 1200+ entries ! In the final week (Oct 25~Oct 31, 2021), we will add some fun and give out a T-shirt to lucky voters who cast:
- The 12000th vote
- The 12500th vote
- The 13000th vote
- The 13500th vote
- The 14000th vote
- The 14500th vote
- The 15000th vote
- The 15500th vote
- The 16000th vote
Furthermore, for every vote an entry gets, MathWorks will donate $1 to Direct Relief (Maximum amount of $20 donated per entry; maximum of $20,000 in total).
Look at the entries , and if they make you smile, VOTE!
I currently have my ThingSpeak log temp, airflow velocity raw and airflow velocity filtered. The column names show as field1, field 2 and field 3. Is there a way for me to change field1 to temperature? Thanks
In Week 3, we passed several amazing milestones! 1,000 Participants in the Treasure Hunt , 1,000 ENTRIES and 10,000 votes in the MATLAB Mini Hack , and $10,000 charity donation from both contests! I recommend you read Ned Gulley’s recent blog post , which is a fantastic summary of the contest highlights.
During the last week of this contest, we strongly encourage you to inspire your colleagues, classmates, or friends to participate by either VOTING or CREATING entries. To add some fun, we will give out a T-shirt to LUCKY voters who cast:
- The 12000th vote
- The 12500th vote
- The 13000th vote
- The 13500th vote
- The 14000th vote
- The 14500th vote
- The 15000th vote
- The 15500th vote
- The 16000th vote
MATLAB Mini Hack Winners - Week 3
We’ve received many creative entries for our new categories. Congratulations to the winners! Each of you won a special edition T-shirt:
Greg, entry: better Christmas tree , category: Holidays
Ratul Das, entry: To All Pepperoni Lovers , category: Food
Peter Stampfli, entry: Louis V , category: Fractals
Adrien Leygue, entry: Stained Glass membrane , category: MathWorks Logo
Spencer Miesner, entry: ~Breathe~ , category: Album Cover
Stewart Thomas, entry: The only QR code you ever need , category: Black & White
Sebastian Kraemer, entry: sun , category: 3D
Jenny Bosten, entry: The joys of spring , category: Plant
Adam Danz, entry: MATropolis rooftop view , category: Illustration
Eric Ogier, entry: UFO , category: Fun
Simon Thor, entry: Mandelbrot in 52 characters , category: Concise
Tim, entry: Low Tide , category: Realism
Bonus Prize Winners - Week 3
We are giving out additional giveaways to participants of both the Treasure Hunt and the MATLAB Mini Hack . Congratulations to our 5 winners. Each of you has also won a special edition T-shirt.
- Teodo
- Dyuman Joshi
- Shanshan Wang
- Nirvik Sinha
- Felipe Torres
Week 4
After the contest ends, we need additional time to validate entries for Grand Prize and Weekly Prize. The winners are expected to be announced within a couple of days after the contest ends. Thank you in advance for your patience.
Hi,
I am experiencing trouble in sending the actual sensor values to Thingspeak. I use a code template that I downloaded from a github repository https://github.com/mathworks/thingspeak-arduino/tree/master/examples/ESP32/WriteMultipleFields. The main issue is that I don't know how to fill out the source code to get real sensor values instead of random values.
I am using a DHT sensor, from which I want to measure both the temperature and the humidity. Here is what it looks like in the serial monitor after uploading the code to the ESP32 dev board.
Here is my code that I amended from the source template, and uploaded to the ESP32 board.
#include "DHT.h" #include <WiFi.h> #include "ThingSpeak.h"
// The wire is in pin 14 as required by the DHT-sensor, so it is written here: #define DHTPIN 14
// We use a DHT11-sensor #define DHTTYPE DHT110
const char* ssid = "Koti_9BE9"; // your network SSID (name) const char* password = "XXXXXXX"; // your network password
WiFiClient client;
// We write one (1) as the channel number. Assumably in that order in which they are in the MyChannels-page. unsigned long myChannelNumber = 1; const char * myWriteAPIKey = "NW34MMOB5J1NGRL2";
// Timer variables unsigned long lastTime = 0; unsigned long timerDelay = 10000; // This specifies what kind of delay we want between measurements. DHT11 // The fastest measurement interval of DHT sensors is 2000 ms (2 seconds).
// An object from where values are brought from the DHT library DHT dht(DHTPIN, DHTTYPE);
// Initialize our values. Writing down the values that need to be measured from DHT-sensors: // humidity h, temperature t, and temperature in fahrenheit-scale f float h = dht.readHumidity(); float t = dht.readTemperature(); float f = dht.readTemperature(true); String myStatus = "";
void setup() {
Serial.begin(115200);
Serial.println(F("DHT11 test!"));
dht.begin();
WiFi.mode(WIFI_STA);
ThingSpeak.begin(client); }
void loop() {
delay(20000);
float h = dht.readHumidity();
float t = dht.readTemperature();
float f = dht.readTemperature(true);
if (isnan(h) || isnan(t) || isnan(f)) {
Serial.println(F("Failed to read from DHT sensor!"));
return;
} if(WiFi.status() != WL_CONNECTED){
Serial.print("Attempting to connect");
while(WiFi.status() != WL_CONNECTED){
WiFi.begin(ssid, password);
delay(5000);
}
Serial.println("\nConnected.");
}float hif = dht.computeHeatIndex(f, h);
float hic = dht.computeHeatIndex(t, h, false);
Serial.print(F("Humidity: "));
Serial.print(h);
Serial.print(F("% Temperature: "));
Serial.print(t);
Serial.print(F("°C "));
Serial.print(f);
Serial.print(F("°F Heat index: "));
Serial.print(hic);
Serial.print(F("°C "));
Serial.print(hif);
Serial.println(F("°F"));int x = ThingSpeak.writeFields(myChannelNumber, myWriteAPIKey);
if(x == 200){
Serial.println("Channel update successful.");
}
else{
Serial.println("Problem updating channel. HTTP error code " + String(x));
}
}
Many thanks for any advice.
Lauri
i have url that contains value for reading data, how can i send data to field from url that i have?
I have a project that collects data from a CO2 sensor and stored it in these ints:
CO2PPM = (int)data[2] * 256 + (int)data[3];
temperature = (int)data[4] - 40; which are defined as ints. Then just before the http request, they are processed like this:
static char outstr3[15];
static char outstr4[15];
String dataString3 = dtostrf(CO2PPM, 8, 2, outstr3);
String dataString4 = dtostrf(temperature, 8, 2, outstr4);and finally used in the GET request:
wifly.println("GET /update?api_key=apikey&field1="dataString4"&field2="+dataString3+" HTTP/1.1");which fails to successfully register the data into TS. However if I hardcode it like this:
wifly.println("GET /update?api_key=apikey&field1=23.45&field2=67.89 HTTP/1.1");it works, the data is registered.
Any idea how to fix this issue?
Greetings!
So, I'm working on a project that needs to send collected data using a SIM808 over GPRS to ThingSpeak to multiple fields. The upload interval is 2 minutes with samples taken every 10 seconds and each batch of samples includes 19 bytes of data (12 sets of 19 bytes equal 228B for each bulk data pack that has to be sent and the memory can be flushed). It's worth mentioning that I'm using an Arduino Pro Mini (ATmega328P).
I've looked at the bulk data upload example, and I'm having some trouble adapting it to the SIM808. I am also not sure how to send multiple fields using the bulk method. Unfortunately, I don't have much time to tinker with the code as the whole project had to be done in 2 days and I've only got one day to finish. I'd appreciate any help regarding this as I'm on a very tight schedule.
Thanks in advance!
We've started a new video series on how and why to use ThingSpeak. IoT from Data to Action . Most of you pros here at the forum probably already know this stuff, but there's some great overview material in these videos if you are interested. Two of four planned movies are posted, Ill let you know again when the others come out too. -Christopher
