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.
The XML is configured for no open access. If we start getting ones with permissions, Michelle will create a second XML file for them, and they'll need to be done separately.
...
- Open the Excel template version 5.1.
- Run the macro "Delete_Everything" by using CTRL-X. This will delete the content of sheet 1 and any existing XML map. If there is not an existing XML map, it will make an error which can be ignore.
- Delete the sheet2 that has old content in it. Create a new worksheet and rename it sheet2 if not named that already.
- Return to sheet1, cell 1A. Use developer import to import the file you created using Editix.
- Press ctr-r to run the reformatter macro.
- Go to the sheet2.
- Separate the keywords by semi-colons by changing commas in the keyword field to semicolons where appropriate.
- In the filename column, enter the names of any extra files to be loaded in the appropriate line. Separate it from the existing file with ||. In the dc.description column for these, add a note indicating that there's a supplement and it's format, eg "Include 1 .jpeg3 supplement"
- Save your sheet2 (you must be on it) as a .csv file.
- Be sure to close Excel or the next steps won't work.
Run the SAF builder:
- Put the .csv metadata file is in the same directory with all of the file to be loaded.
- Go the dos prompt: in the start menu, click "Run," then type cmd in the box, and click ok.
- Change the directory to the safbuilder directory, by typing cd c:\safbuilder
- Run the safbuilder by typing" safbuilder.sh -c c:path to metadata file." For example, "safbuilder.sh -c c:\ETD\metadata.csv would run the safbuilder on the metadata.csv file and all of the files in the directory with it.
- The program will make a bunch of text appear in the DOS window. If it says ERROR in square brackets, the program didn't run. You probably made a typo when you typed the run command in. Try again, and be sure to type it all correctly.
- When it's run correctly, and SimpleArchiveFormat directory appears in the folder your files and csv are in.
- In DOS window, it should indicate that ETDtempDspace.csv has been used 0 times.These errors happen when the files in the folder and filenames in the csv file don't match. Determine if there is a problem that needs to be corrected by comparing your .csv file to the contents of your directory. If necessary, make the corrections, delete your SimpleArchiveFormat directory, and run the safbuilder again. If you can't fix the problems, ask Michelle for help. If she's not there, you can copy and paste all the errors to Word by pushing the PrtScn and Ctrl keys together to copy your screen to the clipboard, and paste your screen into Word--if there are many errors, scroll through them getting them all pasted into Word.
To run the program to create the collection files:
...