×

Notice

The forum is in read only mode.
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Extracting gps coordinates from database to excel?

Extracting gps coordinates from database to excel? 11 years 11 months ago #16202

  • CJ Disabled 4
  • CJ Disabled 4's Avatar Topic Author
  • Offline
  • User is blocked
  • User is blocked
  • Posts: 50
  • Thank you received: 0
Is there any tools so i can extract the data i have put in hotspots to an excel file, i want to be able to create a tom tom/garmin file to install it on my sat nav?

Maybe this would be a great addition to hotspots if something was developed for this purpose alone

Thanks in advance

Keith

Re: Extracting gps coordinates from database to excel? 11 years 11 months ago #16203

  • Eliecer Marchante
  • Eliecer Marchante's Avatar
  • Offline
  • Platinum Boarder
  • Platinum Boarder
  • Posts: 493
  • Karma: 11
  • Thank you received: 13
You can do that directly from the server. There are plenty of options to export the information from the database.

-CodeGen
-CSV
-CSV for MS Excel
-Microsoft Word 2000
-LaTeX
-MediaWiki Table
-Open Document Spreadsheet
-Open Document Text
-PDF
-PHP array
-SQL
-Texy! text
-Excel 97-2003 XLS Workbook
-Excel 2007 XLSX Workbook
-XML
-YAML

My server use phpMyAdmin, and all I have to do is select the database, hit Export and select one of the options mentioned above.
The following user(s) said Thank You: CJ Disabled 4

Re: Extracting gps coordinates from database to excel? 11 years 11 months ago #16204

  • CJ Disabled 4
  • CJ Disabled 4's Avatar Topic Author
  • Offline
  • User is blocked
  • User is blocked
  • Posts: 50
  • Thank you received: 0
Thank you Eliecer,

I have done this now i just have to find were the "save to file" went to on the server!

Keith

Re: Extracting gps coordinates from database to excel? 11 years 11 months ago #16213

  • Eliecer Marchante
  • Eliecer Marchante's Avatar
  • Offline
  • Platinum Boarder
  • Platinum Boarder
  • Posts: 493
  • Karma: 11
  • Thank you received: 13
It won't be saved on the server. Usually, it's saved in your computer, somewhere inside the download folder.
  • Page:
  • 1
Time to create page: 0.103 seconds