News:

Thou shalt confirm thine airspeed on final, lest the earth rise up and smite thee. (pre-landing checklist, v1)

Main Menu

Import User Waypoints

Started by gdawg, July 24, 2011, 01:35:49 AM

Previous topic - Next topic

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?

Tim. @TimArnot

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?

Tim. @TimArnot

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?

Tim. @TimArnot

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.

Tim. @TimArnot

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.

Tim. @TimArnot