Print

Print


You might find it helpful to view the CSV import template for the AtoM finding aid application:

https://www.qubit-toolkit.org/wiki/CSV_import

It uses the pipe character ( | ) to indicate repeating values in a given field, but it also uses a pair of columns to indicate the parent/child relationship between the various levels of description. There has been quite a bit of discussion about CSV import on the ICA-AtoM user group, for example:

https://groups.google.com/forum/#!msg/ica-atom-users/WxQ4tomnLRQ/tZ6Zi9bTPgwJ

Jason Ronallo developed a program that converts CSV files into EAD, called Stead.  There was a web-based version (http://steady.heroku.com/) but it appears to be offline at the moment. The code is on GitHub:

https://github.com/jronallo/stead

We’ve used both with great success. Open Refine (http://openrefine.org/) was also used in a recent project to convert MS Access databases into EAD finding aids.

Hope that helps,

Creighton

From: Encoded Archival Description List [mailto:[log in to unmask]] On Behalf Of Marsha Maguire
Sent: Friday, November 29, 2013 8:15 PM
To: [log in to unmask]
Subject: Generating EAD and/or MARC from spreadsheets -- how?

Greetings, all. If I may, I wanted to revisit a thread from a couple of weeks ago (I was out of town when it first came up).

Kate Bowers said, "Starting with a spreadsheet, you can generate both MARC records and EAD components from the same source data."
But how, exactly (I ask as a non-programmer), is this done? Spreadsheet structure being flat and seemingly one-to-one (unless a lot of data is repeated in succeeding rows), I'm wondering how to indicate in the spreadsheet that a given title (say, of a book or a sound recording) described in a spreadsheet row has more than one creator or subject. In other words, how should a spreadsheet be set up to handle one-to-many relationships, so that its data can be exported and converted to EAD XML or MARC XML? May I ask anyone who is kind enough to consider answering this to please be specific or provide specific examples?
Apologies if this is obvious to many of you. Thanks so much.

Marsha Maguire
[log in to unmask]<mailto:[log in to unmask]>