Import User Waypoints

[gdawg]

Hi Tim,
I've created a list of about 740 user waypoints in .csv format that I wanted to import into Plan-G (2.0.5.493) but the lat/long fields are in the form of degrees/minutes/seconds and I believe Plan-G requires them to be in the form of degrees/decimal? At least, when I try to import them I get an invalid latitude on line 1. Is there any way I can work around this or is it a question of "Abandon all hope ye....."?
Gary

[tim arnot]

You need to convert them somehow. Excel?

[gdawg]

LOL! I looked online and found several "converters" but none that will batch convert when the "N" or "W" is present in the coordinates. A shame really, I wanted to upload a list in the forum of locations populated by various sceneries for FSX some payware and some freeware. It's always nice to deviate from your route to see something along the way.
Gary

[tim arnot]

Where has the data come from? Is it a decompiled bgl?

[gdawg]

Wish I knew how to decompile a .bgl but no, this is just a plain text file I snagged off the net and worked into the (almost) correct format  using regex.

Gary

[tim arnot]

Ok, could you post a sample?

[gdawg]

You mean of where I stand with it right now?


N54 21.21   W130 28.26
N54 25.81   W130 46.65
N53 48.38   W131 51.86
N56 2.28          W131 27.54
N53 41.93   W129 42.82
N56 24.94   W132 12.99
N55 56.39   W132 04.07
N54 9.65           W129 57.32
N54 09.21   W129 56.58
N53 59.82   W128 47.20
N53 44.72   W129 24.79
N52 26.30   W127 16.49
N55 59.35   W132 18.51
N52 22.81   W127 29.57
N54 8.71      W130 8.04

these are two fields strips out of an open offic org calc spread sheet there are actually about 700 + lines like this
Let me know if I misread your question.
Gary

[tim arnot]

Ok, that's degrees-decimal minutes, not degrees-minutes-seconds, so it should be slightly easier to process. You need to do three things:

1. Strip off the NSEW. Replace the S and W with - signs, so that those numbers are negative.

2. Reimport the data into a spreadsheet, using space as a separator, so that degrees and decimal minutes are in different columns

3. Create a calculation that divides the decimal minutes by 60, and adds it to the degrees. That is your result.

[gdawg]

Ahhh! Thank you Tim,
I guess I was really out to lunch on that one Another quick question for the first field, Category I think is there a list of the different values it can hold?

Gary

[tim arnot]

Go into the Manage User Waypoints dialog and click in one of the category cells. You'll get a drop down with all the possible values.