James, Awesome, this works. For the record (and for future space travelers, including myself!), it was sufficient to do an `index-update` afterwards to update the search / browse indexes. No stopping of Tomcat and `index-init` required.
Cheers, Alan On 06/13/2014 06:57 PM, James Creel wrote: > UPDATE metadatavalue SET text_value = ’REPORT' WHERE text_value = > ’TECHNICAL REPORT’; > > Directly manipulating the database is often the most expedient way to > solve a problem or get a report, but at the database prompt you are > always exactly one query away from destroying your DSpace. This query > is fairly safe, but it’s very wise to back stuff up first and maybe kill > current sessions on the system-wide alerts page so nobody loses their > work if you have to restore. Good luck! > > > > James Creel > Senior Lead Software Applications Developer > Texas A&M University Libraries Digital Initiatives > jcr...@library.tamu.edu <mailto:jcr...@library.tamu.edu> > > > > > > On Jun 13, 2014, at 1039, Alan Orth <alan.o...@gmail.com > <mailto:alan.o...@gmail.com>> wrote: > >> Hi, >> >> We've updated some of our controlled vocabularies for new conventions in >> our organization, like "TECHNICAL REPORT" -> "REPORT", but now I need to >> do a batch update of the stored meta data values. If it were simply a >> collection I'd export the meta data CSV and then change it there, but we >> have records across the whole repository which need to be updated. I >> assume SQL is the only way? >> >> I'm not very familiar with DSpace's PostgreSQL schema, so I really need >> advice on how to approach this in a safe way. We're on DSpace 3.1. >> >> Thanks, >> -- >> Alan Orth >> alan.o...@gmail.com <mailto:alan.o...@gmail.com> >> http://alaninkenya.org >> http://mjanja.co.ke >> "I have always wished for my computer to be as easy to use as my >> telephone; my wish has come true because I can no longer figure out how >> to use my telephone." -Bjarne Stroustrup, inventor of C++ >> GPG public key ID: 0x8cb0d0acb5cd81ec209c6cdfbd1a0e09c2f836c0 >> >> ------------------------------------------------------------------------------ >> HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions >> Find What Matters Most in Your Big Data with HPCC Systems >> Open Source. Fast. Scalable. Simple. Ideal for Dirty Data. >> Leverages Graph Analysis for Fast Processing & Easy Data Exploration >> http://p.sf.net/sfu/hpccsystems_______________________________________________ >> 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 > -- Alan Orth alan.o...@gmail.com http://alaninkenya.org http://mjanja.co.ke "I have always wished for my computer to be as easy to use as my telephone; my wish has come true because I can no longer figure out how to use my telephone." -Bjarne Stroustrup, inventor of C++ GPG public key ID: 0x8cb0d0acb5cd81ec209c6cdfbd1a0e09c2f836c0
signature.asc
Description: OpenPGP digital signature
------------------------------------------------------------------------------ HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions Find What Matters Most in Your Big Data with HPCC Systems Open Source. Fast. Scalable. Simple. Ideal for Dirty Data. Leverages Graph Analysis for Fast Processing & Easy Data Exploration http://p.sf.net/sfu/hpccsystems
_______________________________________________ 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