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

Pocket GPS World :: View topic - database help please - Nokia N95
 Forum FAQForum FAQ   SearchSearch   UsergroupsUsergroups   ProfileProfile   Log in for private messagesLog in for private messages   Log inLog in 

database help please - Nokia N95

 
Post new topic   Reply to topic    Pocket GPS World Forum Index -> PocketGPSWorld Speed Camera Database
View previous topic :: View next topic  
Author Message
egg661
Occasional Visitor


Joined: May 19, 2008
Posts: 4

PostPosted: Mon May 19, 2008 10:33 pm    Post subject: database help please - Nokia N95 Reply with quote

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
Back to top
View user's profile Send private message
Andy_P
Pocket GPS Moderator
Pocket GPS Moderator


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

PostPosted: Mon May 19, 2008 10:48 pm    Post subject: Reply with quote

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).
Back to top
View user's profile Send private message
PaulB2005
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Jan 04, 2006
Posts: 9323
Location: Durham, UK

PostPosted: Mon May 19, 2008 11:10 pm    Post subject: Reply with quote

Title edited to add model.
Back to top
View user's profile Send private message
egg661
Occasional Visitor


Joined: May 19, 2008
Posts: 4

PostPosted: Tue May 20, 2008 6:57 am    Post subject: Reply with quote

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]
Back to top
View user's profile Send private message
Kremmen
Pocket GPS Verifier
Pocket GPS Verifier


Joined: Mar 03, 2006
Posts: 7123
Location: Reading

PostPosted: Tue May 20, 2008 7:12 am    Post subject: Reply with quote

If you know anyone with Excel Macro skills I would think it could be used to change the format to the one required ?
_________________
DashCam:
Viofo A119 V3
Back to top
View user's profile Send private message
egg661
Occasional Visitor


Joined: May 19, 2008
Posts: 4

PostPosted: Tue May 20, 2008 7:16 am    Post subject: Reply with quote

Kremmen wrote:
If you know anyone with Excel Macro skills I would think it could be used to change the format to the one required ?


Yes wish I had a Seceratery Laughing Out Loud Very Happy Very Happy
Back to top
View user's profile Send private message
Andy_P
Pocket GPS Moderator
Pocket GPS Moderator


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

PostPosted: Tue May 20, 2008 10:10 am    Post subject: Reply with quote

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).
Back to top
View user's profile Send private message
mikealder
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Jan 14, 2005
Posts: 19638
Location: Blackpool , Lancs

PostPosted: Tue May 20, 2008 12:53 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail MSN Messenger
egg661
Occasional Visitor


Joined: May 19, 2008
Posts: 4

PostPosted: Tue May 20, 2008 8:11 pm    Post subject: Reply with quote

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
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: Wed Jun 25, 2008 9:01 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Paul80
Regular Visitor


Joined: Aug 25, 2005
Posts: 246

PostPosted: Wed Jun 25, 2008 7:14 pm    Post subject: Reply with quote

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

Paul
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: Wed Jun 25, 2008 7:21 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail Visit poster's website
MaFt
Pocket GPS Staff
Pocket GPS Staff


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

PostPosted: Wed Jun 25, 2008 11:08 pm    Post subject: Reply with quote

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

Shocked Laughing Laughing Laughing Laughing

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

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







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 -> PocketGPSWorld Speed Camera Database 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.105 (30 Oct 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