Page History

...

• DSpace's "Batch Metadata Editing" tool allows you to export sets of DSpace Item Metadata (all Items or just those in specific Communities/Collections) into a CSV file.  The metadata values/fields in the CSV file can then be edited using Microsoft Excel (or OpenOffice Calc).  Once editing is complete, you can re-import the modified CSV to apply the metadata changes into DSpace.
• Detailed "Batch Metadata Editing" Tutorial (from Maureen Walsh at Ohio State University).  (Note that DSpaceDirect uses the XMLUI, so those are the instructions to follow in the tutorial)
  
  • https://kb.osu.edu/dspace/bitstream/handle/1811/47279/WalshMaureenP_SPARC-DSUG_2010-slides.pdf?sequence=7
• Recorded "Batch Metadata Editing" tutorial (from Leonie Hayes at the University of Auckland). (Note that the recording is an interactive tutorial and it is hard to see the screen) 
  
  • http://or2010.fecyt.es/Publico/videos/index.aspx?video=5
• Demo: Batch Metadata Editing basics
  
  • Batch Metadata Editing can be performed at a Community or Collection level
  • Browse to a specific Community or Collection. The "Context" menu will display an option for "Export Metadata".
  • Click "Export Metadata".  This will generate a CSV file that contains all the metadata for every Item within that Community or Collection hierarchy. 
    
    • WARNING: For extremely large communities or collections the export (and import) processes may take a long time (or cause your site to significantly slow down). Therefore, it is recommended to try to edit less than 500 Items (i.e. lines in CSV) at a single time.
  • Edit the CSV using either Microsoft Excel or OpenOffice Calc
    
    • EXCEL WARNING: By default, Excel will not open a CSV in Unicode/UTF-8 encoding. This means that special characters may be improperly displayed and also can be "corrupted" during re-import of the CSV.
      
      • You need to tell Excel this CSV is Unicode, by importing it as follows:
        
        • Open Excel (with an empty sheet open)
        • Select "Data" tab
        • Click "From Text" button (in the "External Data" section)
        • Select your CSV file
        • Wizard Step 1
          
          • Choose "Delimited" option
          • In the "File origin" selectbox, select "65001 : Unicode (UTF-8)"
          • Click Next
        • Wizard Step 2
          
          • Select "Comma" as the only delimiter
          • Click Next
        • Wizard Step 3
          
          • Select "Text" as the "Column data format"
          • Click Finish
  • Perform your edits. Once finished, re-upload the changes to DSpace
  • Click "Import Metadata" (under "Administrative" menu)
  • Select the CSV
  • (A better walkthrough with screenshots of this entire process (and additional hints) is available in the Batch Metadata Editing tutorial linked above)

...