Page Comparison

When needing to create spreadsheets for batch ingesting Variations files.

Variations XML Files

This guide will take you through the process of creating an ingest spreadsheet from Variations XML files. The XSL code converts the XML tag content into a txt file that can be imported into a spreadsheet (using "^" as the separator). 

Step-by-step guide

1. Open an SSH Client.
2. Log into magnolia.dlib.indiana.edu
   
   1. Log in with your username and password.
3. Create a file named xmlingest_sort.xsl using the code found below.

4. Run this command: 

   Code Block
   language bash
   xsltproc xmlingest_sort.xsl ../srv/variations/content/access/audio/files.xml >> batchingest.txt

   1. You'll need to replace "files.xml" with the Variations xml files you wish to ingest.
   2. Replace "batchingest.txt" with the TXT file name you wish to create.

Create a spreadsheet

1. Add column titles with the following:
   1. Bibliographic ID
      1. The Bibliographic ID will be the Variations XML file name (i.e. "VAA5239" from the file VAA5239.xml).
      2. Variations XML tag: //RecordSet/MediaObject/Label
   2. Bibliographic ID Label
      1. The XSL will fill this column with the word "other".
   3. Title
      1. This information will be overwritten by the information that the Bibliographic ID pulls in, but it is required.
      2. Variations XML tag: //DisplayTitle
   4. Creator
      1. This information will be overwritten by the information that the Bibliographic ID pulls in, but it is required.
      2. Variations XML tag: //Publisher
   5. Date Issued
      1. This information will be overwritten by the information that the Bibliographic ID pulls in, but it is required.
      2. Variations XML tag: //PublicationDate
   6. Label
      1. The XSL will fill this column with the word "other".
   7. File
      1. The file name(s) will be in the format of: vaa1234a.192k.mov
      2. You'll need a File column for each file associated with a Variations item.
      3. Variations XML tag: //RecordSet/MediaObject (The XSL edits the content of this tag so that it matches the file name and adds ".192k.mov")
   8. Label
      1. Leave this column blank.

...