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
------------------------------------------------------------------------------
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
