Thnaks!  I got an aswer just like this one privately from another Dspace
user.  This is what I thought I might have to do.  I suppose I will have
to run index-all after making this change, right? 

-----Original Message-----
From: Claudia Juergen [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 07, 2007 2:36 PM
To: Blanco, Jose
Cc: [email protected]
Subject: Re: [Dspace-tech] Moving an item from one collection to another

Hi Jose,

there is a move item patch in the patch queue, but I haven't tried it
yet.

You can achieve this on db level with the following commands:

update item set owning_collection=NewCollectionID where item_id=ItemID;

update collection2item set collection_id=NewCollectionID where
collection_id=OldCollectionID and item_id=ItemID;

hope that helps

Claudia

> I need to move an item from one collection to another.  I tried ( in 
> my dev area ) to use ItemExport to get the item, and then I deleted 
> the item using the interface, then I used ItemImport to put the item 
> in the new collection, but when I log in as admin to view the item it 
> seems to have created a different item_id and I can't edit the item.  
> I don't have confidence in this procedure.  Is there a better way to
do this?
>
> Thanks!
> Jose
>
> ----------------------------------------------------------------------
> --- This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a
browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/ 
> _______________________________________________
> DSpace-tech mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>



-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Reply via email to