ThingSpeak: The uploaded file was not imported because it is missing timestamps.
4 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponses (1)
Christopher Stapels
le 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 commentaires
Voir également
Catégories
En savoir plus sur ThingSpeak dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!