ThingSpeak: The uploaded file was not imported because it is missing timestamps.
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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
0 Kommentare
Antworten (1)
Christopher Stapels
am 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.
0 Kommentare
Siehe auch
Kategorien
Mehr zu ThingSpeak finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!