Making csv files work with the new POI Loader

MaFt · Last edited by MaFt on Fri Mar 10, 2006 3:23 pm; edited 1 time in total

Received this email from Graham:

"I have just downloaded the latest Garmin POI Loader, there was a problem
with All my POI csv files, the problem I have discovered is the Headers at
the top of each file now need to be preceded with ';' to mark them as
comment or be completed removed."

So, basically remove the 'title' row (row 1) from ALL csv files and this should work.

I will get the files edited on my site ASAP and will request that the PGPSW files are edited if possible.

MaFt

Tim Buxton · Posted: Wed Jan 25, 2006 5:38 pm Post subject:

MaFt, if the ; works, it is a much better solution than removing the header information. Adding the ; means that the data can still be read into Autoroute without having to add the header informantion, which would have to be done if said info was removed.
_________________
Tim

MaFt · Posted: Wed Jan 25, 2006 8:31 pm Post subject:

the semi colon DOES work Smile

MaFt · Posted: Wed Jan 25, 2006 8:37 pm Post subject:

go to news section of http://www.garminpoi.co.uk to get the updated versions of poi's

MaFt

Almahadeus · Frequent Visitor Joined: Aug 06, 2005 Posts: 346

Will the new modified POI files work with the old POILoader ?

MaFt · Posted: Thu Feb 02, 2006 12:13 pm Post subject:

Almahadeus · Frequent Visitor Joined: Aug 06, 2005 Posts: 346

Not really MaFt as I was put off updating my i3 this month by the single files released for the speedcam database. I will probably try it this weekened.

fred12 · Occasional Visitor Joined: Sep 29, 2005 Posts: 7

Unfortuately the new ones do not owrk with the old software what is pocket gps playing changing the formato of the speed camera files again.

What format are we going to get when we have to pay for them Rolling Eyes

MaFt · Posted: Sat Feb 11, 2006 11:50 am Post subject:

Ayla · Occasional Visitor Joined: Feb 23, 2006 Posts: 22

I have absolutely no idea how to work with CSV files. Please can someone help? Where do I put the semi-colon? In cell A1? For example:

pocketgps_uk_mobile.csv

Cell A1 = -3.71976
Cell B1 = 51.52475
Cell C1 = MOBILE:5607

Ergo, would Cell A1 = ;-3.71976 ?

Thank you.

mors1 · Occasional Visitor Joined: Feb 15, 2006 Posts: 5

if working in excel - just save it as a csv file

Ayla · Occasional Visitor Joined: Feb 23, 2006 Posts: 22

Oldboy · Posted: Sat Feb 25, 2006 9:18 am Post subject:

Ayla · Occasional Visitor Joined: Feb 23, 2006 Posts: 22

Thank you OldBoy! I have no text headers, which is why I was getting confused - I couldn't work out why a sem-colon would be required in front of a + or - sign and numbers.

I presume, then, that the database has been modified to remove the text headers.

I have downloaded them on to my i3 with absolutely no problem. All I have to do now is figure out how to actually make use of them Wink

I guess I'll be driving around tomorrow....

HUK · Occasional Visitor Joined: Sep 23, 2005 Posts: 19

Hey MaFt

Haven't posted on here for ages. Good to see you're one of the mods now.
Just wanna check that if I install the latest POI loader (v2.2.1) it will go straight over the top of my previous version, and all POI files on your site will load as they previously did, albeit using the new formats and new POI software.

If I don't update the POI software then the camera database (which I understand you can't provide anymore) will not work, however it is fully compatiable if all software is kept up-to-date.

Hope that makes sense

Cheers

	PocketGPS
	Web