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 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 items from 7 to 2 update collection2item set collection_id='2' where collection_id='7'; update collection_item_count set count='0' where collection_id='7'; # change the new collection ID over to the existing collection update item set owning_collection='2' where owning_collection='7'; # run /data/dspace/bin/dspace itemcounter On Mon, 2014-09-22 at 15:28 +0200, amutsik...@uzlib.uz.ac.zw wrote: > 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 dodge the > consequences of dodging our responsibilities.” Josiah Charles Stamp, > 1880-1941, former director of the Bank of England > > > > > > > ---------------------------------------------------------------------- > -------- Meet PCI DSS 3.0 Compliance Requirements with EventLog > Analyzer Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI > DSS Reports Are you Audit-Ready for PCI DSS 3.0 Compliance? Download > White paper Comply to PCI DSS 3.0 Requirement 10 and 11.5 with > EventLog Analyzer > http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg. > clktrk _______________________________________________ DSpace-tech > mailing list DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech List > Etiquette: > https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette ------------------------------------------------------------------------------ Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette