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

