Yes, but also make sure to maintain the foreign key relationships in the communities2item table. Otherwise, individual items pages will not display the correct owning community.
Kyle Kaliebe Systems Developer/Engineer Knowledge Bank University Libraries Ohio State University [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Claudia Juergen Sent: Friday, April 25, 2008 16:48 To: Jeffrey Trimble Cc: [email protected] Subject: Re: [Dspace-tech] moving a collection to a different community Hi Jeffrey, the easiest way to move a collection is straight via the database. If you want to move collection id 34 from community id 3 to community id 7, do update community2collection set community_id=7 where community_id=3 and collection_id=34; Then run [dspace}/bin/index-all. Make sure you got a dump of your db, before you lay hand on it. Hope that helps Claudia > Does anyone have a script to move a collection from one community to > another? While I could > export the data and re-import it, I'm afraid that I might loose the > handle ID. > > Now, if I retain the handle file, and do not delete the handle from > the metadata (edit the > migrate script a little), would this work when I re-import? > > Any comments, caution? > > TIA, > > Jeff > > Jeffrey Trimble > Systems Librarian > Maag Library > Youngstown State University > 330-941-2483 (Office) > [EMAIL PROTECTED] > http://www.maag.ysu.edu > http://digital.maag.ysu.edu > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference > Don't miss this year's exciting event. There's still time to save $100. > Use priority code J8TL2D2. > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao ne_______________________________________________ > DSpace-tech mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspace-tech > ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao ne _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
