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
