View previous topic :: View next topic |
Author |
Message |
MaFt Pocket GPS Staff
Joined: Aug 31, 2005 Posts: 15297 Location: Bradford, West Yorkshire
|
Posted: Wed Feb 24, 2010 5:09 pm Post subject: Nissan Connect Specific Download Now Available! |
|
|
Just to let you know that we have now made a specific download available for Nissan Connect. This does not contain the copyright line in the files nor does it contain the bmp's in the zip file.
You can download it using the 'Nissan Connect' option on the download page.
MaFt |
|
Back to top |
|
|
Grace0803 Occasional Visitor
Joined: Feb 26, 2006 Posts: 13
|
Posted: Tue Jun 01, 2010 9:33 pm Post subject: |
|
|
I have just downloaded the dedicated Nissan Connect files.
Excellent work and many thanks for your efforts.
I just have one niggle though:
I usually download the .csv file and then edit each one to remove the copyright line from the bottom which is what you have done for us.
But I also changed the name of the cameras so instead of "W-SPECS:82503@50" and all the others, I would change the text in the "Name" column in that file to read "Average Speed Camera". Likewise with the other camera types, I would change them to "Mobile Speed Camera" or "Fixed Speed Camera".
I can do this by changing the entire column so I only need to do it once for each camera type, 5 in total. Takes about 10 minutes. The only thing I can't do is add the speed of each camera because they are mixed up and that would mean editing every line.
So my question is can you add the speed of each camera as a seperate column?
So you would have:
;Longitude Latitude Name Speed
Then when I edit the "Name" column, the speed stays the same.
I would be eternally grateful as I am sure many others would be.
Cheers,
Brian. |
|
Back to top |
|
|
MaFt Pocket GPS Staff
Joined: Aug 31, 2005 Posts: 15297 Location: Bradford, West Yorkshire
|
Posted: Tue Jun 01, 2010 9:48 pm Post subject: |
|
|
I was under the impression that the Nissan Connect required only those 3 fields: Lon / Lat / Name ?
You could always open the CSV file in a text editor like Notepad and change all the @ to commas so they would be an extra column in the CSV.
MaFt |
|
Back to top |
|
|
Grace0803 Occasional Visitor
Joined: Feb 26, 2006 Posts: 13
|
Posted: Tue Jun 01, 2010 11:01 pm Post subject: |
|
|
MaFt, you're correct, the Connect system does need only 3 but can use more.
I tried the comma conversion thing but it just changed all the @ symbols to commas in the same excel cell.
I will keep at it.
Cheers,
Brian. |
|
Back to top |
|
|
M8TJT The Other Tired Old Man
Joined: Apr 04, 2006 Posts: 10118 Location: Bexhill, South Sussex, UK
|
Posted: Tue Jun 01, 2010 11:07 pm Post subject: |
|
|
MaFt wrote: | You could always open the CSV file in a text editor like Notepad and change all the @ to commas so they would be an extra column in the CSV. | The result that you get in Excel would be expected. Can you not save the Excel file as a .csv then re-import it to see what happens? |
|
Back to top |
|
|
Grace0803 Occasional Visitor
Joined: Feb 26, 2006 Posts: 13
|
Posted: Tue Jun 01, 2010 11:13 pm Post subject: |
|
|
I'm getting there, I can use the "Text to Colums Wizard" and do it that way.
I will try the results on the Nissan Connect and post back. |
|
Back to top |
|
|
MaFt Pocket GPS Staff
Joined: Aug 31, 2005 Posts: 15297 Location: Bradford, West Yorkshire
|
Posted: Tue Jun 01, 2010 11:20 pm Post subject: |
|
|
Grace0803 wrote: | MaFt, you're correct, the Connect system does need only 3 but can use more.
I tried the comma conversion thing but it just changed all the @ symbols to commas in the same excel cell.
I will keep at it.
Cheers,
Brian. |
assuming you are using windows, hold down 'shift' and then right-click the csv file. you should get an extra option of 'open with...'. click this and select 'notepad'. this is a text editor - THEN once open in notepad, use CTRL+H to pull up the find and replace - then change @ to comma
MaFt |
|
Back to top |
|
|
M8TJT The Other Tired Old Man
Joined: Apr 04, 2006 Posts: 10118 Location: Bexhill, South Sussex, UK
|
Posted: Wed Jun 02, 2010 7:37 am Post subject: |
|
|
M8TJT wrote: | Can you not save the Excel file as a .csv then re-import it to see what happens? | That doen't work, just tried it because excel puts quotes around the field containing the comma
MaFt's method does though. |
|
Back to top |
|
|
Grace0803 Occasional Visitor
Joined: Feb 26, 2006 Posts: 13
|
Posted: Fri Jun 04, 2010 6:25 pm Post subject: |
|
|
Sorted, now instead of getting the message:
"W-SPECS:82503@50"
I get:
"Average Speed Camera 50"
and for the others I get:
"Mobile Camera 50"
"Speed Camera 50"
"Poss Camera Site 50"
"Redlight Camera"
I still need to edit the Nissan Connect file each time I download it but I can live with that.
Many thanks for your help guys.
Brian. |
|
Back to top |
|
|
ratman633 Lifetime Member
Joined: Aug 03, 2006 Posts: 84 Location: Essex
|
Posted: Sat Jun 05, 2010 3:22 pm Post subject: |
|
|
Grace0803 wrote: | Sorted, now instead of getting the message:
"W-SPECS:82503@50"
I get:
"Average Speed Camera 50"
and for the others I get:
"Mobile Camera 50"
"Speed Camera 50"
"Poss Camera Site 50"
"Redlight Camera"
I still need to edit the Nissan Connect file each time I download it but I can live with that.
Many thanks for your help guys.
Brian. |
I tried something similar with M8TJT's help, but had problems http://www.pocketgpsworld.com/modules.php?name=Forums&file=viewtopic&t=82671 my connect would only sound a warning when approaching a camera from one direction, it wouldn't warn when travelling in the opposite direction. For some cameras it didn't warn in either direction. Reinstalling the CSV file as downloaded and it works fine. Have you had any problems like this?
Keith |
|
Back to top |
|
|
Grace0803 Occasional Visitor
Joined: Feb 26, 2006 Posts: 13
|
Posted: Mon Jun 07, 2010 3:52 pm Post subject: |
|
|
I haven't been checking Keith, but I will from now on.
I will let you know, thanks for the heads up. |
|
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 |
|
|
|