Spent most of a couple of days cleaning up remaining problems in data provided in main spreadsheet by BI and processing that through the ten-step procedure. Some problems were typographic errors, some were new values in lookups (e.g. archive, collection, keyword, location) and either the code in my Transformer routine didn't include those new values, or the tables in the database didn't include those. Compared the values in Ben's spreadsheet, my processing code and in the database tables for all the secondary tables to ensure they reconciled. Still have to upload the values for the various one-to-many tables as generated by my code - shouldn't be hard. All future edits, additions to the db by BI will be through the adaptive DB front end at (at least for now) https://lettuce.tapor.uvic.ca/~siberian/edit/editor/enter.php
This entry was posted by and filed under Activity log.