Fyi... The batch metadata editing function will allow you to update the
owning collection for an item in a controlled manner.
https://wiki.duraspace.org/display/DSDOC3x/Batch+Metadata+Editing
See "Editing Collection Membership"
On Tue, Sep 23, 2014 at 1:05 AM, Hilton Gibson <[email protected]>
wrote:
> 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
>
--
Terry Brady
Applications Programmer Analyst
Georgetown University Library Information Technology
https://www.library.georgetown.edu/lit/code
425-298-5498
------------------------------------------------------------------------------
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
