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 > -- ======================================== Tim Donohue Research Programmer, Illinois Digital Environment for Access to Learning and Scholarship (IDEALS) 135 Grainger Engineering Library University of Illinois at Urbana-Champaign email: [EMAIL PROTECTED] web: http://www.ideals.uiuc.edu phone: (217) 333-4648 fax: (217) 244-7764 ======================================== ------------------------------------------------------------------------- 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
