My Adventures in Getting Data into the ArchivistsToolkit

Georgia Tech Archives is moving its accessions database from a home grown sql/php based archival database tool to the Archivist's Toolkit which was recently released. The easiest route I thought was to export the current data to two spreadsheets in csv format, clean it up, and import the results. It couldn't be that hard: just convert csv to Toolkit format.

Get The Data From The Old Tool

That was as easy as pushing the right buttons on phpmyadmn. We ended up with two tables; one described the donors, the other the accessions linked to donors by via donor ids.