Re: [Dspace-tech] Moving items from one Collection to another

2014-09-23 Thread amutsikiwa
Thank you very much for the information. -Original Message- From: Keir Vaughan-Taylor [mailto:kei...@optusnet.com.au] Sent: Tuesday, September 23, 2014 1:49 AM To: amutsik...@uzlib.uz.ac.zw Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Moving items from one Collection

Re: [Dspace-tech] Moving items from one Collection to another

2014-09-23 Thread Hilton Gibson
@lists.sourceforge.net Subject: Re: [Dspace-tech] Moving items from one Collection to another # Use psql commands to # move one collection into another # where collection defined by its ID #Adjust the two totals for each collection. #Find the collection id for the two collections. #In this example moving

Re: [Dspace-tech] Moving items from one Collection to another

2014-09-23 Thread Terry Brady
-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Moving items from one Collection to another # Use psql commands to # move one collection into another # where collection defined by its ID #Adjust the two totals for each collection. #Find the collection id for the two collections

[Dspace-tech] Moving items from one Collection to another

2014-09-22 Thread amutsikiwa
Hi I am interested in the sql statement that will enable me to move a number of items from one collection to another. Kind Regards, Admire Mutsikiwa ICT Projects Manager Libraries University of Zimbabwe Tel:+263-4-303276 It is easy to dodge our responsibilities, but we cannot

Re: [Dspace-tech] Moving items from one Collection to another

2014-09-22 Thread Bhavesh Patel
Hi, May be this will help you : http://permalink.gmane.org/gmane.comp.db.dspace.user/25745 Thanks, Bhavesh Thanks Regards, *Bhavesh R. Patel * - www.bhaveshpatel.info - www.onlinequizportal.com - www.hindisuvichar.com Never leave till tomorrow which you can do today *Please consider

Re: [Dspace-tech] Moving items from one Collection to another

2014-09-22 Thread Keir Vaughan-Taylor
# Use psql commands to # move one collection into another # where collection defined by its ID #Adjust the two totals for each collection. #Find the collection id for the two collections. #In this example moving items from 7 to 2 update collection2item set collection_id='2' where

[Dspace-tech] Moving items from one collection top another

2009-10-30 Thread John Preston
Can someone give me the sql to move an item from one collection to another. As I remeber it in an earlier DSpace incarnation it used to be possibl;e John -- Come build with us! The BlackBerry(R) Developer Conference in

Re: [Dspace-tech] Moving items from one collection top another

2009-10-30 Thread Claudia Juergen
Hello John, meanwhile there is a move item feature in DSpace. If you are using an older version, here is the sql with the usual warning (backup db etc. before manipulating it): update item set owning_collection=NewCollectionID where item_id=ItemID; update collection2item set