This facility is in the upcoming 1.5 release, in the JSP user interface. The option appears to an administrator when editing an item.
On 5/3/08 16:31, "Mika Stenberg" <[EMAIL PROTECTED]> wrote: > 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
