Data Export oddity | ThingSpeak API | 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
Data Export oddity
Avatar
SouthPark
New Member
Forum Posts: 4
sp_UserOfflineSmall Offline
1
December 18, 2017 - 3:46 am
sp_Permalink sp_Print

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!

Avatar
Hans
Natick, MA

Forum Posts: 390
sp_UserOfflineSmall Offline
2
December 18, 2017 - 4:43 am
sp_Permalink sp_Print

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. 

Avatar
SouthPark
New Member
Forum Posts: 4
sp_UserOfflineSmall Offline
3
December 18, 2017 - 7:35 am
sp_Permalink sp_Print sp_EditHistory

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:
29 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:

candacele1

WilliamBer

roxieob18

Metawatch

ozayagw

ubabeutiti

Forum Stats:

Groups: 4

Forums: 17

Topics: 1313

Posts: 4565

 

Member Stats:

Guest Posters: 1

Members: 5703

Moderators: 0

Admins: 2

Administrators: Hans, lee