Porting GEOmetaDB from SQLite to FileMaker Pro

Prepared by Yidong Chen

1. FileMaker Pro database (GEOmetadDB.fp7) is a straight port from GEOmetaDB.sqlite. The intent of FMP database is only for people to see the content of the database easily, without any prior knowledge of SQLite.

2. The building of FileMaker Pro database is done with a Mac Pro, and it require a ODBC driver from Actual Technologies, Inc at
http://www.actualtechnologies.com/
Specific ODBC driver for SQLite is 'Open Source Database'.

For anyone who would like to rebuild the FileMaker DB from the latest SQLite database download, a few notes might help you get it quickly,
  a. FileMaker can port data from SQLite database via 'Import' function, not 'file reference'.
  b. There is no username/password for SQLite database, so just not enter anything when prompted before hit the return.
  c. Using SQL command provided in each table, and then match the name.

3. The FileMaker database (GEOmetaDB.fp7) is pre-built with all information exist in the SQLite GEOmetaDB.sqlite. The tables/fields in FileMaker Pro match the tables/field names in the SQLite database.

Enjoy!