From UA Libraries Digital Services Planning and Documentation
- After your spreadsheet is finished, the subjects are all tagged, and the names (except in description and title) all have database numbers,
- Use ExcelConverter (S:\Digital Projects\Administrative\scripts\ExcelConverter\ExcelConverter.pl) to export a tab-delimited UTF8 (without Byte Order Mark) file into the collection Metadata directory.
- Run spreadsheetcheck.pl (S:\Digital Projects\Administrative\scripts\Metadata\spreadsheetCheck.pl) to verify that your Metadata file is error free before creating MODS.
- Click on GUI_makeMods.pl (S:\Digital Projects\Administrative\scripts\Metadata\makeMods\GUI_makeMods.pl) and navigate to your spreadsheet
- GUI_makeMods.pl will create a MODS directory in the same directory as the spreadsheet and put the generated MODS there.
- A manifest and an error file will be put in the same directory also.
- When the script has finished, look in your Metadata directory for any errors file that may have been generated.
- If found, repair the errors, and go back to step 1.
- If not found, there should now be MODS in the MODS directory, and a manifest.xml file listing those MODS in the Metadata directory. Go forth and validate!