[Dspace-general] How can I move an item from one collection to another?

[Claudia Juergen]

Hello Ann,

you can try the patch for the move item feature for xmlui:
http://jira.dspace.org/jira/browse/DS-238

The move on db level is not that difficult.  Make sure you got the proper
backups.

The sql commands for moving a single item are:

update item set owning_collection=NewCollectionID where item_id=ItemID;

update collection2item set collection_id=NewCollectionID where
collection_id=OldCollectionID;


Then run index-update.


Hope that helps

Claudia Jürgen


> Hello Claudia,
>   We're using 1.5 xmlui - so I guess we'll need to wait for the next
> version if we want to avoid using the db method.  Thanks!
>
> Ann Nez
>
>
>
> -----Original Message-----
> From: Claudia Juergen [mailto:Claudia.Juergen at ub.tu-dortmund.de]
> Sent: Tuesday, January 19, 2010 9:52 AM
> To: Ann C. Nez
> Cc: 'dspace-general at mit.edu'
> Subject: Re: [Dspace-general] How can I move an item from one collection
> to another?
>
> Hello Ann,
>
> which version of DSpace with which UI are you using?
>
> Since 1.5 there is a feature (jspui, 1.6 for  xmlui) to move items from
> the DSpace UI. Log in as the DSpace instance administrator, navigate to
> the item you want to move, click on "Edit" in the admin tools. Then choose
> "Move Item" and select the collection you want the item to move to.
>
> If you are using a lower DSpace version you got to do it on db level.
>
> Hope that helps
>
> Claudia Jürgen
>
>> We have items in several collections in a sub-community that we want to
>> move to a different collection under a main community.
>>
>> I tried mapping a test item from one collection to another, and then
>> deleting the test collection.
>> Before I deleted the test collection (containing the one test item),
>> the
>> system displayed the warning:
>>
>> Are you sure collection test 2 collection should be deleted? This will
>> delete:
>>
>>  *   Any items and incomplete submissions in this collection that aren't
>> contained in other collections
>>  *   The contents of those items
>>  *   All associated authorization policies
>> I took this to mean that as long as the test item had been mapped to
>> another collection it would continue to exist in that collection.
>> However, after I deleted the test2 collection (and it's one item), the
>> test item was no longer available in the collection to which it had been
>> mapped.
>>
>> Is there a way to move an item to another collection without re-entering
>> it as a new item?
>>
>> Ann Nez
>> University of Washington Gallagher Law Library
>> acnez at u.washington.edu
>> _______________________________________________
>> Dspace-general mailing list
>> Dspace-general at mit.edu
>> http://mailman.mit.edu/mailman/listinfo/dspace-general
>>
>
>
> --
> Claudia Jürgen
> Eldorado - Repositorium der TU Dortmund
>
> Universitätsbibliothek Dortmund
> Vogeplothsweg 76
> D-44227 Dortmund
> Tel.: 0049-231-755-4043
>
>
>
>


-- 
Claudia Jürgen
Eldorado - Repositorium der TU Dortmund

Universitätsbibliothek Dortmund
Vogeplothsweg 76
D-44227 Dortmund
Tel.: 0049-231-755-4043