Dear Obi, Many thanks.
Where do I specify the collection/community DB ID in the SQL commands? I have 2 scenarios, I need to do a mass change for a collection with DB ID 12 (collection_id=12) while another mass change for a community with DB ID 3 (community_id=3). Thanks. From: Odu Obiajulu [mailto:[email protected]] Sent: Monday, 16 April, 2012 5:10 PM To: LIBRIS Reference (LIBRIS); [email protected] Subject: RE: How to mass change value for metadata 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
