Thanks for the input everyone. I was successful using the method of
changing the handle value in the csv.
On Oct 14, 2013 5:29 PM, "Keir Vaughan-Taylor" <k...@usyd.edu.au> wrote:
> Just a "be careful" note
>
> I usually execute these commands manually.
> The 62310 count is the sum of items in each collection.
>
>
> On Tue, 2013-10-15 at 07:48 +1100, Keir Vaughan-Taylor wrote:
> > You can use code sililar to this - You have to work out the correct
> > collection IDs
> >
> > #Author Keir Vaughan-Taylor
> > # Use psql commands to
> > # move one collection into another
> > # where collection defined by its ID
> > select * from collection_item_count;
> > #Adjust the two totals for each collection.
> > update collection2item set collection_id='2' where collection_id='7';
> > update collection_item_count set count='62310' where collection_id='2';
> > 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';
> >
> >
> >
> >
> > On Mon, 2013-10-14 at 16:24 +0200, helix84 wrote:
> > > Hi Matt,
> > >
> > > the officially recommended option would be AIP import/export
> > > (available since DSpace 1.7).
> > >
> > > I can also suggest an alternative if you're dealing with an older
> > > DSpace version or if you want to do it quickly. Use SQL to change
> > > item's parent collection in the collection2item table (if you use item
> > > mapping, one item can be in multiple collections). Then run either
> > > "index-init" or "update-discovery-index -f" depending on whether you
> > > use Discovery. Do not run any SQL queries unless you have backed up
> > > the database and made sure noone else is making changes at the same
> > > time (e.g. disable auth plugins) - I recommend to test it first in a
> > > development clone of you production installation.
> > >
> > >
> > > Regards,
> > > ~~helix84
> > >
> > > Compulsory reading: DSpace Mailing List Etiquette
> > > https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
> > >
> > >
> ------------------------------------------------------------------------------
> > > October Webinars: Code for Performance
> > > Free Intel webinars can help you accelerate application performance.
> > > Explore tips for MPI, OpenMP, advanced profiling, and more. Get the
> most from
> > > the latest Intel processors and coprocessors. See abstracts and
> register >
> > >
> http://pubads.g.doubleclick.net/gampad/clk?id=60134071&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
> >
>
> --
>
>
>
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
> from
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60135031&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
>
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135031&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
