ThingSpeak: The uploaded file was not imported because it is missing timestamps.

7 views (last 30 days)
Hi, I have looked through the information online and I cannot see an answer that works. I have a file which is using ISO8601 timestamps and I am getting the missing timestamp error when loading this into ThingSpeak. This is the first row of my data with headers. I even just tried to load this one record and it still failed.
This is a correct timestamp format according to ISO8601, however it does not load. The examples that you get when downloading the Import_Template_File.csv are not valid timestamps except for the last one, however my data is not in UTC.
2019-12-02 11:23:56+300,1.1,2.2,3.3,4.4,5.5,6.6,7.7,8.8,0.5,-170,23,Snoozing
2020-05-15 20:03:48 UTC,1.11,2.22,3.33,4.44,5.55,6.66,7.77,8.88,90,0,24,Asleep
as the second data line only has 3 digits in the offset.
I even changed my one line of data to be UTC according to the last example and it still failed to load.
2022-05-23 03:28:11 UTC,15.8,16.3,16.5,Off

Answers (1)

Christopher Stapels
Christopher Stapels on 5 Jan 2024
I used the data you provided and was able to upload it sucessfully to one of my channels
2022-05-23 03:28:11 UTC,15.8,16.3,16.5,Off
It is possible you are not formatting your csv file as expected by the server. I generally use excel.
The template data also works for me when I upload it to a channel.


Find more on ThingSpeak in Help Center and File Exchange


Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!