Hello,
I found an older thread (by Shaun Donovan, 2014) on the list discussing
this issue and he offered some SQL commands for exploring the mappings of
an item:
dspace=# select * from collection2item where item_id = '80596';
Using that, I removed all mappings except the legitimate ones:
dspace=# delete from collection2item where item_id = '80596' and id not
in (90792, 90806, 90807);
After refreshing the item view for the particular item I now see only the
three correct mappings remaining. Is this solution sufficient, or are there
some other relationships I should take care of in the database?
Thank you,
On Tue, Jan 10, 2017 at 3:19 PM Alan Orth <[email protected]> wrote:
> Hello,
>
> I tried to remedy this by exporting the item's metadata as CSV, deleting
> the duplicate mappings in the file, and re-importing, but DSpace says that
> "no changes were detected". Does anyone have any ideas about this?
>
> Thanks,
>
> On Mon, Jan 9, 2017 at 6:17 PM Alan Orth <[email protected]> wrote:
>
> Hello,
>
> Has anyone ever had issues with duplicate item mappings? We have an item
> that has been mapped to the same collection 184 times (really). I doubt the
> editor did this on purpose!
>
> We are running DSpace 5.5 with XMLUI on PostgreSQL 9.5.
>
> Thanks,
> [image: Screen Shot 2017-01-09 at 17.59.32-fs8.png]
> --
>
> Alan Orth
> [email protected]
> https://englishbulgaria.net
> https://alaninkenya.org
> https://mjanja.ch
>
> --
>
> Alan Orth
> [email protected]
> https://englishbulgaria.net
> https://alaninkenya.org
> https://mjanja.ch
>
--
Alan Orth
[email protected]
https://englishbulgaria.net
https://alaninkenya.org
https://mjanja.ch
--
You received this message because you are subscribed to the Google Groups
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.
