 |
 |
If you have access to oXygen, you can also do this there with an xslt. I wrote a tutorial about how to do this here: http://icantiemyownshoes.wordpress.com/2014/03/04/tutorial-how-to-turn-a-spreadsheet-into-the-contents-list-of-an-ead-encoded-finding-aid/ I’ve also done the MS Word mail merge thing before and it totally works – I found that I’ve sometimes run into performance problems, though, if I’m working with a file with a lot of rows. Maureen Maureen Callahan Archivist, Metadata Specialist Manuscripts & Archives Yale University Library [log in to unmask]<mailto:[log in to unmask]> 203.432.3627 Webpage: web.library.yale.edu/mssa Collections: drs.library.yale.edu From: Encoded Archival Description List [mailto:[log in to unmask]] On Behalf Of Elizabeth Perkes Sent: Thursday, July 17, 2014 12:46 PM To: [log in to unmask] Subject: Re: Excel-to-EAD scripts, macros, whatever You can use Excel as the data source for Word's mail merge function. Put the XML wrappers in Word with placeholders for the fields defined in Excel, run the merge, delete section breaks, and paste into your EAD document. Elizabeth Perkes Electronic Records Archivist Utah State Archives 346 South Rio Grande Salt Lake City, UT 84101 801-531-3852<tel:801-531-3852> [log in to unmask]<mailto:[log in to unmask]> On Thu, Jul 17, 2014 at 10:38 AM, Michele R Combs <[log in to unmask]<mailto:[log in to unmask]>> wrote: Hi guys -- I seem to recall someone, or perhaps several someones, mentioning on this list that they had macros or scripts or something to convert collection inventories in Excel to EAD. Yes? Michele +++++++++++++++ Michele Combs Lead Archivist Special Collections Research Center Syracuse University Libraries 315-443-2081<tel:315-443-2081> [log in to unmask]<mailto:[log in to unmask]> scrc.syr.edu<http://scrc.syr.edu>