Moving form Axiell Calm to AtoM

[Donna Maguire]

HI dose anyone have experience of moving their database over to AtoM form Calm and would you be willing to let me know how you got on. 

thanks 

donna Maguire 

SCA

[Dan Gillean]

Hi Donna, 

I've tried to compile my general recommendations for AtoM migrations in the following slide deck:

• https://www.slideshare.net/accesstomemory/atom-data-migrations
  

We find CSVs to be the most flexible way to migrate data, so if you can get CSV exports from CALM, you can then perform some data cleanup either manually, or using a spreadsheet tool like LibreOffice Calc, or else with a tool like OpenRefine. 

Two other slide decks that might help generally - one on how AtoM CSV templates should be filled in for archival descriptions, and the other full of general tips, tricks, and gotchas about AtoM: 

• https://www.slideshare.net/accesstomemory/csv-import-in-atom
  
• https://www.slideshare.net/accesstomemory/things-i-wish-id-known-atom-tips-tricks-and-gotchas
  

Of course the documentation for the command-line CSV imports will also be essential: 

• https://www.accesstomemory.org/docs/latest/admin-manual/maintenance/cli-import-export
  
• See also: https://www.accesstomemory.org/docs/latest/user-manual/import-export/csv-import/

Our CSV templates can be found in AtoM's code (at lib/task/import/example), and we also keep copies on our wiki, here:

• https://wiki.accesstomemory.org/Resources/CSV_templates

We include a couple sample rows in these templates that list the name and number of the field from the corresponding standard to which they relate, to help you better understand how the CSV is organized. You can import these example rows to see exactly where and how they will appear in AtoM once uploaded. This can be very helpful in working out how to map your data in CALM to what AtoM expects.

There are a couple older threads in the forum that mention CALM migrations. One of them also includes a number of general links about OpenRefine, which is also mentioned in the Data Migration slides linked above. See: 

• https://groups.google.com/g/ica-atom-users/c/5we2sKmwcZ4/m/WDZVYQ47AQAJ
  
• https://groups.google.com/g/ica-atom-users/c/5ZEy8php0tc/m/aQH7LztHCAAJ
  

You can also browse all threads with a "migration" label in the forum here: 

• https://groups.google.com/g/ica-atom-users?label=migration
  

Hope this helps! 

Dan Gillean, MAS, MLIS
AtoM Program Manager
Artefactual Systems, Inc.
604-527-2056

@accesstomemory

he / him

--
You received this message because you are subscribed to the Google Groups "AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/62cee9a4-7e92-4b73-8e0c-2973c5120267n%40googlegroups.com.

[Mark Smith]

Hi Donna,

We did exactly this at the Shetland Archives a few years ago.  CSVs exported from CALM then cleaned up manually using LibreOffice Calc was the method we used.  We did it fond by fond, starting with the smallest ones first until we got better at it.  The work was painstaking, and slow - there were about 100,000 CALM records and, working on it pretty much all the time, the export took me about a year and a half.  It was 100% worth it, though.  AtoM is far superior to CALM, in the opinion of the three archive staff who work here, and, after months of going through spreadsheets I now know the catalogue far better than I did before.

Do feel free to get in touch if there's anything I can help with.  My email is mark....@shetlandamenity.org

Mark