...
- Collection Items (will become cataloging records including item-specific acquisition values) (Chris)
- ETL notes: I do need to check that the columns are in the right order (as expected by the header row) by importing into Excel. !!NOTE: I'm excluding the Image field (which breaks the export) and the TR_No_SORT field (which I thought was breaking the output file). Copy output to Data/collectionitems.tab
Merge groups
- Artist Lineitems (will become repeating Production Person and possibly Production Organization on cataloging, likely in new custom field group with Qualifier). CollectionItem:Engravers would also become Production Person values with role Engraver. (Chris)
- Collections Lineitems (will become repeating Collection values on cataloging) (Chris)
- Measurements (will become repeating measurements information on cataloging) (Lam)
- Collection Texts (will become repeating text-labels on cataloging)
- CollectionItem/Period-Style (FileMaker repeating PeriodOrStyle field will reuse repeating Style field on cataloging; tie to new dynamic controlled list) (Chris)
- CollectionItem/Subjects-Themes (FileMaker repeating subdescription field will become new repeating SubjectsThemes field, but need to decide how to parse data entered where BAMPFA created an implicit hierarchy) (Chris)
- Titles: Main Title and Alternate Title (Chris)
- Current value field group: Primary current value, source, date. Current value old to pos=1. (Chris)
- Controlled lists:
- Collection (will become collection dynamic controlled list)
...