MATLAB Answers

csv upload fails "...contains invalid location fields"

2 views (last 30 days)
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
Jimi Rex Pacete
Jimi Rex Pacete 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 :(

Sign in to comment.

Accepted Answer

Christopher Stapels
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?
Yam Schuster
Yam Schuster on 18 Feb 2020
you are welcome ;-)) thanks in advance for your effort!!!

Sign in to comment.

More Answers (1)

Yam Schuster
Yam Schuster on 18 Feb 2020
@Christopher. my recent changes / trials:
  • filled the lat&lon fileds w/ dummy values --> still not working
  • played arround with the date Time:
  • "2019-11-07 14:32:12 UTC" ~~> "2019-11-07T14:32:12"
  • "2019-11-07 14:32:12 UTC" ~~> "2019-11-07T14:32:12+0"
  • "2019-11-07 14:32:12 UTC" ~~> "2019-11-07T14:32:12+000"
  • "2019-11-07 14:32:12 UTC" ~~> "2019-11-07T14:32:12" same result: --> still not uploading
  • ---> there must be something regarding the values itself , but where and what?
See my 3 examples from yesterday: there I figured out : if changing only one certain value, this can be the show stopper. But why? I see no rule behind it.
cheers Joachim
Yam Schuster
Yam Schuster on 20 Feb 2020
Hey Vinod & Christopher,
thanks for your support. I tested it today, everything is fine again now. the Upload works again!!! Good Job!!!

Sign in to comment.


More Answers in the  ThingSpeak Community

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!