On Wed, Mar 05, 2008 at 04:31:16PM +0000, Mika Stenberg wrote: > Ability to move items from collection to another should be added to the > WebUI. Has this been considered in the future releases?
The functionality of CommunityFiliator (a CLI app to move communities around) has been extended to be usable for arbitrary DSpaceObjects for the 1.6 release. Tools for one or more web interfaces may be made available. Jim > -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 -- James Rutherford | Hewlett-Packard Limited registered Office: Research Engineer | Cain Road, HP Labs | Bracknell, Bristol, UK | Berks +44 117 312 7066 | RG12 1HN. [EMAIL PROTECTED] | Registered No: 690597 England The contents of this message and any attachments to it are confidential and may be legally privileged. If you have received this message in error, you should delete it from your system immediately and advise the sender. To any recipient of this message within HP, unless otherwise stated you should consider this message and attachments as "HP CONFIDENTIAL". ------------------------------------------------------------------------- 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
