Skip to content
  • Categories
  • Recent
  • Popular
  • Support
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.
  • 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
    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
      Instructor RouteXperts
      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
        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
          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
            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
              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 ✌️

                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
                  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 ✌️

                    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
                      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
                        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
                          Instructor RouteXperts
                          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
                            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
                              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
                              RetiredWingManundefined
                              RetiredWingMan
                              Hans van de Ven MR.MRAundefined
                              Hans van de Ven MR.MRA
                              GT JWRundefined
                              GT JWR
                              paul69undefined
                              paul69
                              POPULAR TOPICS
                              • Forum update
                                Dae 0undefined
                                Dae 0
                                9
                                13
                                228

                              • Route guidance issues
                                Nick Carthewundefined
                                Nick Carthew
                                0
                                8
                                170

                              • Wegpunkte werden übersprungen welche ich noch gar nicht erreicht habe!
                                Hubert Thoringundefined
                                Hubert Thoring
                                0
                                9
                                202

                              • Seizoensafsluitingen uitschakelen tijdens navigeren
                                CD130undefined
                                CD130
                                0
                                7
                                112

                              • Sharing a Google Maps location
                                Con Hennekensundefined
                                Con Hennekens
                                0
                                3
                                73

                              • Silverfox H1
                                Corjan Meijerinkundefined
                                Corjan Meijerink
                                0
                                4
                                133

                              • Automatically skipping waypoints (shaping points) issue
                                Adrian Avramundefined
                                Adrian Avram
                                0
                                2
                                11

                              • Navigate to closest waypoint
                                Nick Carthewundefined
                                Nick Carthew
                                0
                                2
                                25
                              MY GROUPS
                              • Login

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