3760T gpx to csv

While it's possible to open a GPX in Excel, I have to wonder how you were able to manipulate the data in such a fashion without losing the XML-based coding within the GPX file. In updating Historic Ships of the US and Canada, I tried on multiple occasions to open the GPX file in an Office program (Word or Excel) and save it. Each time I lost the XML coding.

For my problem, the solution was to use Notepad ++ with the spellchecker add-on, which preserved everything. How did you do it in Excel?

is possible to upload the csv file so you can look at it?

It sounds like POI Loader compiled the gpx file, not the csv file.

Sure, you can open a CSV file in Excel. However, GPX and CSV are two different formats. GPX supports the icon encoding you mentioned in your geocaching file. CSV does not.

A CSV file is in a format like shown below, and the order of the information can be altered easily in Excel:

A GPX file (example below) looks a lot like a HTML webpage, and its information requires either thorough knowledge of XML coding to do the job in notepad, or a program like Extra POI Editor.

There are additional items that can be put into a GPX file, such as individual icons. The GPX example above is from my Historic Ships file. I didn't use individual icons or photographs in the entries, so the code for those items does not appear in the file.

the 3760 has strange things going on, I have a csv file with the same company as on the standard POI that Garmin supply with their maps and when I looked at under the extras for the company the phone number was included. So it has gone to another file to get the phone number and inserted with information in my csv file. But I don't know how it would have happened with this one as it hasn't happened with all the others which I have loaded. for example the file from http://www.geocaching.com which I would have thought would have been treated the same

Here is a copy of the csv file

172.4917833 -43.4537333 OX2J7CX Scouting out a Bonus (Canterbury) by rediguana, Traditional Cache(2.0/4.8/2.9)
172.3252333 -41.8015 OX1KG8C Murchison Earthquake Memorial (Nelson/Marlborough) by Kiwi_Explorer, Traditional
172.61665 -41.6878833 OX2H8WM The Ghost Train Rides Again! (Nelson/Marlborough) by Kiwi_Explorer, Traditional
173.0023833 -41.7253333 OX2J6ZZ Red Hill Savannah (Nelson/Marlborough) by beltfamily, Traditional Cache(2.0/4.0/
173.2784833 -41.4854833 OX2HHG9 Slaty Hut (Nelson/Marlborough) by beltfamily, Traditional Cache(2.0/4.5/3.0)
173.1758167 -41.3219333 OX1HNZD Busy Little Bees (Nelson/Marlborough) by Kiwi_Explorer, Traditional Cache(2.0/2.
173.2243833 -41.32405 OX19T1X Fuddley's Walkway (Nelson/Marlborough) by Fuddley, Multi-cache(1.5/1.1/2.9)
173.2402333 -41.31385 OX19D28 A Walk in the Park (Nelson/Marlborough) by Kiwi_Explorer, Traditional Cache(2.0/
173.0100667 -41.1344167 OX2NTH4 How Long is a piece of string by STRETCH0, Traditional Cache(1.5/1.5/3.0)
173.85865 -41.5121667 OX1HGTF Sierra Alpha Echo (Nelson/Marlborough) by Kiwi_Explorer, Traditional Cache(2.0/1
172.8239 -40.8520667 OX22CZ3 Labyrinth Rocks (Nelson/Marlborough) by Kiwi_Explorer, Traditional Cache(2.0/2.0
169.32305 -45.53925 OXNQMQ Apricot Valley View (Central Otago) by JAMESGREENE, Traditional Cache(2.9/2.6/3.
168.1021167 -44.8053167 OXHXGQ Marian Falls (Milford Road, Fiordland) by kiwitonita, Traditional Cache(2.2/2.2/
168.0792333 -44.8920167 OXHW72 Lake Gunn Fishermans Rest (Milford Rd, Fiordland) by kiwitonita, Traditional Cac
168.0071 -44.9997167 OXGEQ6 Deer Flat Wee Hillocks (Milford Road, Fiordland) by kiwitonita, Traditional Cach
175.6312 -40.3757667 OX11YFG Pork Chop (Manawatu) by nzcoozer, Traditional Cache(2.0/1.6/3.5)

Here is a copy of the csv file

172.4917833 -43.4537333 OX2J7CX Scouting out a Bonus (Canterbury) by rediguana, Traditional Cache(2.0/4.8/2.9)
172.3252333 -41.8015 OX1KG8C Murchison Earthquake Memorial (Nelson/Marlborough) by Kiwi_Explorer, Traditional
172.61665 -41.6878833 OX2H8WM The Ghost Train Rides Again! (Nelson/Marlborough) by Kiwi_Explorer, Traditional
173.0023833 -41.7253333 OX2J6ZZ Red Hill Savannah (Nelson/Marlborough) by beltfamily, Traditional Cache(2.0/4.0/
173.2784833 -41.4854833 OX2HHG9 Slaty Hut (Nelson/Marlborough) by beltfamily, Traditional Cache(2.0/4.5/3.0)
173.1758167 -41.3219333 OX1HNZD Busy Little Bees (Nelson/Marlborough) by Kiwi_Explorer, Traditional Cache(2.0/2.
173.2243833 -41.32405 OX19T1X Fuddley's Walkway (Nelson/Marlborough) by Fuddley, Multi-cache(1.5/1.1/2.9)
173.2402333 -41.31385 OX19D28 A Walk in the Park (Nelson/Marlborough) by Kiwi_Explorer, Traditional Cache(2.0/
173.0100667 -41.1344167 OX2NTH4 How Long is a piece of string by STRETCH0, Traditional Cache(1.5/1.5/3.0)
173.85865 -41.5121667 OX1HGTF Sierra Alpha Echo (Nelson/Marlborough) by Kiwi_Explorer, Traditional Cache(2.0/1
172.8239 -40.8520667 OX22CZ3 Labyrinth Rocks (Nelson/Marlborough) by Kiwi_Explorer, Traditional Cache(2.0/2.0
169.32305 -45.53925 OXNQMQ Apricot Valley View (Central Otago) by JAMESGREENE, Traditional Cache(2.9/2.6/3.
168.1021167 -44.8053167 OXHXGQ Marian Falls (Milford Road, Fiordland) by kiwitonita, Traditional Cache(2.2/2.2/
168.0792333 -44.8920167 OXHW72 Lake Gunn Fishermans Rest (Milford Rd, Fiordland) by kiwitonita, Traditional Cac
168.0071 -44.9997167 OXGEQ6 Deer Flat Wee Hillocks (Milford Road, Fiordland) by kiwitonita, Traditional Cach
175.6312 -40.3757667 OX11YFG Pork Chop (Manawatu) by nzcoozer, Traditional Cache(2.0/1.6/3.5)

Is there are specific reason why are you convert to CSV rather than just using the GPX file?

I think you hit upon the answer to his problem.

He, and many others out there I believe convert from GPX to CSV in the mistaken belief they will save space. POI Loader doesn't work like that, if I recall.

The gpx file wont load onto my 3760t, there seems to be some strange things going on with the down load from http://www.opencaching.com, which is supported by Garmin, or even a branch Garmin.

Two things.

Try a different browser, or upload a copy of the file so we can look at it.

Custom POI files do not interact in any way, shape or form with the built in POI files. So you need to examine your csv files again, because the information must already be in the csv.

You are right, opened it in note pad and there it was, it did not show in excel.

Ok what about the original question

We need to see the GPX file to see if it is bugged.

Ok, how do I go about uploading the files to you?

I'm thinking, they can do it so can we.

Just tell us where to get the original file. We need to know what you entered into the search field on OpenCaching in order to get the same file.

OpenCaching says it will output a GPX file, if that is the case, the GPX will load using POI Loader. There is no need to convert the file. A GPX doesn't use any more space on your unit than a CSV, the file is read by POI Loader and compiled into a GPI file which is what the unit uses. It will use a GPX directly as a route file or as a list of favorite locations depending on where it is stored in the unit. I know the 37XX series uses different locations than others, so I can't tell you where in the Nuvi to place the files.

on opengeocache I searched New Zealand and it came up with 28 caches

I have just down loaded again, now the GPX file wont open in excel, I think http://www.opencaching.com are mucking around with their files

Why in the world are you trying to open GPX files in Excel?

Why not use an application designed for GPX files?

get EPE here

http://turboccc.wikispaces.com/Extra_POI_Editor#toc5

GPX and CSV are both TEXT files. It just happens that Excel will handle a CSV file as it is often used to exchange data between database programs. Excel is a database manager designed for numeric data.

Just to add my two cents, this is was what I was asking you at the beginning of the thread, though I wasn't as direct as Motorcycle Mama in asking it.

The others have mentioned what you can use to open a GPX file, so I need not duplicate their efforts.

Lets start again, I down loaded a gpx file from http://www.opencaching.com, which opened in my mapping software OK, but using POI loader, it will not load onto my 3760T.
So I opened it in excel and converted it into a csv file, by moving the columns into the correct order for a csv file, it then loaded onto the 3760T ok.

The question is without any related bmp files I have on the screen some large icons in the shape of the geocache box. does any body know what caused the icons appear?

I have since gone back to ttp://www.opencaching.com, but they have change the format of the gpx file and I can see the difference in note pad so I am no longer able to get the same result again.

The question is why did these icon appear on the screen of the gps when I am using csv file.

I know you are going to say it can not happen but it has.

1. What do you mean by "using POI Loader, it will not load"? What exactly happens?

2. Excel is not the proper software to convert a GPX file to CSV. Use EPE.

3. The Geocache icon likely appeared if you copied the GPX file to the device directly and they loaded at Favorites instead of Custom POIs.

I tried downloading a GPX file from opencaching.com and the first barrier I ran into was a popup stating an incorrect value for bbox. The site also is a beta, so that also indicates some things may not be working correctly. A disclaimer also pops up stating the user takes all responsibility for the data, so they do not make any claims regarding the files. The statement may also mean they take no responsibility for the content of the files.

You keep saying you opened the file in Excel, unless the software is completely different on your side of the equator, Excel does not work with GPX files. This can also mean the file extension is wrong and it is actually a CSV file with a GPX extension.

The other point is you state you "opened it in your mapping software." This can be another source of problems. What mapping software are you using? Of course, the other point being if I couldn't get the file to download using FireFox 3.6.17, what are you using for a browser to download the file?

When you download the file, where are you downloading it to? If the target is the GPS, then you are placing a GPX file on the unit and those can carry symbol information.

My personal guess is the site is still undergoing development and was made available without fully tested software. That's one reason it states BETA and the fact you are seeing file formats change is another. I would just stay away from the site until the major bugs are worked out. But then, I don't cache either.

Why not just use geocaching.com? The site has been around longer, has a better reputation, has far more caches available, and is also free, etc.

http://www.geocaching.com/seek/default.aspx