WCSU Archives' EAD Production Guide

This guide provides all the elements needed for creation of EAD-encoded finding aids for the collections of Western Connecticut State University. Our production of EAD relies on NoteTab as the XML editor and MS Excel for an encoding template.

Finding aids created from these templates are designed to conform to local content standards based on those of delineated by RLG. We are in the process of migrating our templates to OpenOffice documents from Microsoft documents. Please check back for updates.

Brian Stevens, Archivist and Special Collections Librarian

1. Getting Started

The links below are files that are needed to configure NoteTab for EAD production. These may be downloaded. To download the file, right-click on the link, select "Save" and place in the folder specified with the link. Install all these elements before moving to the directions.

NoteTab Resources

EADCookbookforNoteTab.exe EadCookbookforNoteTab.exe

This is a self-extracting exe that will create a directory called eadcb under C:. You will need to replace some of the default library files. For more information on this tool, see Chris Prom's site


EAD Cookbook for New.clb EAD Cookbook for New.clb

This WCSU version of the clb file configures NoteTab to work with EAD XML files. It should be placed in the NoteTab libraries directory under Program Files (for example: C:\Program Files\NoteTab Pro\Libraries). It includes a NoteTab clip called "big conversion" which takes the product of the Excel template and strips out formatting. It also includes "EAD Schema Validation" - a clip that does just that in concert with xmlStarlet

xmlStarlet (for Windows) xmlStarlet

A Java application for validating an EAD document against the new EAD schema (ead.xsd). This should be installed in C:\Program Files. If not you will need to edit the "EAD Schema Validation" clip accordingly.


Clip for removing Excel formatting Big conversion clip
This is the clip that is used in concert with the Excel EAD template and will save a file in eadcb/EADfiles/ with the file name of the eadid value.
You may download this zip file and replace the c:/Program Files/NoteTab Pro/Libraries with this Libraries folder which contains both the above clips and the EAD Cookbook Tab. Libraries.zip

Excel Templates and macro code

MS Excel EAD template eadTemplate.xls
VB code for Excel macro macro.txt

Directions on use of this template is included in the file. The file is set as "read only." You don't need the macro to use the template but it's an easy way to retrieve everything you need from the template. To set-up the macro:

  • open macro.txt and copy all the contents onto your clipboard
  • open eadTemplate.xls in Excel, and click Tools/Macro/Record New Macro.
  • create a macro called "bigConversion"
  • in the "store in" box, select "personal macro workbook
  • you will see a tiny prompt like the one below, click the square stop button.

  • click Tools/Macro/Macros and you will see a prompt like the one below

  • click "Step Into." This will open VB editor. Delete all the content of that macro in the Module1 (Code) and paste in what you copied onto your clipboard from macro.txt

  • click the save icon and close the VB editor.

XSD, Character Entity Reference Files, and style sheet

EAD Schema file ead.xsd
XLINK Schema file xlink.xsd
Entity Files Zipped entity files
Generic xslt style sheet yOURsTYLEsHEEThERE.xsl

These files should all go into the EADFiles folder in which you will be creating your finding aids. The WCSU Archives stylesheet based on one of James Ford Bell's style sheet and was embellished with code written by Leslie Myrick and Brian Stevens. This file should be placed in c:/eadcb/EADFiles.

back to top

2. Directions

  • Fill out the Excel EAD template carefully using established best practices for content*
  • Paste into a blank NoteTab document (make sure that you have the EAD Cookbook For New clip book open in NoteTab (clip books are represented by tabs at the bottom of the page)
  • Double click the bigConversion clip
  • Validate the EAD
  • Make sure you have a stylesheet with same name you assigned in the Excel template. By default the name of the stylesheet is yOURsTYLEsHEEThERE.xsl which is a generic style sheet provided here to download.
  • View the xml document in your browser

* For content help see:

back to top

3. Examples

back to top
Find us on Facebook