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
@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
-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
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
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
# 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
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
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
8 matches
Mail list logo