Education Commons^™

Batch Uploading To Contentdm With The Help Of Ms Access, Joanne M. Riley

Joanne M. Riley

Microsoft Access is a great tool for minimizing headaches, streamlining data entry and ensuring quality control in preparing batch uploads for CONTENTdm collections. At UMass Boston, we store our descriptive metadata in MS Access tables by way of easy data entry forms. Then we use Access queries to automatically create all of the other necessary fields, to check for errors and, finally to generate a delimited text file that imports easily into the Project Client - almost always ;). This process has saved staff a great deal of time and effort and keeps their metadata safely backed up and available …