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

4 vues (au cours des 30 derniers jours)
Yam Schuster
Yam Schuster le 17 Fév 2020
Commenté : Yam Schuster le 20 Fév 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 commentaires
Yam Schuster
Yam Schuster le 17 Fév 2020
@Joachim Keinert: thanks for your hint, so I´m not 'allone' ;-)
and @all: I of course checked the 'RTMF' ;-) regarding the csv files, and of course checked the coding thing regarding UTF-8 ..... ;-))
thanks in advance for showing the direction for my further investigations.
Joachim
Jj
Jj le 18 Fév 2020
I used to export the data log on to the channel then reimport. But now I can't. My issue is still unresolved :(

Connectez-vous pour commenter.

Réponse acceptée

Christopher Stapels
Christopher Stapels le 18 Fév 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 commentaires
Christopher Stapels
Christopher Stapels le 18 Fév 2020
Ill test your file and let you know when I have more information.
Yam Schuster
Yam Schuster le 18 Fév 2020
you are welcome ;-)) thanks in advance for your effort!!!

Connectez-vous pour commenter.

Plus de réponses (1)

Yam Schuster
Yam Schuster le 18 Fév 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
  4 commentaires
Vinod
Vinod le 19 Fév 2020
Thank you for reporting the issue. It has been resolved.
Yam Schuster
Yam Schuster le 20 Fév 2020
Hey Vinod & Christopher,
thanks for your support. I tested it today, everything is fine again now. the Upload works again!!! Good Job!!!
Regards
Joachim

Connectez-vous pour commenter.

Communautés

Plus de réponses dans  ThingSpeak Community

Catégories

En savoir plus sur Downloads 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!

Translated by