# 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, [email protected] 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 > [email protected] > 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 [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
