Export all data to the computer | ESP8266 Wi-Fi Module | Forum

Avatar

Please consider registering
Guest

Search

— Forum Scope —






— Match —





— Forum Options —





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

Register Lost password?
sp_Feed sp_TopicIcon
Export all data to the computer
Avatar
Sommoh
New Member
Forum Posts: 2
sp_UserOfflineSmall Offline
1
July 9, 2017 - 7:53 am
sp_Permalink sp_Print

Hello everyone;

I need to export all my data to a file, but the Data Export button only exports the last 100 entries. How can I export them all?

Thanks in advanceSmile

Avatar
piajola

Gold
Forum Posts: 75
sp_UserOfflineSmall Offline
2
July 9, 2017 - 8:14 pm
sp_Permalink sp_Print

Sommoh

In my case with windows 10, having one free account in Thimgspeak channels (not the forum one) signed in and the webpage changes a little showing

CHANNEL NAME
Channel ID: 000000
Author: xxxxxxx
Access: Public (or Private)

 -------------- -------------- ------------------- ----------- --------------------------
Private View|Public View|Channel Setting|API Keys|Data Import / Export|  (5 tabs)

-----------------------   ------------------------------------
|Add Visualizations| |Data Export MATLAB Analysis| (2 buttons)
-----------------------   ------------------------------------

then press the last tab (5th) Data Import / Export NOT any button

will change to next screen, you will see 2 zones

Import

 ---------
|Upload| ( green button)
 ---------

Export

 ------------
|Download| ( green button)
 ------------

press Download green button then it will shows a dialogBox asking for place & name for the .csv file that will be in your machine

In my case:

start 18:03  --  end  18:27

31,0 MB (32.518.144 bytes)
665907 lines of csv data

created_at,                       entry_id,field1,field2,field3,field4,field5,field6,field7,field8
2016-02-03 00:19:58 UTC,1,         5,10,15,15,,,,
2016-02-03 00:20:15 UTC,2,         5,10,15,15,,,,
2016-02-03 00:20:33 UTC,3,         5,10,15,15,,,,
2016-02-03 00:20:50 UTC,4,         5,10,15,15,,,,
.
.
.
2017-07-09 23:24:36 UTC,665904,21.59,66.86,,,,,,
2017-07-09 23:25:37 UTC,665905,21.53,66.84,,,,,,
2017-07-09 23:26:38 UTC,665906,21.56,67.06,,,,,,

Hope this is some help

You are welcome in advance 🙂

Avatar
Sommoh
New Member
Forum Posts: 2
sp_UserOfflineSmall Offline
3
July 10, 2017 - 9:39 am
sp_Permalink sp_Print

piajola said
Sommoh

In my case with windows 10, having one free account in Thimgspeak channels (not the forum one) signed in and the webpage changes a little showing

CHANNEL NAME
Channel ID: 000000
Author: xxxxxxx
Access: Public (or Private)

 -------------- -------------- ------------------- ----------- --------------------------
Private View|Public View|Channel Setting|API Keys|Data Import / Export|  (5 tabs)

-----------------------   ------------------------------------
|Add Visualizations| |Data Export MATLAB Analysis| (2 buttons)
-----------------------   ------------------------------------

then press the last tab (5th) Data Import / Export NOT any button

will change to next screen, you will see 2 zones

Import

 ---------
|Upload| ( green button)
 ---------

Export

 ------------
|Download| ( green button)
 ------------

press Download green button then it will shows a dialogBox asking for place & name for the .csv file that will be in your machine

In my case:

start 18:03  --  end  18:27

31,0 MB (32.518.144 bytes)
665907 lines of csv data

created_at,                       entry_id,field1,field2,field3,field4,field5,field6,field7,field8
2016-02-03 00:19:58 UTC,1,         5,10,15,15,,,,
2016-02-03 00:20:15 UTC,2,         5,10,15,15,,,,
2016-02-03 00:20:33 UTC,3,         5,10,15,15,,,,
2016-02-03 00:20:50 UTC,4,         5,10,15,15,,,,
.
.
.
2017-07-09 23:24:36 UTC,665904,21.59,66.86,,,,,,
2017-07-09 23:25:37 UTC,665905,21.53,66.84,,,,,,
2017-07-09 23:26:38 UTC,665906,21.56,67.06,,,,,,

Hope this is some help

You are welcome in advance 🙂  


Thank you very much. The Export Data button in Private View won't do it, but this button does the trick.
Very niceSmile

Avatar
cstapels

Gold
Forum Posts: 126
sp_UserOnlineSmall Online
4
July 10, 2017 - 3:53 pm
sp_Permalink sp_Print

The export data button in Private view will export  what you see in your private view.  If you want to export more data, try changing the number of data points on your plot (using the pencil icon on top of the chart), and then the number of data points exported should change accordingly.  Or you can use the export tab as suggested above.

Forum Timezone: America/New_York

Most Users Ever Online: 114

Currently Online: cstapels
16 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

rw950431: 252

Vinod: 164

cstapels: 96

piajola: 75

vespapierre: 63

Adarsh_Murthy: 59

Newest Members:

Nsneilotof

angieus2

goldiepw11

BinanceoSt

gnarender123@gmail.com

edenderest

Forum Stats:

Groups: 4

Forums: 17

Topics: 1313

Posts: 4565

 

Member Stats:

Guest Posters: 1

Members: 5703

Moderators: 0

Admins: 2

Administrators: Hans, lee