Memory Map CSV layout

[+Custheyder]

Hi

 

Any chance of an example of the csv format text file you import into memory map (version 5) which has the cachemate loader bit in it?

 

...or even a list of what each column is?

 

Cheers

 

Cust.

[+Moote]

Is this what you want?

 

IC01,101,"c:\programs\gsak\icons\EventF.bmp"
IC01,102,"c:\programs\gsak\icons\LetterboxF.bmp"
IC01,104,"c:\programs\gsak\icons\MicroF.bmp"
IC01,105,"c:\programs\gsak\icons\MulticacheF.bmp"
IC01,106,"c:\programs\gsak\icons\TraditionalF.bmp"
IC01,107,"c:\programs\gsak\icons\UnknownF.bmp"
IC01,108,"c:\programs\gsak\icons\VirtualF.bmp"
IC01,109,"c:\programs\gsak\icons\WebcamF.bmp"
IC01,110,"c:\programs\gsak\icons\EarthF.bmp"
IC01,120,"c:\programs\gsak\icons\MM_F.bmp"
IC01,121,"c:\programs\gsak\icons\CitoF.bmp"
IC01,122,"c:\programs\gsak\icons\TrigpointF.bmp"
IC01,123,"c:\programs\gsak\icons\parking.bmp"
IC01,201,"c:\programs\gsak\icons\EventN.bmp"
IC01,202,"c:\programs\gsak\icons\LetterboxN.bmp"
IC01,204,"c:\programs\gsak\icons\MicroN.bmp"
IC01,205,"c:\programs\gsak\icons\MulticacheN.bmp"
IC01,206,"c:\programs\gsak\icons\TraditionalN.bmp"
IC01,207,"c:\programs\gsak\icons\UnknownN.bmp"
IC01,208,"c:\programs\gsak\icons\VirtualN.bmp"
IC01,209,"c:\programs\gsak\icons\WebcamN.bmp"
IC01,210,"c:\programs\gsak\icons\EarthN.bmp"
IC01,220,"c:\programs\gsak\icons\MM_N.bmp"
IC01,221,"c:\programs\gsak\icons\CitoN.bmp"
IC01,222,"c:\programs\gsak\icons\TrigpointN.bmp"
IC01,301,"c:\programs\gsak\icons\EventO.bmp"
IC01,302,"c:\programs\gsak\icons\LetterboxO.bmp"
IC01,304,"c:\programs\gsak\icons\MicroO.bmp"
IC01,305,"c:\programs\gsak\icons\MulticacheO.bmp"
IC01,306,"c:\programs\gsak\icons\TraditionalO.bmp"
IC01,307,"c:\programs\gsak\icons\UnknownO.bmp"
IC01,308,"c:\programs\gsak\icons\VirtualO.bmp"
IC01,309,"c:\programs\gsak\icons\WebcamO.bmp"
IC01,310,"c:\programs\gsak\icons\EarthO.bmp"
IC01,320,"c:\programs\gsak\icons\MM_O.bmp"
IC01,321,"c:\programs\gsak\icons\CitoO.bmp"
IC01,401,"c:\programs\gsak\icons\EventU.bmp"
IC01,402,"c:\programs\gsak\icons\LetterboxU.bmp"
IC01,404,"c:\programs\gsak\icons\MicroU.bmp"
IC01,405,"c:\programs\gsak\icons\MulticacheU.bmp"
IC01,406,"c:\programs\gsak\icons\TraditionalU.bmp"
IC01,407,"c:\programs\gsak\icons\UnknownU.bmp"
IC01,408,"c:\programs\gsak\icons\VirtualU.bmp"
IC01,409,"c:\programs\gsak\icons\WebcamU.bmp"
IC01,410,"c:\programs\gsak\icons\EarthU.bmp"
IC01,420,"c:\programs\gsak\icons\MM_U.bmp"
IC01,421,"c:\programs\gsak\icons\CitoU.bmp"
IC01,422,"c:\programs\gsak\icons\TrigpointU.bmp"
IC01,1101,"c:\programs\gsak\icons\EventFBug.bmp"
IC01,1102,"c:\programs\gsak\icons\LetterboxFBug.bmp"
IC01,1104,"c:\programs\gsak\icons\MicroFBug.bmp"
IC01,1105,"c:\programs\gsak\icons\MulticacheFBug.bmp"
IC01,1106,"c:\programs\gsak\icons\TraditionalFBug.bmp"
IC01,1107,"c:\programs\gsak\icons\UnknownFBug.bmp"
IC01,1120,"c:\programs\gsak\icons\MM_FBug.bmp"
IC01,1121,"c:\programs\gsak\icons\CitoFBug.bmp"
IC01,1201,"c:\programs\gsak\icons\EventNBug.bmp"
IC01,1202,"c:\programs\gsak\icons\LetterboxNBug.bmp"
IC01,1204,"c:\programs\gsak\icons\MicroNBug.bmp"
IC01,1205,"c:\programs\gsak\icons\MulticacheNBug.bmp"
IC01,1206,"c:\programs\gsak\icons\TraditionalNBug.bmp"
IC01,1207,"c:\programs\gsak\icons\UnknownNBug.bmp"
IC01,1220,"c:\programs\gsak\icons\MM_NBug.bmp"
IC01,1221,"c:\programs\gsak\icons\CitoNBug.bmp"
IC01,1301,"c:\programs\gsak\icons\EventOBug.bmp"
IC01,1302,"c:\programs\gsak\icons\LetterboxOBug.bmp"
IC01,1304,"c:\programs\gsak\icons\MicroOBug.bmp"
IC01,1305,"c:\programs\gsak\icons\MulticacheOBug.bmp"
IC01,1306,"c:\programs\gsak\icons\TraditionalOBug.bmp"
IC01,1307,"c:\programs\gsak\icons\UnknownOBug.bmp"
IC01,1320,"c:\programs\gsak\icons\MM_OBug.bmp"
IC01,1321,"c:\programs\gsak\icons\CitoOBug.bmp"
IC01,1401,"c:\programs\gsak\icons\EventUBug.bmp"
IC01,1402,"c:\programs\gsak\icons\LetterboxUBug.bmp"
IC01,1404,"c:\programs\gsak\icons\MicroUBug.bmp"
IC01,1405,"c:\programs\gsak\icons\MulticacheUBug.bmp"
IC01,1406,"c:\programs\gsak\icons\TraditionalUBug.bmp"
IC01,1407,"c:\programs\gsak\icons\UnknownUBug.bmp"
IC01,1420,"c:\programs\gsak\icons\MM_UBug.bmp"
IC01,1421,"c:\programs\gsak\icons\CitoUBug.bmp"
WP04, 52.4125, -1.748817, 205, "Hidden History - A Haul of Halls (Solihull) by Beer Monster (2/3 MR)", "MRNXK8", "\cmate://MRNXK8", 0.0, 1, "MRNXK8", 1, 1, "Multi", 0
WP04, 52.4068, -1.739233, 220, "Motorway Mayhem M42 J5 - Cow Hayes by Modge_uk (1/1.5 TM)", "TMXYX5", "\cmate://TMXYX5", 0.0, 1, "TMXYX5", 1, 1, "Micro", 0
WP04, 52.404267, -1.761617, 206, "Oaky Suburbs II by Caz & Guy (2/1.5 TR)", "TRNDV3", "\cmate://TRNDV3", 0.0, 1, "TRNDV3", 1, 1, "Traditional", 0
WP04, 52.399467, -1.74515, 1207, "ANTLER NOBS by wykenwizard & Auntie Clockwise (2/1 US)", "US10W53", "\cmate://US10W53", 0.0, 1, "US10W53", 1, 1, "Unknown", 0
WP04, 52.406445, -1.769267, 206, "Urban View - Solihull by Caz & Guy (2/2 TR)", "TRJGQA", "\cmate://TRJGQA", 0.0, 1, "TRJGQA", 1, 1, "Traditional", 0
WP04, 52.39995, -1.766667, 205, "HOW THE OTHER HALF LIVE by signyred (1.5/1.5 MS)", "MS12R7B", "\cmate://MS12R7B", 0.0, 1, "MS12R7B", 1, 1, "Multi", 0
WP04, 52.4009, -1.724167, 1207, "Uppa Cut !... by wykenwizard & Auntie Clockwise (2/2 US)", "US13GMY", "\cmate://US13GMY", 0.0, 1, "US13GMY", 1, 1, "Unknown", 0
WP04, 52.395467, -1.7319, 1207, "Don't beat around the bush by wykenwizard & Auntie Clockwise (2/1.5 US)", "US113D8", "\cmate://US113D8", 0.0, 1, "US113D8", 1, 1, "Unknown", 0
WP04, 52.396683, -1.774267, 206, "Station to Station - Widney Manor by Team Balders (2/2 TS)", "TS11Z5G", "\cmate://TS11Z5G", 0.0, 1, "TS11Z5G", 1, 1, "Traditional", 0
WP04, 52.390233, -1.736467, 207, "The Secret Policeman's Ball by wykenwizard & Auntie Clockwise (2/2 UM)", "UM13GM8", "\cmate://UM13GM8", 0.0, 1, "UM13GM8", 1, 1, "Unknown", 0
WP04, 52.40995, -1.788583, 206, "Tudor Grange - Solihull by Caz & Guy (1.5/1.5 TR)", "TRJKN9", "\cmate://TRJKN9", 0.0, 1, "TRJKN9", 1, 1, "Traditional", 0
WP04, 52.388017, -1.742833, 1205, "Rambo's Cache by Stag Ramblers and Machimbo (2/2.5 MS)", "MS13VXB", "\cmate://MS13VXB", 0.0, 1, "MS13VXB", 1, 1, "Multi", 0
WP04, 52.38805, -1.733717, 1105, "Knot in Knowle by wisewol (1.5/2 MR)", "MRTBYZ", "\cmate://MRTBYZ", 0.0, 1, "MRTBYZ", 1, 1, "Found", 0
WP04, 52.387133, -1.774617, 206, "Shelly Coppice (Solihull) by Beer Monster (2.5/1.5 TS)", "TSJM9Q", "\cmate://TSJM9Q", 0.0, 1, "TSJM9Q", 1, 1, "Traditional", 0
WP04, 52.423417, -1.701617, 1207, "The Sound of Laughter TB Lounge by beasy (1.5/1.5 UR)", "URZX6Y", "\cmate://URZX6Y", 0.0, 1, "URZX6Y", 1, 1, "Unknown", 0
WP04, 52.423417, -1.7016, 407, "The Currency Converter by beasy (2/2 US)", "US10Z9R", "\cmate://US10Z9R", 0.0, 1, "US10Z9R", 1, 1, "Unavailable", 0
WP04, 52.394467, -1.7073, 1105, "Elvers Enigma by Stag Ramblers (2.5/2.5 MS)", "MSYHMV", "\cmate://MSYHMV", 0.0, 1, "MSYHMV", 1, 1, "Found", 0
WP04, 52.409167, -1.6977, 206, "Virgin View by Stag Ramblers (1/2.5 TS)", "TSVE9H", "\cmate://TSVE9H", 0.0, 1, "TSVE9H", 1, 1, "Traditional", 0
WP04, 52.428033, -1.703983, 204, "Hampton Manor by beasy (1.5/1.5 TM)", "TM10R02", "\cmate://TM10R02", 0.0, 1, "TM10R02", 1, 1, "Micro", 0
WP04, 52.3982, -1.70235, 107, "HOB GOBLINS' HAUNT by wykenwizard (2/2 US)", "USZ7FN", "\cmate://USZ7FN", 0.0, 1, "USZ7FN", 1, 1, "Found", 0
WP04, 52.430367, -1.704967, 205, "Hampton Wood Wander by beasy (1.5/1 MU)", "MUWF0M", "\cmate://MUWF0M", 0.0, 1, "MUWF0M", 1, 1, "Multi", 0
WP04, 52.426900, -1.698133, 106, "Arden Railway Rummage by beasy (1/1.5 TS)", "TSXFYM", "\cmate://TSXFYM", 0.0, 1, "TSXFYM", 1, 1, "Found", 0
WP04, 52.420267, -1.69125, 406, "Hampton View by owhite5 (1.5/1.5 TS)", "TSZ2MF", "\cmate://TSZ2MF", 0.0, 1, "TSZ2MF", 1, 1, "Unavailable", 0
WP04, 52.422367, -1.692283, 1206, "Landslide Saint Mew Min by beasy (2/2 TS)", "TS126DB", "\cmate://TS126DB", 0.0, 1, "TS126DB", 1, 1, "Traditional", 0
WP04, 52.41965, -1.689083, 1205, "Packhorse Amble by wisewol (2/2 MS)", "MSV5V0", "\cmate://MSV5V0", 0.0, 1, "MSV5V0", 1, 1, "Multi", 0
WP04, 52.41965, -1.689083, 207, "Fentham Festivities- 12 days of Christmas by beasy (1/3 US)", "USZV8F", "\cmate://USZV8F", 0.0, 1, "USZV8F", 1, 1, "Unknown", 0
WP04, 52.419617, -1.68905, 207, "Down at the Beech- West Midlands by beasy (1.5/1.5 UM)", "UMZWCB", "\cmate://UMZWCB", 0.0, 1, "UMZWCB", 1, 1, "Unknown", 0
WP04, 52.419617, -1.689033, 407, "Near the lake...but where? by beasy (3/1.5 UM)", "UM13AJF", "\cmate://UM13AJF", 0.0, 1, "UM13AJF", 1, 1, "Unavailable", 0
WP04, 52.373300, -1.753517, 107, "Dorridge View 2 by pete3 (4/2.5 US)", "USWVBQ", "\cmate://USWVBQ", 0.0, 1, "USWVBQ", 1, 1, "Found", 0
WP04, 52.4309, -1.691933, 207, "Lights! Camera! Action! by beasy (1.5/1.5 UR)", "URZWQF", "\cmate://URZWQF", 0.0, 1, "URZWQF", 1, 1, "Unknown", 0
WP04, 52.38235, -1.790817, 220, "Motorway Mayhem M42 J4 - Monkspath Hill by Modge_uk (1/1.5 TM)", "TMXYX4", "\cmate://TMXYX4", 0.0, 1, "TMXYX4", 1, 1, "Micro", 0
WP04, 52.371633, -1.752200, 107, "Dorridge View 1 by pete3 (4/2.5 US)", "USWVB3", "\cmate://USWVB3", 0.0, 1, "USWVB3", 1, 1, "Found", 0
WP04, 52.443683, -1.704733, 104, "Bikers Paradise by JollyJax (1/1 TM)", "TMMMTD", "\cmate://TMMMTD", 0.0, 1, "TMMMTD", 1, 1, "Found", 0
WP04, 52.375283, -1.777533, 106, "M42 J4 TB Inn by wisewol (1/1 TR)", "TRTVAX", "\cmate://TRTVAX", 0.0, 1, "TRTVAX", 1, 1, "Found", 0
WP04, 52.413417, -1.6802, 206, "Windmill Farm by beasy (1.5/1.5 TS)", "TS1076F", "\cmate://TS1076F", 0.0, 1, "TS1076F", 1, 1, "Traditional", 0
WP04, 52.375517, -1.716, 204, "Post Haste by wykenwizard & Auntie Clockwise (1/1 TM)", "TM13VQ8", "\cmate://TM13VQ8", 0.0, 1, "TM13VQ8", 1, 1, "Micro", 0
WP04, 52.4238, -1.681733, 206, "Swan Lake by wykenwizard (1.5/1 TS)", "TSTJPZ", "\cmate://TSTJPZ", 0.0, 1, "TSTJPZ", 1, 1, "Traditional", 0
WP04, 52.417900, -1.818883, 405, "Surgical Stump by kool kidz (2/1.5 MS)", "MSYW3J", "\cmate://MSYW3J", 0.0, 1, "MSYW3J", 1, 1, "Unavailable", 0
WP04, 52.445967, -1.702233, 120, "Motorway Mayhem M42 J6 - Middle Bickenhill by Modge_uk (1/1.5 TM)", "TMXYX6", "\cmate://TMXYX6", 0.0, 1, "TMXYX6", 1, 1, "Found", 0
WP04, 52.390983, -1.685683, 205, "Blythe Spirit by wykenwizard (3/2 MU)", "MUTHGN", "\cmate://MUTHGN", 0.0, 1, "MUTHGN", 1, 1, "Multi", 0
WP04, 52.379733, -1.7, 207, "10 TO 10 ON WEDNESDAYS by signyred (2.5/2.5 US)", "US11EVA", "\cmate://US11EVA", 0.0, 1, "US11EVA", 1, 1, "Unknown", 0
WP04, 52.378433, -1.796917, 406, "The Blythering Monk by jdagnall (2/2.5 TR)", "TRJFJC", "\cmate://TRJFJC", 0.0, 1, "TRJFJC", 1, 1, "Unavailable", 0

[+Custheyder]

WP04, 52.378433, -1.796917, 406, "The Blythering Monk by jdagnall (2/2.5 TR)", "TRJFJC", "\cmate://TRJFJC", 0.0, 1, "TRJFJC", 1, 1, "Unavailable", 0[/code]

 

Excellent thanks. Lets see if I got this straight:

 

Waypoint, longitude, latitude, icon, title, GC Code, File .... then I'm lost as I see the GC code again and numbers. Do you know what the other columns are?

 

Thanks

Cust.

 

Edit: BTW What are the icons prefixed with O? F-Found, N-Not Found, U-Unavailable .... O-Archived?

Edited November 1, 2007 by Custheyder

[+Moote]

WP04, 52.378433, -1.796917, 406, "The Blythering Monk by jdagnall (2/2.5 TR)", "TRJFJC", "\cmate://TRJFJC", 0.0, 1, "TRJFJC", 1, 1, "Unavailable", 0[/code]

 

Excellent thanks. Lets see if I got this straight:

 

Waypoint, longitude, latitude, icon, title, GC Code, File .... then I'm lost as I see the GC code again and numbers. Do you know what the other columns are?

 

Thanks

Cust.

 

Edit: BTW What are the icons prefixed with O? F-Found, N-Not Found, U-Unavailable .... O-Archived?

 

Pop it into a text file and import it into Memory Map all will come clear

 

The "\cmate://TRJFJC" is for CacheMate use on the PPC, it could easily be a standard URL, or even a link into a GSAK Database (Version 7.xx only I think)

 

O from memory is caches which you own.

[+Custheyder]

Thanks for that.... I will do when the DVD arrives! I'm trying to get everything sorted in advance. I have GeoBuddy on my desktop and I'm hoping I can pursuade them to to create an output file I can import but they need more info and I hadn't been able to track it down "ontinternet".

 

If GoeBuddy won't oblige I'll write a little stand alone desktop app that'll just do a straight conversion.

 

It's what bored programmers do it their spare time!

 

Cheers

 

Cust.

[+Moote]

Just one thought, you will need to grab the icons, and also amend the path to reflect where GSAK is installed.

[+Custheyder]

Just one thought, you will need to grab the icons, and also amend the path to reflect where GSAK is installed.

 

Yup already spotted that one thanks.

 

There are of course other icon sets about as well ... LordDelph's for example. I just need to adjus the script to say where the icons live.

 

I might just create this as a stand alone app, just for the heck of it... and release it for free, of course.

[+roolku]

...or even a list of what each column is?

 

There is a comprehensive description in the memory map help file:

 

CSV Format

The CSV (Comma Separated Value) format supports Marks/Waypoints, Routes, Tracks, Text and Icons. Each line starts with a two letter code identifying the type of object described, followed by two numbers that represent the format version of the line.

 

Each icon line of the file is in the form:

 

IC01,Symbol,Name.bmp

 

Symbol is an integer indicating the symbol type. It must be an integer larger than 100. Use the same number in the WP lines to create marks using your defined symbols. The line describing the icon must precede any marks that use that icon.

 

Name.bmp is the name of a bitmap file. It can be the full path, or path relative to the folder containing the CSV file. The bitmap must be 32 by 32 pixels, 16-color, and saved without compression.

 

Each mark / waypoint line of the file is in the form:

 

WP04,Lat,Lon,Symbol,Name,Comment,File,Radius,Display,Unique,Visible,Locked,Category,Circle

 

Lat & Lon are in decimal degrees, on the WGS84 datum, N and E are positive, S and W are negative.

 

Symbol is an integer indicating the symbol type. Experiment with exporting some samples to get the values. -1 means use the icon of the linked file.

 

Name is the text name, which may be shown on the map (use quotes if the name contains a comma)

 

Comment is the comment shown in the properties, in escaped form to allow line-breaks

 

File is the full path of the linked HotSpot filename

 

Radius is the alarm/circle radius in meters. Enter 0 for no circle.

 

Display is an integer that controls the "Show label" flag. A value of 1 does not show the name, a value of 0 does. (The logic got inverted, somehow)

 

Unique is the unique name used when programming a GPS. Each waypoint must have a different unique name. No punctuation, etc, allowed. This may be left empty.

 

Visible is 1 to show the mark, 0 to hide it

 

Locked is 1 to lock the mark, 0 to unlock it.

 

Category is the category for the mark. Objects are organized by category in the Overlay Properties dialog, and you can hide or show all marks in a particular category using the Overlay -> Show All / Hide All menu commands.

 

Circle is the circle or alarm type:

0 - no circle, 1 - passive circle (no alarm), 2 - Proximity alarm, 3 - Anchor alarm

 

[...]

[+Custheyder]

Thanks roolku

 

Thats a great help. Im still waiting for my DVD to turn up.

 

Cust.