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

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

Answer 1

[Christopher Stapels]

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.