CCAP: New data from Barkerville
MK very kindly sent me their complete Access database, which I'm now wrestling into submission. On first analysis, it looks like there are 1584 records in there which have an explicit association with "CHINESE" (culture/group) which are not among the ones they uploaded to our database so far.
117 of these items appear to have associated images.
I need to write some code to generate spreadsheets for importing this data, and while I'm doing that, I could also generate a human-readable version that MK could browse through to check that we're not adding any fields we shouldn't be, and that we're not including any items that should not be public.
We don't know yet whether the images might be available, but if they are, it should be possible to get them in too.
I think it may take me a week or so to get this done.
How I got at the Access data: GN opened the file in Access on a VM on his machine, and opened it to VNC; I was able to view it and export each individual table as an XML file, along with a map of the db schema. The XML files are large, but quite easy to figure out. The export process (table by table) was tiresome and time-consuming, though.