...
CSV would have to comply with http://tools.ietf.org/html/rfc4180
A typical line in the CSV file might look like:
...
- 1. Open the file using Open Office Calc - Spreasheet application. Choose UTF8 format and select the whole column type to be text, then ok
- 2. The spreadsheet opens up and you save it down to an .xls file
- 3. Strip out the fields you don't need like identifier, provenance, as much as possible is best, so you are just left with the id, collection and the fields you want to edit/change.
- 4. A very good tip: this is excellent for importing new items, a whole lot easier than the DSpace import option if you do not have any files to attach. I created a single record with all the details then export this and use the + symbol to add new items. When I have bitstreams I just upload them with skeleton data and use batch editing to enhance the records.
- 5. When you have finished editing the xls file, save it back as a .csv file then import it back into the collection.
- 6. Detailed screen shots of the actual process. Batchmetadata^Batchmetadata.pdf
Vanderbilt University
- Ronee L. Francis (13/05/2009)
I worked with an SQL based application called Collection Workflow Integrated System and so my idea of being able to edit metadata has come from this example. Below is the database I set up a few years back. Next to each subject is a number representing the number of records with that particular subject. When you are logged in as an administrator an "edit" option is also present next to each number. If you choose edit and change the subject it changes the subject in each record where it is present.
http://xserve2.reuther.wayne.edu/SPT--BrowseResources.php
I found it very useful.
...