csv upload fails "...contains invalid location fields"
4 views (last 30 days)
Show older comments
Yam Schuster
on 17 Feb 2020
Commented: Yam Schuster
on 20 Feb 2020
Hey, (sorry about my english)
since yesterday I got , during CSV Upload, the Error message : "The file was not uploaded because it contains invalid location fields"
My investigation, what is wrong with the csv-file, was not helpfull, I found nothing (for me) obvious wrong. The upload procedure I have done a lot of times in the past, w/o any issue!!! but now ?????
(I double checked the file with Excel, notepad++, textpad... deleted rows in the file, added manualy some field values in an row,.... reduced a dummy file to only 10 rows....
==> some times it worked, sometimes not.)
What is the KEY Reason for this error massage? a certain coding? after checking since hours, trying different minor/major changes, I have no glue what is wrong.
I need a simple hint in what direction or on what "Point (?)" I have to check?!?!
....
The File I wants to upload is from TS downloaded -> deleted some (faulty) rows -> upload again.
The Upload procedure I make 1000 of times in the past.... but since yesterday, I was not lucky. :-(((
cheers & thanks in advance
Joachim
5 Comments
Jj
on 18 Feb 2020
I used to export the data log on to the channel then reimport. But now I can't. My issue is still unresolved :(
Accepted Answer
Christopher Stapels
on 18 Feb 2020
There were two recent changes to csv upload.
Position validation: the Latitude must be from -90 to +90, and Longitude from -180 to 180. Also, the time format should be ISO 8601, like this example: 2020-05-15T20:03:48-05:00
If your file continues to fail, can you share a few rows of the file that are failing?
4 Comments
Christopher Stapels
on 18 Feb 2020
Ill test your file and let you know when I have more information.
More Answers (1)
Communities
More Answers in the ThingSpeak Community
See Also
Categories
Find more on Downloads 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!