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

Pocket GPS World :: View topic - CSV files not in Excel format??
 Forum FAQForum FAQ   SearchSearch   UsergroupsUsergroups   ProfileProfile   Log in for private messagesLog in for private messages   Log inLog in 

CSV files not in Excel format??
Goto page 1, 2  Next
 
Post new topic   Reply to topic    Pocket GPS World Forum Index -> PocketGPSWorld Speed Camera Database
View previous topic :: View next topic  
Author Message
DerekFKS85
Occasional Visitor


Joined: Sep 05, 2005
Posts: 45

PostPosted: Tue May 23, 2006 8:38 pm    Post subject: CSV files not in Excel format?? Reply with quote

I downloaded the recent CSV camera files and now they announce underscores, comma's etc.
When I open the files up in excel to edit them, they appear to be in some sort of computer code???

HELP!!!
Back to top
View user's profile Send private message
Oldboy
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Dec 08, 2004
Posts: 10642
Location: Suffolk, UK

PostPosted: Tue May 23, 2006 10:38 pm    Post subject: Reply with quote

Which File did you download, and which Device did you download it for?

Why do you need to Open the Files in Excel?

Are you sure you've got the right File?
_________________
Richard

TT 910 V7.903: Europe Map v1045
TT Via 135 App 12.075: Europe Map v1120
Back to top
View user's profile Send private message Visit poster's website
xda
Lifetime Member


Joined: Mar 11, 2004
Posts: 1199
Location: Park Gate

PostPosted: Tue May 23, 2006 10:54 pm    Post subject: Reply with quote

I have the latest Speed Zoned .CSV files here and they open correctly in Excel,
Displays 3 columns. Latitude, Longitude and Name.
In the name column is the camera No. and speed.
_________________
Graham.
TT Go720, App:9.510(1234792.1) OS:842337
GPS: V1.20, Boot: 5.5279, Home: V2.9.5.3093
Map: Europe V910.4892
Map: Europe_Truck V870.3421, Kingston 8GB SD
Nokia 925 Windows 8
Back to top
View user's profile Send private message Send e-mail
DerekFKS85
Occasional Visitor


Joined: Sep 05, 2005
Posts: 45

PostPosted: Wed May 24, 2006 11:59 am    Post subject: Reply with quote

CSV files for Pocket PC on Mio. 23 files I think.

Thanks for the replies.
Back to top
View user's profile Send private message
DerekFKS85
Occasional Visitor


Joined: Sep 05, 2005
Posts: 45

PostPosted: Fri May 26, 2006 10:36 am    Post subject: Reply with quote

Anyone?
Back to top
View user's profile Send private message
7272Andy
Regular Visitor


Joined: Mar 10, 2006
Posts: 107
Location: Bath

PostPosted: Fri May 26, 2006 10:53 am    Post subject: Reply with quote

Which device did you download the fileset for?
_________________
Samsung Note 20 ultra
CamerAlert
Waze
Back to top
View user's profile Send private message
xda
Lifetime Member


Joined: Mar 11, 2004
Posts: 1199
Location: Park Gate

PostPosted: Sat May 27, 2006 2:19 am    Post subject: Reply with quote

He has already said
Quote:
CSV files for Pocket PC on Mio. 23 files I think

Which would be the speed related CSV archive. Which I have downloaded and opens fine in Excel as I use it in Autoroute, and all the speed cameras import correctly.
_________________
Graham.
TT Go720, App:9.510(1234792.1) OS:842337
GPS: V1.20, Boot: 5.5279, Home: V2.9.5.3093
Map: Europe V910.4892
Map: Europe_Truck V870.3421, Kingston 8GB SD
Nokia 925 Windows 8
Back to top
View user's profile Send private message Send e-mail
Tim Buxton
Pocket GPS Moderator
Pocket GPS Moderator


Joined: 14/09/2002 20:56:18
Posts: 5231
Location: Surrey, United Kingdom

PostPosted: Sat May 27, 2006 10:31 am    Post subject: Reply with quote

xda wrote:
He has already said
Quote:
CSV files for Pocket PC on Mio. 23 files I think

Which would be the speed related CSV archive. Which I have downloaded and opens fine in Excel as I use it in Autoroute, and all the speed cameras import correctly.


What we need to know is what navigation software is being used.
_________________
Tim
Back to top
View user's profile Send private message Send e-mail Visit poster's website
xda
Lifetime Member


Joined: Mar 11, 2004
Posts: 1199
Location: Park Gate

PostPosted: Sat May 27, 2006 11:46 am    Post subject: Reply with quote

I was replying with reference to the second part of his original post where he implied that the CSV file might be faulty.
But yes we need to know what Sat nav software he is running, I seem to recall that the problem of announcing @ etc. was happening in certain programs and the answer was to remove them from the database, hence his reason for trying to access it with excel. I think it may have been CoPilot but not sure.
_________________
Graham.
TT Go720, App:9.510(1234792.1) OS:842337
GPS: V1.20, Boot: 5.5279, Home: V2.9.5.3093
Map: Europe V910.4892
Map: Europe_Truck V870.3421, Kingston 8GB SD
Nokia 925 Windows 8
Back to top
View user's profile Send private message Send e-mail
xda
Lifetime Member


Joined: Mar 11, 2004
Posts: 1199
Location: Park Gate

PostPosted: Sat May 27, 2006 11:49 am    Post subject: Reply with quote

Tim the question regarding his software was asked by Oldboy, at the beginning of the thread but he failed to reply to that in subsequent posts.
_________________
Graham.
TT Go720, App:9.510(1234792.1) OS:842337
GPS: V1.20, Boot: 5.5279, Home: V2.9.5.3093
Map: Europe V910.4892
Map: Europe_Truck V870.3421, Kingston 8GB SD
Nokia 925 Windows 8
Back to top
View user's profile Send private message Send e-mail
DerekFKS85
Occasional Visitor


Joined: Sep 05, 2005
Posts: 45

PostPosted: Sat May 27, 2006 9:32 pm    Post subject: Reply with quote

Ooops sorry guys!

Co-Pilot 6. Embarassed
Back to top
View user's profile Send private message
Tim Buxton
Pocket GPS Moderator
Pocket GPS Moderator


Joined: 14/09/2002 20:56:18
Posts: 5231
Location: Surrey, United Kingdom

PostPosted: Sat May 27, 2006 10:10 pm    Post subject: Reply with quote

DerekFKS85 wrote:
Ooops sorry guys!

Co-Pilot 6. Embarassed


Those are .ov2 files. Have you read this?
_________________
Tim
Back to top
View user's profile Send private message Send e-mail Visit poster's website
DerekFKS85
Occasional Visitor


Joined: Sep 05, 2005
Posts: 45

PostPosted: Mon May 29, 2006 7:44 pm    Post subject: Reply with quote

Hi Tim.

I have downloaded the OV2 file but when I unzip it and open it up it is complete gobbledygook!!

If I e-mail it to you do you think you could have a wee look and see if you have any idea?


Derek.
Back to top
View user's profile Send private message
Tim Buxton
Pocket GPS Moderator
Pocket GPS Moderator


Joined: 14/09/2002 20:56:18
Posts: 5231
Location: Surrey, United Kingdom

PostPosted: Mon May 29, 2006 8:04 pm    Post subject: Reply with quote

DerekFKS85 wrote:
Hi Tim.

I have downloaded the OV2 file but when I unzip it and open it up it is complete gobbledygook!!

If I e-mail it to you do you think you could have a wee look and see if you have any idea?


Derek.


I'm afraid that I have know knowledge of installing the database onto a PPC running Co-Pilot of any vintage. Do the instructions I linked to not work? Perhaps posting in the Co-Pilot section will be more fruitful. Sorry I can't be of more help.
_________________
Tim
Back to top
View user's profile Send private message Send e-mail Visit poster's website
DerekFKS85
Occasional Visitor


Joined: Sep 05, 2005
Posts: 45

PostPosted: Mon May 29, 2006 8:38 pm    Post subject: Reply with quote

Don't worry Tim, thanks for your help anyway.
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 -> PocketGPSWorld Speed Camera Database All times are GMT + 1 Hour
Goto page 1, 2  Next
Page 1 of 2

 
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.051 (01 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