DRS / JSTOR Forum Image Linking Workflow
Workflow Summary:
This workflow facilitates linking of deliverable images in Harvard’s Digital Repository Service (DRS1 or DRS2) to JSTOR Forum Display Records.
New Display Records are created within JSTOR Forum, and a spreadsheet is exported. Using your DRS load report, urns of the images to be linked are added to the spreadsheet. The spreadsheet is imported back to JSTOR Forum, with the urns automatically associated with their corresponding SSIDs.
This workflow assumes that images have already been deposited and a DRS load report is available to acquire urns for the desired images.
1.Create new records in JSTOR Forum: Start by clicking the gear icon in the upper right hand corner.
2. Create the same number of records as images you intend to link.
3. From the record creation success screen, click on “Export to Excel”
This will export an .xls file populated with the new records you’ve just created. The metadata columns will be blank, except for the SSID which has been generated for each new record.
Note: Exported JSTOR Forum Display Record spreadsheets are not sorted by SSID by default. Sorting by SSID is recommended.
4. Open your DRS load report in Excel, and copy the urn’s of the desired images.
5. Prepend “drs:” to the urns.
If working with small numbers of records, this can be done manually. If working with larger numbers of records, a simple concatenate function can be set up in a reusable excel template to accomplish this.
See drs_SS_fileCAT.xlsx
6. The file names should now appear as in column B below. Save and close.
7. Return to your JSTOR Forum project and again use the gear icon to navigate to Excel --> Import records.
8. Browse to your JSTOR Forum spreadsheet, and click “Import”
9. Confirm successful import.
Useful concatenation tool: