Scripts for spreadsheet work

From UA Libraries Digital Services Planning and Documentation
Revision as of 07:44, 25 May 2016 by Cjchatnik (talk | contribs)

New workflow: After you have entered data in your spreadsheet including names and subjects. You will want to tag your subjects.

Remediation workflow: For spreadsheets that are in the metadata queue, you will want to review the spreadsheet and make edits. All names should be searched in the names database and replaced with database correspondence entry including the database number. All subjects should be searched in the subject database and replaced with subject database entry including its tags.

DB_SubjectTagging.pl (S:\Digital Projects\Administrative\scripts\Metadata\DB_SubjectTagging.pl) will read the text file version of the spreadsheet and make a list of Subjects that are in the spreadsheet and not in the subjects database. The list will be generated in the correct format needed to upload several at once with GUI_subsToDbase.pl (S:\Digital Projects\Administrative\scripts\Metadata\GUI_subsToDbase.pl) you would just need enter the tagged value. Needed for the script: Navigate to Text export of Metadata spreadsheet.

DB_SubjectReplace.pl (S:\Digital Projects\Administrative\scripts\Metadata\DB_SubjectReplace.pl) will do a find and replace with untagged subjects to tagged subjects using the database. If there are subjects that are in the spreadsheet but not in the database it will make a list of those subjects. Needed for the script: Navigate to Text export of Metadata spreadsheet.

spreadsheetCheck.pl (S:\Digital Projects\Administrative\scripts\Metadata\spreadsheetCheck.pl) Use to verify that your Metadata file is error free before creating MODS. Needed for the script: Navigate to Text export of Metadata spreadsheet. Which at the moment you can only do on the Digital Projects side. Error message will be located in (S:\Digital Projects\Administrative\output)