Page History

...

CSV would have to comply with http://tools.ietf.org/html/rfc4180^{Image Removed}

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^{Image Removed}

I found it very useful.

...

I think this captures most of what we want, but just wanted to add the following:

• More specifically, ideally the ability to change (add, edit, delete) content of existing metadata fields would include some kind of regular expression capability.

• Test mode, see what the changes would look like on the 'console' before committing to final run

Also, if I may digress slightly, a somewhat different need, although similar in kind, concerns working with bitstreams:

• add or delete a bitstream to every item in a set

For example, we have a use-case where we would like to add another category or bitstream to groups of items without having to reload the entire record.

...