How to Send Data from ESP8266 Using Bascom to Thingspeak Database (AT Commands)

Name: How to Send Data from ESP8266 Using Bascom to Thingspeak Database (AT Commands)
Uploaded: 2016-01-15T14:46:10+01:00
Description: Hello I am trying to send data to the Thingspeak database. Variables: Configuration: Sending: Manually through the website works OK, but through the ESP8266 nothing is added. I guess the fact that I'm trying to send to two channels ( consecutively of course ) has no effect ? Any ideas ? The best...

Question

Hello I am trying to send data to the Thingspeak database. Variables: Configuration: Sending: Manually through the website works OK, but through the ESP8266 nothing is added. I guess the fact that I'm trying to send to two channels ( consecutively of course ) has no effect ? Any ideas ? The best...

piterek-23 · Answer

And does the ESP connect to WiFi at all? Can you see it in the router?

Elektronik_Kraków · Answer

Yes, on the router it is
I even hooked up the FT232 first to the Tx of the atmega and then to the Rx to see what it was transmitting. I had among other things
STA: "192.168.0.120" and the Mac address of the module.

What concerns me, however, is the syntax being sent to Thingspeak. After logging in, under the Data Import/Export tab, there is an example of a


GET https://api.thingspeak.com/update?api_key=NB9OW9K1234567BF&field1=0

or


GET http://api.thingspeak.com/update?api_key=NB9OW9K1234567BF&field1=0

while some write as follows


GET /update?key=WM82DJMQF003MYGU&field1=8

while I still found such information:
before the first Field1 there should be no "&" sign


Thing_string = "GET https://api.thingspeak.com/update?api_key=" + Apikey + "&Field1=" + T1 + "&Field2=" + T7 + "&Field3=" + T3 + "&Field4=" + Str(hum) + "&Field5=" + Str(pressure) + Chr(13) + Chr(10) + Chr(13) + Chr(10)

and that " Chr(13) + Chr(10) + Chr(13) + Chr(10)" is also unnecessary

and as regards

Quote:
The best thing to do would be to check for errors, but I have something wrong with the reception from the ESP8266 because I can't "pull" the IP address that the module gets.

i was more referring to some problems with the configuration of the UART
on the configured
buffer = 245
bytematch = 10

Added after 45 [minutes]:

Unfortunately for now I have a problem receiving more than, one line. Hence the problem to get a good handle on the ESP module.

Maybe a colleague or someone reading will "lighten up" a bit for me ?
It is about the use of Bytematch
Suppose I have

Log in, to see the code

then if there are e.g. 4 lines of data of say 50 characters each ending in character 13, they will be placed in order of arrival and now I standardly use

Log in, to see the code

then I am to receive it

Log in, to see the code

or maybe

Log in, to see the code

whereby ciag1_uart will have the same size as the buffer - 254 and I still have to divide it into four parts myself by parsing with character 13 ?

Anonymous · Answer

It's a bit difficult to understand this code because it probably does something different to what you intend.

When you enable receiving characters into the buffer they are received "in the background" in a "hidden" interrupt handler.

Now, you can find out that there are characters waiting in the buffer either by testing with the Ischarwaiting() function or by setting the trigger to a specific character via the Bytematch

When you have set the trigger on Bytematch(13), you need to put a routine in your code that the program will jump to when it detects a character.

However, I would like you to notice that there are probably already more characters in the buffer and there is definitely no previous character 13 because it would have already called this procedure.

At this point in the code/procedure you are only there when Enter (13) occurs so you probably have one string to pull in there and certainly not via "Uart_get_char = Udr"

From these snippets it's hard to just piece together what you're up to there

There's an example on the MCS Forum of how the ESP8266 pulls time from an NTP server and parses the incoming strings

Elektronik_Kraków · Answer

Hello
Regarding what he is up to

( i.e. how it should work ).
First wanted to put up a webserver, but relied on good handling of reading a few lines ( detecting a few characters that will trigger a subroutine to send to the server ). So to start with something simpler, but I can also see that without good handling of reading a few lines it will be lame.

Back to the topic

Quote:

When you enable receiving characters into the buffer they are received "in the background" in a "hidden" interrupt handler.

this I knew

Quote:

Now, you can find out that there are characters waiting in the buffer either by testing with the Ischarwaiting() function or by setting the trigger to a specific character via Bytematch

i.e. character 13 will cause e.g. a flag to be set and the contents of the buffer to be read by e.g. Input. So I should quickly check if there is something interesting there because another one is about to arrive ( e.g. ESP in server mode can send eight lines ) ?

Maybe a stupid question, but will the atmega program "time out" at 115200 ?

Ultimately:
Buffer = 254
Bytematch = 13

1 line ending with 13
Input ciag_uart Noecho
parsing
2 line ending with 13
Input ciag_uart Noecho
parsing
3rd line ending with char 13
Input ciag_uart Noecho
parsing
4 line ending with char 13
Input ciag_uart Noecho
parsing

I also have a question about Input - I read that it automatically deletes the contents of the buffer, so you don't have to do clearin0 - is this true?

i found this topic - thank you. Inkey is used there, but it gives some food for thought

Added after 29 [minutes]:

As for the ESP8266, the terminal shows:


AT+RST


OK
WIFI DISCONNECT

 ets Jan  8 2013,rst cause:2, boot mode:(3,7)

load 0x40100000, len 1396, room 16 
tail 4
chksum 0x89
load 0x3ffe8000, len 776, room 4 
tail 4
chksum 0xe8
load 0x3ffe8308, len 540, room 4 
tail 8
chksum 0xc0
csum 0xc0

2nd boot version : 1.4(b1)
  SPI Speed      : 40MHz
  SPI Mode       : QIO
  SPI Flash Size & Map: 8Mbit(512KB+512KB)
jump to run user1 @ 1000

ŚŐ(¤SQS(RQ¨)HT¨)SHHHC…ä˙rŽĂąô
Ai-Thinker Technology Co. Ltd.

ready
AT+CWMODE=1


OK
AT+CWJAP="nigsdfdsf","qasdfgdfefd"

WIFI CONNECTED
WIFI GOT IP

OK
AT+CIFSR

+CIFSR:STAIP,"192.168.0.100"
+CIFSR:STAMAC,"5c:cf:7f:01:be:a8"

OK
AT+CIPMUX=1


OK
AT+CIPSTART=4,"TCP","184.106.153.149",80

4,CONNECT

OK
AT+CIPSTART=4,119

Link typ ERROR

ERROR
GET http://api.thingspeak.com/update?api_key=NB9O19K734GERRA4BF&Field1=34.5&Field2=47.5&Field3=48.3&Field4=52&Field5=1002


ERROR
AT+CIPCLOSE

MUX=1

ERROR
AT+CIPSTART=4,"TCP","184.106.153.149",80

ALREADY CONNECTED

ERROR
AT+CIPSTART=4,121

Link typ ERROR

ERROR
GET http://api.thingspeak.com/update?api_key=D6GBHJ335G6RVXQI&Field1=54.6&Field2=49.3&Field3=23.6&Field4=34.5&Field5=34.8


ERROR
AT+CIPCLOSE

MUX=1

ERROR

Elektronik_Kraków · Answer

The error was in the code instead of CIPSEND I had CIPSTART.

Now it sends OK ( i.e. I have SEND OK twice ) but I have a Bad Request:


AT+CIPMUX=1


OK
AT+CIPSTART=4,"TCP","184.106.153.149",80

4,CONNECT

OK
AT+CIPSEND=4,120


OK
> 

busy s...

Recv 120 bytes

SEND OK
AT+CIPSEND=4,118


OK
> 

busy s...

Recv 118 bytes

SEND OK

+IPD,4,323:HTTP/1.1 400 Bad Request
Server: nginx/1.7.5
Date: Tue, 12 Jan 2016 14:25:38 GMT
Content-Type: text/html
Content-Length: 172
Connection: close

<html>
<head><title>400 Bad Request</title></head>
<body bgcolor="white">
<center><h1>400 Bad Request</h1></center>
<hr><center>nginx/1.7.5</center>
</body>
</html>
4,CLOSED
AT+CIPCLOSE

MUX=1

ERROR

What is the problem ?

I now send like this:

Log in, to see the code

Added after 20 [minutes]:

I changed to every call before sending.

Log in, to see the code

and now ThingSpeak shows that an item has been added, but nothing can be seen on the graph.

Added after 9 [minutes]:

I did an export to CSV and got:

created_at entry_id field1 field2 field3 field4 field5
2016-01-10 22:58:06 UTC 1 0 27.9 58.4 34
2016-01-10 22:59:27 UTC 2 0.1 27.5 57.9 34 986
2016-01-10 23:00:26 UTC 3 -0.4 26.5 55.8 34 984
2016-01-11 18:56:31 UTC 4 2.1 26.5 55.8 34 984
2016-01-11 22:25:50 UTC 5 2.1 26.5 55.8 34 984
2016-01-11 22:51:56 UTC 6 2.1 26.5 55.8 34 984
2016-01-12 14:37:00 UTC 7
2016-01-12 14:37:32 UTC 8
2016-01-12 14:37:48 UTC 9
2016-01-12 14:38:05 UTC 10
2016-01-12 14:39:39 UTC 11
2016-01-12 14:43:36 UTC 12
2016-01-12 14:53:44 UTC 13
2016-01-12 14:55:47 UTC 14
2016-01-12 14:58:32 UTC 15
2016-01-12 14:59:02 UTC 16

Anonymous · Answer

I have a NodeMCU with a USBSERIAL converter connected and I am a bit uncomfortable connecting this to the microcontroller. However, see what data and how it sends in the example to LUA and Thingspeak software. Maybe you can figure something out. There was no time to play with it Code: BashLog in, to see the code

Anonymous · Answer

Please. I don't know if a colleague managed to solve the problem, but as I had moments I'll share with everyone.
I have the ESP8266 on a NodeMCU and prefer to program it there, but I wanted to play around with AT commands so I connected it to Xmega because this thing is also 3 volt and has up to 7 USART interfaces

On the second COM I made myself such a Debug.
The program responds to receiving a "WIFI GOT IP" command so you can turn off the ESP to save power.
I didn't elaborate the code because I just fired it up for fun.

You can see how it works in the video. I gave up on the Charmatch. It runs smoothly and everything is absolutely non-blocking. No expectations or delays.

Log in, to see the code

Have fun

piterek-23 · Answer

Fellow @niveasoft a question a little bit from a different barrel.... Where do you get such nice lines connecting functions in BASCOM?

Anonymous · Answer

I enable in the options

I also always have line numbering enabled and in the window options I enable Code Explorer.
In addition, the option "Code Folding" allows you to collapse pieces of code and there is less scrolling in the window

All this is already in 2078

Elektronik_Kraków · Answer

Thank you colleague niveasoft for your reply - I will be testing my colleague's solution. I was a bit afraid of this Inkey, because it always blocked something for me, but since there is information that it doesn't block anything it's a joy. Regarding my problem, two things came up: Code: text Expand Select all Copy to clipboard Thing_string = GET  the field name &field1= is supposed to be lowercase, i.e. &field1= and the other thing is unfortunately the WiFi range, turned out to be worse than I assumed, but I've already ordered a 12dBi antenna, so maybe it will work. Perhaps it's not entirely the module's fault, I have a small repeater like this that plugs into the socket, but it's without an antenna. I have also encountered opinions that the speed 115200 is a bit too high ( unfortunately it is not possible to change it permanently to another one ), but I see that a colleague uses one. Can the timing of the controller ( 8 MHz in my case ) affect the performance of the UART reading ?

Anonymous · Answer

I took the Xmege for convenience because everything worked on the same voltage and I had a second COM.

But at the beginning I configured myself internal 32MHz oscillator and on speed 19200 was lame. Same Chinese characters, chopped, in other words rubbish

So I configured Xmege to work with an external resonator not much faster than 8MHz, i.e. such a USART`friendly 11059200Hz and it worked seamlessly

In the end I thought about turning on the automatic oscillator calibration and trying to work on the internal oscillator again. It worked elegantly so I posted the code with this internal timing.

As for this Inkey() it is an instruction that writes a character from the serial interface to a byte.
The interface can be buffered. Then with the Ischarwaiting() function we check if there is a character waiting in the buffer and only use Inkey()
So there is no fear that the program hangs waiting for the character because it is the character already waiting for me....

As for Charmatch, it turns out that it is a "hooked" function attached to the interrupt handler routine that receives characters into the buffer.
A normal buffer handler routine only puts back on the stack the three registers it uses.
When we use Charmatch, if we include more instructions in the character detection routine, we have to take care of preserving the used registers ourselves.
So I added a function to my little tool

To summarise. If you take care of the correct clocking then everything should run at 8MHz and even without Charmatch as I have coded it.
Note that this part of the code at the beginning is a function to handle this Thingspeak and can be moved to another file and then encapsulated. In the program afterwards it just needs to be called often enough. The program, on the other hand, can of course do much more

Elektronik_Kraków · Answer

Thank you for your reply.
As there are no waits anywhere, I wanted to ask how the Colleague did the ESP8266 configuration ?
I am doing it on waits for now unfortunately.

Log in, to see the code

I was wondering if this could be done with a Timer:

Log in, to see the code

Alternatively, maybe using Case, checking whether an OK Error or ready came on the UART.

Anonymous · Answer

It's like M.Kardasio's video tutorials for the HC-05.
Why configure this ESP over and over again?
I configured mine once. Now, when I connect a terminal to it, it logs in to my router by itself after switching on/resetting.
It says WIFI CONNECTED and WIFI GOT IP

I have presented the programme as an example and something that I managed to get working in this simple version.
The whole thing works in such a way that one "State" byte constantly holds a value which reflects what I am currently doing with the module. So after I transmit something, I change the state to "Waiting" and store the previous state for various needs.

Then, by cyclically calling the handler function by dropping into it, I check via Select Case what stage we are at. If Waiting and there are characters waiting in the buffer, I receive them. Depending on what I have received from the module, I take the next steps. If there is no ERROR then I give the next instruction and set State to Waiting

You can assign Aliases to values, i.e. Waiting means 1, Sending, for example, 2

Then in the program I can write Status = Sending and the microcontroller sees Status = 2

It doesn't cost anything because this message is just for us and the compiler which value we want, and the code is clearer.

In this configuration, if the Select case matches the status, it does not check the others and leaves it, so even a change of status to the next one will be considered only in the next call of the function.
And here is an interesting fact. If we have a long code, we can call functions in several places.

Elektronik_Kraków · Answer

That is, as long as you do not change the WiFi network, there is no need to configure, possibly after receiving WIFI GOT IP you can still ask for the IP - AT+CIFSR, and there is also AT+CWMODE=1 mode. But with me rather problems with correct reception from UART. Something too fast is going forward. If I want to receive characters from UART and display them on LCD I do the following Code: VB.netLog in, to see the code Because what should happen in Case I understand ( admittedly I didn't know about these labels for Case ) 1. incoming character - Ischarwaiting(#1) > 0 2. receiving the character in the subroutine via Inkey(#1) 3. omitting characters 10 and 13 4. adding each received character to a variable of type string Uart_string 5. when the value of the counter exceeds the size of the variable Uart_string resetting the counter and the variable Uart_string 6. when there is something in the buffer, setting the flag Mark This is how I described it so that I don't know what's going on The code above, apart from the time from the PCF8563 being read every 0.5 seconds, does not display any data received. As for Thingspeak itself ( not to be off topic ) I want to update the data with a flag from the Timer - ie I have a board that : measures the DS18B20 measures the DHT11 measures MPL115A2 sends throughout the house via RFM12 writes to the SD card also planned to check the status of the pumps gas sensors chimney thermocouple sensor on MAX6675 chip a second master in the attic ( as the main one does not have access to all the data I am interested in)

Anonymous · Answer

Maybe you are waiting for data on another port

Either remove those " #1 " from those brackets or add in the code :

Log in, to see the code

I put these max string lengths in because ESP spits out a series of version data etc during boot up without validating them with anything. That's why I made the assumption that if the message is long I don't need it because I expect shorter ones.

Elektronik_Kraków · Answer

That worked. Thank you Only there is a non-blocking problem. The display only refreshes the time when the mark(s) are received.

Anonymous · Answer

You know, everyone has to sit down if they want to do something themselves and not monkey around

So the example works for what it proves, but another module probably needs a different treatment.

You have such a microcontroller that you can run a terminal on the other USART.
You can set yourself some diode and turn it on one by one in different routines and turn it off on their output. You'll know where it's stuck.

Maybe the module transmitted something there but didn't transmit 10 or 13 and there in the Do Loop the program is spinning waiting for characters and there are none in the buffer. You can check this and exit the loop if there are no characters in the buffer. You just have to be careful that they arrive in time

Log in, to see the code

This can be written in several ways even Loop Until Ischarwaiting() > 0 getting rid of the Buffer variable , but sometimes the data doesn't arrive that fast and will leave you looping. And by receiving one character at a time you can't clear this variable always on entry.

You have to play around - that's the coolest thing

Elektronik_Kraków · Answer

Of course you are right mate - by the way, I was well defined by my brother-in-law who I got into electronics and controllers - I think too much about how a function works, instead of thinking about how to use it well. Correct, e.g. now disconnecting the board via FT232 to the PC and changing the Code: VB.netLog in, to see the code it works OK, but how it will work with the ESP8266 or with the SIM800L is to be seen in the wash

How to Send Data from ESP8266 Using Bascom to Thingspeak Database (AT Commands)

Post #1

Post #2

Post #3

Post #4

Post #5

Post #6

Post #7

Post #8

Post #9

Post #10

Post #11

Post #12

Post #13

Post #14

Post #15

Post #16

Post #17

Post #18

Post #19

Didn't find an answer? Ask Artificial Intelligence