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

...

• 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.

...