Re: [Dspace-tech] Moving items to new collection
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/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net 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/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net 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/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net 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/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Moving items to new collection
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/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net 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/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net 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/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Moving items to new collection
On Wed, Mar 05, 2008 at 04:31:16PM +, 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/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net 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/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net 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/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net 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/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Moving items to new collection
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: dspace-tech@lists.sourceforge.net 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/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net 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/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net 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/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net 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/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Moving items to new collection
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/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Moving items to new collection
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/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net 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/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
