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
[email protected]<mailto:[email protected]>
On Jun 13, 2014, at 1039, Alan Orth
<[email protected]<mailto:[email protected]>> 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
[email protected]<mailto:[email protected]>
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
