Overview

In this step, you will be

1. Downloading your spreadsheet template as a CSV file

2. Accessing the spreadsheet ingest module page in the repository

3. Uploading your csv and configuring the spreadsheet page

4. Reviewing your ingest and trouble shooting as necessary

Jump to:

Downloading Template as a CSV

• Once you have filled out your spreadsheet, you need to download the sheet as a CSV file.

• In Google Sheets go to File → Download → Comma Separated Values (.csv, current sheet).

Open

• Your spreadsheet will download as a CSV file and you are ready to use the spreadsheet ingest module in the repository.

Using the Spreadsheet Ingest Page

Log into https://manage.ctdigitalarchive.org

Go to: https://manage.ctdigitalarchive.org/islandora_spreadsheet_ingest.

1. Choose your CSV file. 

2. Click Upload.

3. Choose Ingest Template 2.0 from the Template dropdown list depending on the spreadsheet template you are using.

4. Select MODS as the Output DSID.

5. Click the Transform output check box.

6. Enter DC into the Transform DSID text box

7. Select sites/all/modules/islandora_xml_forms/builder/transforms/mods_to_dc.xml from the Transform XSLT dropdown

Open

8. home/sftp_uconn/chroot/uploads/. In the example in the image, the files that are ready for upload are located at 40002/Videos. If you are ingesting a newspaper title, newspaper issue, book object or compound object, you do not need to enter anything into this field.

9. If you are ingesting newspaper, book, or manuscript page objects, you should click the check box. You will see options to Create PDFs, Generate OCR, Generate HOCR, or Aggregate OCR.

10. The Namespace is your institution's identifying number. Enter it without the colon. If you are unsure of your institution's namespace, you can look for it here or email ctda@uconn.edu.

11. Make sure the Ingest immediately box is checked.

12. Click the Batch Ingest button.

Double Check Before Ingest

Double check the following:

• You have chosen the correct template

• The Base Binaries Folder address is correct

• You have entered the correct namespace

After clicking Batch Ingest

• A progress bar will appear displaying the progress of the ingest process.

• Once the process is complete, you will be brought back to the Spreadsheet Ingest page.