ScholarWorks provides batch metadata editing using CSV (Excel) files. Each campus can download the latest metadata (updated each night) from the URL provided by the Chancellor’s Office. Contact David if you don’t have that URL.
The metadata will come in a .zip file, containing multiple CSV files – one for each data model / form. You can edit the spreadsheets as you like and email the changes to the Chancellor’s Office. At that point, we will create a report showing what changes will be made. Once you approve those, we’ll run the changes for real in ScholarWorks.
Fields with multiple values
Fields that have with multiple values should use the pipe symbol ( | ) to separate each value.
...
Other than the person’s name, which needs to be the first element – and should not have any carets preceding it – the other subfields can be in any order. The importer will determine if the subfield is an email address or ORCID ID if the value matches those respective patterns (so make sure they do!).
Otherwise, if the subfield value matches neither pattern and also does not have a number or '@' in it, the importer will assume the value is the institution name. This may change slightly in the future if we add more subfields.
...