Data Export oddity | ThingSpeak API | Forum


Please consider registering

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
Data Export oddity
No permission to create posts
December 18, 2017
3:46 am
New Member
Forum Posts: 4
Member Since:
December 18, 2017
sp_UserOfflineSmall Offline

Hi all!

I notice that the ThingSpeak menu options has the following buttons:

Private View, Public View, Channel Settings, Sharing, API Keys, Data Import / Export

The very last button "Data Import/Export" leads us to options for downloading the channel feed data in CSV format. The file downloaded from this area is noticed to contain the *full* set of recorded data values.

But, I also notice that the Private View and the Public View areas also have 'Data Export' options. Here - the CSV data file obtained from the Private View and/or Public View downloads do *not* contain the full data set. That is, the downloaded file is usually just a sub-set of the full (actual) data set.

Is it possible for ThingSpeak admins to fix this, so that all buttons for 'Data Export' will allow download of the full data set?

Thanks all!

December 18, 2017
4:43 am
Natick, MA

Forum Posts: 396
Member Since:
January 18, 2011
sp_UserOfflineSmall Offline

The Data Export button on the channel views are designed for programmatic access to your data from the API. You will notice that json, xml and CSV are supported. The default data set through the API is 1 day or up to 8000 data points without supplying more API parameters. 

December 18, 2017
7:35 am
New Member
Forum Posts: 4
Member Since:
December 18, 2017
sp_UserOfflineSmall Offline

Thanks Hans. Through the web-browser, I used the 'pencil' icon to change the default value to '8000'. But the downloaded (exported) data via Private View and Public View is still a subset of the full data set. I was only able to obtain the full data set by going the other route......which is "Data Import / Export" (followed by choosing DOWNLOAD).

I understand and know which area of ThingSpeak I need to access in order to download the full data set.

But, for the new users ----- they will likely see a 'EXPORT DATA' button in the Private View or Public View, and they will intuitively assume that is the one to use for downloading data, and then they will certainly be scratching their heads and wondering why ThingSpeak is only giving them a snap-shot (subset) of the full data set. It will certainly confuse them.

I'm thinking that the ThingSpeak admin should fix up the system, or at least put some kind of pop-up note to just let users know where to download the 'full data set', rather than make new users wonder why they just receive a small portion of the full data set.

Or at least have a sticky or notification in the Private View and Public View pages that says something like "For web-browsers, don't use this area to download data sets.......instead, use the Data Import / Export option (next to the "API Keys" button) for downloading full data set". This will prevent new users from getting confused and waste their time trying to figure what is going on.

Forum Timezone: America/New_York

Most Users Ever Online: 114

Currently Online:
14 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:

harriettlf60, ShaToow, Aleftinfenny, DiaBentee,, Pisaruk530

Administrators: Hans: 387, lee: 457