Thanks Claudia. I tested out here and it looks fine here. The InitializeBrowse, 
DSIndexer and MediaFilterManager also went well. 
Cheers!

-----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: [email protected]
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
> [email protected]
> 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
[email protected]
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Reply via email to