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=154622311iu=/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=154622311iu=/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
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, amutsik...@uzlib.uz.ac.zw 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=154622311iu=/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=154622311iu=/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=154622311iu=/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
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 hilton.gib...@gmail.com 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, amutsik...@uzlib.uz.ac.zw 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=154622311iu=/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=154622311iu=/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=154622311iu=/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 -- 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=154622311iu=/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
[Dspace-tech] Moving items from one Collection to another
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=154622311iu=/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, 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=154622311iu=/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=154622311iu=/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=154622311iu=/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=154622311iu=/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
[Dspace-tech] Moving items from one collection top another
Can someone give me the sql to move an item from one collection to another. As I remeber it in an earlier DSpace incarnation it used to be possibl;e John -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Moving items from one collection top another
Hello John, meanwhile there is a move item feature in DSpace. If you are using an older version, here is the sql with the usual warning (backup db etc. before manipulating it): update item set owning_collection=NewCollectionID where item_id=ItemID; update collection2item set collection_id=NewCollectionID where collection_id=OldCollectionID and item_id=ItemID; Hope that helps Claudia Jürgen Can someone give me the sql to move an item from one collection to another. As I remeber it in an earlier DSpace incarnation it used to be possibl;e John -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech -- Claudia Jürgen Eldorado - Repositorium der TU Dortmund Universitätsbibliothek Dortmund Vogeplothsweg 76 D-44227 Dortmund Tel.: 0049-231-755-4043 -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech