Hi,
Try this first on a test DSpace and NOT on a production instance.
Cheers
Obi Odu
University of Tromsø
Norway
#psql xxxxxx
UPDATE metadatavalue
SET text_value='Dissertation'
WHERE metadata_value_id IN
(
SELECT metadata_value_id
FROM metadatavalue mv,
metadatafieldregistry mfr,
metadataschemaregistry msr
WHERE mv.metadata_field_id = mfr.metadata_field_id
AND mfr.metadata_schema_id = msr.metadata_schema_id
AND mfr.element = 'type'
AND msr.short_id = 'dc'
And mv.text_value='Thesis'
);
From: LIBRIS Reference (LIBRIS) [mailto:[email protected]]
Sent: 16. april 2012 10:45
To: [email protected]
Subject: [Dspace-tech] How to mass change value for metadata
Dear All,
My DSpace is v1.4. I need to change value for metadata for all items in a
collection/community from dc.type=Thesis to dc.type=Dissertation. Is there any
way to do a mass change?
Thanks.
Sherman
National Institute of Education (Singapore) http://www.nie.edu.sg
DISCLAIMER : The information contained in this email, including any
attachments, may contain confidential information.
This email is intended only for the use of the addressee(s) listed above.
Unauthorised sight, dissemination or any other
use of the information contained in this email is strictly prohibited. If you
have received this email by fault, please
notify the sender and delete it immediately.
------------------------------------------------------------------------------
For Developers, A Lot Can Happen In A Second.
Boundary is the first to Know...and Tell You.
Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
http://p.sf.net/sfu/Boundary-d2dvs2
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
