On Thu, Jan 24, 2013 at 5:51 PM, Kirti Bodhmage <k.bodhm...@qmul.ac.uk> wrote: > For some reason we got duplicates of dc.relation.ispartof metadata field in > many of the records in repository. > > Is there any sql to remove these duplicates ?
I'm not sure if it can be done using just SQL. In any case, it would be very complex. The easiest solution might be to use Batch Metadata Editor. 1) export all items: [dspace]/bin/dspace metadata-export -f export.csv -a Depending on the size of your repository, this might produce a huge CSV file. 2) To reduce the file size, remove all columns except for id, collection, action and any dc.relation.ispartof columns. 3) Remove duplicities (search for the "||" separator) 4) Re-import the file: [dspace]/bin/dspace metadata-export -f export.csv -e adminsem...@example.com Another solution would be to use a curation task. Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette ------------------------------------------------------------------------------ Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette