{"word_count": 356, "character_count": 2530}
There you are idly scrolling through Twitter when someone announces a tempting resource that's just crying out for TEI-ification. And there goes the afternoon and most of the evening. Anyway, creating my EEBO Bibliography in TEI was insultingly easy. I just grabbed the Excel spreadsheet (34 Mb) thoughtfully created by those lovely people at Protext, and even more thoughtfully publicized by the even more lovely Heather Froelich on twitter this morning. I opened it up in Open Office. I exported it as a CSV file (85 Mb) and munged same through the standard TEI cvstotei stylesheet to generate 175 Mb of TEI compatible data. Then I sat down to consider how to make it actually TEI conformant, i.e. how to make the title of a bibliographic entry appear not as the content of &#60;cell n="5"&#62; but as the content of a .... &#60;title&#62;. As you might suppose, defining the right mapping was easy for some things, but less so for others of the 17 cells in each of the 146,323 rows of the spreadsheet. There's a table to show the mapping I decided on at the end of this blog, for those unwilling to read my pellucid XSLT code which actually uses it.  The resulting TEI file isn't quite complete because it doesn't have a TEI Header, needed to define the prefixes I use to save space in the URLs, but (at 120 Mb) it's too big for github. And it's now available at https://app.box.com/s/r8sxc68239g6pen09blzmul93tqs8rbv for your xpathing pleasure.  Here's the table. The whole spreadsheet is a &#60;listBibl&#62; and each row becomes a &#60;bibl&#62;. I like simple solutions. I'm not proud of the &#60;note type="foo"&#62;s, but that's the best I could think of without getting far too complicated. 1MARC identifier@xml:id : prefixed by eebo:2Image set identifier@facs : prefixed by eeboIs:3Publication type@type (always either Book or Issue)4Collection &#60;series&#62;5Title&#60;title&#62;6 Author&#60;author&#62;7Publication Date&#60;pubDate&#62;8Publisher&#60;publisher&#62;9Country name&#60;pubPlace&#62;10Publication language@xml:lang gives ISO code equivalent; text goes in a&#60;note type="langNote"&#62; c11Accession number&#60;idno&#62;12Source Library&#60;note type="sourceLibrary"&#62;13Full text imageif "Y", &#60;note type="transcriptType"&#62; contains "image"14Full textif "Y", &#60;note type="transcriptType"&#62; contains "text"15USTC Classification&#60;note type="keywords"&#62;16Release dateToo boring to include17 URL@ref with prefix proquest:Mapping EEBO spreadsheet fields to  bits of a TEI &#60;bibl&#62;