DePauw-IRtomods.xml

<!-- For Prefix -->

<?xml version="1.0" encoding="UTF-8"?>
<modsCollection xmlns="http://www.loc.gov/mods/v3" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.loc.gov/mods/v3 http://www.loc.gov/standards/mods/v3/mods-3-4.xsd">

<!-- For Row Template -->

<mods xmlns="http://www.loc.gov/mods/v3" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.loc.gov/mods/v3 http://www.loc.gov/standards/mods/v3/mods-3-4.xsd">
  <name>
    <namePart>{{jsonize(cells["author 1"].value).replace('"', '')}}</namePart>
    <affiliation>{{jsonize(cells["institution"].value).replace('"', '')}}</affiliation>
    <role>
      <roleTerm authority="marcrelator" type="text">Creator</roleTerm>
    </role>
  </name>
  <name>
    <namePart>{{jsonize(cells["author 2"].value).replace('"', '')}}</namePart>
    <affiliation>{{jsonize(cells["institution"].value).replace('"', '')}}</affiliation>
    <role>
      <roleTerm authority="marcrelator" type="text">Creator</roleTerm>
    </role>
  </name>
  <name>
    <namePart>{{jsonize(cells["author 3"].value).replace('"', '')}}</namePart>
    <affiliation>{{jsonize(cells["institution"].value).replace('"', '')}}</affiliation>
    <role>
      <roleTerm authority="marcrelator" type="text">Creator</roleTerm>
    </role>
  </name>
  <name>
    <namePart>{{jsonize(cells["author 4"].value).replace('"', '')}}</namePart>
    <affiliation>{{jsonize(cells["institution"].value).replace('"', '')}}</affiliation>
    <role>
      <roleTerm authority="marcrelator" type="text">Creator</roleTerm>
    </role>
  </name>
  <name>
    <namePart>{{jsonize(cells["author 5"].value).replace('"', '')}}</namePart>
    <affiliation>{{jsonize(cells["institution"].value).replace('"', '')}}</affiliation>
    <role>
      <roleTerm authority="marcrelator" type="text">Creator</roleTerm>
    </role>
  </name>
  <name>
    <namePart>{{jsonize(cells["advisor 1"].value).replace('"', '')}}</namePart>
    <role>
      <roleTerm authority="marcrelator" type="text">Advisor</roleTerm>
    </role>
  </name>
  <name>
    <namePart>{{jsonize(cells["advisor 2"].value).replace('"', '')}}</namePart>
    <role>
      <roleTerm authority="marcrelator" type="text">Other</roleTerm>
    </role>
  </name>
  <name>
    <namePart>{{jsonize(cells["advisor 3"].value).replace('"', '')}}</namePart>
    <role>
      <roleTerm authority="marcrelator" type="text">Other</roleTerm>
    </role>
  </name>
    <name>
    <namePart>{{jsonize(cells["advisor 4"].value).replace('"', '')}}</namePart>
    <role>
      <roleTerm authority="marcrelator" type="text">Other</roleTerm>
    </role>
  </name>
    <name>
    <namePart>{{jsonize(cells["advisor 5"].value).replace('"', '')}}</namePart>
    <role>
      <roleTerm authority="marcrelator" type="text">Other</roleTerm>
    </role>
  </name>
  <identifier type="local">{{jsonize(cells["article id"].value).replace('"', '')}}</identifier>
  <identifier type="uri">{{jsonize(cells["streaming media"].value).replace('"', '')}}</identifier>
  <note>{{jsonize(cells["comments"].value).replace('"', '')}}</note>
  <abstract>{{jsonize(cells["abstract"].value).replace('"', '')}}</abstract>
  <subject>
         <topic>{{jsonize(cells["subject topic 1"].value).replace('"', '')}}</topic>
         <topic>{{jsonize(cells["subject topic 2"].value).replace('"', '')}}</topic>
         <topic>{{jsonize(cells["subject topic 3"].value).replace('"', '')}}</topic>
         <topic>{{jsonize(cells["subject topic 4"].value).replace('"', '')}}</topic>
         <topic>{{jsonize(cells["subject topic 5"].value).replace('"', '')}}</topic>
         <topic>{{jsonize(cells["subject topic 6"].value).replace('"', '')}}</topic>
         <topic>{{jsonize(cells["subject topic 7"].value).replace('"', '')}}</topic>
         <topic>{{jsonize(cells["subject topic 8"].value).replace('"', '')}}</topic>
         <topic>{{jsonize(cells["subject topic 9"].value).replace('"', '')}}</topic>
         <topic>{{jsonize(cells["subject topic 10"].value).replace('"', '')}}</topic>
  </subject>
  <titleInfo>
    <title>{{jsonize(cells["title"].value).replace('"', '')}}</title>
  </titleInfo>
  <typeOfResource>{{jsonize(cells["type"].value).replace('"', '')}}</typeOfResource>
  <genre authority="local">{{jsonize(cells["document type"].value).replace('"', '')}}</genre>
  <originInfo>
    <dateOther>{{jsonize(cells["embargo_date"].value).replace('"', '')}}</dateOther>
    <dateCreated>{{jsonize(cells["publication-date"].value).replace('"', '')}}</dateCreated>
    <dateCaptured>{{jsonize(cells["submission-date"].value).replace('"', '')}}</dateIssued>
  </originInfo>
  <relatedItem type="host">
         <titleInfo>
            <title>{{jsonize(cells["department"].value).replace('"', '')}}</title>
         </titleInfo>
  </relatedItem>
  <relatedItem type="host">
         <titleInfo>
            <title>{{jsonize(cells["discipline"].value).replace('"', '')}}</title>
         </titleInfo>
  </relatedItem>
  <relatedItem type="original">
         <titleInfo>
            <title>{{jsonize(cells["citation"].value).replace('"', '')}}</title>
         </titleInfo>
  </relatedItem>
</mods>

<!-- Don't put anything in Row Separator -->

<!-- For Suffix -->

</modsCollection>

PALNItomods.xml

<!-- For Prefix -->

<?xml version="1.0" encoding="UTF-8"?>
<modsCollection xmlns="http://www.loc.gov/mods/v3" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.loc.gov/mods/v3 http://www.loc.gov/standards/mods/v3/mods-3-4.xsd">

<!-- For Row Template -->

<mods xmlns="http://www.loc.gov/mods/v3" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.loc.gov/mods/v3 http://www.loc.gov/standards/mods/v3/mods-3-4.xsd">
      <titleInfo>
         <title>{{jsonize(cells["Title"].value).replace('"', '')}}</title>
      </titleInfo>
      <classification authority="lcc">{{jsonize(cells["Call Number 1"].value).replace('"', '')}}</classification>
      <classification authority="lcc">{{jsonize(cells["Call Number 2"].value).replace('"', '')}}</classification>
      <classification authority="lcc">{{jsonize(cells["Call Number 3"].value).replace('"', '')}}</classification>
      <classification authority="lcc">{{jsonize(cells["Call Number 4"].value).replace('"', '')}}</classification>
      <classification authority="lcc">{{jsonize(cells["Call Number 5"].value).replace('"', '')}}</classification>
      <genre authority="local">{{jsonize(cells["Genre 1"].value).replace('"', '')}}</genre>
      <genre authority="local">{{jsonize(cells["Genre 2"].value).replace('"', '')}}</genre>
      <genre authority="local">{{jsonize(cells["Genre 3"].value).replace('"', '')}}</genre>
      <genre authority="local">{{jsonize(cells["Genre 4"].value).replace('"', '')}}</genre>
      <genre authority="local">{{jsonize(cells["Genre 5"].value).replace('"', '')}}</genre>
      <subject>
         <namePart>{{jsonize(cells["Personal Name as Subject 1"].value).replace('"', '')}}</namePart>
         <namePart>{{jsonize(cells["Personal Name as Subject 2"].value).replace('"', '')}}</namePart>
         <namePart>{{jsonize(cells["Personal Name as Subject 3"].value).replace('"', '')}}</namePart>
         <namePart>{{jsonize(cells["Personal Name as Subject 4"].value).replace('"', '')}}</namePart>
         <namePart>{{jsonize(cells["Personal Name as Subject 5"].value).replace('"', '')}}</namePart>
         <topic>{{jsonize(cells["General Subject 1"].value).replace('"', '')}}</topic>
         <topic>{{jsonize(cells["General Subject 2"].value).replace('"', '')}}</topic>
         <topic>{{jsonize(cells["General Subject 3"].value).replace('"', '')}}</topic>
         <topic>{{jsonize(cells["General Subject 4"].value).replace('"', '')}}</topic>
         <topic>{{jsonize(cells["General Subject 5"].value).replace('"', '')}}</topic>
         <topic>{{jsonize(cells["Specific Subject 1"].value).replace('"', '')}}</topic>
         <topic>{{jsonize(cells["Specific Subject 2"].value).replace('"', '')}}</topic>
         <topic>{{jsonize(cells["Specific Subject 3"].value).replace('"', '')}}</topic>
         <topic>{{jsonize(cells["Specific Subject 4"].value).replace('"', '')}}</topic>
         <topic>{{jsonize(cells["Specific Subject 5"].value).replace('"', '')}}</topic>
         <temporal>{{jsonize(cells["Time Period 1"].value).replace('"', '')}}</temporal>
         <temporal>{{jsonize(cells["Time Period 2"].value).replace('"', '')}}</temporal>
         <temporal>{{jsonize(cells["Time Period 3"].value).replace('"', '')}}</temporal>
         <temporal>{{jsonize(cells["Time Period 4"].value).replace('"', '')}}</temporal>
         <temporal>{{jsonize(cells["Time Period 5"].value).replace('"', '')}}</temporal>
      </subject>
      <note type="description">{{jsonize(cells["Summary"].value).replace('"', '')}}</note>
      <note>{{jsonize(cells["Notes"].value).replace('"', '')}}</note>
      <note>{{jsonize(cells["Program"].value).replace('"', '')}}</note>
      <originInfo>
         <dateCaptured>{{jsonize(cells["Digital Audio Date"].value).replace('"', '')}}</dateCaptured>
         <dateCreated>{{jsonize(cells["Date 1"].value).replace('"', '')}}</dateCreated>
         <dateCreated>{{jsonize(cells["Date 2"].value).replace('"', '')}}</dateCreated>
         <dateCreated>{{jsonize(cells["Date 3"].value).replace('"', '')}}</dateCreated>
         <dateCreated>{{jsonize(cells["Date 4"].value).replace('"', '')}}</dateCreated>
         <dateCreated>{{jsonize(cells["Date 5"].value).replace('"', '')}}</dateCreated>
      </originInfo>
      <physicalDescription>
         <note displayLabel="Digitization Specifications">{{jsonize(cells["Technical Specifications"].value).replace('"', '')}}</note>
         <internetMediaType>{{jsonize(cells["Digital Format"].value).replace('"', '')}}</internetMediaType>
         <internetMediaType>{{jsonize(cells["Streaming Format"].value).replace('"', '')}}</internetMediaType>
         <form type="Original Format">{{jsonize(cells["Original Format 1"].value).replace('"', '')}}</form>
         <form type="Original Format">{{jsonize(cells["Original Format 2"].value).replace('"', '')}}</form>
      </physicalDescription>
      <relatedItem type="host">
         <titleInfo>
            <title>{{jsonize(cells["Collection Name"].value).replace('"', '')}}</title>
         </titleInfo>
      </relatedItem>
      <identifier type="local">{{jsonize(cells["CONTENTdm file name"].value).replace('"', '')}}</identifier>
      <identifier type="uri">{{jsonize(cells["avsource"].value).replace('"', '')}}</identifier>
      <identifier type="uri">{{jsonize(cells["YouTube URL"].value).replace('"', '')}}</identifier>
      <accessCondition>{{jsonize(cells["Permissions"].value).replace('"', '')}}</accessCondition>
      <accessCondition>{{jsonize(cells["Rights Statement"].value).replace('"', '')}}</accessCondition>
      <recordInfo>
            <recordInfoNote>{{jsonize(cells["Cataloged?"].value).replace('"', '')}}</recordInfoNote>
            <recordInfoNote>{{jsonize(cells["Digitized?"].value).replace('"', '')}}</recordInfoNote>      
      </recordInfo>
   </mods>

<!-- Don't put anything in Row Separator -->

<!-- For Suffix -->

</modsCollection>

UIndy-IRtomods.xml

<!-- For Prefix -->

<?xml version="1.0" encoding="UTF-8"?>
<modsCollection xmlns="http://www.loc.gov/mods/v3" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.loc.gov/mods/v3 http://www.loc.gov/standards/mods/v3/mods-3-4.xsd">

<!-- For Row Template -->

<mods xmlns="http://www.loc.gov/mods/v3" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.loc.gov/mods/v3 http://www.loc.gov/standards/mods/v3/mods-3-4.xsd">
  <titleInfo>
    <title>{{jsonize(cells["Title"].value).replace('"', '')}}</title>
  </titleInfo>
  <name>
    <namePart>{{jsonize(cells["Authors(s) 1"].value).replace('"', '')}}</namePart>
    <role>
      <roleTerm authority="marcrelator" type="text">Creator</roleTerm>
    </role>
  </name>
  <name>
    <namePart>{{jsonize(cells["Authors(s) 2"].value).replace('"', '')}}</namePart>
    <role>
      <roleTerm authority="marcrelator" type="text">Creator</roleTerm>
    </role>
  </name>
  <name>
    <namePart>{{jsonize(cells["Authors(s) 3"].value).replace('"', '')}}</namePart>
    <role>
      <roleTerm authority="marcrelator" type="text">Creator</roleTerm>
    </role>
  </name>
  <name>
    <namePart>{{jsonize(cells["Authors(s) 4"].value).replace('"', '')}}</namePart>
    <role>
      <roleTerm authority="marcrelator" type="text">Creator</roleTerm>
    </role>
  </name>
  <name>
    <namePart>{{jsonize(cells["Authors(s) 5"].value).replace('"', '')}}</namePart>
    <role>
      <roleTerm authority="marcrelator" type="text">Creator</roleTerm>
    </role>
  </name>
  <name>
    <namePart>{{jsonize(cells["Advisor"].value).replace('"', '')}}</namePart>
    <role>
      <roleTerm authority="marcrelator" type="text">Advisor</roleTerm>
    </role>
  </name>
  <identifier type="local">{{jsonize(cells["Identifier"].value).replace('"', '')}}</identifier>
  <accessCondition>
    <rights.holder>{{jsonize(cells["Rights"].value).replace('"', '')}}</rights.holder>
  </accessCondition>
  <note>{{jsonize(cells["Degree"].value).replace('"', '')}}</note>
  <abstract>{{jsonize(cells["Description"].value).replace('"', '')}}</abstract>
  <subject>
         <topic>{{jsonize(cells["Subject 1"].value).replace('"', '')}}</topic>
  </subject>
  <typeOfResource>{{jsonize(cells["Type"].value).replace('"', '')}}</typeOfResource>
  <originInfo>
    <dateCreated>{{jsonize(cells["Date"].value).replace('"', '')}}</dateCreated>
    <publisher>{{jsonize(cells["Publisher"].value).replace('"', '')}}</publisher>
  </originInfo>
  <physicalDescription>
         <internetMediaType>{{jsonize(cells["Format"].value).replace('"', '')}}</internetMediaType>
  </physicalDescription>
  <relatedItem type="host">
         <titleInfo>
            <title>{{jsonize(cells["College"].value).replace('"', '')}}</title>
         </titleInfo>
  </relatedItem>
  <relatedItem type="host">
         <titleInfo>
            <title>{{jsonize(cells["Department"].value).replace('"', '')}}</title>
         </titleInfo>
  </relatedItem>
  <language>
    <languageTerm type="text">{{jsonize(cells["Language"].value).replace('"', '')}}</languageTerm>
  </language>
</mods>

<!-- Don't put anything in Row Separator -->

<!-- For Suffix -->

</modsCollection>