Results 1 to 9 of 9

Thread: Speed Camera Updates in MapMonkey

  1. #1
    Low Bitrate
    Join Date
    Mar 2003
    Location
    UK
    Posts
    78

    Speed Camera Updates in MapMonkey

    How would I go about converting the latest Speed Camera Updates from http://www.pocketgps.co.uk to work with map monkey?

    Is there an easy way to do this?

    Thanks guys

  2. #2
    Variable Bitrate
    Join Date
    May 2005
    Location
    Derbyshire, UK
    Posts
    422
    I have done this...look at the format of the mapmonkey csv file and with the single file version from pocketgps, put it in the same format...

    Gimme a minute and I'll redo it and give step by step details...

    The pocketgps database doesn't have the bus lane data in it though...
    Old setup
    Epia M10k, Cubid 2699R case, 512MB, 40GB 3.5" drive
    New setup
    Optiplex 260SX (2.8GHz P4, 512MB, 30GB, DVD)
    Xenarc 700IDT, USB hub, 802.11g, bluetooth, P2140, P5V

  3. #3
    Variable Bitrate
    Join Date
    May 2005
    Location
    Derbyshire, UK
    Posts
    422
    See if you can follow this....

    Insert column before A
    Select column D, data menu convert text to columns, tick in other : in box, finish.
    Select column D, move it to A (grab just below column heading, cursor will change to 4 way arrow)
    Rename column A to "Type"
    Select column E and text to columns with @
    Create a formulae in column G, =IF(F2>0,F2,0) Copy it down the whole column (press shift, ctrl and end together) Press ctrl+D
    Copy column G while it's still selected (ctrl+c)
    Paste special into column H, paste values.
    Delete columns E to G
    In column D type in 1 then 2, select those cells then goto the bottom right corner (cursor changes to cross) Drag down to last entry (6210 at the moment), this will number them all with a unique number.
    Name column D and E, "Name" and "Speed"
    Save it as a CSV.

    Now, the MapMonkey file doesn't have Truvelo so I don't know if that will make a difference. Not sure how it uses that apart from just a label for the poi ??

    You could copy the buslane, tollgate and distance rows from the MapMonkey file and add them to the end (be sure to change the name column to continue the numbering you did earlier)



    Anyone anything to add to that, or see any problems with it ??
    Old setup
    Epia M10k, Cubid 2699R case, 512MB, 40GB 3.5" drive
    New setup
    Optiplex 260SX (2.8GHz P4, 512MB, 30GB, DVD)
    Xenarc 700IDT, USB hub, 802.11g, bluetooth, P2140, P5V

  4. #4
    Low Bitrate
    Join Date
    Mar 2003
    Location
    UK
    Posts
    78
    Owww thanks for the how-to

    What software are you using in your how-to so i know what to use to convert it?


    Thanks again

  5. #5
    Variable Bitrate
    Join Date
    May 2005
    Location
    Derbyshire, UK
    Posts
    422
    Office XP, Excel....
    Old setup
    Epia M10k, Cubid 2699R case, 512MB, 40GB 3.5" drive
    New setup
    Optiplex 260SX (2.8GHz P4, 512MB, 30GB, DVD)
    Xenarc 700IDT, USB hub, 802.11g, bluetooth, P2140, P5V

  6. #6
    Low Bitrate
    Join Date
    Mar 2003
    Location
    UK
    Posts
    78
    Excellent

    Thanks for that

  7. #7
    Map Monkey Creator Ninja Monkey's Avatar
    Join Date
    Aug 2003
    Location
    Warrington, UK
    Posts
    1,012
    map monkey actually supports importing the pocketgps csv files...no need to convert
    Destinator 3 For PC! - http://www.map-monkey.co.uk/

  8. #8
    Variable Bitrate
    Join Date
    May 2005
    Location
    Derbyshire, UK
    Posts
    422
    Quote Originally Posted by Ninja Monkey
    map monkey actually supports importing the pocketgps csv files...no need to convert
    Nice one I was playing it safe by having the columns etc in the same order.

    One thing though, I had problems with importing if I didn't give each one a unique name. (maybe that's because I split the name into seperate columns)...


    While we're on the subject of pocketgps databases, Is it possible to import the seperate databases (different speeds/types) and associate different icons with each one ?? Like I can in Mapsonic......
    Old setup
    Epia M10k, Cubid 2699R case, 512MB, 40GB 3.5" drive
    New setup
    Optiplex 260SX (2.8GHz P4, 512MB, 30GB, DVD)
    Xenarc 700IDT, USB hub, 802.11g, bluetooth, P2140, P5V

  9. #9
    Low Bitrate
    Join Date
    Mar 2003
    Location
    UK
    Posts
    78
    Quote Originally Posted by Ninja Monkey
    map monkey actually supports importing the pocketgps csv files...no need to convert


    Thanks for that!

    Just imported another 1400 cams

Similar Threads

  1. [REVIEW] In-Bumper Rear-view camera
    By RoyN in forum General Hardware Discussion
    Replies: 104
    Last Post: 12-30-2006, 02:42 PM
  2. Speed Camera Database Updates
    By Ninja Monkey in forum Map Monkey
    Replies: 75
    Last Post: 06-29-2006, 07:01 AM
  3. speed camera in frodo?
    By Erwin in forum Map Monkey
    Replies: 0
    Last Post: 03-30-2005, 11:21 AM
  4. Speed / Red Light Camera
    By Skorpion in forum Map Monkey
    Replies: 6
    Last Post: 02-22-2005, 01:44 PM
  5. Replies: 11
    Last Post: 04-12-2004, 05:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •