Convert xlsx Export file in a GPX

Ebike Oscar4 years ago

Hello Guys

I love relive videos and I´m traying to convert the xlsx file traccar manager gave me into a file usefull by Relive app ( .fit, .gpx o .tcx ).
I got to donwload direcctly a gpx file through the API but conversor or the app still saying is wrong file.

Any expert can help please!!

Anton Tananaev4 years ago

Have you checked the file? Check it against the standard and see if there's anything wrong with it.

Ebike Oscar4 years ago

I check as I know but I don´t know if is wrong, There is a link if you wanna try:

https://drive.google.com/file/d/13DXQxZmVFvgc7K7wDMm_YyZCBqXRtaCH/view?usp=sharing

Thanks Anton

Anton Tananaev4 years ago

I was talking about GPX file.

Ebike Oscar4 years ago

The Gpx file I get is this:

https://drive.google.com/file/d/1B9zVFExlPqGvr_MzKbVqQu95qE1WjWjG/view?usp=sharing

And I get it with this command:

curl "http://demo3.traccar.org/api/positions/" "deviceid: 9171008237" "from: 2020-08-16T08:00:00Z" -H "to: 2020-08-18T13:00:00Z" -H "authorization: Basic myAuth" "accept: application/gpx+xml" > export.gpx

Can you try to download and see whats wrong please?

Anton Tananaev4 years ago

You should probably check the response yourself. Your API request is simply incorrect.

Ebike Oscar4 years ago

I really thanks your answers but is first time for me requesting API, I read all documentation I found in traccar.org and expend more than 5 hours with this.
Could you please refer to me any way to get it??

Now I tried :

C:\Users\elect>curl "https://demo3.traccar.org/api/positions" "deviceid=9171008237&from=2019-03-21T08:00:00Z" "to=2019-03-21T13:00:00Z" -H "authorization: Basic myAuth" -H "accept: application/gpx+xml"
curl: (7) Failed to connect to demo3.traccar.org port 443: Connection refused
curl: (3) Port number ended with ':'
curl: (3) Port number ended with ':'

And I don´t know what to do more :(

Anton Tananaev4 years ago

Have you read curl documentation? Your request makes zero sense to me. There are so many issues that I don't even know where to start listing them.

  • Demo server doesn't provide https access. Why are you using it?
  • Why are you splitting URL into 3 separate parts?

It feels like you are just randomly trying something without putting any thought into it at all. Read Traccar API documentation. Read curl documentation. Understand what each parameter means and how to form a correct request.

Ebike Oscar4 years ago

Thanks Anton but I give up your way, I just hope someone else share his wisdom with me instead of try to learn how to program :)

Arvind3 years ago

Hi, i have created gpx export through api with my custom UI based on traccar API