Skip to content
  • Categories
  • Recent
  • Popular
  • Support
  • MyRoute-app
Collapse
Brand Logo

MRA Community Forum

  1. Home
  2. [Beta] The MyRoute-app
  3. [Beta] Suggestions and Discussions
  4. Import Coordinates/Excel data

Import Coordinates/Excel data

Scheduled Pinned Locked Moved [Beta] Suggestions and Discussions
17 Posts 4 Posters 137 Views 2 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • GT JWRundefined 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.MRAundefined Offline
    Hans van de Ven MR.MRAundefined Offline
    Hans van de Ven MR.MRA
    RouteXpert
    wrote on last edited by
    #2

    @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.

    Garmin Zumo XT2/XT/BMW Connected Ride Navigator/MyRouteapp (The App)
    Een dag niet gelachen is een dag niet geleefd / Een route is net zo goed als deze uitgezet is.

    GT JWRundefined 2 Replies Last reply
    1
    • Hans van de Ven MR.MRAundefined 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 JWRundefined Offline
      GT JWRundefined Offline
      GT JWR
      Valued contributor
      wrote on last edited by
      #3

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

      1 Reply Last reply
      0
      • Hans van de Ven MR.MRAundefined 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 JWRundefined Offline
        GT JWRundefined Offline
        GT JWR
        Valued contributor
        wrote on last edited by
        #4

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

        c0df7d23-a9e4-4309-bed7-7b62ebca1b7c-image.png

        b5a613e1-1132-4d5d-a154-4498f19ecbf8-image.png

        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...5ccaa81c-3e28-4485-8676-42a7d84f249b-image.png

        Hans van de Ven MR.MRAundefined 1 Reply Last reply
        0
        • GT JWRundefined GT JWR

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

          c0df7d23-a9e4-4309-bed7-7b62ebca1b7c-image.png

          b5a613e1-1132-4d5d-a154-4498f19ecbf8-image.png

          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...5ccaa81c-3e28-4485-8676-42a7d84f249b-image.png

          Hans van de Ven MR.MRAundefined Offline
          Hans van de Ven MR.MRAundefined Offline
          Hans van de Ven MR.MRA
          RouteXpert
          wrote on last edited by
          #5

          @GT-JWR
          Add the name like in the example

          Garmin Zumo XT2/XT/BMW Connected Ride Navigator/MyRouteapp (The App)
          Een dag niet gelachen is een dag niet geleefd / Een route is net zo goed als deze uitgezet is.

          GT JWRundefined 1 Reply Last reply
          0
          • Hans van de Ven MR.MRAundefined Hans van de Ven MR.MRA

            @GT-JWR
            Add the name like in the example

            GT JWRundefined Offline
            GT JWRundefined Offline
            GT JWR
            Valued contributor
            wrote on last edited by
            #6

            @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. 🤷

            RetiredWingManundefined 1 Reply Last reply
            0
            • GT JWRundefined 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. 🤷

              RetiredWingManundefined Offline
              RetiredWingManundefined Offline
              RetiredWingMan
              Valued contributor
              wrote on last edited by
              #7

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

              2010 GL1800 Goldwing using Samsung Galaxy S20 5G Android 13.

              GT JWRundefined 1 Reply Last reply
              0
              • RetiredWingManundefined RetiredWingMan

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

                GT JWRundefined Offline
                GT JWRundefined Offline
                GT JWR
                Valued contributor
                wrote on last edited by GT JWR
                #8

                @RetiredWingMan I did...see this image above. 83b2166f-5fbb-4bcc-b15c-354c4937ef18-image.png

                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?

                RetiredWingManundefined 1 Reply Last reply
                0
                • GT JWRundefined GT JWR

                  @RetiredWingMan I did...see this image above. 83b2166f-5fbb-4bcc-b15c-354c4937ef18-image.png

                  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?

                  RetiredWingManundefined Offline
                  RetiredWingManundefined Offline
                  RetiredWingMan
                  Valued contributor
                  wrote on last edited by
                  #9

                  @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.

                  2010 GL1800 Goldwing using Samsung Galaxy S20 5G Android 13.

                  1 Reply Last reply
                  0
                  • paul69undefined Offline
                    paul69undefined Offline
                    paul69
                    wrote on last edited by
                    #10

                    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.

                    Screenshot 2024-06-09 at 17.41.28.png

                    so this seems to work for me.

                    to achieve, we must first attempt ✌️
                    K1600 GTL
                    Oukitel RT3
                    iPhone 13 Pro, carpuride 702b

                    GT JWRundefined 1 Reply Last reply
                    0
                    • paul69undefined 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.

                      Screenshot 2024-06-09 at 17.41.28.png

                      so this seems to work for me.

                      GT JWRundefined Offline
                      GT JWRundefined Offline
                      GT JWR
                      Valued contributor
                      wrote on last edited by
                      #11

                      @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.

                      80c98639-48f6-4f44-9c73-8350d4800638-image.png

                      RetiredWingManundefined 1 Reply Last reply
                      0
                      • paul69undefined Offline
                        paul69undefined Offline
                        paul69
                        wrote on last edited by
                        #12

                        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.

                        to achieve, we must first attempt ✌️
                        K1600 GTL
                        Oukitel RT3
                        iPhone 13 Pro, carpuride 702b

                        1 Reply Last reply
                        1
                        • GT JWRundefined 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.

                          80c98639-48f6-4f44-9c73-8350d4800638-image.png

                          RetiredWingManundefined Offline
                          RetiredWingManundefined Offline
                          RetiredWingMan
                          Valued contributor
                          wrote on last edited by RetiredWingMan
                          #13

                          @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.

                          Screenshot_20240610-095250_Chrome.jpg

                          Screenshot_20240610-094748_Chrome.jpg

                          2010 GL1800 Goldwing using Samsung Galaxy S20 5G Android 13.

                          GT JWRundefined 1 Reply Last reply
                          0
                          • RetiredWingManundefined 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.

                            Screenshot_20240610-095250_Chrome.jpg

                            Screenshot_20240610-094748_Chrome.jpg

                            GT JWRundefined Offline
                            GT JWRundefined Offline
                            GT JWR
                            Valued contributor
                            wrote on last edited by
                            #14

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

                            Hans van de Ven MR.MRAundefined 1 Reply Last reply
                            0
                            • GT JWRundefined GT JWR

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

                              Hans van de Ven MR.MRAundefined Offline
                              Hans van de Ven MR.MRAundefined Offline
                              Hans van de Ven MR.MRA
                              RouteXpert
                              wrote on last edited by
                              #15

                              @GT-JWR

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

                              And then upload it as POi

                              Garmin Zumo XT2/XT/BMW Connected Ride Navigator/MyRouteapp (The App)
                              Een dag niet gelachen is een dag niet geleefd / Een route is net zo goed als deze uitgezet is.

                              GT JWRundefined 1 Reply Last reply
                              0
                              • Hans van de Ven MR.MRAundefined 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 JWRundefined Offline
                                GT JWRundefined Offline
                                GT JWR
                                Valued contributor
                                wrote on last edited by
                                #16

                                @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 JWRundefined 1 Reply Last reply
                                0
                                • GT JWRundefined 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 JWRundefined Offline
                                  GT JWRundefined Offline
                                  GT JWR
                                  Valued contributor
                                  wrote on last edited by
                                  #17

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

                                  1 Reply Last reply
                                  0
                                  Reply
                                  • Reply as topic
                                  Log in to reply
                                  • Oldest to Newest
                                  • Newest to Oldest
                                  • Most Votes


                                  ACTIVE USERS
                                  Hans van de Ven MR.MRAundefined
                                  Hans van de Ven MR.MRA
                                  RetiredWingManundefined
                                  RetiredWingMan
                                  GT JWRundefined
                                  GT JWR
                                  paul69undefined
                                  paul69
                                  POPULAR TOPICS
                                  • 12 Tage in den Seealpen mit MRA und es war eher NICHT gut..
                                    Bouke Entundefined
                                    Bouke Ent
                                    1
                                    28
                                    616

                                  • Ungewollte Abweichung von der Originalroute
                                    Hubert Thoringundefined
                                    Hubert Thoring
                                    0
                                    4
                                    39

                                  • Scenic routing & RouteXpert library improvements
                                    Rob Verhoeffundefined
                                    Rob Verhoeff
                                    13
                                    25
                                    2.3k

                                  • Looking for a Route from Roermond to Ijmuiden, Netherlands?
                                    steve 2kundefined
                                    steve 2k
                                    0
                                    12
                                    235

                                  • Hoe kan ik verschillende gpx bestanden samenvoegen?
                                    Hans van de Ven MR.MRAundefined
                                    Hans van de Ven MR.MRA
                                    0
                                    2
                                    35

                                  • android auto
                                    white.mouseundefined
                                    white.mouse
                                    0
                                    2
                                    52

                                  • New beta! 4.4.0 (400)
                                    CD130undefined
                                    CD130
                                    10
                                    14
                                    139

                                  • Garmin XT2 Error
                                    Guztundefined
                                    Guzt
                                    0
                                    3
                                    103
                                  MY GROUPS
                                  • Login

                                  • Login or register to search.
                                  • First post
                                    Last post
                                  0
                                  • Categories
                                  • Recent
                                  • Popular
                                  • Support
                                  • MyRoute-app