Import Coordinates/Excel data

[GT JWR]

Have searched and couldn't find previous history - is it possible to import coordinate data sets, from an excel spreadsheet, for example, into the planner?

[Hans van de Ven MR.MRA]

@GT-JWR
Yes you can. create a csv file with the data like this
-4.4740426540375,57.522252802735,"The Singleton of Glen Ord Distillery, Visitor Centre & Whisky Shop",""
Import the file as a POI file.

[GT JWR]

@Hans-van-de-Ven-MR-MRA thanks.

[GT JWR]

@Hans-van-de-Ven-MR-MRA I have successfully created and imported a *.csv file into POI.

However, I am not having any success with the coordinates showing up in/along the planned route - what am I missing?

For example, the 4th set of coordinates should show up where the yellow highlighted circle is...

[Hans van de Ven MR.MRA]

@GT-JWR
Add the name like in the example

[GT JWR]

@Hans-van-de-Ven-MR-MRA when I click on 'Add', it simply wants me to re-import the file - it does not add it to the route map.

[RetiredWingMan]

@GT-JWR use the 3 bar menu (top left side) to display points of interest.

[GT JWR]

@RetiredWingMan I did...see this image above.

Clicking on 'Add' does nothing except wanting to re-import the file - absolutely no coordinates from that file get added to the map I am wanting to add them to. Something's missing?

[RetiredWingMan]

@GT-JWR when you go back to the map your POIs should appear. You may have to zoom in a bit for them to appear.

[paul69]

hi @GT-JWR

i have just used the top co-ordinate that you put in the screen shot
29.812298226572583, -95.7728516190678

and this was the rsult when i added it as a POI, obviously the blue square, i just named it test for a sample.

so this seems to work for me.

[GT JWR]

@paul69 @RetiredWingMan - appreciate the advice.

Perhaps I need to clarify, to make sure I understand what takes place vs what is supposed to take place.

If I have a *.csv file, that has 20 coordinates it it, for example, what are the steps? My understanding of what should happen:

• click on POI, which opens 3 options.... Search, Manage & Library.
• go to Library, click on Add...select the *.csv file, and it imports
• place a check in the box, and ALL coordinates in that file should now show on the map.

Is this correct?

None of the coordinates show up, even when zoomed in.

According to the Manual in loading POI's, it should work.

[paul69]

hi @GT-JWR

apologies but I am unable to help any further, I do not normally use this function, I only tried it to see if it worked for me.

somebody with a lot more experience than I will be along to help you, of that, I am sure.

[RetiredWingMan]

@GT-JWR as you can see in the screen shot below, I added a POI list of distilleries in Scotland. When I zoom in sufficiently, they appear on the planning map. The only thing I can think of is that your file of POIs does not include all of the data required to properly create the POIs. You did not replicate the example in June of the first responses. Your missing a name for the POI as well as a trailing text field.

[GT JWR]

@RetiredWingMan I will input names and see if that brings me success! Thanks.

[Hans van de Ven MR.MRA]

@GT-JWR

Download this file as: POI.csv
https://www.facebook.com/share/p/BPkBZXz1GWxdUjU1/

And then upload it as POi

[GT JWR]

@Hans-van-de-Ven-MR-MRA I did that - the link opens MRA directly, and all POI's are there.

So then out of curiousity, I went to the 'Files' on that FB page, found this file, Afsluitingen_NLD_20220118.csv, and when saving to my PC, noticed it was a 'CSV UTF-8' file. Thinking this might have something to do with the issue I'm having, I also saved it as a simple '*,CSV' file.

Then added both to my POI list, both opened up and showed as expected.

Perhaps I have something wrong with the file I am trying to load?

...tried to copy file here, saying I don't have enough privelages...will try to copy in a 2nd reply.

[GT JWR]

@Hans-van-de-Ven-MR-MRA ...well, appears I cannot attach the file...