View previous topic :: View next topic |
Author |
Message |
egg661 Occasional Visitor
Joined: May 19, 2008 Posts: 4
|
Posted: Mon May 19, 2008 10:33 pm Post subject: database help please - Nokia N95 |
|
|
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 |
|
Back to top |
|
|
Andy_P Pocket GPS Moderator
Joined: Jun 04, 2005 Posts: 19991 Location: West and Southwest London
|
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). |
|
Back to top |
|
|
PaulB2005 Pocket GPS Moderator
Joined: Jan 04, 2006 Posts: 9323 Location: Durham, UK
|
Posted: Mon May 19, 2008 11:10 pm Post subject: |
|
|
Title edited to add model. |
|
Back to top |
|
|
egg661 Occasional Visitor
Joined: May 19, 2008 Posts: 4
|
Posted: Tue May 20, 2008 6:57 am Post subject: |
|
|
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 |
|
|
Kremmen Pocket GPS Verifier
Joined: Mar 03, 2006 Posts: 7123 Location: Reading
|
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 ? _________________ DashCam:
Viofo A119 V3 |
|
Back to top |
|
|
egg661 Occasional Visitor
Joined: May 19, 2008 Posts: 4
|
Posted: Tue May 20, 2008 7:16 am Post subject: |
|
|
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 |
|
Back to top |
|
|
Andy_P Pocket GPS Moderator
Joined: Jun 04, 2005 Posts: 19991 Location: West and Southwest London
|
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). |
|
Back to top |
|
|
mikealder Pocket GPS Moderator
Joined: Jan 14, 2005 Posts: 19638 Location: Blackpool , Lancs
|
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 |
|
Back to top |
|
|
egg661 Occasional Visitor
Joined: May 19, 2008 Posts: 4
|
Posted: Tue May 20, 2008 8:11 pm Post subject: |
|
|
Thanks Guys
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
This is a link to the software I'm using on the N95
http://mcbiskits1.googlepages.com/
Many Thanks
Mark |
|
Back to top |
|
|
Darren Frequent Visitor
Joined: 11/07/2002 14:36:40 Posts: 23848 Location: Hampshire, UK
|
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 |
|
Back to top |
|
|
Paul80 Regular Visitor
Joined: Aug 25, 2005 Posts: 246
|
Posted: Wed Jun 25, 2008 7:14 pm Post subject: |
|
|
Count me in for using the data if its made available.
Paul |
|
Back to top |
|
|
Darren Frequent Visitor
Joined: 11/07/2002 14:36:40 Posts: 23848 Location: Hampshire, UK
|
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 |
|
Back to top |
|
|
MaFt Pocket GPS Staff
Joined: Aug 31, 2005 Posts: 15258 Location: Bradford, West Yorkshire
|
|
Back to top |
|
|
|
Posted: Today Post subject: Pocket GPS Advertising |
|
|
We see you’re using an ad-blocker. We’re fine with that and won’t stop you visiting the site.
Have you considered making a donation towards website running costs?. Or you could disable your ad-blocker for this site. We think you’ll find our adverts are not overbearing!
|
|
Back to top |
|
|
|