Hello Helix,
Thank you for assistance and absolutely I will back up the database.
Regards,
Lewatle
From: helix84 [mailto:[email protected]]
Sent: 13 February 2013 01:46 PM
To: Lewatle Phaladi
Cc: [email protected]
Subject: Re: [Dspace-tech] Updating items with wrong metadata simultaneously
Hi Lewatle,
this answers your question:
http://dspace.2283337.n4.nabble.com/How-to-mass-change-value-for-metadata-tp4560928p4560981.html
The example changes all the values of dc.type from "Thesis" to "Dissertation"
in the whole repository. If you want to further restrict the changes only to a
specific community, modify the SELECT clause:
* add collection2item to FROM
* add AND collection2item.item_id = metadata_value_id.item_id AND
collection2item.collection_id = YOUR_COLLECTION_ID to WHERE
Don't forget to take a complete backup of the database before changing anything.
Regards,
~~helix84
Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
<html><p><font face = "verdana" size = "0.8" color = "navy">This communication
is intended for the addressee only. It is confidential. If you have received
this communication in error, please notify us immediately and destroy the
original message. You may not copy or disseminate this communication without
the permission of the University. Only authorized signatories are competent to
enter into agreements on behalf of the University and recipients are thus
advised that the content of this message may not be legally binding on the
University and may contain the personal views and opinions of the author, which
are not necessarily the views and opinions of The University of the
Witwatersrand, Johannesburg. All agreements between the University and
outsiders are subject to South African Law unless the University agrees in
writing to the contrary.</font></p></html>
------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________
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
