Also don't forget to update owning_collection in the item table. Sue -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mika Stenberg Sent: Wednesday, March 05, 2008 11:31 AM To: [email protected] Subject: Re: [Dspace-tech] Moving items to new collection
Ability to move items from collection to another should be added to the WebUI. Has this been considered in the future releases? -Mika > David, > > David, > > Similar to what George mentioned, I've always done this at the database > level. > > I use the same basic SQL query (mentioned by George): > > update collection2item set collection_id=<new collection's id> where > item_id=<item's id>; > > Or, if you are moving *all* the items in one collection to another: > > update collection2item set collection_id=<new collection's id> where > collection_id=<OLD collection's id>; > > And then re-run the [dspace]/bin/index-all script, which will correct > all the DSpace browsing interfaces, etc. > > I hope that helps! > > - Tim > > > George Kozak wrote: >> David: >> >> I would do this in SQL. Here is an example of the command I use: >> >> update collection2item set collection_id=<new collection's id> where >> item_id=<item's id>; >> >> Then I do the following: >> >> update item set owning_collection=<new collection's id> where >> item_id=<item's id>; >> >> OR run index_all after making the changes and it would fix the owning >> collections and communities. >> >> If you have a lot of items to move, then a PERL script could be used >> (if you have DBD::Pg compiled for your PERL module). >> >> At 09:58 AM 3/4/2008, David Reynolds wrote: >>> Dear colleagues, >>> >>> I want to move items from one collection to another in order to >>> delete the old collection but still retain the handles on the items. >>> One colleague suggested the following, but he stressed that he had >>> not tried it before: >>> >>> "I would try exporting the item ( you'll get the handle ), then >>> deleting the collection and then reimport the item with the handle." >>> >>> Does this sound like the right approach? I've searched the >>> documentation but have found nothing about moving items from one >>> collection to another. Thanks in advance for your advice. >>> >>> >>> >>> >>> David Reynolds >>> Manager of Scholarly Digital Initiatives >>> Johns Hopkins University >>> 3400 N. Charles St. >>> Baltimore, MD 21218-2683 >>> >>> [EMAIL PROTECTED] >>> (410) 516-7220 >>> >>> >>> ------------------------------------------------------------------------ - >>> This SF.net email is sponsored by: Microsoft >>> Defy all challenges. Microsoft(R) Visual Studio 2008. >>> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ >>> _______________________________________________ >>> DSpace-tech mailing list >>> [email protected] >>> https://lists.sourceforge.net/lists/listinfo/dspace-tech >> *************************** >> George Kozak >> Coordinator >> Web Development and Management >> Digital Media Group >> 501 Olin Library >> Cornell University >> 607-255-8924 >> *************************** >> [EMAIL PROTECTED] >> >> >> ------------------------------------------------------------------------ - >> This SF.net email is sponsored by: Microsoft >> Defy all challenges. Microsoft(R) Visual Studio 2008. >> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ >> _______________________________________________ >> DSpace-tech mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/dspace-tech >> > ------------------------------------------------------------------------ - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
