+Deckyon Posted February 18, 2005 Share Posted February 18, 2005 I have set up a batch file that loads GSAK to run a specific macro. After downloading my personal querys as zip files, I kick off this macro. In short, here is what it does: 1. Imports each of the 4 queries into my database 2. Selects my Home point 3. Exports gpx files based on different saved queries 1. 0-25 miles 2. 25-50 miles 3. 50-75 miles 4. 75-100 miles ... x. 475-500 miles xx. My Found caches 4. From there I copy the GPX files to my SD card and plug it into my PDA. 5. On my PDA, I run either GPX Sonar or GPX view and select the file I want to use. I do this because on PPc, the files load into memory, and by having multiple GPX files, I can keep the PPC memory clear for the GPS apps and still have enough caches to search through... I have over 4000 caches in the files, more than enough to keep me plenty busy. While there is a bit of prep work in setting up the saved queries, it is worth it. What used to take me 30 minutes or more to do by hand now takes less than 5 minutes in the background while I work on something else. If someone is interested, I can post the macro file for others to use. Quote Link to comment
+Dan_Edwards Posted February 19, 2005 Share Posted February 19, 2005 Actually I would be interested to see the macro. One thing I really need to do is setup a batch file that would automate the process of downloading the .zip files from my email program (thunderbird) and then launch GSAK to automaticly update my SD card for my GPS and my Palm and Cachemate. In order to really make this work I would need two SD card readers, and four SD cards (two in PC and one in each unit) then swap them each weekend. Anouther thing that would be worth posting is arc/poly lines. I know I can generate them pretty easy with TopoUSA, but it still takes time to follow roads or encompass a park (I use it include or exclude cache within Rocky Mountain National Park) Quote Link to comment
+Hi-Tek Posted February 19, 2005 Share Posted February 19, 2005 Actually I would be interested to see the macro. One thing I really need to do is setup a batch file that would automate the process of downloading the .zip files from my email program (thunderbird) and then launch GSAK to automaticly update my SD card for my GPS and my Palm and Cachemate. In order to really make this work I would need two SD card readers, and four SD cards (two in PC and one in each unit) then swap them each weekend. Anouther thing that would be worth posting is arc/poly lines. I know I can generate them pretty easy with TopoUSA, but it still takes time to follow roads or encompass a park (I use it include or exclude cache within Rocky Mountain National Park) because I work away from home for several days at a time I found that my email box was 'filling up' and I was getting 'Mailbox over the watermark' warnings from my service provider - result some emails were being bounced. To overcome this problem I downloaded a free email client called Calypso. I set this up to check my email several times a day and download any Pq attachments into a specific folder and delete them from the email. I then get Win2K to schedule the following simple GSAK Macro to load the PQ's. DATABASE Name="UK All" Action=select LOAD Settings="Open All" FILTER name="Dummy" EXPORT Type=gpx File="D:\GSAK GPX Files\Dummy.gpx" EXIT Note: The Dummy.gpx file is created to ensure that there is always a file in the folder to load. If the folder is empty then the macro pauses warning that there are no files in the folder and waits for the OK button to be pressed before continuing - no good when I'm not there. Something similar to the above should enable you to get the results you desire. Quote Link to comment
+Deckyon Posted February 21, 2005 Author Share Posted February 21, 2005 Here is the full step by step of my macro. First, create an "Open GPX/LOC File" profile. This will allow you to call it from within your macro. Since I am using an SD card in my Axim for the geocache files, I make sure it is in my card reader and assigned a driveletter - preferably the same drive letter all the time. Next, create a .cmd file (win NT, 2000 and XP) or .bat file (win 95, 98, ME) containing the following lines: CD "<SD Drive>:\My Documents\geocaches\"MKDIR geocaches Echo Hit ENTER to run GSAK in Automated Mode PAUSE "C:\Program Files\GSAK\GSAK.exe" /run "C:\Program Files\GSAK\Macros\AximExport.txt" EXIT * Change "<SD Drive>" to match the drive letter you have, and the path to where you want to store the exports. Now, in GSAK, set up the following Stored filters: "000-025 Miles""025-050 Miles" "050-075 Miles" "075-100 Miles" "100-125 Miles" "125-150 Miles" "150-175 Miles" "175-200 Miles" "200-225 Miles" "225-250 Miles" "250-275 Miles" "275-300 Miles" "300-325 Miles" "325-350 Miles" "350-375 Miles" "375-400 Miles" "400-425 Miles" "425-450 Miles" "450-475 Miles" "475-500 Miles" "Found" * I use these to help with keeping memory free on the Axim when the GPXSonar app is running. Speeds up the searches. Enter your home coordinates as the HOME location in the Options. Make sure it is set for HOME. Now, create a txt file that matches what is in the cmd or bat file above and paste the following text: LOAD Settings="Default" database="Default"DATABASE Name="Default" Action=select CENTRE LOCATION="Home" FILTER Name="000-025 Miles" EXPORT Type=GPX File="<SD Drive>:\My Documents\geocaches\000-025_Miles.gpx" ENDFILTER FILTER Name="025-050 Miles" EXPORT Type=GPX File="<SD Drive>:\My Documents\geocaches\025-050_Miles.gpx" ENDFILTER FILTER Name="050-075 Miles" EXPORT Type=GPX File="<SD Drive>:\My Documents\geocaches\050-075_Miles.gpx" ENDFILTER FILTER Name="075-100 Miles" EXPORT Type=GPX File="<SD Drive>:\My Documents\geocaches\075-100_Miles.gpx" ENDFILTER FILTER Name="100-125 Miles" EXPORT Type=GPX File="<SD Drive>:\My Documents\geocaches\100-125_Miles.gpx" ENDFILTER FILTER Name="125-150 Miles" EXPORT Type=GPX File="<SD Drive>:\My Documents\geocaches\125-150_Miles.gpx" ENDFILTER FILTER Name="150-175 Miles" EXPORT Type=GPX File="<SD Drive>:\My Documents\geocaches\150-175_Miles.gpx" ENDFILTER FILTER Name="175-200 Miles" EXPORT Type=GPX File="<SD Drive>:\My Documents\geocaches\175-200_Miles.gpx" ENDFILTER FILTER Name="200-225 Miles" EXPORT Type=GPX File="<SD Drive>:\My Documents\geocaches\200-225_Miles.gpx" ENDFILTER FILTER Name="225-250 Miles" EXPORT Type=GPX File="<SD Drive>:\My Documents\geocaches\225-250_Miles.gpx" ENDFILTER FILTER Name="250-275 Miles" EXPORT Type=GPX File="<SD Drive>:\My Documents\geocaches\250-275_Miles.gpx" ENDFILTER FILTER Name="275-300 Miles" EXPORT Type=GPX File="<SD Drive>:\My Documents\geocaches\275-300_Miles.gpx" ENDFILTER FILTER Name="300-325 Miles" EXPORT Type=GPX File="<SD Drive>:\My Documents\geocaches\300-325_Miles.gpx" ENDFILTER FILTER Name="325-350 Miles" EXPORT Type=GPX File="<SD Drive>:\My Documents\geocaches\325-350_Miles.gpx" ENDFILTER FILTER Name="350-375 Miles" EXPORT Type=GPX File="<SD Drive>:\My Documents\geocaches\350-375_Miles.gpx" ENDFILTER FILTER Name="375-400 Miles" EXPORT Type=GPX File="<SD Drive>:\My Documents\geocaches\375-400_Miles.gpx" ENDFILTER FILTER Name="400-425 Miles" EXPORT Type=GPX File="<SD Drive>:\My Documents\geocaches\400-425_Miles.gpx" ENDFILTER FILTER Name="425-450 Miles" EXPORT Type=GPX File="<SD Drive>:\My Documents\geocaches\425-450_Miles.gpx" ENDFILTER FILTER Name="450-475 Miles" EXPORT Type=GPX File="<SD Drive>:\My Documents\geocaches\450-475_Miles.gpx" FILTER Name="475-500 Miles" EXPORT Type=GPX File="<SD Drive>:\My Documents\geocaches\475-500_Miles.gpx" ENDFILTER FILTER Name="Found" EXPORT Type=GPX File="<SD Drive>:\My Documents\geocaches\Found.gpx" ENDFILTER EXIT I created a link to the cmd file (located in the GSAK directory) and run it after I have downloaded the zip files into the directory specified in the "Open GPX/LOC File" profile and run the cmd file. Quote Link to comment
+habot Posted February 21, 2005 Share Posted February 21, 2005 Main Macro # GSAK Update LOAD Setting="GSAK Update" # Data for Belgium FILTER Name="99 BE Main" EXPORT Type=OZI File="D:\Geocaching\ExpOZI\GC Belgique.wpt" FILTER Name="99 BE Antwerpen" EXPORT Type=GPX File="D:\Geocaching\ExpGPX\GC BE Antwerpen.gpx" FILTER Name="99 BE Brabant wallon" EXPORT Type=GPX File="D:\Geocaching\ExpGPX\GC BE Brabant wallon.gpx" FILTER Name="99 BE Hainaut" EXPORT Type=GPX File="D:\Geocaching\ExpGPX\GC BE Hainaut.gpx" FILTER Name="99 BE Limburg" EXPORT Type=GPX File="D:\Geocaching\ExpGPX\GC BE Limburg.gpx" FILTER Name="99 BE Liège" EXPORT Type=GPX File="D:\Geocaching\ExpGPX\GC BE Liège.gpx" FILTER Name="99 BE Luxembourg" EXPORT Type=GPX File="D:\Geocaching\ExpGPX\GC BE Luxembourg.gpx" FILTER Name="99 BE Namur" EXPORT Type=GPX File="D:\Geocaching\ExpGPX\GC BE Namur.gpx" FILTER Name="99 BE Oost-Vlaanderen" EXPORT Type=GPX File="D:\Geocaching\ExpGPX\GC BE Oost-Vlaanderen.gpx" FILTER Name="99 BE Vlaams-Brabant" EXPORT Type=GPX File="D:\Geocaching\ExpGPX\GC BE Vlaams-Brabant.gpx" FILTER Name="99 BE West-Vlaanderen" EXPORT Type=GPX File="D:\Geocaching\ExpGPX\GC BE West-Vlaanderen.gpx" FILTER Name="99 BE _non affectées" EXPORT Type=GPX File="D:\Geocaching\ExpGPX\GC BE Autres.gpx" # Data for Luxemburg FILTER Name="99 LU Main" EXPORT Type=GPX File="D:\Geocaching\ExpGPX\GC Luxembourg.gpx" EXPORT Type=OZI File="D:\Geocaching\ExpOZI\GC Luxembourg.wpt" # Data for BeLuc - Split TTN3 FILTER Name="R BeLux Arc" EXPORT Type=POI File="D:\Geocaching\ExpTTN\GC BeLux Arc.ov2" FILTER Name="R BeLux Found" EXPORT Type=POI File="D:\Geocaching\ExpTTN\GC BeLux Found.ov2" FILTER Name="02 Traditional" EXPORT Type=POI File="D:\Geocaching\ExpTTN\GC BeLux Tra.ov2" FILTER Name="02 Multicache" EXPORT Type=POI File="D:\Geocaching\ExpTTN\GC BeLux Mul.ov2" FILTER Name="02 Mystery" EXPORT Type=POI File="D:\Geocaching\ExpTTN\GC BeLux Mys.ov2" FILTER Name="02 Virtual" EXPORT Type=POI File="D:\Geocaching\ExpTTN\GC BeLux Vir.ov2" FILTER Name="02 WebCam" EXPORT Type=POI File="D:\Geocaching\ExpTTN\GC BeLux Cam.ov2" FILTER Name="NONE" Macro for "Campaign" # Campagne FILTER Name="00 Campagne" EXPORT Type=GPX File="D:\Geocaching\ExpGPX\GC Campagne.gpx" EXPORT Type=OZI File="D:\Geocaching\ExpOZI\GC Campagne.wpt" EXPORT Type=OZI File="D:\Geocaching\ExpOZI\GC Campagne Park.wpt" EXPORT Type=OZI File="D:\Geocaching\ExpTTN\GC Campagne.ov2" FILTER Name="NONE" Quote Link to comment
+caderoux Posted February 22, 2005 Share Posted February 22, 2005 Here's my Outlook Macro: Public Sub GetAttachments() On Error GoTo GetAttachments_err Dim ns As NameSpace Dim Inbox As MAPIFolder Dim SubFolder As MAPIFolder Dim DestFolder As MAPIFolder Dim Item As Object Dim Msg As MailItem Dim Atmt As Attachment Dim i As Integer Dim DoMove As Boolean Set ns = GetNamespace("MAPI") Set Inbox = ns.GetDefaultFolder(olFolderInbox) Set SubFolder = Inbox.Folders("Geocaching").Folders("ToProcess") Set DestFolder = Inbox.Folders("Geocaching").Folders("Processed") If SubFolder.Items.Count = 0 Then Exit Sub End If i = 0 For Each Item In SubFolder.Items If TypeOf Item Is MailItem Then Set Msg = Item If Msg.Attachments.Count <> 0 Then DoMove = False For Each Atmt In Msg.Attachments If Atmt.FileName Like "*.zip" Then Atmt.SaveAsFile "C:\Documents and Settings\Cade\Desktop\Geocaching\" & Atmt.FileName i = i + 1 DoMove = True End If Next Atmt If DoMove Then Msg.FlagIcon = olNoFlagIcon Msg.FlagStatus = olNoFlag Msg.Save Msg.Move DestFolder End If End If End If Next Item If i > 0 Then MsgBox i & " attached files saved.", vbInformation, "Finished!" End If GetAttachments_exit: Set Atmt = Nothing Set Item = Nothing Set ns = Nothing Exit Sub GetAttachments_err: MsgBox "An unexpected error has occurred." _ & vbCrLf & "Please note and report the following information." _ & vbCrLf & "Macro Name: GetAttachments" _ & vbCrLf & "Error Number: " & Err.Number _ & vbCrLf & "Error Description: " & Err.Description, vbCritical, "Error!" Resume GetAttachments_exit End Sub Here's my batch file which creates a gsak script: @echo off :begin echo # GSAK File Generated By Batch File >geoprep.gsak if not exist 31327.zip goto next1 echo LOADING Unfound echo LOAD File="C:\Documents and Settings\Cade\Desktop\Geocaching\31327 - Unfound.gpx" >>geoprep.gsak del 31327*.gpx wzunzip 31327.zip ren 31327.gpx "31327 - Unfound.gpx" del 31327.zip :next1 if not exist 40314.zip goto next2 echo LOADING Watched echo LOAD File="C:\Documents and Settings\Cade\Desktop\Geocaching\40314 - Watched Caches.gpx" >>geoprep.gsak del 40314*.gpx wzunzip 40314.zip ren 40314.gpx "40314 - Watched Caches.gpx" del 40314.zip :next2 if not exist 40315.zip goto next3 echo LOADING New echo LOAD File="C:\Documents and Settings\Cade\Desktop\Geocaching\40315 - New Caches.gpx" >>geoprep.gsak del 40315*.gpx wzunzip 40315.zip ren 40315.gpx "40315 - New Caches.gpx" del 40315.zip :next3 if not exist 40940.zip goto next4 echo LOADING Found echo LOAD File="C:\Documents and Settings\Cade\Desktop\Geocaching\40940 - Found Caches.gpx" >>geoprep.gsak del 40940*.gpx wzunzip 40940.zip ren 40940.gpx "40940 - Found Caches.gpx" del 40940.zip :next4 if not exist 168193.zip goto next5 echo LOADING Found echo LOAD File="C:\Documents and Settings\Cade\Desktop\Geocaching\168193 - New 2.gpx" >>geoprep.gsak del 168193*.gpx wzunzip 168193.zip ren 168193.gpx "168193 - New 2.gpx" del 168193.zip :next5 if not exist 73297.zip goto next6 del 73297*.gpx wzunzip 73297.zip start 73297.gpx /wait ren 73297.gpx "73297 - Cambridge.gpx" del 73297.zip :next6 if not exist 84588.zip goto next7 del 84588*.gpx wzunzip 84588.zip ren 84588.gpx "84588 - Miami.gpx" del 84588.zip :next7 if not exist 84983.zip goto next8 del 84983*.gpx wzunzip 84983.zip ren 84983.gpx "84983 - London.gpx" del 84983.zip :next8 if not exist 84985.zip goto next9 del 84985*.gpx wzunzip 84985.zip ren 84985.gpx "84985 - Waddesdon.gpx" del 84985.zip :next9 if not exist 106573.zip goto end echo LOADING Orlando echo LOAD File="C:\Documents and Settings\Cade\Desktop\Geocaching\106573 - Orlando Caches.gpx" >>geoprep.gsak del 106573*.gpx wzunzip 106573.zip ren 106573.gpx "106573 - Orlando Caches.gpx" del 106573.zip :end echo FILTER Name="Hitlist" >>geoprep.gsak echo EXPORT Type=GPX File="C:\Documents and Settings\Cade\Desktop\Geocaching\hitlist.gpx" >>geoprep.gsak "C:\Program Files\GSAK3\GSAK" /run "C:\Documents and Settings\Cade\Desktop\Geocaching\geoprep.gsak" :finish I know that technically you don't need to unzip the files, but I like to rename the original GPX files so I know the names and put them on my iPaq, too. Quote Link to comment
+ClydeE Posted February 22, 2005 Share Posted February 22, 2005 (edited) The following macro will generate a route of caches that are the closest distance from each other for a "cache raid" Basically, the macro allows you to build a "cache chain". You select a cache then the macro will build a database of a direct route of the caches that are the shortest distance from last one (of course ignoring caches that are already in your "cache chain"). You can then use this "route" to plan your next cache raid. Note: this is not quite as sophisticated as selecting a centre point then doing the calculations to provide the shortest route to collect all caches within x miles of this point (I'm not even sure how I would do this). This version just keeps on selecting the cache that is the next closest then adds it to the "cache raid" database. So depending what your starting cache is, and how many you want for this "cache raid" you could end up anywhere (of course you could always start by setting a filter that is x miles from your starting point to make sure you don't end up too far from your starting point) Unfortunately, there is no looping (yet) in GSAK so you need to copy the requried block of code for as many caches as you want in your "cache chain". The sample macro will generate 5 caches in the chain, but of course you can change this to suit yourself. The macro is quite convoluted but it does get the job done. It is also a good exercise to view the various commands used. There are a few things you need to be aware of to get this version of the macro to work. 1. Create 2 new empty databases called "chain1" and "chain2" 2. Create 2 new Move/Copy settings called "chain1" and "chain2" (see pictures at the end) 3. You must have a saved filter called "User flag = set" and the only item in this filter should be user flag = set. (default filter shipped with GSAK) 4. Change the line just after "# select the starting database again" to reflect your starting database (mine was Clyde2) # create a chain of waypoints starting at the currently selected one# depending on your settings some of the following commands may not # be required, however by putting these in this makes sure this macro # will work no matter what your current sort sequence is or what settings # you have # remove the following # if you would like to see this macro execute one line at a time #debug status=on # first clear all user flags userflag type=clear range=all # set user flag for starting cache userflag type=set range=1 # make sure the chain1 and chain2 databases are empty Database name="chain1" action=delete Database name="chain2" action=delete Database name="chain1" action=create Database name="chain2" action=create # select the starting database again because the previouse create automatically changes the database database name="clyde2" # select a filter here (remove the #) if you don't want the whole database to be used in the cache chain # Note: your starting waypoint must meet this filter condition also, otherwise the macro won't work. # Filter name="my filter" # copy over all waypoints in this subset to chain1 database movecopy settings="chain1" Database name="chain1" #set center to the starting waypoint filter name="user flag = set" center sort by="distance" # now start moving waypoints to the chain2 database goto position=top userflag type=set range=1 filter name="user flag = set" movecopy settings="chain2" sort by="distance" cancelfilter goto position=top center goto position=top userflag type=set range=1 filter name="user flag = set" movecopy settings="chain2" cancelfilter sort by="distance" goto position=top center goto position=top userflag type=set range=1 filter name="user flag = set" movecopy settings="chain2" cancelfilter sort by="distance" goto position=top center goto position=top userflag type=set range=1 filter name="user flag = set" movecopy settings="chain2" cancelfilter sort by="distance" goto position=top center goto position=top userflag type=set range=1 filter name="user flag = set" movecopy settings="chain2" cancelfilter sort by="distance" goto position=top center # finally select the chain 2 database and sort in natural order database name="chain2" sort by="natural" goto position=top Chain1 move copy Chain2 move copy Edited February 22, 2005 by ClydeE Quote Link to comment
+trippy1976 Posted February 22, 2005 Share Posted February 22, 2005 This is so freakin' excellent. GSAK just keeps getting better and better for me. I hadn't even tapped into macros yet, but this will make my life much easier. Now if only my 60CS had a cradle or took a SD card... Quote Link to comment
+SnoWake Posted February 25, 2005 Share Posted February 25, 2005 Clyde: That macro is way cool, and rather clever, as well. I bumped it up to creating a string of 10 caches, and it's working as-advertised. The only thing that seems a bit odd is that it generates an alert box on each pass through, that reads "Error: Filter contains 0 waypoints - it will now be cleared" - and the user has to acknowledge this - so, I have to sit here and watch it run, and hit enter 10 times - it would be nice if that alert could be supressed, at least in this context. One more quick question: Once this macro completes, and GSAK is displaying the chain2 database with the (in my case, 10) 'chained' waypoints - what does the value in the distance column represent? The distance between the current cache, and the next one in the list - or vice versa? I can't quite make sense of it. Either way - it's definitely cool. Couple this feature with the new(ish) "Cache Density" option available in the HTML export, and you've got some pretty useful tools for designing a "cache raid", as you so appropriately put it. I sometimes think of them as a blitz, or a spree, or even a rampage... If it's simply a matter of storage space, I would be happy to host a library of GSAK macros at http://www.gotwake.com/ - but the Forums and/or gsak.net are probably more suitable locations. Let me know if there's anything I can do to be of assistance, and... Thanks! Billy Quote Link to comment
+SnoWake Posted February 25, 2005 Share Posted February 25, 2005 (edited) Here's a fairly simple macro I use to process my incoming GPX files (PQs) by importing into GSAK, and then filtering and exporting to CacheMate, Streets and Trips, and even (optionally) the GPSr: # Load directory of NotFound GPX files - includes database selection LOAD Settings=ClearLoadNotFound Database=NotFound # Export ALL Not Found caches to CacheMate EXPORT Type=CMT Settings=CMnotfound # Center on home CENTRE Location=Home # Apply "Close" filter - selecting < 1000 caches closest to home FILTER Name=close # Export to HTML EXPORT Type=HTML Settings=HomeNotFound # Export to Streets and Trips EXPORT Type=SNT Settings=HomeNotFound # Send to GPS receiver PAUSE Msg="Is GPSr connected?" EXPORT Type=GPS Settings=60CS Of course, you would have to customize to match your database and settings names, etc. Nothing fancy, but it sure saves me a whole bunch of clicks! I've just started using the Thunderbird "Attachment Extractor" plug-in, which streamlines the process of downloading/saving the attachments - but I'm considering this a temporary fix, until Clyde adds POP support and (once again) further simplifies the whole process. Let me know if you've got any questions, Billy Edited February 25, 2005 by SnoWake Quote Link to comment
+ClydeE Posted February 25, 2005 Share Posted February 25, 2005 The only thing that seems a bit odd is that it generates an alert box on each pass through, that reads "Error: Filter contains 0 waypoints - it will now be cleared" - and the user has to acknowledge this - so, I have to sit here and watch it run, and hit enter 10 times - it would be nice if that alert could be supressed, at least in this context. What version of GSAK are you running? (Help=>About) This issue should have been resolved in the latest public release (5.1.1) available at http://gsak.net One more quick question: Once this macro completes, and GSAK is displaying the chain2 database with the (in my case, 10) 'chained' waypoints - what does the value in the distance column represent? Unfortunately the distance really doesn't have any relation to the "cache raid". As always the distance column is just the distance from your current centre point which is probably the first cache in the raid. If it's simply a matter of storage space, I would be happy to host a library of GSAK macros at http://www.gotwake.com/ - but the Forums and/or gsak.net are probably more suitable locations. Let me know if there's anything I can do to be of assistance, and... No, storage is the least of my problems. Like many other new features it is a matter of time for me being able to implement this. I guess I could just set up FTP access to an area people could share macros, however I think users are expecting a bit more. Ideally, I would like to set up some web interface that allows uploading, perhaps with a short narrative explaining what the macro will do, then display all the macros and allow downloading. However, If anyone would like to set this up I can give FTP access to a directory on my website to test this out. Quote Link to comment
+SnoWake Posted February 25, 2005 Share Posted February 25, 2005 One more, even more simplistic macro: My "found" PQs come in three chunks, to get them all returned under the 500-cache-per-PQ limit (I may have to go to four, soon). Again, I extract all the PQs into a particular directory, and then run the following script, which pulls them into my Found database, exports to Streets and Trips, does a MOVECOPY to a Report database. At that point, I'd like to purge all the logs except my own - resulting in an HTML "journal" of sorts - of my finds, in chronological order, which only my log entries displayed (as seen here: http://www.gotwake.com/caches/foundMy Caching Journal Don't hesitate to ask if you have any questions on filter or export settings that go along with either of these macros. Next will be to automate my "Tahoe Arc" process, where I pick out all the caches within 2 miles of my route on weekly commute from the Bay Area to Lake Tahoe. Very cool getting these things down to a single macro... make that Menu Bar Button Click! # Load directory of NotFound GPX files - includes database selection LOAD Settings=found Database=found # Export to Streets and Trips EXPORT Type=SNT Settings=found # Copy the waypoints to the Reports Database MOVECOPY Settings=Report # Hmmm - no purge function via Macro commands? # At least, not the purge I'm looking for (PURGENOTE is different) # Perform this step manually for now # Export to HTML 'journal' EXPORT Type=HTML Settings=Found Nothing very fancy here - but with the frequency that I perform this task, it still saves me measurable time. Have a great evening, Billy Quote Link to comment
+SnoWake Posted February 25, 2005 Share Posted February 25, 2005 What version of GSAK are you running? (Help=>About) This issue should have been resolved in the latest public release (5.1.1) available at http://gsak.net I'm running 5.1.1. Help->About shows: 5.1.1 (Build 14) Unfortunately the distance really doesn't have any relation to the "cache raid". As always the distance column is just the distance from your current centre point which is probably the first cache in the raid. Interesting - in my case, each time I've run it, selecting different starting caches - the "center point" as displayed in the bottom status bar is not one of the caches in the raid. I'm wondering if it might be the "next" cache? Haven't really walked through the logic, nor am I that concerned - it just caught my eye. At first, I thought it was just incrementing, like a "route distance" or something - but then realized that wasn't the case. No big deal, at all - I was just curious. No, storage is the least of my problems. Like many other new features it is a matter of time for me being able to implement this. I guess I could just set up FTP access to an area people could share macros, however I think users are expecting a bit more. Ideally, I would like to set up some web interface that allows uploading, perhaps with a short narrative explaining what the macro will do, then display all the macros and allow downloading. However, If anyone would like to set this up I can give FTP access to a directory on my website to test this out. Well, the PostNuke content management system I use provides a download section, complete with categories, ratings, links, etc. I'm just using the "out-of-the-box" one right now, but there are enhanced ones that provide more functionality (remote user uploads, etc). I would certainly be more than happy to provide such a service, if it were deemed valuable. On the other hand, I wouldn't bother taking the time to configure it if everyone is just as happy posting them here... Whaddya think? Billy Quote Link to comment
+PDOP's Posted February 25, 2005 Share Posted February 25, 2005 My "found" PQs come in three chunks, to get them all returned under the 500-cache-per-PQ limit (I may have to go to four, soon). I'm going to hijack this thread for a minute. I got caught by a pocket query that grew to over 500 caches with out me realizing it as I import multiple PQ files ( a folder of 4) to get the "Not Found" caches that I'm interested in. The PQ's are overlapping circles and I just let GSAK eliminate any duplicate caches. Clyde would it be possible to setup GSAK to give a warning when a Pocket Query file has 500 caches? To bring this back on topic if GSAK did this I'm not sure how it would work in macros where dialogue boxes are suppressed. We now return you to your regularly scheduled programming Quote Link to comment
+ClydeE Posted February 25, 2005 Share Posted February 25, 2005 (edited) I'm going to hijack this thread for a minute. I got caught by a pocket query that grew to over 500 caches with out me realizing it as I import multiple PQ files ( a folder of 4) to get the "Not Found" caches that I'm interested in. The PQ's are overlapping circles and I just let GSAK eliminate any duplicate caches. Clyde would it be possible to setup GSAK to give a warning when a Pocket Query file has 500 caches? I'll have to give that one some thought. The whole idea of macros is to suppress all error/warning messages. Also GPX files can come from other sources or generated "in house" by utilities such as GPSBabel and GSAK itself. SnowWake - I just tried the macro and did not get any of the message boxes you describe. Could you please send me as screen shot of this warning message so I can track down exactly where it is comming from. Edited February 25, 2005 by ClydeE Quote Link to comment
+PDOP's Posted February 25, 2005 Share Posted February 25, 2005 I'll have to give that one some thought. The whole idea of macros is to suppress all error/warning messages. Also GPX files can come from other sources or generated "in house" by utilities such as GPSBabel and GSAK itself. I was wondering about something similar to the "Send to GPS" function where it warns if you try to send more than 500 (or whatever value is set in the GPS Setup). I supose I could do this by importing the PQs individually to a separate database then move them individually to the final database with the replace and add options set. Quote Link to comment
+UKGeoCyclist Posted February 25, 2005 Share Posted February 25, 2005 Clyde, I am also getting the same error as Snowake, and am using the same version of GSAK(5.1.1 (Build 14). I have modified the macro to filter out my finds, and to give 10 caches, but that is all. Quote Link to comment
+GLM Posted February 25, 2005 Share Posted February 25, 2005 I got caught by a pocket query that grew to over 500 caches with out me realizing it as I import multiple PQ files ( a folder of 4) to get the "Not Found" caches that I'm interested in. A while back I got caught by the same thing. I had the waypoint in my GPS but for some reason didn't have it in my PDA loaded with descriptions. Took me a while to figure it out. The waypoint was previously loaded when the pocket query was less than 500. As the caches grew, I downloaded the latest pocket query to my PDA and it wasn't included because the file had grown to over 500 and this happen to be the one that wasn't included. I spent a great deal of time tweaking my pocket queries so that I could get ALL waypoints downloaded that were within 100 mile radius of my home. I used the preview function of the pocket queries to see how many were in each one. I finally had to divide them up by difficulty and terrain settings to be able to get all of them. It was NOT an easy task figuring out how to get them all. I get 5/day that have all of my unfound caches within 100 mile redius. Once a week I have it set to download my "finds" so that my GSAK database remains current with GC.com Gary Quote Link to comment
+PDOP's Posted February 25, 2005 Share Posted February 25, 2005 I spent a great deal of time tweaking my pocket queries so that I could get ALL waypoints downloaded that were within 100 mile radius of my home. I used the preview function of the pocket queries to see how many were in each one. I finally had to divide them up by difficulty and terrain settings to be able to get all of them. It was NOT an easy task figuring out how to get them all. I also use the preview function to check on the size of the PQ's ( it's a pain) but was hoping that GSAK could automate this. As for setting up PQ's to catch all the caches of interest without exceeding the magic 500 limit I agree it's also a pain. There's another thread on some innovative ways of doing this by date placed and other criteria rather than location which I'm using. I'll have to try them out. Hopefully the improvements to Pocket Queries such as the "Bounding Box" discussed here will come sooner rather than later. Quote Link to comment
+Hynr Posted February 27, 2005 Share Posted February 27, 2005 Since we are talking about macros... and since looping is probably on the horizon: here is a macro that I want to be able to run on my cummulative data so as to fix any archive/unavailable flags that are out of date: Select database... Select filter... Activate split screen (initialize browser inside GSAK display) Loop through active filter - for each record do the following: Display on-line version of current record Extract off the html code <span id=ErrorText>...</span> to buffer Set current record status to "available" If the word “unavailable” shows up in this buffer then change record status to “unavailable” If the word “archived” shows up in this buffer then change record status to "archived" Pause a few seconds (to prevent throttling at GC.com) Clear buffer Advance pointer to next record in filter End of loop Exit macro I could see a lot of use in having the ability to pull stuff from various other <span ID=...> items off the on-line page. Quote Link to comment
+PDOP's Posted March 3, 2005 Share Posted March 3, 2005 Bump There's a nice GSAK macro along with some .bat files and a WinBatch file which together allow you easily get your caches into Street&Trips. The process is described in this thread along with links to download the files required. With this you can filter your GSAK database for different types of caches, export the csv files required by Streets&Trips then automatically have them imported into Streets&Trips with different icons assigned for each type. Quote Link to comment
+Amazon Annie Posted March 3, 2005 Share Posted March 3, 2005 Wow, thanks PDOP for pointing this out! Xangxa has done a great job. I've been learning the macros for GSAK and I am thrilled with the results. (Thanks Clyde) Now when I get a phone call I can click and get out the door with a fresh batch of info faster than I can get my boots on! I have MS S&T but haven't used it much in the past - other than trying to refine a route that we might take. This certainly has put the program back up on my list of necessary software for the laptop in the car. Quote Link to comment
+Pen&Card Posted March 13, 2005 Share Posted March 13, 2005 Macro's and/or automating tasks in GSAK are probably way over my head but thought I would give it a go. Not sure if this is really on topic for macros or if it is something for the "run program" feature of GSAK. I would like to automatically run USAPhotomaps to bring up the individual cache, hopefully with a waypoint icon of my choosing, and the GSAK generated code to label the waypoint (I drop the GC in the code). Anyway to do this? Thanks, Pen of Pen&Card Quote Link to comment
+Xangxa Posted March 16, 2005 Share Posted March 16, 2005 Macro's and/or automating tasks in GSAK are probably way over my head but thought I would give it a go. Not sure if this is really on topic for macros or if it is something for the "run program" feature of GSAK. I would like to automatically run USAPhotomaps to bring up the individual cache, hopefully with a waypoint icon of my choosing, and the GSAK generated code to label the waypoint (I drop the GC in the code). Anyway to do this? Thanks, Pen of Pen&Card I've tried viewing your link on different days, but I get a "Web site not found" each time. Quote Link to comment
+baloo&bd Posted March 16, 2005 Share Posted March 16, 2005 There's another thread on some innovative ways of doing this by date placed and other criteria rather than location which I'm using. I'll have to try them out. Hopefully the improvements to Pocket Queries such as the "Bounding Box" discussed here will come sooner rather than later. Where is the thread for tweaking PQs? I can't seem to locate it with a search. Quote Link to comment
+PDOP's Posted March 16, 2005 Share Posted March 16, 2005 (edited) This one discusses it a bit. Basically the logic is that a search by a set radius will return increasingly more caches over time as more caches are placed. Eventually it will exceed the limit of 500 without you knowing. The results of a search by date placed will remain static or decrease over time so it will never exceed 500. I don't know that it's any easier to do the initial setup by date placed but once it's done it should be maintenance free. Edit: Here's the one I was referrring to. Edited March 16, 2005 by PDOP's Quote Link to comment
+baloo&bd Posted March 16, 2005 Share Posted March 16, 2005 This one discusses it a bit. Basically the logic is that a search by a set radius will return increasingly more caches over time as more caches are placed. Eventually it will exceed the limit of 500 without you knowing. The results of a search by date placed will remain static or decrease over time so it will never exceed 500. I don't know that it's any easier to do the initial setup by date placed but once it's done it should be maintenance free. Edit: Here's the one I was referrring to. Thanks, big help however this leads to another question; Is there a limit on number of miles? In otherwords, if I do the date method, but instead of a state I want to set it to a radius around my house of say 150, 200 or even 500 miles, is there a limit? I have set it to higher numbers but have had some weird and inconsistant results. Quote Link to comment
+Pen&Card Posted March 17, 2005 Share Posted March 17, 2005 QUOTE (Pen&Card @ Mar 13 2005, 01:25 PM) Macro's and/or automating tasks in GSAK are probably way over my head but thought I would give it a go. Not sure if this is really on topic for macros or if it is something for the "run program" feature of GSAK. I would like to automatically run USAPhotomaps to bring up the individual cache, hopefully with a waypoint icon of my choosing, and the GSAK generated code to label the waypoint (I drop the GC in the code). Anyway to do this? Thanks, Pen of Pen&Card Xangxa Posted on Mar 16 2005, 05:37 AMI've tried viewing your link on different days, but I get a "Web site not found" each time. Well, that's because I gave you the wrong link. Sorry about that. Try http://jdmcox.com/ or this link USAPhotomaps Quote Link to comment
+Pasha Posted May 10, 2005 Share Posted May 10, 2005 (edited) With the release of GSAK 5.5 I can post my extra super-duper Cache Logging macro for taking finds from Cachemate on your Palm directly into GC.com's logging pages. It's very user-friendly - just run it and answer the questions. There's only one requirement: you need to have a filter to show only Found caches, else you'll find yourself logging all sorts of caches that you haven't found. The setup dialogs will take you through it. If you're NOT running Windows XP, you may need to change each instance of C:\Windows\ to match your own Windows location - on Win2K it should be "C:\WINNT\" but otherwise should work. Please advise if you have problems - about the only way the beta group has found to break it is to give it a bad Finds filter name, since there's no way (yet) for the macro language to check for the existence of a filter. (Edited to remove macro code - use the one 4 posts below instead.) Edited May 10, 2005 by Pasha Quote Link to comment
+CompuCash Posted May 10, 2005 Share Posted May 10, 2005 (edited) This is a rather simple macro by comparison to some of these - This Macro allows you to select a single cache around which you can name a distance to find caches. Useful for getting a number of caches around a single one when going out to grab a bunch in one day. Usage - clear all user flags and set one then run the macro. Requires filter called "Single-Checked" The filter is set for Set User Flags only. Requires filter called "2MileRadius-UnFound" - three items in this filter all on General page - 1 - Distance = 2 miles (you can adjust this for the --- - actual distance you want to deal with or adjust for the number of caches) - 2 - Found status = Not found and exclude mine - 3 - Available Status = available only Macro Follows ============================ CANCELFILTER # load filter - single checked chache FILTER name="Single-Checked" # set current single cache as center Center FILTER name="2MileRadius-UnFound" sort by="distance" sequence=A goto position=top Edited May 10, 2005 by CompuCash Quote Link to comment
+CompuCash Posted May 10, 2005 Share Posted May 10, 2005 this is the one I use for uploading to my Garmin - Combines 3 filters First is a filter called "Mine" which filters only my own caches Second is a filter called "Unfound-Available" Third is "User flag set" These should be pretty obvious The macro filters the first to setting flags as it goes then filters on the flags to give me Mine and all avail. and unfound. it then exports to a Saved Garmin export called "Garmin" Obviously the GPS has to be on and plugged in to the computer. This file gives you the ability to set up for YOUR GPS without changing the macro. I have three of these - One for serial and one for USB Garmin and one for Magellan. ## Combine 2 filters and send to GPS # # clear all user flags first USERFLAG type=clear range=all # load first filter - mine and available FILTER name="Mine" # set user flags for this filter USERFLAG type=set range=filter # load second filter FILTER name="Unfound-Available" # set user flags for this filter USERFLAG type=set range=filter # # now finally set a filter on User flags = set FILTER Name="User flag set" # # Send waypoints to GPS # EXPORT type=gps settings="Garmin" Quote Link to comment
+CompuCash Posted May 10, 2005 Share Posted May 10, 2005 This last macro does an export to Delorme format to add the caches from the latest PQ to my Delorme Topo. After running this I just import it into topo. requires filter called "Mine+NotFound" -- pretty obvious requires export file called "Delorme" This allows you to set any export you want. Don't forget that the export file needs a full path in the export dialog. This macro will over write any previous version of the file without asking. CANCELFILTER # load filter - all mine and not found FILTER name="Mine+NotFound" # Export to Delorme Export Type="DEL" Settings="Delorme" #Export to D:\Downloads\GPS\GSAK-Out\Caches.txt (will over write the file) Quote Link to comment
+Pasha Posted May 10, 2005 Share Posted May 10, 2005 Unfortunately (or fortunately if you haven't tried it yet) a user pointed out a bug in my monster logging macro. It should only manifest if you try to set the saved Cachemate settings value to "none". The below code will take care of that. If you've already run the one above, you'll need to delete the "logem.dat" file in your GSAK\Macros folder before running this one. If you haven't seen any errors, don't bother replacing the old one. ############################################# # Macro to get the latest copy of Cachemate's # backup database, extract the finds, update # the local copy, then sequentially (by found # date and distance from home) open the # GC.com logging page with the user notes # from the local record copied into the # clipboard. Once logging is complete, finds # are moved to another database if the user # has defined that. # # REQUIRED: you must have a filter to # separate your "found" caches from the rest, # with (at least) "Found" checked under Found # Status - else you're going to be logging # non-finds. ############################################# Debug Status=Off # Data file path SET $datafile=$_Install + "\Macros\Logem.dat" # Does it already exist? IF (FileExists($datafile)) # Yes? Read config values and assign to our vars SET $vars=GETFILE($datafile) IF Left($vars, 7) = "*Error*" PAUSE Msg="Unable to read $datafile! ENDIF SET $database=EXTRACT($vars, ";", 1) SET $cm2gpx=EXTRACT($vars, ";", 2) SET $cm2options=EXTRACT($vars, ";", 3) SET $findsgpx=EXTRACT($vars, ";", 4) SET $cmsettings=EXTRACT($vars, ";", 5) SET $pdbfile=EXTRACT($vars, ";", 6) SET $findsfilter=EXTRACT($vars, ";", 7) SET $movecopysettings=EXTRACT($vars, ";", 8) ENDIF IF .NOT. (FileExists($datafile)) # No? Then we have to ask for the various values and check to see if they're valid. # Database in which to import finds SET $database="Default" SET $inputmsg="Enter the name of the datase to which to import finds from Cachemate" INPUT Msg="$inputmsg" Default="$database" Varname=$database WHILE .NOT. (DataBaseExists($database)) SET $inputmsg="That database doesn't exist! Enter a valid database name:" INPUT Msg="$inputmsg" Default="$database" Varname=$database ENDWHILE # Location of cm2gpx.exe SET $cm2gpx=$_Install + "\cm2gpx.exe" WHILE .NOT. (FileExists($cm2gpx)) SET $inputmsg=$cm2gpx + " not found." + $_NewLine + "Enter fully-qualified path to CM2GPX.exe" INPUT Msg="$inputmsg" Default="$cm2gpx" Varname=$cm2gpx ENDWHILE # cm2gpx.exe command line options SET $cm2options="-f" SET $inputmsg="Enter cm2gpx.exe command-line options." + $_NewLine + $_NewLine + "(The default is to only import records in the 'Found' category. See the cm2gpx help for more information.)" INPUT Msg="$inputmsg" Default="$cm2options" Varname=$cm2options # GPX file to write SET $findsgpx=$_Install + "\Macros\newfinds.gpx" SET $inputmsg="GPX file to write:" + $_NewLine + $_NewLine + "(The default should work for any installation.)" INPUT Msg="$inputmsg" Default="$findsgpx" Varname=$findsgpx # Saved "Load Cachemate logs and finds" settings name, if any SET $cmsettings="New Finds" SET $inputmsg="Saved 'Load Cachemate logs and finds' settings name" + $_NewLine + $_NewLine + "(If you don't have one, delete this value and we'll use the defaults.)" INPUT Msg="$inputmsg" Default="$cmsettings" Varname=$cmsettings # Cachemate database backup file to grab finds from SET $pdbfile="C:\PROGRA~1\palmOne\YOUR PALM USERNAME\Backup\DEFAUL~1.PDB" SET $inputmsg="Cachemate database file to grab finds from:" + $_NewLine + $_NewLine + "(Change YOUR PALM USERNAME to match your backup location, and change DEFAUL~1.PDB to match the PDB file to want, if different." INPUT Msg="$inputmsg" Default="$pdbfile" Varname=$pdbfile WHILE .NOT. (FileExists($pdbfile)) SET $inputmsg="No such file exists!" + $_NewLine + "Cachemate database file to grab finds from:" + $_NewLine + $_NewLine + "(Change YOUR PALM USERNAME to match your backup location, and change DEFAUL~1.PDB to match the PDB file to want, if different." INPUT Msg="$inputmsg" Default="$pdbfile" Varname=$pdbfile ENDWHILE # Filter name to only show found statuses. Crucial if you don't want to log LOTS of caches you haven't found. SET $findsfilter="Found" SET $inputmsg="'Finds' filter name:" + $_NewLine + $_NewLine + "(You MUST have a filter that shows only records with a 'Found' status, else you'll be logging LOTS of caches you haven't found yet.)" INPUT Msg="$inputmsg" Default="$findsfilter" Varname=$findsfilter # Move/Copy saved settings name SET $movecopysettings="Found" SET $inputmsg="Move/Copy saved settings name:" + $_NewLine + $_NewLine + "(If you don't want to move or copy your new finds to a different database after logging, delete this value.)" INPUT Msg="$inputmsg" Default="$movecopysettings" Varname=$movecopysettings # Now save all those values for next time into $datafile, separated by; # If there's blanks SET $vars=$database + ";" + $cm2gpx + ";" + $cm2options + ";" + $findsgpx + ";" + $cmsettings + ";" + $pdbfile + ";" + $findsfilter + ";" + $movecopysettings SET $result=PUTFILE($datafile, $vars) IF Left($result, 7) = "*Error*" CANCEL Msg="Unable to write to $datafile!" ENDIF # End "No $datafile" IF ENDIF # Whew. Now we can actually do something with all those vars: # Select the database DATABASE Name="$database" Action=Select # Create a batch file to run cm2gpx to get around the inability to put quotes into a RUNPGM line SET $batfile=$_Install + "\cm2gpx.bat" SET $battext=$cm2gpx + " " + $cm2options + " -o " + $findsgpx + " " + $pdbfile SET $result=PUTFILE($batfile, $battext) IF Left($result, 7) = "*Error*" # If we can't create the batch file, we have to cancel. CANCEL Msg="$result" ENDIF # Run the batch file to create $findsgpx RUNPGM Pgm="$batfile" Wait=Yes # If the user hasn't defined a saved Cachemate setting, use the defaults. IF $cmsettings = "" CACHEMATE File="$findsgpx" ENDIF # If they've defined one, use it instead IF .NOT. ($cmsettings = "") CACHEMATE Settings="$cmsettings" File="$findsgpx" ENDIF # Filter so our list is only new finds FILTER Name=$findsfilter # If there's records in the filter, sort 'em and log 'em, pausing between each for the user to confirm. IF .NOT. ($_FilterCount = 0) CENTRE Location="Home" SORT By="FoundByMe;UserSort" WHILE .NOT. $_EOL CLIP tags="%UserLog" WEB url="http://www.geocaching.com/seek/log.aspx?ID=%gcid" PAUSE Msg="Click Continue when logged successfully." GOTO Position=Next ENDWHILE # If the user has defined $movecopysettings, use them. IF .NOT. ($movecopysettings = "") MOVECOPY Settings=$movecopysettings ENDIF ENDIF # Done with everything. Remove the batch file and the GPX file. RUNPGM Pgm="C:\Windows\System32\cmd.exe" Parms=" /C del $batfile" RUNPGM Pgm="C:\Windows\System32\cmd.exe" Parms=" /C del $findsgpx" Quote Link to comment
+ClydeE Posted May 10, 2005 Share Posted May 10, 2005 I have now set up a central repository for GSAK macros. You can find them here http://gsak.net/Macros.php Quote Link to comment
+LBSurfer Posted May 10, 2005 Share Posted May 10, 2005 (edited) So, I wrote a fairly simple macro to import my PQ's from my mail and then separate everything out. What I'm having problems with is when I want to sort out my DNF's. When I run the macro and there's no DNF's, it defaults to the WP's in the existing DB and then moves them ALL to the DNF DB. It's the same as getting one of these errors And then having GSAK revert back to the pre-existing DB that you were trying to filter from. Here's the code for the Macro. Any help on being able to actually use the DNF Filter and MOVECOPY commands w/o moving the whole DB when I don't have a DNF come in on my PQ would be most appreciated. ################################################################# # UPDATE HISTORY ################################################################# # # 05.05.05 - Added Filtering and DB Management for caches near # Mom & Dad. Added UPDATE HISTORY header. # # 05.01.05 - Fine tuned Filtering and sorting features # # 04.29.05 - Macro creation date # ################################################################# # Select Default DB DATABASE Name="Default" Action=select # Get PQ's from POP3 Mail GETMAIL Settings="Earthwake_Mail" OnError=Prompt # Filter out all the 'Found' Caches FILTER Name="My Found Caches (GSAK default)" Reverse=No # Move the 'Found' Caches to the Found DB MOVECOPY Settings="Found_Caches" ################################################################# # For future release once OWNED Caches are introduced ################################################################# # # Return to Default DB # DATABASE Name="Default" Action=select # # # Filter out all the 'Owned' Caches # FILTER Name="My Owned Caches (GSAK default)" Reverse=No # # # Move the 'Owned' Caches to the Owned DB # MOVECOPY Settings="Owned_Caches" ################################################################# # Return to Default DB DATABASE Name="Default" Action=select # Filter out all Massachusetts Caches FILTER Name="Massachusetts" Reverse=No # Move the MA Caches to the Mom & Dad DB MOVECOPY Settings="Wrentham" # Return to Default DB DATABASE Name="Default" Action=select # Filter out all Rhode Island Caches FILTER Name="Rhode Island" Reverse=No # Move the MA Caches to the Mom & Dad DB MOVECOPY Settings="Wrentham" # Return to Default DB DATABASE Name="Default" Action=select ################################################################# # For future consideration if DNF Caches become a major concern ################################################################# # #Filter out all the 'DNF' Caches # Filter Name="DNF" Reverse=No # # # Move the 'DNF' Caches to the DNF DB # MOVECOPY Settings="DNF" # # # Return to Default DB # DATABASE Name="Default" Action=select ################################################################# The only way I can think of doing this is to add the DNF FILTER and MOVECOPY commands and then go to the DNF DB, run a reverse DNF FILTER and MOVECOPY that subset BACK to the default DB. That's a ton of work though. Edited May 10, 2005 by LBSurfer Quote Link to comment
+ClydeE Posted May 10, 2005 Share Posted May 10, 2005 (edited) So, I wrote a fairly simple macro to import my PQ's from my mail and then separate everything out. What I'm having problems with is when I want to sort out my DNF's. When I run the macro and there's no DNF's, it defaults to the WP's in the existing DB and then moves them ALL to the DNF DB. It's the same as getting one of these errors [ The only way I can think of doing this is to add the DNF FILTER and MOVECOPY commands and then go to the DNF DB, run a reverse DNF FILTER and MOVECOPY that subset BACK to the default DB. That's a ton of work though. What version of GSAK are you running? Version 5.5 intoduced many new features that allow you to handle this type of situation. When you do a filter, GSAK sets a system variable called $_FilterCount. All you need to do is use this variable in an if statement: #Filter out all the 'DNF' Caches Filter Name="DNF" Reverse=No # Only do the following statements if filter has waypoints If $_FilterCount > 0 # Move the 'DNF' Caches to the DNF DB MOVECOPY Settings="DNF" ENDIF # Return to Default DB DATABASE Name="Default" Action=select Edited May 10, 2005 by ClydeE Quote Link to comment
+Pasha Posted May 11, 2005 Share Posted May 11, 2005 I have now set up a central repository for GSAK macros. You can find them here http://gsak.net/Macros.php Awesome Clyde, thanks. Posting my bodacious logger here turned up a few bugs so it's probably ready for prime time now. Quote Link to comment
+LBSurfer Posted May 11, 2005 Share Posted May 11, 2005 So, I wrote a fairly simple macro to import my PQ's from my mail and then separate everything out. What I'm having problems with is when I want to sort out my DNF's. When I run the macro and there's no DNF's, it defaults to the WP's in the existing DB and then moves them ALL to the DNF DB. It's the same as getting one of these errors [ The only way I can think of doing this is to add the DNF FILTER and MOVECOPY commands and then go to the DNF DB, run a reverse DNF FILTER and MOVECOPY that subset BACK to the default DB. That's a ton of work though. What version of GSAK are you running? Version 5.5 intoduced many new features that allow you to handle this type of situation. When you do a filter, GSAK sets a system variable called $_FilterCount. All you need to do is use this variable in an if statement: #Filter out all the 'DNF' Caches Filter Name="DNF" Reverse=No # Only do the following statements if filter has waypoints If $_FilterCount > 0 # Move the 'DNF' Caches to the DNF DB MOVECOPY Settings="DNF" ENDIF # Return to Default DB DATABASE Name="Default" Action=select Thanks Clyde...I knew it was just something simple I was missing. (I'm running the latest version btw). Much, much appreciated. Quote Link to comment
+martinp13 Posted July 4, 2005 Share Posted July 4, 2005 (edited) I'm having trouble getting a GSAK 5.6.0 macro to kickoff Plucker. I've tried many combinations of pgm and parms, and nothing seems to work. The most common error is that the channel names don't exist in the .ini file. Does anyone have a concrete example that works? Thanks! Edited July 4, 2005 by martinp13 Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.