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.
created_at,field1,field2,field3,status
2022-05-23T13:28:11+10:00,15.8,16.3,16.5,Off
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.
created_at,field1,field2,field3,field4,field5,field6,field7,field8,latitude,longitude,elevation,status
1494878622,1,2,3,4,5,6,7,8,-89,155.6,22,Awake
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.
created_at,field1,field2,field3,status
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
created_at,field1,field2,field3,status
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.

Categories

Find more on ThingSpeak in Help Center and File Exchange

Products

Community Treasure Hunt

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

Start Hunting!