database help please - Nokia N95

egg661 · Occasional Visitor Joined: May 19, 2008 Posts: 4

Hi all can anybody help, i need a database to use with my N95 phone. I have downloaded the uk csv file. when i open it it is in MS excel format and the Python Software does not regonise it.

I need a database that is pocketgps sc.txt and is in this format

Longitude,Latitude,CameraType@SpeedLimit
-1.00000,51.00000,GATSO@40
-1.10000,51.10000,GATSO
-1.20000,51.20000,MOBILE@60
-1.30000,51.30000,TRUVELO@0
-1.30000,51.30000,RedLight@30
-1.40000,51.40000,SPECS@70

-1.30235,53.32794,pMOBILE:13028@30
-3.44428,50.68226,pMOBILE:27038@40
-0.74001,51.41849,pMOBILE:27060@30
-5.36802,50.20407,pMOBILE:27776@30

any ideas or how can i convert the excel format with out manually removing the spaces and entering comas Rolling Eyes

Andy_P · Posted: Mon May 19, 2008 10:48 pm Post subject:

Are you trying "Other CSV" (near the bottom of the drop down list)?

Excel is probably set up on your PC to open csv files by default, so that's not necessarily the problem.

I've just downloaded that version and opened it in Notepad and the format is:
-2.17787,50.68305,"GATSO:1@40" which looks right apart from the quotation marks around the name.

Maybe it doesn't like the first line, which says:
;Longitude,Latitude,Name
Try just opening the file you've got in Notepad and deleting that line then resaving (with a .txt extension).

PaulB2005 · Posted: Mon May 19, 2008 11:10 pm Post subject:

Title edited to add model.

egg661 · Occasional Visitor Joined: May 19, 2008 Posts: 4

cheers Andy i downloaded ther Other CVS file, but its still does not like the format. I've tried lots of things. the only format it excepts is

-2.17787,50.68304,gatso@40

the downloaded cvs file is

-2.17787,50.68304,GATSO:1@40

small differance but it wont take it

??

Mark[/quote]

Kremmen · Posted: Tue May 20, 2008 7:12 am Post subject:

If you know anyone with Excel Macro skills I would think it could be used to change the format to the one required ?
_________________
Satnav:
Garmin 2599 LMT-D (Indoor test rig)
DashCam:
Viofo A119 V3
Car Average MPG :

egg661 · Occasional Visitor Joined: May 19, 2008 Posts: 4

Andy_P · Posted: Tue May 20, 2008 10:10 am Post subject:

Sorry, I must be going blind! Don't know how I missed the extra punctuation that you don't want.

But... as this is just a text file, you should be able to open it in any word processor, do a few "find and replace-es" for the bits you want to change or remove and then resave as text. (You might have to change the extension back to .csv again at the end).

Also, in your examples you have TWO different formats... Do you need to lose the camera ID number or not? You only seem to have put them on for the pMobiles, when in fact every camera entry will have one.

If the ID number can be part of the text, all you need to lose is the ":".
In other words if you are allowed "gatso" or "Redlight" then you should be allowed "gatso1" or "Redlight5678"
That will be easy to do in Word or whatever. Just FIND ":" and REPLACE with nothing.

(Edit: I've just checked - Excel's "find and replace" works in just the same way if you want to use that instead).

mikealder · Posted: Tue May 20, 2008 12:53 pm Post subject:

If you send me the file you want converting I will strip out the bits not required using some Labview code on the PC before sending it back, my e-mail button can be used for this purpose. It has to be your original file though as each download is unique. Out of interest what application is it you are using on the n95 for the warnings - Mike

egg661 · Occasional Visitor Joined: May 19, 2008 Posts: 4

Thanks Guys Laughing

With all your tips I have amended the data file easily and is now installed and working.

Just need to find a scamra to test it Very Happy

This is a link to the software I'm using on the N95

http://mcbiskits1.googlepages.com/

Many Thanks

Mark

Darren · Posted: Wed Jun 25, 2008 9:01 am Post subject:

If we can demonstrate sufficient demand for a version to suit this app we can look at creating one, so if anyone else is using our data on this app or you know of them, post here and we can gauge interest.
_________________
Darren Griffin

Paul80 · Regular Visitor Joined: Aug 25, 2005 Posts: 246

Count me in for using the data if its made available.

Paul

Darren · Posted: Wed Jun 25, 2008 7:21 pm Post subject:

Will do, it's 'available' now but needs a tiny bit of twiddling. You need to find/replace the quotes in the .csv file. Takes a few seconds to do and is very straightforward.

I'm happy to do this for you if you want to get going sooner but if not, we will seriously look at adding this as a new format.
_________________
Darren Griffin

MaFt · Posted: Wed Jun 25, 2008 11:08 pm Post subject:

http://www.pocketgpsworld.com/modules.php?name=Forums&file=viewtopic&t=68373

Shocked

enjoy! and let me know any changes that need making!

MaFt

	PocketGPS
	Web