At the University of North Texas Digital Newspaper Unit we use many tools to create and edit metadata. One of our workflows involves gathering metadata from the US Newspaper Directory and entering it in an Excel spreadsheet.
The metadata is later transferred manually to an online interface called the New Record Creator (NRC) that exports XML templates for applying metadata to groups of newspapers as they are uploaded to the Portal to Texas History (PTH).
I recently developed a proof of concept script in Ruby that uses OLE automation to create an XML file directly from a spreadsheet. It also provides an option to immediately upload the metadata to the NRC with Selenium WebDriver.
The metadata is later transferred manually to an online interface called the New Record Creator (NRC) that exports XML templates for applying metadata to groups of newspapers as they are uploaded to the Portal to Texas History (PTH).
I recently developed a proof of concept script in Ruby that uses OLE automation to create an XML file directly from a spreadsheet. It also provides an option to immediately upload the metadata to the NRC with Selenium WebDriver.