Hi! On a similar note here we have a duplicate collection with empty items. The collection holds the same title as the original collection that has imported items. Using the administrator interface doesn't show the edit panel to edit or delete the collection. Can anyone suggest how to delete this duplicated collection? We have this on the production server and hence would like to get some feedback before trying this out on the database. Have anyone tried out an SQL that just deletes the specified collection alone. Please suggest.
Thanks, Jayan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Claudia Jürgen Sent: Thursday, February 21, 2008 11:26 PM To: John Preston Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Moving a collection from one community to another Hi John, at the moment the easiest way is to do it straight on the database. Make sure you got a dump of your db. Assuming you are running postgres with default db-schema it would be: update community2collection set community_id=NewCommunityID where community_id=OldCommunityID and collection_id=YourCollectionID; Then run [dspace]/bin/index-all to build the indices. E.g. You want to move Collection 34 from Community 3 to Community 7 update community2collection set community_id=7 where community_id=3 and collection_id=34; hope that helps Claudia John Preston schrieb: > Can anyone say what the preferred method of moving a collection (and all its > contents) from one community to another, in DSpace 1.4.2. I know that > exporting and then importing is possible, but then I have to delete all the > old items and collection. Is there not a quicker way say just changing the > parent community id in the database for the particular collection. I have 26 > collections to change. > > John > > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > > > ------------------------------------------------------------------------ > > _______________________________________________ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech