Author Topic: Export POIs to edit them fully in Excel (or another tool)  (Read 213 times)

Offline argaume

  • Newbie
  • *
  • Posts: 4
    • View Profile
  • Device: Xperia XZ2
Export POIs to edit them fully in Excel (or another tool)
« on: February 06, 2019, 10:04:04 »
Hi there,

I have a bunch of POIs which are have more or less complete information in the Locus Map app, containing descriptions, url, address....

I would like to edit them all in Excel to clean them up and also to add more information as it is easier doing so in the PC.

However, when exporting under GPX format, parts of the info retrieve is readable and can be edited, but some are under HTML format... CSV is no go because there is too little information to edit.

I was interesting to edit all the field, particularly, description, phone, url, address, ....

How can you do that in Excel or/and do you have a tool where you can do that seamlessly?

Many thanks in advance
 

Offline menion

  • Administrator
  • Professor of Locus
  • *****
  • Posts: 11000
  • Thanked: 222 times
    • View Profile
    • http://www.asamm.com
  • Device: SGS7
Re: Export POIs to edit them fully in Excel (or another tool)
« Reply #1 on: February 06, 2019, 10:59:40 »
Hi, try to disable "incl. images & description" in export screen. This should work in your case.
Ideas, wishes, problems
Advanced topics, public discussion, sharing of knowledges, testing beta versions: you're here!
 
The following users thanked this post: argaume

Offline argaume

  • Newbie
  • *
  • Posts: 4
    • View Profile
  • Device: Xperia XZ2
Re: Export POIs to edit them fully in Excel (or another tool)
« Reply #2 on: February 06, 2019, 14:22:19 »
Hi Menion, yes thanks it works to a certain degree, it shows limited info like name and description and URL.

So to turn the question around, what are the field that can be imported into Locus map, and what should be the format. If there would be a concise example of such file representing all the info that can be imported that would help me then.
 

Offline argaume

  • Newbie
  • *
  • Posts: 4
    • View Profile
  • Device: Xperia XZ2
Re: Export POIs to edit them fully in Excel (or another tool)
« Reply #3 on: February 07, 2019, 09:33:58 »
adding:

- It would be great having a tool to edit the locus map formatted POIs.
 

Offline Saturo

  • Apprentice of Locus
  • **
  • Posts: 147
  • Thanked: 4 times
    • View Profile
  • Device: SG III
Re: Export POIs to edit them fully in Excel (or another tool)
« Reply #4 on: February 07, 2019, 14:14:49 »
I use qmapshack for editing and archiving of my Pois.
 

Offline argaume

  • Newbie
  • *
  • Posts: 4
    • View Profile
  • Device: Xperia XZ2
Re: Export POIs to edit them fully in Excel (or another tool)
« Reply #5 on: February 10, 2019, 13:40:00 »
Hi and thanks, I have tried now Qmapshak but when exporting to Locus Map, a bunch of HTML codes shows up so that is not optimal. Too bad there isn't a tool dedicated to Locus Map management of POIs.