Print

Print


Hey Ruth --

I think the best place for them is SAA's EAD site.  I think I sent the link earlier but here it is again:

http://www2.archivists.org/groups/technical-subcommittee-on-encoded-archival-description-ead/encoded-archival-description-ead 

Michele

-----Original Message-----
From: Encoded Archival Description List [mailto:[log in to unmask]] On Behalf Of Ruth Kitchin Tillman
Sent: Thursday, July 17, 2014 4:27 PM
To: [log in to unmask]
Subject: Re: Excel-to-EAD scripts, macros, whatever

FYI, most of these attachments aren't coming through for me, despite subscribing to individual emails. It sounds like we've got a great doc exchange going, however. Is there a way people could upload some & send links? And then might this be a good thing to group in a central location when everyone's shared theirs?

With great interest,
Ruth

On Thu, Jul 17, 2014 at 4:14 PM, Callie Bowdish <[log in to unmask]> wrote:
> 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
>
>



--
http://eadiva.com | http://ruthtillman.com/ | @ruthbrarian