Tue 18 Jul 2006
Getting a books database on a PalmOS PDA
Posted by boz under Books , ComputingComments Off on Getting a books database on a PalmOS PDA
Ok, so this might sound like a bit much, but the following are the steps I have to take to get my book collection database onto my Palm T|X:
- Export from Booxster (on my Mac) to an XML file
- Prepend a dummy record that has all fields to top of XML file (see end of this entry for xml)
- Import XML into online (MySQL) version of DB (for use on this blog, for instance), using Navicat software
- Delete the dummy record via [delete from books where keyword = ‘deleteme’]
- Export the db again, this time from the newly created online version, to XML again via Navicat
- This is because the FMP import (see next step) barfs on the XML file created in the Booxster export (step 1). But this is not so bad, because I want to update the online version anyway…
- Import this second XML file into a FileMaker Pro (FMP) database
- Sync the Palm T|X, using FMSync software to sync FMP with JFile on the Palm.
Seems like a lot of work, but the whole process takes about 5 minutes, with about 30 seconds of user interaction (biggest wait is the import of Booxster XML into online version via Navicat). At the end, I have my 3 database versions synced up. The PalmOS version is especially useful when I go into a bookstore – no more duplicate purchases, or the converse of passing up a purchase because I thought I had a copy.
(more…)