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

MRA Community Forum

  1. Home
  2. MyRoute-app Routeplanner
  3. [Web] Suggestions and Discussion
  4. Bulk Upload of POI's

Bulk Upload of POI's

Scheduled Pinned Locked Moved [Web] Suggestions and Discussion
25 Posts 8 Posters 2.0k Views 6 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.
  • Greenhamundefined Greenham

    Is there an easy way to bulk upload POI's? I am referring to the use of a spreadsheet/CVS that I would properly add all my desired POI's into a spreadsheet then upload them ALL?

    It would be really handy to have a formatted example of a spreadsheet/CVS with all the proper headings for easy population. They could be easily shared, added too etc.

    It has to be fairly easy as this is just one big database.

    Am I right?

    Adrian Avramundefined Offline
    Adrian Avramundefined Offline
    Adrian Avram
    wrote on last edited by
    #7

    @Greenham I have a POI file that I am constantly updating and I use this website. I upload the file, add points, then download the new updated file.
    https://www.poieditor.com/

    Best regards,
    Adrian

    Samsung S24 Ultra and iPhone 13 with Android Auto / CarPlay
    MyRoute-APP (Planner+Navigation, GOLD Lifetime)
    Honda NC750X (2021) with CHIGEE Aio-5 Play

    1 Reply Last reply
    0
    • Nomko Nomdenundefined Nomko Nomden

      Da's heel apart, die ik het in ChatGPT dan krijg ik dit te zien:

      24dfe37a-c4a1-491a-b817-8b341a2e64d4-image.png

      Geen .gpx bestand zoals bij @Dikke-Wim. Doe ik iets verkeerd?

      Dikke Wimundefined Offline
      Dikke Wimundefined Offline
      Dikke Wim
      Valued contributor
      wrote on last edited by Dikke Wim
      #8

      @Nomko-Nomden

      Ik heb ChatGPT gebruikt en daarbinnen de ChatBot "Travel Guide". Helaas kun je die maar zeer beperkt gratis gebruiken. Dus gisteravond moest ik wachten om verder te kunnen.

      Maar uiteindelijk wordt er een GPX file gegenereerd en een KML file op mijn verzoek om in Google Earth e.a. te kunnen zien.

      Zie hieronder wat ik bedoel met "Travel Guide">

      0397d99d-08be-4875-b9f2-1e811e769ae7-image.png

      BMW R1300 GS, BMW Connect Ride Next navigator; Quad Lock with Samsung Galaxy Ultra, iPad Pro (iPadOS 18.0 bèta version) MacBook Pro (MacOS Sequoia 15.2 bèta version), iMac (MacOS Monterey 12.7.6)

      Mzokkundefined 1 Reply Last reply
      0
      • Dikke Wimundefined Dikke Wim

        @Nomko-Nomden

        Ik heb ChatGPT gebruikt en daarbinnen de ChatBot "Travel Guide". Helaas kun je die maar zeer beperkt gratis gebruiken. Dus gisteravond moest ik wachten om verder te kunnen.

        Maar uiteindelijk wordt er een GPX file gegenereerd en een KML file op mijn verzoek om in Google Earth e.a. te kunnen zien.

        Zie hieronder wat ik bedoel met "Travel Guide">

        0397d99d-08be-4875-b9f2-1e811e769ae7-image.png

        Mzokkundefined Offline
        Mzokkundefined Offline
        Mzokk
        wrote on last edited by
        #9

        @Dikke-Wim you can also use Qgis to harvest POI's from OSM mapping.

        This is Castles for UK and Ireland.ksnip_20250113-163911.jpg

        You need two add ins to get the information QuickOSM
        Which gives a dialog like this.

        QuickOSM.jpg
        And POI exporter which allows export as a GPX file that MRA can read.

        POI Exporter.jpg

        Dikke Wimundefined 1 Reply Last reply
        0
        • Mzokkundefined Mzokk

          @Dikke-Wim you can also use Qgis to harvest POI's from OSM mapping.

          This is Castles for UK and Ireland.ksnip_20250113-163911.jpg

          You need two add ins to get the information QuickOSM
          Which gives a dialog like this.

          QuickOSM.jpg
          And POI exporter which allows export as a GPX file that MRA can read.

          POI Exporter.jpg

          Dikke Wimundefined Offline
          Dikke Wimundefined Offline
          Dikke Wim
          Valued contributor
          wrote on last edited by
          #10

          @Mzokk Thanks a lot. But.... is a lot of work I guess. Therefore I prefer AI who takes over the difficult stuff. I'm doing some experiments with AI. Curious how things work out.

          BMW R1300 GS, BMW Connect Ride Next navigator; Quad Lock with Samsung Galaxy Ultra, iPad Pro (iPadOS 18.0 bèta version) MacBook Pro (MacOS Sequoia 15.2 bèta version), iMac (MacOS Monterey 12.7.6)

          Martin Wilckeundefined Mzokkundefined 2 Replies Last reply
          0
          • Dikke Wimundefined Dikke Wim

            @Mzokk Thanks a lot. But.... is a lot of work I guess. Therefore I prefer AI who takes over the difficult stuff. I'm doing some experiments with AI. Curious how things work out.

            Martin Wilckeundefined Offline
            Martin Wilckeundefined Offline
            Martin Wilcke
            wrote on last edited by Martin Wilcke
            #11

            @Dikke-Wim @Mzokk

            Here's another attempt in three simple steps:

            1. Launch a query on overpass-turbo.eu

            Overpass-1.jpg

            1. export as gpx

            Overpass-2.jpg

            1. upload into MRA

            Overpass-3.jpg

            BertMundefined Dikke Wimundefined 2 Replies Last reply
            0
            • Martin Wilckeundefined Martin Wilcke

              @Dikke-Wim @Mzokk

              Here's another attempt in three simple steps:

              1. Launch a query on overpass-turbo.eu

              Overpass-1.jpg

              1. export as gpx

              Overpass-2.jpg

              1. upload into MRA

              Overpass-3.jpg

              BertMundefined Offline
              BertMundefined Offline
              BertM
              wrote on last edited by
              #12

              I do not think @Greenham want to harvest POI's but to put his own POI's into MRA in bulk.
              I use Excel to make them and then convert to GPX.
              MRA only uses the description but If I load them into my Garmin I get the other fields also. I am now busy to find out how to bulk import a GPX into my little housemade tool.

              POIEXcel.JPG

              Greenhamundefined 1 Reply Last reply
              0
              • Martin Wilckeundefined Martin Wilcke

                @Dikke-Wim @Mzokk

                Here's another attempt in three simple steps:

                1. Launch a query on overpass-turbo.eu

                Overpass-1.jpg

                1. export as gpx

                Overpass-2.jpg

                1. upload into MRA

                Overpass-3.jpg

                Dikke Wimundefined Offline
                Dikke Wimundefined Offline
                Dikke Wim
                Valued contributor
                wrote on last edited by
                #13

                @Martin-Wilcke
                Thank you very much! It seems to work great....
                However, not all dots of castles of South UH that are shown on the map are found in MRA when imported.

                Do you have any idea how to fix this? See screendumps below.

                See e.g. Cornwall with many castles
                e39f2ddb-5d1a-447d-9a07-6b545ca257d5-image.png

                Cornwall without any castles
                9d561261-31ca-4173-94b3-d2512543137b-image.png

                BMW R1300 GS, BMW Connect Ride Next navigator; Quad Lock with Samsung Galaxy Ultra, iPad Pro (iPadOS 18.0 bèta version) MacBook Pro (MacOS Sequoia 15.2 bèta version), iMac (MacOS Monterey 12.7.6)

                Martin Wilckeundefined 1 Reply Last reply
                0
                • Dikke Wimundefined Dikke Wim

                  @Martin-Wilcke
                  Thank you very much! It seems to work great....
                  However, not all dots of castles of South UH that are shown on the map are found in MRA when imported.

                  Do you have any idea how to fix this? See screendumps below.

                  See e.g. Cornwall with many castles
                  e39f2ddb-5d1a-447d-9a07-6b545ca257d5-image.png

                  Cornwall without any castles
                  9d561261-31ca-4173-94b3-d2512543137b-image.png

                  Martin Wilckeundefined Offline
                  Martin Wilckeundefined Offline
                  Martin Wilcke
                  wrote on last edited by
                  #14

                  @Dikke-Wim said in Bulk Upload of POI's:

                  However, not all dots of castles of South UH that are shown on the map are found in MRA when imported.

                  Hmmm... Maybe you need to zoom in?

                  Overpass:
                  UK Castles 1.jpg

                  Imported:
                  UK Castles 2.jpg

                  Dikke Wimundefined 1 Reply Last reply
                  0
                  • Martin Wilckeundefined Martin Wilcke

                    @Dikke-Wim said in Bulk Upload of POI's:

                    However, not all dots of castles of South UH that are shown on the map are found in MRA when imported.

                    Hmmm... Maybe you need to zoom in?

                    Overpass:
                    UK Castles 1.jpg

                    Imported:
                    UK Castles 2.jpg

                    Dikke Wimundefined Offline
                    Dikke Wimundefined Offline
                    Dikke Wim
                    Valued contributor
                    wrote on last edited by Dikke Wim
                    #15

                    @Martin-Wilcke

                    Unfortunately even when I zoom in more than in the example above, no additional castles appear. Only "few" of the cirkels with castles in the overpass.eu website, are visible.

                    Any suggestions what I do wrong?

                    Example of the map with castles in Cornwall
                    1b0ccb6d-7087-4a15-b18e-b45c0c2d965e-image.png

                    No castles in Cornwall after importing the GPX file
                    e6571a01-0273-4e94-9854-ccb350ee1905-image.png

                    the KML file shows more castles in Google Earth than the GPX file in MRA

                    8de64d6b-ea55-4f0d-8789-1b8ac9469b67-image.png

                    BMW R1300 GS, BMW Connect Ride Next navigator; Quad Lock with Samsung Galaxy Ultra, iPad Pro (iPadOS 18.0 bèta version) MacBook Pro (MacOS Sequoia 15.2 bèta version), iMac (MacOS Monterey 12.7.6)

                    Martin Wilckeundefined 3 Replies Last reply
                    0
                    • Dikke Wimundefined Dikke Wim

                      @Martin-Wilcke

                      Unfortunately even when I zoom in more than in the example above, no additional castles appear. Only "few" of the cirkels with castles in the overpass.eu website, are visible.

                      Any suggestions what I do wrong?

                      Example of the map with castles in Cornwall
                      1b0ccb6d-7087-4a15-b18e-b45c0c2d965e-image.png

                      No castles in Cornwall after importing the GPX file
                      e6571a01-0273-4e94-9854-ccb350ee1905-image.png

                      the KML file shows more castles in Google Earth than the GPX file in MRA

                      8de64d6b-ea55-4f0d-8789-1b8ac9469b67-image.png

                      Martin Wilckeundefined Offline
                      Martin Wilckeundefined Offline
                      Martin Wilcke
                      wrote on last edited by
                      #16

                      @Dikke-Wim

                      OK - let's focus on "Crane Castle" as an example; it's this one:

                      crane 1.jpg

                      Please have a look at the GPX you've uploaded with an editor and search for "Crane", there should be a match like this:

                      crane 2.jpg

                      In MRA, search for "Portreath" and zoom in to a scale of 1 km / 1 mile or less:

                      crane 3.jpg

                      Does it show up?

                      1 Reply Last reply
                      0
                      • Dikke Wimundefined Dikke Wim

                        @Martin-Wilcke

                        Unfortunately even when I zoom in more than in the example above, no additional castles appear. Only "few" of the cirkels with castles in the overpass.eu website, are visible.

                        Any suggestions what I do wrong?

                        Example of the map with castles in Cornwall
                        1b0ccb6d-7087-4a15-b18e-b45c0c2d965e-image.png

                        No castles in Cornwall after importing the GPX file
                        e6571a01-0273-4e94-9854-ccb350ee1905-image.png

                        the KML file shows more castles in Google Earth than the GPX file in MRA

                        8de64d6b-ea55-4f0d-8789-1b8ac9469b67-image.png

                        Martin Wilckeundefined Offline
                        Martin Wilckeundefined Offline
                        Martin Wilcke
                        wrote on last edited by
                        #17

                        @Dikke-Wim

                        And one more note:

                        I have just noticed that "historic=castle" can be modelled both as a ‘node’ (point) and as a ‘way’ (path, here in the sense of area). They appear as yellow dots for nodes and red dots for ways/areas.

                        That's why my example query node ["historic"="castle"]; is not ideal, because it only finds castles that are modelled as a point.

                        Better, as in your example, is nwr ["historic"="castle"]; as it includes nodes, ways and relations.

                        1 Reply Last reply
                        0
                        • Dikke Wimundefined Dikke Wim

                          @Martin-Wilcke

                          Unfortunately even when I zoom in more than in the example above, no additional castles appear. Only "few" of the cirkels with castles in the overpass.eu website, are visible.

                          Any suggestions what I do wrong?

                          Example of the map with castles in Cornwall
                          1b0ccb6d-7087-4a15-b18e-b45c0c2d965e-image.png

                          No castles in Cornwall after importing the GPX file
                          e6571a01-0273-4e94-9854-ccb350ee1905-image.png

                          the KML file shows more castles in Google Earth than the GPX file in MRA

                          8de64d6b-ea55-4f0d-8789-1b8ac9469b67-image.png

                          Martin Wilckeundefined Offline
                          Martin Wilckeundefined Offline
                          Martin Wilcke
                          wrote on last edited by
                          #18

                          @Dikke-Wim

                          OK - I got it.

                          You need an out centre (instead of an out geom) to create a single node for ways/areas. This will generate waypoints for both types (nodes and ways) when exporting as GPX.

                          Here's the result

                          https://hidrive.ionos.com/lnk/LhseBgcKc

                          for the query:

                          UK Castles 3.jpg

                          Sorry for the confusion!

                          Dikke Wimundefined JP dundefined 2 Replies Last reply
                          0
                          • Dikke Wimundefined Dikke Wim

                            @Mzokk Thanks a lot. But.... is a lot of work I guess. Therefore I prefer AI who takes over the difficult stuff. I'm doing some experiments with AI. Curious how things work out.

                            Mzokkundefined Offline
                            Mzokkundefined Offline
                            Mzokk
                            wrote on last edited by
                            #19

                            @Dikke-Wim Somewhat less work than the method you describe👍

                            Dikke Wimundefined 1 Reply Last reply
                            0
                            • Martin Wilckeundefined Martin Wilcke

                              @Dikke-Wim

                              OK - I got it.

                              You need an out centre (instead of an out geom) to create a single node for ways/areas. This will generate waypoints for both types (nodes and ways) when exporting as GPX.

                              Here's the result

                              https://hidrive.ionos.com/lnk/LhseBgcKc

                              for the query:

                              UK Castles 3.jpg

                              Sorry for the confusion!

                              Dikke Wimundefined Offline
                              Dikke Wimundefined Offline
                              Dikke Wim
                              Valued contributor
                              wrote on last edited by
                              #20

                              @Martin-Wilcke

                              Thanks Martin. It works now much better (see below).
                              f45a36c1-6b9e-41bd-ba3c-03809ef23506-image.png

                              BMW R1300 GS, BMW Connect Ride Next navigator; Quad Lock with Samsung Galaxy Ultra, iPad Pro (iPadOS 18.0 bèta version) MacBook Pro (MacOS Sequoia 15.2 bèta version), iMac (MacOS Monterey 12.7.6)

                              Martin Wilckeundefined 1 Reply Last reply
                              0
                              • Mzokkundefined Mzokk

                                @Dikke-Wim Somewhat less work than the method you describe👍

                                Dikke Wimundefined Offline
                                Dikke Wimundefined Offline
                                Dikke Wim
                                Valued contributor
                                wrote on last edited by
                                #21

                                @Mzokk

                                What method do you mean? I don't get it.
                                For me: the easier the better!

                                BMW R1300 GS, BMW Connect Ride Next navigator; Quad Lock with Samsung Galaxy Ultra, iPad Pro (iPadOS 18.0 bèta version) MacBook Pro (MacOS Sequoia 15.2 bèta version), iMac (MacOS Monterey 12.7.6)

                                1 Reply Last reply
                                0
                                • Dikke Wimundefined Dikke Wim

                                  @Martin-Wilcke

                                  Thanks Martin. It works now much better (see below).
                                  f45a36c1-6b9e-41bd-ba3c-03809ef23506-image.png

                                  Martin Wilckeundefined Offline
                                  Martin Wilckeundefined Offline
                                  Martin Wilcke
                                  wrote on last edited by
                                  #22

                                  @Dikke-Wim
                                  👍

                                  1 Reply Last reply
                                  0
                                  • Martin Wilckeundefined Martin Wilcke

                                    @Dikke-Wim

                                    OK - I got it.

                                    You need an out centre (instead of an out geom) to create a single node for ways/areas. This will generate waypoints for both types (nodes and ways) when exporting as GPX.

                                    Here's the result

                                    https://hidrive.ionos.com/lnk/LhseBgcKc

                                    for the query:

                                    UK Castles 3.jpg

                                    Sorry for the confusion!

                                    JP dundefined Offline
                                    JP dundefined Offline
                                    JP d
                                    wrote on last edited by
                                    #23

                                    @Martin-Wilcke this is amazing never knew how to use this feature! It would be of great help if the MRA team @Corjan-Meijerink could make a YouTube tutorial on this. 🙏

                                    1 Reply Last reply
                                    0
                                    • BertMundefined BertM

                                      I do not think @Greenham want to harvest POI's but to put his own POI's into MRA in bulk.
                                      I use Excel to make them and then convert to GPX.
                                      MRA only uses the description but If I load them into my Garmin I get the other fields also. I am now busy to find out how to bulk import a GPX into my little housemade tool.

                                      POIEXcel.JPG

                                      Greenhamundefined Offline
                                      Greenhamundefined Offline
                                      Greenham
                                      wrote on last edited by
                                      #24

                                      @BertM

                                      Yes this is what I am trying to do. Add my own POI's

                                      BertMundefined 1 Reply Last reply
                                      0
                                      • Greenhamundefined Greenham

                                        @BertM

                                        Yes this is what I am trying to do. Add my own POI's

                                        BertMundefined Offline
                                        BertMundefined Offline
                                        BertM
                                        wrote on last edited by
                                        #25

                                        @Greenham said in Bulk Upload of POI's:

                                        @BertM

                                        Yes this is what I am trying to do. Add my own POI's

                                        As another member of this forum asked me the same because I replied here, I have been dusting off my 20 year old programming skills in Excel VBA 🙂

                                        the today status of the tools is the following

                                        • Import simple POI GPX files into Excel

                                        • Edit the imported file and add Symbol, Description, Street, Phone etc for import into Garmin devices

                                        • Export the POI file to GPX format

                                        • Double Click on the filled in row and the POI wil open in Google maps.

                                        Excel file with Ribbon (KML does not work yet)
                                        MOHO hotels GPX imported into Excel
                                        *

                                        55fe76c9-4529-4956-aa88-187b6e52461c-image.png

                                        3rd Item in the list selected and button "Show in Google Maps" selected

                                        e23dc9f7-65d3-43b3-9234-a73992e056d5-image.png

                                        Import in MRA from GPX file
                                        108d4b72-58e8-4f93-996c-5a584a2aa1d3-image.png

                                        Import in Basecamp with selected symbol
                                        c26cd62c-f8ee-4dff-9e24-924ad4cc7c21-image.png

                                        Data added in Excel and transferred to Garmin GPX, see also the different symbols in the same GPX

                                        c3212141-58ca-4b2b-b383-37443fec46e0-image.png

                                        Send me your email in a PB and I send you the current file with the following status:

                                        • Made and only tested in Excel/Windows10

                                        • Error handeling is still poor in the progarmming

                                        • Program as is, it works on my system, not tested on other equipment.

                                        • Program is made in MS VBA and not tested in other programs.

                                        regards,
                                        Bert

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


                                        • 1
                                        • 2
                                        ACTIVE USERS
                                        Mzokkundefined
                                        Mzokk
                                        BertMundefined
                                        BertM
                                        Adrian Avramundefined
                                        Adrian Avram
                                        Dikke Wimundefined
                                        Dikke Wim
                                        Nomko Nomdenundefined
                                        Nomko Nomden
                                        JP dundefined
                                        JP d
                                        Martin Wilckeundefined
                                        Martin Wilcke
                                        Greenhamundefined
                                        Greenham
                                        POPULAR TOPICS
                                        • Route recalculation
                                          M. Schrijverundefined
                                          M. Schrijver
                                          -1
                                          6
                                          159

                                        • Tracklog anders bij gebruik als laag bij maken route
                                          Marinus van Deudekomundefined
                                          Marinus van Deudekom
                                          0
                                          3
                                          54

                                        • Reverse your route?
                                          Matthew Perkins 0undefined
                                          Matthew Perkins 0
                                          0
                                          3
                                          77

                                        • Another fuel station question...
                                          Marinus van Deudekomundefined
                                          Marinus van Deudekom
                                          0
                                          2
                                          28

                                        • Waypoint names.
                                          Mzokkundefined
                                          Mzokk
                                          0
                                          4
                                          152

                                        • App wil vormingspunt niet verbergen
                                          Nick Carthewundefined
                                          Nick Carthew
                                          0
                                          2
                                          40

                                        • Kompass Nord Ausrichten fix
                                          Hubert Thoringundefined
                                          Hubert Thoring
                                          0
                                          3
                                          32

                                        • Herberekenen route
                                          Con Hennekensundefined
                                          Con Hennekens
                                          0
                                          17
                                          349
                                        MY GROUPS
                                        • Login

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