Mac - DbToSqlite

GSAK (Geocaching Swiss Army Knife)

DbToSqLite (function)

DbToSQLite(sTable,sFields,sDatabase,[sMfilter]) : string

This function will convert a GSAK native table to a SQLite table, creating a SQLite database if one does not exist

Note: As of version 7.5 GSAK internal database has been converted to sqlite for the "logs" and "waypoints" table. It is therefore recommended that you only use this function for the "caches" table as you can access "waypoints" and "logs" directly via sqlite(). Using the GSAK database directly will be quicker and will always provide the most up to date information.

sTable = must be caches, waypoints, or logs

sFields = A comma delimited list of database fields. The names are the same as for database variables. However to avoid confusion when using variable substitution, you must remove the "$d_" part. So if you want the field $d_code in your sql table, it should be entered as "code" only.

sDatabase = The fully qualified path to the sqlite database name (if the database does not exist, it will be created)

sMfilter = This parameter is optional. If used it must be a valid mfilter expression. You would usually use this to limit the logs generated (they can get quite large). For example: Use "IsOwner()" to limit the generation to only your logs.

If the table already exists in that database, it will be replaced. It should also be noted that this function preserves the full fidelity of all the information in the database (including line feeds and delimiters)

Alpha List Category List