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

Pocket GPS World :: View topic - Creating Garmin CSV File
 Forum FAQForum FAQ   SearchSearch   UsergroupsUsergroups   ProfileProfile   Log in for private messagesLog in for private messages   Log inLog in 

Creating Garmin CSV File

 
Post new topic   Reply to topic    Pocket GPS World Forum Index -> Garmin Portable Navigation Devices
View previous topic :: View next topic  
Author Message
Gazatteer
Occasional Visitor


Joined: Apr 17, 2006
Posts: 14

PostPosted: Fri Apr 28, 2006 10:00 am    Post subject: Creating Garmin CSV File Reply with quote

I have been searching for over an hour now and could not find the answer to my question.

I like to create my own custom CSV file for all Garmin devices.
I have read in one of the posts that I would need four headings, longitude, latitude, name and details.

I have also read on another website is that the first line in .csv file should be the headings, set out in the following format. Otherwise the POI Loader will not detect the file as .csv file. Here is example:

;longitude,;latitude,;name,;details

So before the heading a ';' must exist otherwise POI Loader will not recognise it has CSV file.

Is this true?
Back to top
View user's profile Send private message
mhb
Regular Visitor


Joined: Dec 21, 2005
Posts: 155

PostPosted: Fri Apr 28, 2006 11:58 am    Post subject: Reply with quote

Yes that is correct. However you only need a single semi colon at the start of the first line not in front of each label.
i.e.

;longitude,latitude,name,details
Back to top
View user's profile Send private message
Gazatteer
Occasional Visitor


Joined: Apr 17, 2006
Posts: 14

PostPosted: Fri Apr 28, 2006 12:06 pm    Post subject: Reply with quote

Would the semi colons before each label cause an error or would it still work?
Back to top
View user's profile Send private message
MaFt
Pocket GPS Staff
Pocket GPS Staff


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

PostPosted: Fri Apr 28, 2006 12:18 pm    Post subject: Reply with quote

Gazatteer wrote:
Would the semi colons before each label cause an error or would it still work?


no, it still works - it sees the initial semi-colon and knows to ignore the rest of the line.

MaFt
Back to top
View user's profile Send private message Visit poster's website
timber
Frequent Visitor


Joined: Jan 18, 2006
Posts: 422
Location: Wild and Windy SW Scotland UK

PostPosted: Fri Apr 28, 2006 12:19 pm    Post subject: Re: Creating Garmin CSV File Reply with quote

Gazatteer wrote:
I have been searching for over an hour now and could not find the answer to my question.

I like to create my own custom CSV file for all Garmin devices.
I have read in one of the posts that I would need four headings, longitude, latitude, name and details.

I have also read on another website is that the first line in .csv file should be the headings, set out in the following format. Otherwise the POI Loader will not detect the file as .csv file. Here is example:

;longitude,;latitude,;name,;details

So before the heading a ';' must exist otherwise POI Loader will not recognise it has CSV file.
Is this true?


Speed camera csv file shown in notepad
-3.32644,55.00616,TEMP: A75 @60

Motorway Services csv file shown in notepad
-3.092,55.0082,MWay A74(M) -Gretna

Caravan and Camping csv file shown in notepad
-2.304461,53.602484,BURRS COUNTRY PARK

I use excel to create and save as csv file the (,) comma is put in by the software.

The poi you have created must have a bmp file named exactly the same as the csv file and be exactly 22 x 22 pixel

There will be a limit on the name/description field before you ask i don't know the answer it will take more than can be displayed on the screen so use common sense.

Any poi's i create are checked out by importing into Autoroute to check before i load them into the Garmin.
Back to top
View user's profile Send private message
Gazatteer
Occasional Visitor


Joined: Apr 17, 2006
Posts: 14

PostPosted: Fri Apr 28, 2006 12:40 pm    Post subject: Reply with quote

Thank you, that clears things up for me.

What Garmin devices support csv? Do they all use POI Loader?

Thanks
Back to top
View user's profile Send private message
timber
Frequent Visitor


Joined: Jan 18, 2006
Posts: 422
Location: Wild and Windy SW Scotland UK

PostPosted: Fri Apr 28, 2006 12:54 pm    Post subject: Reply with quote

Gazatteer wrote:
Thank you, that clears things up for me.

What Garmin devices support csv? Do they all use POI Loader?

Thanks


go to http://www.garmin.com/support/blosp.jsp select the device your intrested in and you will see if the poi loader is part of the download options for that device.
Back to top
View user's profile Send private message
Gazatteer
Occasional Visitor


Joined: Apr 17, 2006
Posts: 14

PostPosted: Sun Apr 30, 2006 10:21 pm    Post subject: Reply with quote

I have Garmin iQue 3600.

I have visited the Garmin website (clicked on the link in the above post) and I have found out that POI Loader is not listed for iQue 3600. In another words I don't think POI Loader works with iQue 3600.

I have tried using POI Loader anyway and I get a data error on lines 177 and 33. When I looked at these lines they correct and as I wanted them. The csv file looks correct.

What should I do now?
Back to top
View user's profile Send private message
missing_user



Joined: Aug 30, 2008
Posts: -7

PostPosted: Sun Apr 30, 2006 10:27 pm    Post subject: Reply with quote

Would not .gdb or.gpx or.wpt files me easier to use on Mapsource and you iQue 3600?

You could then use POI converter to change the file type later.
Back to top
View user's profile Send private message
Gazatteer
Occasional Visitor


Joined: Apr 17, 2006
Posts: 14

PostPosted: Sun Apr 30, 2006 10:43 pm    Post subject: Reply with quote

Sorry, but I don't understand what you mean. Can you explain a little more?

Thanks
Back to top
View user's profile Send private message
Gazatteer
Occasional Visitor


Joined: Apr 17, 2006
Posts: 14

PostPosted: Sun Apr 30, 2006 11:02 pm    Post subject: Reply with quote

Gazatteer wrote:
I have Garmin iQue 3600.

I have visited the Garmin website (clicked on the link in the above post) and I have found out that POI Loader is not listed for iQue 3600. In another words I don't think POI Loader works with iQue 3600.

I have tried using POI Loader anyway and I get a data error on lines 177 and 33. When I looked at these lines they correct and as I wanted them. The csv file looks correct.

What should I do now?


Sorry, there is a typing error. There is a data error on line 17, not 177.

Regards
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 -> Garmin Portable Navigation Devices 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.053 (15 May 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