Converting GPS Marks

[Aussie123]

Hi Guys
Does anyone know how to convert a list of gps marks in a text document (txt) into a xml file to use in the c-map pc planner software.

Thanks
Lance

[Owen]

The two files attached have had their extensions changed coz you can't upload text and xml files here. Or zip for that matter
Rename one to test.txt and the other to test.xml

Open the attached text file in excel.
Put all your way points in the appropriate spot.
Then get GPS Babel and import them (Garmin Tab Delimited Format)
Then Export them as something your GPS can read.
I only see one XML type - Coastal Explorer
See if you can import the attached file.

[Aussie123]

Hi Owen
Thanks for those files.
Do the marks have to be manually typed into the files as I have 2000 marks and I need to some how do them with the pc if that makes any sence

[Owen]

As long as they are formatted the same way you can cut & paste them in.

ie The must look like this

S23 41.499 E151 36.984

If you have them all in a single column you should be able to copy & paste into the appropriate column.

Naming them is your other issue, but you could just use incrementing numbers

[Aussie123]

This is how they are in the TXT file

153.17.306E 30.54.515S
153.16.871E 30.40.885S
153.17.802E 30.40.483S
153.16.775E 30.40.403S
153.17.160E 30.56.381S
153.14.078E 30.54.231S
153.12.356E 30.54.535S

[Owen]

Just search and replace the space with a comma.
Then search & replace things like "153." and replace them with "153 " note the space.
Then search and replce "E" with "" i.e nothing.
Same with "S"
Load it in excel and use =Concatenate("E", A1) as a formula to get it right.
Do the same with the S co-ords

COPY AND PASTE THE CORRECT BITS INTO NOTEPAD

then save it AND RE-NAME IT as a csv file
eg "marks.csv"

I just did it and exported to Garmin and got this.

You still need to make sure you can export out of GPS Babel into something your GPS can read, but it's do-able.

I'm assuming that the file you have came OUT of a GPS?
If so which one?
GPS Babel may read it's native format.

[Aussie123]

the original file is from a JLU 121 gps/plotter and saved as a C-Plot USR file onto disc.
I am trying to get the data into a xml or cvs file to upload into the cmap pc planner program and then I can use it in my gps once I buy a user card next week.

[Owen]

GPS Babel will read the USR file directly. Or at least shows Lowrance USR.
Then just export the csv or xml
Just double check a couple of marks to make sure it came out right.

[Aussie123]

I have tried gpsbabel and the output files dont work so I think the usr may be diff to the lowrance ones.
I attached a cmap xml file that i converted to csv to have a look at how they are set out.
Change the doc back to csv to have a proper look.
That is the layout I need to get my marks into.

[Owen]

Did you try GPS Utility as was recommended to you on a previous thread?

From their site

- import of CPLOT *.USR files (Unix format)

[thylacene]

I have tried gpsbabel and the output files dont work so I think the usr may be diff to the lowrance ones.
I attached a cmap xml file that i converted to csv to have a look at how they are set out.
Change the doc back to csv to have a proper look.
That is the layout I need to get my marks into.

Use Microsoft Excel or your choice of spreadsheet to manipulate and bulk update .csv & other text files, takes the hard work out of it.

If you care to email me the file you want to convert and the make and model of the gps you created them on I can probably do it for you.

I choose not to write an essay on how to but I do some of this stuff for a living. IT will probably be quicker to convert and take notes than try and cover off all possible options.

PM me if u would like to take up my offer

Cheers

Thy