Skip to main content
UploadLanguage (EN)Support
BusinessMobileSocial MediaMarketingTechnologyArt & PhotosCareerDesignEducationPresentations & Public SpeakingGovernment & NonprofitHealthcareInternetLawLeadership & ManagementAutomotiveEngineeringSoftwareRecruiting & HRRetailSalesServicesScienceSmall Business & EntrepreneurshipFoodEnvironmentEconomy & FinanceData & AnalyticsInvestor RelationsSportsSpiritualNews & PoliticsTravelSelf ImprovementReal EstateEntertainment & HumorHealth & MedicineDevices & HardwareLifestyle
Uploaded byguest53eac8
PPT, PDF563 views

Digital + Container List

This document outlines a process for integrating a finding aid (series inventory) with digital objects in a CONTENTdm collection. It describes exporting metadata from CONTENTdm, transforming it with an XSLT stylesheet to include URLs, and inserting the results into the finding aid using Microsoft Word mail merge to link containers to digital files. The end result is an EAD finding aid with integrated links from the container list to digital objects.

Technology◦Economy & Finance◦Education◦
Download to read offline
Digital + Container List EAD and CONTENTdm Integration
Define the Need Series inventory (finding aid) online is central location for information about the records Link to finding aid from digital metadata (=one direction) How to link to digital folder/file/object from finding aid?
Discovery Process Asked DiMeMa Technical Support How to get list of Reference URLs? Not sure, suggested XML output Experimented with XML “ Standard CONTENTdm XML” contains Reference URL (“ViewerURL”)
Unexpected Help December 2006 Max Evans expresses interest in project and offers advice on XML Series of email correspondence working through ideas and suggestions, from using Excel extensively to creating an XSLT stylesheet Ready to experiment with creating our own stylesheet with guidance and modeling after existing stylesheet for transforming our inventories
The Final Process Export Standard CONTENTdm XML Run stylesheet (XML Spy Home [Free]) Copy resulting table from HTML to Excel Check that URLs and Titles and/or Identifiers line up then copy links into column “link” Merge using MS Word to wrap EAD around container list (existing procedure)
1. Export Standard CONTENTdm XML
XML Export <?xml version=&quot;1.0&quot; encoding=&quot;ISO-8859-1&quot;?> <metadata> <record> <source>13373</source> <creator>Governor (1993-2003: Michael Okerlund Leavitt)</creator> <title>No. 578-597, Mar 1, 2002-Apr 6, 2001</title> <isPartOf>Press releases</isPartOf> <identifier>Box 4 Folder 9</identifier> <relation>Series 13373 | Governor (1993-2003: Michael Okerlund Leavitt) | Press releases | No. 578-597, Mar 1, 2002-Apr 6, 2001</relation> <date>1993-2003</date> <date>2004</date> <type>Text</type> <format>Image/jpeg</format> <format>Epson GT-3000, MicroTek 9800 XL and Adobe Photoshop CS v 8. TIFF Text: 400 ppi at 1 bit Bitonal Black and White. Dark and colored text or text with poor resolution 400 ppi at 8 bit Grayscale. TIFF Photographic Print: 600 ppi at 24 bit color and TIFF Photographic Negative: 1600 ppi at 48 bit color. JPEG Text and Photographic Print/Negative: 150 ppi resolution 700 x 906 pixels.</format> <language>en</language> <rights>Digital Image © 2004 Utah State Archives. All Rights Reserved.</rights> <unmapped>Utah State Archives</unmapped> <unmapped>http://historyresearch.utah.gov/inventories/13373.html</unmapped> <identifier>13373004009</identifier> <description></description> <fullResolution></fullResolution> <cdmid>31</cdmid> <cdmaccess></cdmaccess> <cdmcreated>2006-10-22</cdmcreated> <cdmmodified>2006-12-21</cdmmodified> <thumbnailURL>http://images.archives.utah.gov/cgi-bin/thumbnail.exe?CISOROOT=/13373&amp;CISOPTR=31</thumbnailURL> <viewerURL>http://images.archives.utah.gov/u?/13373,31</viewerURL> Title so I know what I’m working with Numeric string helps me sort The desired URL
2. The Stylesheet (XML -> HTML) <?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?> <xsl:stylesheet version=&quot;1.0&quot; xmlns:xsl=&quot;http://www.w3.org/1999/XSL/Transform&quot;> <xsl:template match=&quot;/&quot;> <html> <head> <title>Extraction of Digital Collection Identifier and URL for Container Lists</title> </head> <body> <p>Copy the following table into the original container list using the <i>Identifier</i> field to properly sort the objects.</p> <table> <tbody> <tr> <th>Title</th> <th>URL</th> <th>Identifier</th> </tr> <xsl:for-each select=&quot;metadata/record&quot;> <xsl:sort select=&quot;identifier[last()]&quot;/> <tr> <td><xsl:value-of select=&quot; title &quot;/></td> <td><xsl:value-of select=&quot; viewerURL &quot;/></td> <td><xsl:value-of select=&quot; identifier[last()] &quot;/></td> </tr> </xsl:for-each> </tbody> </table> </body> </html> </xsl:template> </xsl:stylesheet> Identifier with numeric string for sorting. Calling LAST use of that field as other metadata mapped to Identifier (consult XSLT documentation for more). The 3 fields that will create 3 columns in HTML table For Each compound object
3. HTML output
4. Container List in Excel
5. Creating EAD Microsoft Word Mail Merge <c02 level=&quot;file&quot;> <did> <container type=&quot;reel&quot;>«reel»</container> <container type=&quot;box&quot;>«box»</container> <container type=&quot;folder&quot;>«folder»</container> <unittitle><extref href=&quot;«link»&quot;>«description»</extref></unittitle> </did> </c02> Reel, box, folder and link from Excel spreadsheet. Using mail merge to “wrap” EAD tags around content from container list. Copied to full EAD finding aid document edited usually in XMetal.
EAD container list with links <c01 level=&quot;series&quot;><did> <unittitle>CONTAINER LIST</unittitle></did><c02 level=&quot;file&quot;> <did> <container type=&quot;reel&quot;>1</container> <container type=&quot;box&quot;>1</container> <container type=&quot;folder&quot;>1</container> <unittitle><extref href=&quot;http://images.archives.utah.gov/u?/13373,986&quot;>Transition Index for No. 1-7, Nov 1992-Dec 1992</extref></unittitle> </did> </c02> <c02 level=&quot;file&quot;> <did> <container type=&quot;reel&quot;>1</container> <container type=&quot;box&quot;>1</container> <container type=&quot;folder&quot;>2</container> <unittitle><extref href=&quot;http://images.archives.utah.gov/u?/13373,1007&quot;>Transition No. 1-7, Nov 12, 1992-Dec 7,1992</extref></unittitle> </did> </c02>
Linked container list
The End Archives Digital Collections Archives & History Research Center Call 801-531-3843  Email [email_address]