Re: [Dspace-tech] Moving items from one Collection to another
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 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, wrote: > >> 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 >> > > > > -- > 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 >
Re: [Dspace-tech] Moving items from one Collection to another
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, wrote: > 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 > -- 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
Re: [Dspace-tech] Moving items from one Collection to another
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
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
Re: [Dspace-tech] Moving items from one Collection to another
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 the environment before printing this e-mail.* On Mon, Sep 22, 2014 at 6:58 PM, 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
