Hi Chris, Have you seen the Batch Metadata Editing functionality in DSpace? This may do exactly what you are looking for. It exports metadata to spreadsheet. Then you can edit the spreadsheet and reimport it (from the Admin UI). DSpace will verify the changes & give you a detailed list of all the modifications that it will make. At that point you can approve them or cancel.
See https://wiki.duraspace.org/display/DSDOC5x/Batch+Metadata+Editing Personally, I never recommend changing things at the database level (unless there really is no other way). Doing so is inherently dangerous, as DSpace obviously has no way to validate your changes. If you do go that route, I recommend thoroughly testing your entire process on a Test Server (or a copy of your Production Server) before you do anything in Production. You also should be sure to backup your database beforehand. - Tim On 6/3/2015 12:02 PM, Chris Gray wrote: > We've found a certain amount of dirty data in our DSpace instance and we > would like to correct it. > > We are considering doing this by extracting records that need correction > from the database into a spreadsheet, by editing the spreadsheet, and > then by updating the spreadsheet data into the database. This would be > more efficient and less error prone than doing all of this through the GUI. > > It is mostly editing or adding metadata field text values and moving > items that were placed in the wrong collection. > > Will this bypass a record keeping function that is managed by the GUI > and will it cause problems in the future? > > For instance, the metadatavalue table includes the columns place, > authority, and confidence. The last two seem unused, but the first is > just an integer that means nothing to me. > > Chris Gray > Systems Analyst > 519-888-4567, ext. 35764 > cpg...@uwaterloo.ca > University of Waterloo > > > ------------------------------------------------------------------------------ > _______________________________________________ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech > List Etiquette: > https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette > ------------------------------------------------------------------------------ _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
