...
When you process the metadata for embargoed documents in Excel, insert a note into the metadata for the document stating: "At the author's request, this dissertation isn't being made available at this time." The metadata is then uploaded as usual along with the title page. The metadata will be revised to remove this note when we receive the full file.
For other problems with the files Proquest FTP's to us, ask Michelle to call Proquest technical support at 877-408-5027 to find a soluation.
Prepare the metadata:
- Open the Excel Metadata Template spreadsheet and insure that you're on the ContentDM worksheet. Then run the macro "Delete_Everything" by using CTRL-X. IMPORTANT: This Macro will delete everything on whatever worksheet you happen to be on, so be absolutely certain you're in the right place before running it.
- Go to the Proquest worksheet and import each XML file. To import, click "Developer" then "Import" then find and select there file. After each import, run the "Mover" macro to move each metadata record into the ContentDM worksheet by using CTRL-M.
- Insure that you have a metadata record for each PDF before proceeding. If not, you missed something or did something twice and need to figure out what you did and fix it.
- Run the macro "ReFormatter" macro by using CTRL-R.
- Check all fields that require checking against the XML files. A metadata map showing how each ContentDM field corresponds to the Proquest XML data is attached. Correct or report any problems. Details:
...