Print

Print


Hi All,

 

Here is a doc from our wiki on  how I’ve been working with converting item level information in a spreadsheet to work with Archivsts’ Toolkit, using the mail merge method.  It would be nice to have time to work with setting up an xslt file. But this works for me now. I’ve been a bit disappointed in the learning curve involved with setting up helpful xslt files. It sure feels like an information management tool that could be helpful but that is not so readily used because of the disappointing learning curve. The devil is in the details.

 

Callie

 

------ 

Callie Bowdish

Processing Specialist
California Ethnic and Multicultural Archives
Department of Special Collections, Davidson Library
University of California Santa Barbara, CA 93106-9010
Tel:805-893-8563  FAX:805-893-5749 http://www.library.ucsb.edu/special-collections/cema

 

From: Encoded Archival Description List [mailto:[log in to unmask]] On Behalf Of Wiedeman, Gregory
Sent: Thursday, July 17, 2014 11:08 AM
To: [log in to unmask]
Subject: Re: Excel-to-EAD scripts, macros, whatever

 

Using mail merge is the most common method, although I find there is sometimes issues with Excel’s formatting.

 

The method I use is a basic XML schema mapped to an Excel workbook. This lets you enter all of the collection data—including front matter, collection hierarchy etc.—and then save it as an XML file without any formatting. Then I use an XQuery script running with BaseX on a desktop that turns it all into EAD. I hope to run the script on a server so that all you would have to do is save the spreadsheet as XML on the server and it would just pop out as valid EAD. I’m writing it up for publication but it still needs documentation and smoothing out some of the less-common ways we do things here. I can send the Excel workbook and the script if anyone is interested.

 

Hope this helps,

Greg

 

Gregory Wiedeman

Project Archivist

M. E. Grenander Department of Special Collections & Archives

University at Albany, SUNY

[log in to unmask]

 

From: Encoded Archival Description List [mailto:[log in to unmask]] On Behalf Of Callahan, Maureen
Sent: Thursday, July 17, 2014 12:58 PM
To: [log in to unmask]
Subject: Re: Excel-to-EAD scripts, macros, whatever

 

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]

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
[log in to unmask]

 

On Thu, Jul 17, 2014 at 10:38 AM, Michele R Combs <[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
[log in to unmask]
scrc.syr.edu