automation

5 views
Skip to first unread message

asa letourneau

unread,
Apr 8, 2011, 2:48:44 AM4/8/11
to eaditor
I have been playing around with NoteTab using the EAD Cookbook Note
Tab customisation package to create EAD docs, validate them and
transform them into html.

What I'd really like to do know is how to automate the process i.e.
have a script or something that will get the required metatdata from
an excel spreadsheet and place it into the EAD template. I'd then like
to do a batch process where I can conceivavbly create a large number
of EAD docs automatically without having to manually key in the
details.

Does anyone know if this has been done?

Cheers

Ethan Gruber

unread,
Apr 8, 2011, 9:19:34 PM4/8/11
to ead...@googlegroups.com
Hi Asa,

Did you intend to send this to the LOC EAD list rather than EADitor?

Excel allows for exporting to XML, so you could conceivably process the spreadsheet in XML form to generate a numerous EAD finding aids.  Even better, you can use Google Docs to create and update the spreadsheet and take advantage of Google's API that returns all or sections of the spreadsheet in the form of Atom XML.  This makes the processing easier because you don't have to manually export the spreadsheet to XML as you would with Excel.  Moreover, the Atom entry for a row includes its modification date, so you can process rows nightly that were modified earlier that day.

Ethan
Reply all
Reply to author
Forward
0 new messages