I've now entered the values for the two regions tables and the source type table into the db, and I've also started work on some XSLT that will convert the MODS output from Zotero into SQL to insert the data into the sources table. So far I'm processing the biblio items correctly, and inserting them, but I'm not yet processing the authors, editors, translators etc. I need to first pull out all the people and insert them into the inkSlingers table, then after each source creation, I need to pull back the latest id in the sources table, and create appropriate author/editor/etc. links in the linking tables.

Had to add a couple of new fields, one for abstracts (useful, not to be wasted, might as well be in there), and one for "full title" (since many titles are paragraph-length things, and have to be truncated for the ordinary title field).

This isn't strictly speaking worth the time for the 39 entries in this sample data file, but it will be useful in future if Zotero can be used to collect sources and input them into the db, and I'm sure the same issue will come up with other dbs in future.