Ruth:
Just put some spreadsheets and instructions here. Accessible for anyone with the link.
https://drive.google.com/folderview?id=0BwpPTyl4mMrqRUtKc1BGQUcyem8&usp=sharing
Kate
-----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: [EAD] 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
|