Import csv file to thingspeak with automatically | ThingSpeak API | 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
Import csv file to thingspeak with automatically
No permission to create posts
September 10, 2018
12:16 pm
Avatar
rizafajar
New Member
Members
Forum Posts: 2
Member Since:
July 27, 2018
sp_UserOfflineSmall Offline

I am a new user of ThingsPeak and a new user from Arduino Uno.
at the moment I am still confused with my school assignments. I have a plan:

1. Results from the temperature sensor, humidity will be stored in the sdcard module (csv file).
2. Then the CSV files stored in the sdcard module will be imported to ThingsPeak automatically with the time specified. I'm using ESP8266.
.
is this possible?
How i can do it?
I am still confused.

Please help me
Thank you 🙂

September 12, 2018
8:08 am
Avatar
cstapels
Moderator
Members


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

I would recommend starting with the examples at https://www.mathworks.com/help/thingspeak/examples.html.
There are some specific to the ESP8266, but the Arduino examples are very similar and possibly portable to ESP.

What advantage will you get from the SD card? Your ESP should be able to connect to ThingSpeak whenever there is a network.

September 12, 2018
12:22 pm
Avatar
rizafajar
New Member
Members
Forum Posts: 2
Member Since:
July 27, 2018
sp_UserOfflineSmall Offline

cstapels said

I would recommend starting with the examples at https://www.mathworks.com/help/thingspeak/examples.html.
There are some specific to the ESP8266, but the Arduino examples are very similar and possibly portable to ESP.

What advantage will you get from the SD card? Your ESP should be able to connect to ThingSpeak whenever there is a network.  

The advantage is that it can save battery power. The plan is I will send CSV files once a week. Is that possible? What is your opinion?

because if every second sends data to ThingsPeak, the battery will run out quickly.

September 12, 2018
2:45 pm
Avatar
cstapels
Moderator
Members


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

Saving power is definitely a good reason to limit your posts. Here is an ESP8266 example using deep sleep:
https://www.mathworks.com/help/thingspeak/MoistureMonitor.html

When you wake the device, you will want to use the bulk update to write multiple points in one entry. See
https://www.mathworks.com/help/thingspeak/bulkwritejsondata.html
and
https://www.mathworks.com/help/thingspeak/continuously-collect-data-and-bulk-update-a-thingspeak-channel-using-an-arduino-mkr1000-board-or-an-esp8266-board.html

If you have very many points, the buffer may get filled before you are able to print all the points.
If you are using the the last example I linked above-and the buffer overflows, you can resize the data array and then print to the wifi client one character at a time
instead of client.println(data);
use something like
loop i:{client.println(data[i]);}
I have heard that the memory for SD card management is large. Can you let us know if you get it working?

Forum Timezone: America/New_York

Most Users Ever Online: 114

Currently Online: ziplock9000
28 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

rw950431: 261

Vinod: 196

piajola: 85

turgo: 70

vespapierre: 63

Adarsh_Murthy: 62

Member Stats:

Guest Posters: 1

Members: 5703

Moderators: 0

Admins: 2

Forum Stats:

Groups: 4

Forums: 17

Topics: 1313

Posts: 4565

Newest Members:

EnigmBioge, debbiepe18, MatthewmUb, cathrynww1, Slark, inads11

Administrators: Hans: 387, lee: 457