Improved Export From Gsak To Memory Map

October 29, 2005

2. There is also a problem with quotations in cache names, but I'm not sure if this is an easy fix or not. The tooltip that pops up for the cache when you hover the mouse over a cache with quotes in the title are blank and the hyperlink in some cases fails, but not always.

I don't appear to have the quotation mark problem you mention.

I've just tried it on 7 caches of various types and they all appear OK. I do enter the quotation marks in the "problem characters to remove from description box" in the GSAK custom export dialogue window. This seems to remove them from the cache name.

I also use %code %name in the "Waypoint description format" box. This gives me both the gc code and the cache name in the mouseover pop up.

HTH

3.3k · October 29, 2005

Fantastic! Thank you to The Royles and to The Motley Crew for your help! All three problems resolved now

I can go to sleep now, hehe :cool:

1.6k · October 30, 2005

Maybe it's me but I exported files in GSAK to a MM csv file then imported into MM. No fancy script.

As you export your GSAK files, a dialog box appears and there is a box which is called: GPS Symbols.

In this box it shows

Found=Circle

Not Found=Flag

etc

However, when imported the Placed and Archived caches show up as Square and Skull n Cross Bones which are not the ones listed in the box BUT with one export and one import, the caches show up with different icons. I thought this was a standard feature.

Comments

October 30, 2005

Every time I try to download this script I get 404 not found, is your webpage down and do I have to log it as a DNF?

October 30, 2005

If you look in the csv.xsl script for the first line that reads:

<xsl:value-of select="gpx:name"/>

and replace it with:

<xsl:value-of select="concat(gpx:name,' ',gpx:desc)"/>

This will work, but a more flexible way is to use the fields in the export dialog box. My currently looks like:

but I am sure it can be even more improved.

Cheers

Roolku

October 30, 2005

Every time I try to download this script I get 404 not found, is your webpage down and do I have to log it as a DNF?

Whoops. I seem to have accidently removed it from the we server. Now my current version is online. Various little changes, most I can't remember. :santa:

Have fun

Roolku

October 30, 2005

...noticed that Owner was set to

<xsl:when test="Groundspeak:cache/Groundspeak:owner='roolku'">

This line appears in two parts of the xsl file

I have now changed this to reflect who I am

With the current version, this only needs to be done once near the top of the file:

<xsl:variable name="me">roolku</xsl:variable>

It now also matches caches you have set with somebody else, but as a side effect, if your name is a subset of somebody elses name it will show their caches as owned as well.

Cheers

Roolku

2.5k · October 30, 2005

With the current version, this only needs to be done once near the top of the file:

<xsl:variable name="me">roolku</xsl:variable>

It now also matches caches you have set with somebody else, but as a side effect, if your name is a subset of somebody elses name it will show their caches as owned as well.

Cheers

Roolku

Could you use the number which GC.com gives you; that would prevent any spurious caches being added as your own?

You can find this number by floating your mouse over your name here and looking at the bottom left of your browser

Milton (aka Moote)

Edited October 30, 2005 by Moote

October 30, 2005

Could you use the number which GC.com gives you; that would prevent any spurious caches being added as your own?

Good idea. I have updated the zip file.

Roolku

October 30, 2005

Maybe it's me but I exported files in GSAK to a MM csv file then imported into MM. No fancy script.

As you export your GSAK files, a dialog box appears and there is a box which is called: GPS Symbols.

In this box it shows

Found=Circle

Not Found=Flag

etc

However, when imported the Placed and Archived caches show up as Square and Skull n Cross Bones which are not the ones listed in the box BUT with one export and one import, the caches show up with different icons. I thought this was a standard feature.

Comments

Lester,

Using Roolku's excellent script you can have icons that depict the type of cache, whether you placed it, have found it, not found it, whether it contains TB's etc. not merely the blue dots :santa:

I've sent you a PM with a demo JPG that shows some of the capabilities.

October 31, 2005

If you look in the csv.xsl script for the first line that reads:

<xsl:value-of select="gpx:name"/>

and replace it with:

<xsl:value-of select="concat(gpx:name,' ',gpx:desc)"/>

This will work, but a more flexible way is to use the fields in the export dialog box. My currently looks like:

but I am sure it can be even more improved.

Cheers

Roolku

Any chance you can put these settings in a text file so we can download it...............saves typos?

And there is no readme in the zip file now?

WoodSmoke

October 31, 2005

Any chance you can put these settings in a text file so we can download it...............saves typos?

And there is no readme in the zip file now?

WoodSmoke

Unfortunately I lost the original zip and so I had to create a new one from the working script in my gsak directory. If somebody still has the readme.txt - could you post it to me (roolku at blueyonder.co.uk) and I will update it to reflect the changes & include it in the zip again.

Cheers

Roolku

October 31, 2005

could you post it to me

Mail sent, hope it is the right one.

October 31, 2005

New zip file with readme.txt (including settings) now available at the old location: http://roolku.pwp.blueyonder.co.uk/gsak2mm.zip.

Enjoy

Robert

3.3k · October 31, 2005

Thanks again for your efforts, this really is invaluable!

November 1, 2005

Hi Rolku,

It's all working now thanx :-)

I have one small buglet.............I can only seem to save the file to a root dir of a drive?

If I use another location it goes through the process to completion, but no file is produced? I have searched the whole of my HD for the file.

Any ideas?

Is it your script or GSAK?

WoodSmoke

November 1, 2005

Hi Rolku,

It's all working now thanx :-)

I have one small buglet.............I can only seem to save the file to a root dir of a drive?

If I use another location it goes through the process to completion, but no file is produced? I have searched the whole of my HD for the file.

Any ideas?

Is it your script or GSAK?

WoodSmoke

It's ok, I've sorted it.....................put the path in "" :-)

WoodSmoke

November 21, 2005

What an excellent prog this is and thanks to Stuey who sorted it remotely for me and thanks to Roolku also for the script.

3.3k · November 21, 2005

What an excellent prog this is and thanks to Stuey who sorted it remotely for me

If anyone hasn't used the Remote Assistance tool in XP Pro, you should! It is very very cool, allowing one person to control mouse and keyboard on someone elses PC. I configured Dave's PC from the comfort of my own seat here at home :huh:

(EDIT to add... this type of technology only works once or twice, then the knowledge needs to be passed on .... a bit like pyramid selling )

Edited November 21, 2005 by Stuey

November 22, 2005

Cool piece of work here.

I do have a slight glitch in that not all the icons show on the pda with some coming out as blue dots.

Any ideas?

2.5k · November 22, 2005

Cool piece of work here.
I do have a slight glitch in that not all the icons show on the pda with some coming out as blue dots.

Any ideas?

There was something about this problem, I thought it was this Thread but must be another one as I can't see the answer, but it was something to do with the names of the cache types in the xsl file this is how that section of the xsl file should look:

<xsl:when test="Groundspeak:cache/Groundspeak:type='Other'">

<xsl:text>1</xsl:text>

</xsl:when>

<xsl:when test="Groundspeak:cache/Groundspeak:type='Event Cache'">

<xsl:text>01</xsl:text>

</xsl:when>

<xsl:when test="Groundspeak:cache/Groundspeak:type='Letterbox Hybrid'">

<xsl:text>02</xsl:text>

</xsl:when>

<xsl:when test="Groundspeak:cache/Groundspeak:type='Locationless (Reverse) Cache'">

<xsl:text>03</xsl:text>

</xsl:when>

<xsl:when test="Groundspeak:cache/Groundspeak:type='Multi-cache'">

<xsl:text>05</xsl:text>

</xsl:when>

<xsl:when test="Groundspeak:cache/Groundspeak:type='Virtual Cache'">

<xsl:text>08</xsl:text>

</xsl:when>

<xsl:when test="Groundspeak:cache/Groundspeak:type='Webcam Cache'">

<xsl:text>09</xsl:text>

</xsl:when>

<xsl:when test="Groundspeak:cache/Groundspeak:type='Earthcache'">

<xsl:text>10</xsl:text>

</xsl:when>

<xsl:when test="Groundspeak:cache/Groundspeak:type!='Traditional Cache'">

Milton

1.7k · November 22, 2005

I do have a slight glitch in that not all the icons show on the pda with some coming out as blue dots.

If memory serves me correctly, the blue dots are temporarily unavailable caches that have TBs in them. There is an icon for temped (red) and an icon for caches with TBs (with a little square in the corner) but not for temped with TBs.

To be honest, I don't find it a problem as I generally filter out the unavailable before plotting on memory map anyway.

T

Edit to add - there seems to be one for multis theat are temped with TBs but not others - how curious.

Edited November 22, 2005 by Pengy&Tigger

1.7k · November 22, 2005

Just to add a map showing all temped with TBs

The multi and the ones I have found are ok, but all others come out as blue dots.

2.5k · November 22, 2005

Just to add a map showing all temped with TBs

The multi and the ones I have found are ok, but all others come out as blue dots.

P&T

I think your script might be the old one, I Know Roolku answered a problem recently about the blue dots, I remember that Letterbox caches were coming out incorrect and he fixed the issue and identifed others also.

Milton (aka Moote)

2.5k · November 22, 2005

Found the fix, it was both Stuey and I that noticed some things, sthat reading in the Thread about Here

November 22, 2005

That is how mine reads moote?

Without the capitalisation of the namespace of course.

I do the same as pengy&tigger & filter for available caches only before doing an export. The dots do not show on the PC only the IPAQ

I can manually change the icons on the IPAQ but this sort of defeats the object.

November 22, 2005

It would appear to only be icons that show the presence of a TB, that end up showing the blue dot.

Has anyone else found this?

3.3k · November 22, 2005

Make sure your PDA has the latest patched version of Memory-Map (and your PC for that matter). There was a problem that there weren't enough custom icons on an older release. I have 4.4.3 and it is fine.

2.5k · November 22, 2005

Good Point Stuey

You can get the latest 2004 edition update from Memory Map update

Milton (aka Moote)

1k · January 1, 2006

is it me or is there a problem with the gask2mm.zip download?

1k · January 1, 2006

got it now

1.8k · January 14, 2006

New zip file with readme.txt (including settings) now available at the old location: http://roolku.pwp.blueyonder.co.uk/gsak2mm.zip.

Enjoy

Robert

Just downloaded this and there is no readme.txt - can someone send me the settings file?

1k · January 14, 2006

this is more or less what you need to know from the read me

So if you are still with me, here is the quick guide on how to use it:

1) get msxsl.exe from microsoft and copy it into GSAK directory (usually

C:\program files\gsak)

http://www.microsoft.com/downloads/details...E9-DB4816552E41

2) if you don't have internet explorer 6 you will need to get MSXML 4.0

and install it

http://www.microsoft.com/downloads/details...b6-c5d7485f2b42

3) get the zip file from my website

http://roolku.pwp.blueyonder.co.uk/gsak2mm.zip

4a) put the xsl script (csv.xsl) in the GSAK directory (usually

C:\program files\gsak)

4b) extract the icons from the zip file to c:\program files\gsak\icons

(if you extract the zipfiles with directories to c:\ it should put

things in the right place automatically)

5) open the file csv.xsl and edit line 5 to contain your personal

geocaching id instead of the 217511. This id can be found by floating

your mouse over your name in the forums here and looking at the bottom

left of your browser.

<xsl:variable name="me">217511</xsl:variable>

6) in GASK open "File/Export/GPSBabel custom export" and enter the

following values:

Waypoint name: %typ1%con1%drop2%notGC%code

Problem characters: ",

Waypoint description: %typ1%con1%drop2 - %name%notGC%code - %name

Statement to run: "c:\program files\gsak\msxsl" "c:\program files\gsak\temp\babel.gpx" csv.xsl -o c:\geocache.csv

Experienced users might like to adjust some of the settings to their

taste, especially Waypoint name/description using the usual gsak shorthands.

7) click <Generate> and you should get a geocache.csv file ready for import into memory map

Edited January 14, 2006 by lost it

1.8k · January 14, 2006

Thanks very much - tha tis very helpful. It looks like I have the readme after all - the originator's instructions as to file locations appear faulty.

Edited January 14, 2006 by Learned Gerbil

January 15, 2006

Thanks!

There was something in the instructions that got me up and running to :tired:

January 16, 2006

the originator's instructions as to file locations appear faulty.

Could you let me know what instructions as to file locations you are referring to so I can correct them.

Cheers

Roolku

1k · January 16, 2006

the paths are incorrect if you are using XPx64, but thats just a matter of changing the programs directory and adding the (x86) to the paths

1.8k · January 16, 2006

All I know is I followed the instructions near the top of this thread and ended up with a whole load of files in a load of folders where I wasn't expecting them whic his wh yI couldn't find the readme.txt. Once I had put everythig nwhere i expected it to be it all worked and I found the instructions.

2.5k · January 16, 2006

The version I am using can display offline web pages on your PDA when you tap on the icon, really cool

Here is the block of code

Replace this section

<xsl:value-of select="gpx:name"/>

<xsl:text>", "</xsl:text>

<xsl:value-of select="gpx:url"/>

<xsl:text>&decrypt=y&pf=n&log=y</xsl:text>

With

<xsl:value-of select="gpx:name"/>

<xsl:text>", "</xsl:text>

<xsl:text>\Storage Card\Cache\</xsl:text>

<xsl:number/>

<xsl:text>.htm</xsl:text>

Not my work but the work of The Royals

You then need to run a GSAK HTML export and drag it onto the root of the storage card

N.B. Some devices call their Storage Card - SD Card amend as required.

Moote

1.8k · January 16, 2006

Very impressive! Thanks Moote!

1.7k · January 16, 2006

Excellent work, many thanks for that, just wish i could understand it :grin: .

A couple of questions:

1) What would I need to do to stop trad micros being in a category of there own ie just get the traditional cache icon.

2) We use the "other" category to list additional waypoints associated with a cache ie additional points on a multi/puzzle or parking. It would be useful if we could either exclude any related to owned / found / unavailable caches or have 4 separate categories for "other" so we can filter them in MM

January 17, 2006

1) What would I need to do to stop trad micros being in a category of there own ie just get the traditional cache icon.

Remove these lines (2 seperate blocks of four lines):

<xsl:when test="Groundspeak:cache/Groundspeak:container='Micro'">

<xsl:text>04</xsl:text>

</xsl:when>



<xsl:when test="Groundspeak:cache/Groundspeak:container='Micro'">

<xsl:text>Micro</xsl:text>

</xsl:when>

4 separate categories for "other" so we can filter them in MM

Let me know what you call them, and I will look at it for you.

1.7k · January 17, 2006

You're the man / woman :anibad: , that worked a treat, many thanks.

As for the names for the others category, just the standard Found / Unfound / Owned / Unavailable would do nicely with no extra icons required. The icon currently used I assume is a standard MM icon, what would I need to do to change this?

When I run the script on 12000 waypoints it takes about 15 minutes to complete, is this normal or do I need to put more coal in the puter? When I run my own GSAK macro to do the same (but knowhere near as refined) it takes less than 1 minute to complete.

1.7k · January 17, 2006

As for the names for the others category, just the standard Found / Unfound / Owned / Unavailable would do nicely with no extra icons required. The icon currently used I assume is a standard MM icon, what would I need to do to change this?

What would be good is if the "Others" category could be handled in the same way as all the other categories, ie if found, unavailable or owned they are included in those groups in MM so if you hide all found caches the found others are also hidden. If unfound they would be included in the Others group.

January 17, 2006

so if you hide all found caches the found others are also hidden. If unfound they would be included in the Others group

My head hurts :anibad:

Seriously, I figured out what you mean and will have a look.

January 17, 2006

As for the names for the others category, just the standard Found / Unfound / Owned / Unavailable would do nicely with no extra icons required. The icon currently used I assume is a standard MM icon, what would I need to do to change this?

What would be good is if the "Others" category could be handled in the same way as all the other categories, ie if found, unavailable or owned they are included in those groups in MM so if you hide all found caches the found others are also hidden. If unfound they would be included in the Others group.

First thing to do is back up your file !

Find the block of lines

<xsl:if test="count(Groundspeak:cache/Groundspeak:travelbugs/Groundspeak:travelbug)>'0'">1</xsl:if>
<xsl:choose>



<xsl:when test="Groundspeak:cache/Groundspeak:type='Other'">

<xsl:text></xsl:text>

</xsl:when>

and delete

<xsl:when test="Groundspeak:cache/Groundspeak:type='Other'">

<xsl:text></xsl:text>

</xsl:when>

Then find the block of lines

<xsl:text>, "</xsl:text>
<xsl:choose>



<xsl:when test="Groundspeak:cache/Groundspeak:type='Other'">

<xsl:text>Other</xsl:text>

</xsl:when>



<xsl:when test="Groundspeak:cache/Groundspeak:owner/@id=$me">

<xsl:text>Owned</xsl:text>

</xsl:when>



<xsl:when test="gpx:sym='Geocache Found'">

<xsl:text>Found</xsl:text>

</xsl:when>



<xsl:when test="Groundspeak:cache/@available='False'">

<xsl:text>Unavailable</xsl:text>

</xsl:when>

and move the top four lines to the bottom of the block so it reads

<xsl:text>, "</xsl:text>
<xsl:choose>



<xsl:when test="Groundspeak:cache/Groundspeak:owner/@id=$me">

<xsl:text>Owned</xsl:text>

</xsl:when>



<xsl:when test="gpx:sym='Geocache Found'">

<xsl:text>Found</xsl:text>

</xsl:when>



<xsl:when test="Groundspeak:cache/@available='False'">

<xsl:text>Unavailable</xsl:text>

</xsl:when>



<xsl:when test="Groundspeak:cache/Groundspeak:type='Other'">

<xsl:text>Other</xsl:text>

</xsl:when>

This separates the "other" caches into other, owned, found and unavailable.

If you add the lines

<xsl:text>IC01,31,"c:\program files\gsak\icons\OwnedOther.bmp"
</xsl:text>

<xsl:text>IC01,11,"c:\program files\gsak\icons\FoundOther.bmp"

</xsl:text>

<xsl:text>IC01,41,"c:\program files\gsak\icons\UnavailableOther.bmp"

</xsl:text>

<xsl:text>IC01,21,"c:\program files\gsak\icons\Other.bmp"

</xsl:text>

to the block of icons at the top of the file, and design your own icons for OwnedOther.bmp, FoundOther.bmp, UnavailableOther.bmp, and Other.bmp in your GSAK\icons directory all should work how you want.

If not PM or email me, as I am feeling guilty that we are hijacking a thread

Apologies to all who are not interested, but I thought that one or two may be following this, so I put it up for the world to see.

1.7k · January 19, 2006

Great stuff, worked a treat many thanks.

Sorry everyone for hijacking this thread a bit :anitongue:

January 20, 2006

I must say I am a little puzzled. The "other" (waypoint) category is for non-geocache waypoints such as your house, the carpark etc. Why would you want to "find" these? What am I missing?

January 21, 2006

2) We use the "other" category to list additional waypoints associated with a cache ie additional points on a multi/puzzle or parking. It would be useful if we could either exclude any related to owned / found / unavailable caches or have 4 separate categories for "other" so we can filter them in MM

Been overtaken now by the new GC features (when we get our heads round them)

February 14, 2006

This script just keeps getting better better!!!

I guess the next challenge is to get all non-GC waypoints into another catagory,love the html add-in bit Moote (sorry that should be Royles).

Keep up the good work chaps/chapesses/chaplets.

Improved Export From Gsak To Memory Map

Recommended Posts

Join the conversation