Home PageFacebookRSS News Feed
PocketGPS
Web
SatNav,GPS,Navigation
Pocket GPS World - SatNavs | GPS | Speed Cameras: Forums

Pocket GPS World :: View topic - Can anyone tell me to convert...
 Forum FAQForum FAQ   SearchSearch   UsergroupsUsergroups   ProfileProfile   Log in for private messagesLog in for private messages   Log inLog in 

Can anyone tell me to convert...

 
Post new topic   Reply to topic    Pocket GPS World Forum Index -> Points Of Interest (POIs)
View previous topic :: View next topic  
Author Message
garmin276c
Occasional Visitor


Joined: May 21, 2008
Posts: 6

PostPosted: Fri May 23, 2008 12:58 pm    Post subject: Can anyone tell me to convert... Reply with quote

I have my own waypoints in garmin's .gdb format.
In order to free POI space in my gps, I'd like to export/convert this file to an excel .csv format in order to upload it back onto my gps as an extra 'points of interest category - same as the free POI's I have ssen on this site.

I cannot seem to find the methodology to do this-
Can anyone talk me through it please? it would save me hours of retyping!
thanks
Back to top
View user's profile Send private message
Darren
Frequent Visitor


Joined: 11/07/2002 14:36:40
Posts: 23848
Location: Hampshire, UK

PostPosted: Fri May 23, 2008 1:02 pm    Post subject: Reply with quote

GPSBabel?
http://www.gpsbabel.org/capabilities.html
_________________
Darren Griffin
Back to top
View user's profile Send private message Send e-mail Visit poster's website
garmin276c
Occasional Visitor


Joined: May 21, 2008
Posts: 6

PostPosted: Fri May 23, 2008 1:29 pm    Post subject: thanks Darren Reply with quote

one hiccup
when i convert to a csv file, it puts all the data into one single cell and not three. any way around this?

I've also noticed in the database of free pois you offer, the order from left to right is longitude then latitude then detail

is it necessary to maintain this lay out?
Back to top
View user's profile Send private message
garmin276c
Occasional Visitor


Joined: May 21, 2008
Posts: 6

PostPosted: Fri May 23, 2008 1:46 pm    Post subject: Darren Reply with quote

Darren
In the free poi's files this is the format I find.

Is it necessary to always maintain this format?
and what are the numbers in the details column? are these necessary?

;Longitude Latitude Name Details
-5.14611 50.20352 Imperial Motors 4.41873E+11

Many thanks
Back to top
View user's profile Send private message
MaFt
Pocket GPS Staff
Pocket GPS Staff


Joined: Aug 31, 2005
Posts: 15125
Location: Bradford, West Yorkshire

PostPosted: Fri May 23, 2008 5:15 pm    Post subject: Re: Darren Reply with quote

garmin276c wrote:
In the free poi's files this is the format I find.

Is it necessary to always maintain this format?


yes, garmin requires: lon,lat,name,details


garmin276c wrote:

and what are the numbers in the details column? are these necessary?

;Longitude Latitude Name Details
-5.14611 50.20352 Imperial Motors 4.41873E+11


:GRIN: Laughing Out Loud, let me guess, you opened the csv file in excel? try widening the column or opening it in notepad instead. it's the telephone number of the POI!!

excel changes it to that because it assumes it's a number so it 'simplifies' it to fit in the space available!

MaFt
Back to top
View user's profile Send private message Visit poster's website
Andy_P
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Jun 04, 2005
Posts: 19991
Location: West and Southwest London

PostPosted: Fri May 23, 2008 6:36 pm    Post subject: Reply with quote

Dear Pocket GPS World,
I have not got an exponent key on my phone....
Please advise.


Laughing
Back to top
View user's profile Send private message
garmin276c
Occasional Visitor


Joined: May 21, 2008
Posts: 6

PostPosted: Sat May 24, 2008 10:54 am    Post subject: Re: Darren Reply with quote

MaFt wrote:
garmin276c wrote:
In the free poi's files this is the format I find.

Is it necessary to always maintain this format?


yes, garmin requires: lon,lat,name,details


garmin276c wrote:

and what are the numbers in the details column? are these necessary?

;Longitude Latitude Name Details
-5.14611 50.20352 Imperial Motors 4.41873E+11


:GRIN: Laughing Out Loud, let me guess, you opened the csv file in excel? try widening the column or opening it in notepad instead. it's the telephone number of the POI!!

excel changes it to that because it assumes it's a number so it 'simplifies' it to fit in the space available!

MaFt


Hi MaFt
D'oh! thanks
Although babel has converted my .gbx file, it has sadly put all the information in one single column- so I have begun the laborious task of cut and pasting the 3 relevant pieces of info into three columns.
And how weird is that- it was longitude first then latitude.... totally upside down IMHO ( Grrrr !!)
still some way is better than no way!
Very Happy cheers
Back to top
View user's profile Send private message
garmin276c
Occasional Visitor


Joined: May 21, 2008
Posts: 6

PostPosted: Mon May 26, 2008 12:11 pm    Post subject: help! Reply with quote

Help!
I can't keep cut and pasting ! my fingers are numb.

babelgps has converted my .gbx file but it has sadly put all the information in one single column-

Is there a way to convert directly in the correct format?
i.e.

Longitude Latitude Name details ?

Does anyone know the method please?
Back to top
View user's profile Send private message
Oldboy
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Dec 08, 2004
Posts: 10641
Location: Suffolk, UK

PostPosted: Mon May 26, 2008 2:24 pm    Post subject: Reply with quote

You have a PM.
_________________
Richard

TT 910 V7.903: Europe Map v1045
TT Via 135 App 12.075: Europe Map v1120
Back to top
View user's profile Send private message Visit poster's website
alistairm1
Regular Visitor


Joined: Mar 30, 2005
Posts: 104

PostPosted: Tue May 27, 2008 12:37 pm    Post subject: Reply with quote

In Excel, Highlight the column, then select Data then Text to Columns.
This will present a window for you to select whether to use a delimiter or fixed width columns.
Once you are happy with the sample layout it presents, select apply.

Job done.

Hope this helps.
Back to top
View user's profile Send private message
garmin276c
Occasional Visitor


Joined: May 21, 2008
Posts: 6

PostPosted: Wed May 28, 2008 1:35 pm    Post subject: Alistair Reply with quote

U R a star
problem sorted- many thanks
hours of cut and paste avoided= much appreciated Very Happy
Back to top
View user's profile Send private message







Posted: Today    Post subject: Pocket GPS Advertising

Back to top
Display posts from previous:   
Post new topic   Reply to topic    Pocket GPS World Forum Index -> Points Of Interest (POIs) All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Make a Donation



CamerAlert Database

Click here for the PocketGPSWorld.com Speed Camera Database

Download Speed Camera Database
22.034 (27 Mar 24)



WORLDWIDE SPEED CAMERA SPOTTERS WANTED!

Click here to submit camera positions to the PocketGPSWorld.com Speed Camera Database


12mth Subscriber memberships awarded every week for verified new camera reports!

Submit Speed Camera Locations Now


CamerAlert Apps



iOS QR Code






Android QR Code







© Terms & Privacy


GPS Shopping