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