Created wiki page: http://wiki.lib.sun.ac.za/index.php/SUNScholar/SQL_Tips
for future reference.
*Hilton Gibson*
Ubuntu Linux Systems Administrator
JS Gericke Library
Room 1025C
Stellenbosch University
Private Bag X5036
Stellenbosch
7599
South Africa
Tel: +27 21 808 4100 | Cell: +27 84 646 4758
On 23 September 2014 09:46, <[email protected]> wrote:
> Thank you very much for the information.
>
> -----Original Message-----
> From: Keir Vaughan-Taylor [mailto:[email protected]]
> Sent: Tuesday, September 23, 2014 1:49 AM
> To: [email protected]
> Cc: [email protected]
> 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, [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
>
------------------------------------------------------------------------------
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
