Takes AS ids from an AS-exported EAD and outputs a pipe-separated file compatible with the Harvard Excel DO import plugin

as_ids_from_ead_for_digital_import.xsl

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:xs="http://www.w3.org/2001/XMLSchema"
    xmlns:ead="urn:isbn:1-931666-22-9"
    exclude-result-prefixes="xs"
    version="2.0">
    <xsl:output omit-xml-declaration="yes"/>
    <xsl:template match="ead:ead">
        <xsl:for-each select="//ead:c[@level='file']">
            <xsl:value-of select="//ead:eadid"/>
            <xsl:text>|</xsl:text>
<!--            blank column -->
            <xsl:text>|</xsl:text>
            <xsl:value-of select="substring-after(@id, 'aspace_')"/>
            <!--            blank column -->
            <xsl:text>|</xsl:text>
            <xsl:text>|</xsl:text>
            <xsl:value-of select="ead:did/ead:unittitle"/>
            <xsl:text>|</xsl:text>
<!--            Default value set to true -->
            <xsl:text>TRUE</xsl:text>
            <xsl:text>|</xsl:text>
            <xsl:text>&#xA;</xsl:text>
        </xsl:for-each>
    </xsl:template>
</xsl:stylesheet>

bobfass_dao.xsl

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:xs="http://www.w3.org/2001/XMLSchema"
    xmlns:ead="urn:isbn:1-931666-22-9"
    xmlns:xlink="http://www.w3.org/1999/xlink"
    exclude-result-prefixes="xs"
    version="2.0">
    
    <!-- specific version for bob fass --> 
    
    <xsl:output omit-xml-declaration="yes"/>
    <xsl:template match="ead:ead">
        <xsl:for-each select="//ead:c[@level='file']">
            <xsl:value-of select="//ead:eadid"/>
            <xsl:text>|</xsl:text>
            <!--            blank column -->
            <xsl:text>|</xsl:text>
            <xsl:value-of select="substring-after(@id, 'aspace_')"/>
            <!--            blank column -->
            <xsl:text>|</xsl:text>
            <xsl:text>|</xsl:text>
            <xsl:value-of select="ead:did/ead:unittitle/normalize-space()"/>
            <xsl:text>|</xsl:text>
            <!--            Default value set to true -->
            <xsl:text>TRUE</xsl:text>
            <xsl:text>|</xsl:text>
            <!--            Fass identifier -->
            <xsl:value-of select="substring-before(substring-after(ead:scopecontent/ead:p, 'Unique identifier: '), '.')"/>
            <xsl:text>|</xsl:text>
            <xsl:value-of select="ead:did/ead:dao/@xlink:href"/>
            <xsl:text>&#xA;</xsl:text>
        </xsl:for-each>
    </xsl:template>
</xsl:stylesheet>

conant_as_ids_from_ead_for_digital_import.xsl

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:xs="http://www.w3.org/2001/XMLSchema"
    xmlns:ead="urn:isbn:1-931666-22-9"
    exclude-result-prefixes="xs"
    version="2.0">
    <xsl:output omit-xml-declaration="yes"/>
    <xsl:template match="ead:ead">
        <xsl:for-each select="//ead:c[@level='item']">
            <xsl:value-of select="//ead:eadid"/>
            <xsl:text>|</xsl:text>
            <!--            blank column -->
            <xsl:text>|</xsl:text>
            <xsl:value-of select="substring-after(@id, 'aspace_')"/>
            <xsl:text>|</xsl:text>
            <xsl:value-of select="ead:did/ead:container[1]/normalize-space()"/>
            <xsl:text>; </xsl:text>
            <xsl:value-of select="ead:did/ead:container[2]/normalize-space()"/>
            <xsl:text>|</xsl:text>
            <xsl:value-of select="ead:did/ead:unittitle/normalize-space()"/>
            <xsl:text>|</xsl:text>
            <!--            Default value set to true -->
            <xsl:text>TRUE</xsl:text>
            <xsl:text>|</xsl:text>
            <xsl:text>&#xA;</xsl:text>
        </xsl:for-each>
    </xsl:template>
</xsl:stylesheet>