ThingSpeak: The uploaded file was not imported because it is missing timestamps.
2 次查看(过去 30 天)
显示 更早的评论
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 个评论
回答(1 个)
Christopher Stapels
2024-1-5
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 个评论
另请参阅
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!