Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

Version 1 Next »

System Requirements

  • CONTENTdm Administration

  • Microsoft Excel

Exporting metadata from CONTENTdm

  1. Go to CONTENTdm Administration → Login with your credentials

  2. Go to the “Collections” tab

  3. Select the collection you want to export metadata from in the “Current collection” drop down list → Click on the “Change” button

  4. Click “Export”

    1. Click to check the “Return field names in first record → Click “Next

      Screenshot 2024-07-01 102615.jpg

    2. Right click on “export.text” → select “Save link as…” → Save .txt file to your computer (rename the file according to the collection)

Copying metadata from exported .txt file to new template

  1. Open exported .txt file in Microsoft Excel (optional: save the file as a new Excel workbook)

  2. Open Preservica metadata spreadsheet template (USmetadataTemplate.xlsx)

  3. Use the Qualified Dublin Core mapping document to copy over content from the exported metadata spreadsheet into the new template

    1. Examples:

      1. Title → title

      2. Call number → not mapping (means this does not need to be transferred to new template spreadsheet)

      3. Subject (LCSH) or Subject (Keyword) → maps to subject

Each subject must be separated into individual cells across multiple columns and NOT strung together in the same cell, separated by a semicolon

iv. Geographic locations → map to spatial

Each geographic location must be separated into individual cells across multiple columns and NOT strung together in the same cell, separated by a semicolon

v. Time periods → map to temporal

Each time period (century, decade range) must be separated into individual cells across multiple columns and NOT strung together in the same cell, separated by a semicolon

  1. Repeat copy and paste actions for all mapped content according to the mapping document

  2. Save the new template → rename with this format: QDC_[Name of Collection]_YYYY-MM-DD → Save to Box (Digital Stewardship Program → Digital Preservation and DAM → Preservica → Preservica Metadata → Qualified Dublin Core Metadata)

  • No labels