Required for this procedure:
...
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
...
- Take the licenses want to work on to the copier an put them in the top tray.
- Press email.
- Enter your email address.
- Download the pdf from the email.
- Open the PDF with Acrobat.
- Select tools then select Organize Pages
- Select all of the pages
- Click Extract.
- Check Extract as Separate Files, then click Extract.
- Select the License folder.
- Go to the license folder.
- Open the first file.
- If no choice was made, or license wasn't signed, put in the unusable folder.
- Shrink to 75%.
- Do a "Save As," and rename the individual files using the naming convention author's last name, first initial, _first word of the title (omitting articles), _OPEN (e,g, JonesRFindingOPEN,pdf), or author's last name first initial, _first word of the title (omitting articles), _LIM (JonesrFindingLIM.pdf) depending on if access is supposed to be open or limited. If there is an embargo, put the authors name, document title, and embargo length on the embargo list.
- Find the document in the metadata file, ensuring that both the full author name and title match.
- If no entry matches, put the license in the "not in this load" folder.
- In License and PDF titles do match, in the metadata file, move the files from column A to the Open or Limited access column as appropriate, and add the license file name to column D (if the labels aren't staying at the top, go to view, then click normal, the click Freeze Panes and select Freeze Top Row).
- Proofread the file name and the file name and spreadsheet to ensure that they're both the same and match.
- If the next Sharp file is the one you just did, delete it.
- Repeat for each file.
Saving the Excel file as a .csv file:
...