Required for this procedure:
- Notices from Proquest that files are available.
- Filezilla.
- Proquest FTP login info.
- ETD Directory on hard drive with pdf and xml subdirectories.
- 7-Zip.
- Adobe Acrobat Standard. Modify Acrobat settings: When you're in Acrobat, go to edit, then preferences. Click on "Documents" in the left-hand column. In the main part of the pop-up, under PDF/A view mode, use the drop-down to select "never."
- Computer configured to open XML files with WordPad (Right click an XML file and select "Open with" and then "Chose Program." Select WordPad, then click "Always use the selected program to open this kind of file.").
- Editix XML Editor.
- XSL file for reformatting the XML files, ETDConversionForDspace.xsl (attached here).
- Microsoft Excel with the Developer tab enabled and macros enabled (Left click on the windows symbol and select "Excel Options." On the popular tab, check "Show developer tab in the Ribbon." Go to the Trust Center Tab. Click "Trust Center Settings." Click "Enable all Macros.").
- Excel Template, ETDtempDspace.xlsm, (attached here).
- SAF Builder program (downloaded from Github and installed by LITS) and Java JDK, GIT, and Maven. Oracle VM Virtual Box for running it on Linux, and directory that can be accessed both for Linux and windows.
- Collection File program (attached here in a zip file–unzip it and put it in your ETD directory) and Python to run it.
- For converting video files to mp4's: Avidemux.
...
For other problems with the files Proquest FTP's to us, ask Michelle to call Proquest technical support at 877-408-5027 or 800-889-3358 (or email at tsupport@proquest.com or
http://support.proquest.com/ ) to find a solution.
Adding Supplements to the metadata in Excel and Moving them to the PDF Directory
...
For closed access, the Access Rights field states: "Access limited to the UMBC community. Item may possibly be obtained via Interlibrary Loan through a local library, pending author/copyright holder's permission."
rights: change header to dc.rights
...
- Delete all of the rows where extra data was filled in.
- Change the labels in row 1 as follows:
- Column B: ffilename__permissions:-r'Anonymous'__primary:true
- Column C: filename__permissions:-r'ScholarWorksUMBCIP'__primary:true
- Column D : filename__bundle:LICENSE__permissions:-r'Anonymous'
- Delete column A
- Change the format of any column with data displaying as XXXX to "General." Find all of the 01/01/ and replace with nothing. Skim the dates for anything odd and fix.
Change the format of dc.date.issued filed to text.
- Save your sheet2 (you must be on it) as a .csv file.
- Be sure to close Excel or the next steps won't work.
...
- Zip the SAFbuilder directory that's in the Collection File Program
- Go to
and upload the zipped SAFbuilder directory
E-mail Michelle to have her submit a ticket for DSS to load the files. Let her know the the number of new submissions that you've sent, and she'll confirm that they've all loaded.
...