{"id":159,"date":"2006-07-18T13:30:09","date_gmt":"2006-07-18T18:30:09","guid":{"rendered":"http:\/\/www.hoodedhawk.com\/blog\/2006\/07\/18\/getting-a-books-database-on-a-palmos-pda\/"},"modified":"2006-07-20T00:46:34","modified_gmt":"2006-07-20T05:46:34","slug":"getting-a-books-database-on-a-palmos-pda","status":"publish","type":"post","link":"https:\/\/www.hoodedhawk.com\/blog\/getting-a-books-database-on-a-palmos-pda\/","title":{"rendered":"Getting a books database on a PalmOS PDA"},"content":{"rendered":"<p>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 <a href=\"http:\/\/www.palm.com\/us\/products\/handhelds\/tx\/\">Palm T|X<\/a>:<\/p>\n<ol>\n<li>Export from <a href=\"http:\/\/www.deepprose.com\/\">Booxster<\/a> (on my Mac) to an XML file<\/li>\n<li>Prepend a dummy record that has all fields to top of XML file (see end of this entry for xml)<\/li>\n<li>Import XML into online (<a href=\"http:\/\/www.mysql.com\/\">MySQL<\/a>) version of DB (for use on this blog, for instance), using <a href=\"http:\/\/www.navicat.com\/\">Navicat software<\/a><\/li>\n<li> Delete the dummy record via [delete from books where keyword = &#8216;deleteme&#8217;]<\/li>\n<li>Export the db again, this time from the newly created online version, to XML again via Navicat<\/li>\n<ul>\n<li>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&#8230;<\/li>\n<\/ul>\n<li>Import this second XML file into a <a href=\"http:\/\/www.filemaker.com\/\">FileMaker Pro<\/a> (FMP) database<\/li>\n<li>Sync the Palm T|X, using <a href=\"http:\/\/sourceforge.net\/projects\/fmsync\/\">FMSync<\/a> software to sync FMP with <a href=\"http:\/\/www.land-j.com\/jfile.html\">JFile<\/a> on the Palm.\n<\/ol>\n<p>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 &#8211; no more duplicate purchases, or the converse of passing up a purchase because I thought I had a copy.<br \/>\n<!--more--><br \/>\n<code><br \/>\n&lt;book&gt;<br \/>\n&lt;isbn &gt; 0&lt;\/isbn &gt;<br \/>\n     &lt;lccn &gt; 0&lt;\/lccn &gt;<br \/>\n     &lt;title &gt; A test record&lt;\/title &gt;<br \/>\n     &lt;authors &gt;<br \/>\n          &lt;author &gt; Brown, Dan&lt;\/author &gt;<br \/>\n     &lt;\/authors &gt;<br \/>\n     &lt;genre &gt; &lt;\/genre &gt;<br \/>\n     &lt;obtainedFrom &gt; Bookstore&lt;\/obtainedFrom &gt;<br \/>\n     &lt;dateObtained &gt; 05-01-2004&lt;\/dateObtained &gt;<br \/>\n     &lt;language &gt; English&lt;\/language &gt;<br \/>\n     &lt;format &gt; Hardcover&lt;\/format &gt;<br \/>\n     &lt;publisher &gt; Doubleday&lt;\/publisher &gt;<br \/>\n     &lt;locale &gt; US&lt;\/locale &gt;<br \/>\n     &lt;location &gt; Case 4&lt;\/location &gt;<br \/>\n     &lt;placePublished &gt; New York&lt;\/placePublished &gt;<br \/>\n     &lt;series &gt; None&lt;\/series &gt;<br \/>\n     &lt;editionNumber &gt; 1st ed.&lt;\/editionNumber &gt;<br \/>\n     &lt;deweyClassNumber &gt; 813\/.54 21&lt;\/deweyClassNumber &gt;<br \/>\n     &lt;locClassification &gt; PS3552.R685434 D3 2003&lt;\/locClassification &gt;<br \/>\n     &lt;locSubjects &gt;<br \/>\n          &lt;locSubject &gt; Leonardo, da Vinci, 1452-1519 Appreciation Fiction.&lt;\/locSubject &gt;<br \/>\n     &lt;\/locSubjects &gt;<br \/>\n     &lt;copies &gt; 2&lt;\/copies &gt;<br \/>\n     &lt;pages &gt; 454&lt;\/pages &gt;<br \/>\n     &lt;year &gt; 2003&lt;\/year &gt;<br \/>\n     &lt;originalYear &gt; 2003&lt;\/originalYear &gt;<br \/>\n     &lt;price currency=\"USD\" &gt; 24.95&lt;\/price &gt;<br \/>\n     &lt;pricePaid currency=\"USD\" &gt; 70.00&lt;\/pricePaid &gt;<br \/>\n     &lt;read &gt; true&lt;\/read &gt;<br \/>\n     &lt;dateRead &gt; 06-01-2004&lt;\/dateRead &gt;<br \/>\n     &lt;rating &gt; 0&lt;\/rating &gt;<br \/>\n     &lt;keywords &gt;<br \/>\n          &lt;keyword &gt; deleteme&lt;\/keyword &gt;<br \/>\n     &lt;\/keywords &gt;<br \/>\n     &lt;signed &gt; true&lt;\/signed &gt;<br \/>\n     &lt;owned &gt; true&lt;\/owned &gt;<br \/>\n     &lt;locked &gt; false&lt;\/locked &gt;<br \/>\n     &lt;dateAdded &gt; 07-19-2006&lt;\/dateAdded &gt;<br \/>\n     &lt;dateModified &gt; 07-20-2006&lt;\/dateModified &gt;<br \/>\n     &lt;lentOut &gt; false&lt;\/lentOut &gt;<br \/>\n     &lt;hasCoverImage &gt; true&lt;\/hasCoverImage &gt;<br \/>\n     &lt;condition &gt; Fine\/Fine.  &lt;\/description &gt;<br \/>\n     &lt;notes &gt; &lt;\/notes &gt;<br \/>\n&lt;\/book &gt; <\/p>\n<p><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7,6],"tags":[],"_links":{"self":[{"href":"https:\/\/www.hoodedhawk.com\/blog\/wp-json\/wp\/v2\/posts\/159"}],"collection":[{"href":"https:\/\/www.hoodedhawk.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hoodedhawk.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hoodedhawk.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hoodedhawk.com\/blog\/wp-json\/wp\/v2\/comments?post=159"}],"version-history":[{"count":0,"href":"https:\/\/www.hoodedhawk.com\/blog\/wp-json\/wp\/v2\/posts\/159\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hoodedhawk.com\/blog\/wp-json\/wp\/v2\/media?parent=159"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hoodedhawk.com\/blog\/wp-json\/wp\/v2\/categories?post=159"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hoodedhawk.com\/blog\/wp-json\/wp\/v2\/tags?post=159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}