GSAK (Geocaching Swiss Army Knife) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Contents
- Index
All Database variables begin with $d_ and each variable has a given type. Caches database variables are displayed as columns and more information can be found here. ("string" database variables have a physical limit of 2gb) Most database variables can be updated simply by using the statement $d_SomeVariable = $SomeValue, where $d_SomeVariable is a valid database variable and $SomeValue is any valid variable or literal (but it must match the data type of the database variable). This actually updates your database, but as some variables are calculated from other items in the database there are exceptions. These are: $d_Bearing, $d_Changed, $d_Degrees, $d_Distance, $d_FoundCount, $d_HasCorrected, $d_HasUserNote, $d_HastravelBug, $d_LastFoundDate, $d_LastGPXDate, $d_LastLog, $d_LastUserDate, $d_LatOriginal, $d_LonOriginal, $d_NumberOfLogs, $d_UserNoteDate, $d_cByUser, $d_cParent, $d_cPrefix, $d_kBeforeCounty, $d_kBeforeState, $d_kCode, $d_kBeforeLat, $d_kBeforeLon, $d_lIsowner, $d_lParent, $d_aName $d_ Database variables are separated into 5 GSAK tables - caches, corrected, logs, waypoints, and attributes You can navigate through each of these tables using the Table and Goto commands. Note: The tables CacheImages, LogImages and Custom are not supported in this manner - use Sqlite to read these tables. Caches
[1] - The user note is comprised of two sections, the note section and the log section (see notes dialog) These two sections are separated by the literal string "$~ ". If you wish to split the user notes into these two discrete sections then the macro code would go something like:
For a more complete explanation of some of these fields please this topic $d_Status (Cache Status): A = Available T = Temporary disabled X = Archived $d_CacheType (Cache Types): A = Project Ape B = Letterbox C = Cache In Trash Out D = Groundspeak Lost and Found Celebration E = Event F = Lost and Found Event G = BenchMark H = Groundspeak HQ Cache I = Wherigo J = Giga Event L = Locationless M = Multi O = Other P = Groundspeak Block Party Q = Lab cache R = Earth T = Traditional U = Unknown/Mystery V = Virtual W = Webcam X = Maze Exhibit Y = Waymark Z = Mega event Also see the CacheType() function Corrected
Logs
Waypoints
Notes:
more information Attributes (use view "attname" to also include $d_aName)
Note: currently the attributes table is read only. It is provided here for consistency with other tables, but it is recommend that you use sqlite() in macros to read and interrogate attribute data. |
Copyright 2004-2019 CWE Computer Services Privacy Policy Contact |