The question I would have is why you can't just encode you data in a
structured way to begin with (i.e. XML)? I can't imagine that would
be any less complex than trying to establish complex relationships
and having to create delimiters for multiple values in a single cell
(and verify that they are all correct). I realize that Excel is
more "user-friendly" to those that don't understand cataloging,
series/subseries or hierarchies, but my experience is that those
type of people are not going to be able to create anything other
than a simple flat container list anyways.
On 11/29/2013 4:15 PM, Marsha Maguire
[log in to unmask]"
[log in to unmask]
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.