ThingSpeak

팔로우

I have both of my account profile and channel export time zones set to "(GMT+8000)Beijing". The datetime from the exported feeds.csv looks like: '2021-09-06 11:16:28 CST' I want to import data, but MATLAB do not directly understand its datetime format. I assume "CST" to be "China Standard Time", but when I try to convert it to datetime, MATLAB throws an error: >> datetime(s,'InputFormat',"yyyy-MM-dd HH:mm:ss z","TimeZone","Asia/Shanghai","Locale","zh_CN") Error using datetime (line 651) Unable to convert '2021-09-06 11:16:28 JST' to datetime using the format 'yyyy-MM-dd HH:mm:ss z' and locale 'zh_CN'. However if I change the "Locale" to US instead: >>datetime(s,'InputFormat',"yyyy-MM-dd HH:mm:ss z","TimeZone","Asia/Shanghai","Locale","en_US") ans = datetime 07-Sep-2021 01:16:28 There is no error, but the time is wrong and is 14 hours ahead. So I guess that MATLAB sees this "CST" as "Central Standard Time". My point is: # It's pretty strange that the datetime exported by ThingSpeak could not be directly understood by MATLAB. MATLAB is supposed to work with ThingSpeak data seamlessly, but now I have to find a detour to import ThingSpeak data to MATLAB. # It seems that the datetime function needs improvement to understand this "CST" timezone, or that ThingSpeak could improve its datetime output format. Handling datetime from exported csv file Thank you for sharing. That is good feedback. We'll update the export functionality to return the timestamps as ISO8601 format so it can be read in to MATLAB easily. Thanks for the reply! Definitely looking forward to it. We made an update earlier in the week that results in the data exported from a channel to be in ISO8601 format. The exported file can easily be imported back to a ThingSpeak channel, if you need to manually clear some bad data in a channel. It is also really simple now to import the exported CSV into MATLAB using code like this: table = readtable('feeds.csv') table.created_at = datetime(table.created_at, 'InputFormat', 'yyyy-MM-dd''T''HH:mm:ssXXX', 'TimeZone','UTC') data = table2timetable(table) Thank you! Now it's easier than ever to work with the data. datetime export

How do I view the "Data Export" button in the privately shared channel in ThingSpeak? This button is available for Public Channels i.e., channels shared with "Share channel view with everyone" option. But the button is not available for privately shared channel i.e., "Share channel view only with the following users" option. How can I save the feed as a CSV for privately shared channel? kA00Z000000oTKvSAM 000092334

Hello everyone. Yesterday i started my project and now im trying to export data files (CSV) but it is empty. It cointains just the headers and last read (i think). Anyone knows what is happening? Example CSV exported created_at,entry_id,field1,field2,field3,latitude,longitude,elevation,status 2021-05-26 19:39:23 -03,1,25.00,"43.00 ",,,,, 2021-05-26 19:39:39 -03,2,24.80,40.00" Export data CSV - empty file Have you waited until the file has completed download before opening up the CSV-file? Yes, many times Maybe try a different browser to download the file? If you still see the problem, can you attach your downloaded CSV-file? I tried the download on multiple channels and I see a CSV-file with data. I've tryed with Chrome and Edge, same problem. There is attached the file downloaded. Thank you!! That file seems to have 1156 records as I see it. The data seems to be one minute apart, from 5/26 to 5/27. export csv data report

Hi, I would like to export data from my channel. My channel receives data every 15 minutes but I would like to export the data similar to what I can see when I change the chart/field's timescale to 60 minutes. Thanks! How to export a time-scaled data You can use the API to export data on a 60 minute timescale. Have a look at the query string parameters in the <https://www.mathworks.com/help/thingspeak/readdata.html read data> call, for example sum, timescale, and average. You can use json, xml, or csv data formats for the exported data. data export channel timescale

Hi, I'm trying to export my entire channel's feeds via the the Data Import/Export tab, but I get the HTTP time out error 504 after a while and the download does not start. The csv feed I want to download it's pretty big, I'm not sure if the size is related to the problem I'm having. Thank you in avdance! BR, Andreas

I'm trying to change a single value in a Thingspeak graph, but no results... First I exported the data, changes the value and uploaded the file again, but the error says 'timestamp already exists'. True ofcourse, I trying to change that specific value. It this at all possible? If so, how? Thanks