[Irtalk] Moving a subcommunity to another community

Hilton Gibson hilton.gibson at gmail.com
Thu Feb 10 19:17:10 SAST 2011


Hi

This was on the DSpace tech mailing  list not long ago.
Use at your own risk.
 >>>>
Hello Lewatle,

this is not part of any documentation as it is on database level. But
the db schema is in the docs see
http://scm.dspace.org/svn/repo/dspace/tags/dspace-1.6.2/dspace/docs/image/db-schema.gif

Make sure you got a proper update of your database befor manipulating
it. The sql command would be:

update community2collection set community_id=NewCommunityID where
collection_id=CollectionID and community_id=OldCommunityID;

Replace NewCommunityID with the ID of the target community and so on.

Then run index-update to update the browse indices.

Hope that helps

Claudia Jürgen


Am 11.10.2010 09:59, schrieb Lewatle Phaladi:
 > Hi Claudia
 >
 > Thanks for reply, if you have links that I can also refer to send 
them, for now I don't have enough info to follow.
 >
 > Regards,
 > Lewatle Johannes Phaladi
 > Institutional Repository (WIReDSpace)
 > Library Website
 >
 > How is our service ?
 > If you wish to comment on our service or offer suggestions on service 
issues, please email service.admin at wits.ac.za . Confidentiality will be 
respected, but anonymous complaints will not be followed up.
 >
 >
 >
 >
 >
 >
 > -----Original Message-----
 > From: Claudia Jürgen [mailto:Claudia.Juergen at ub.tu-dortmund.de]
 > Sent: 08 October 2010 04:47 PM
 > To: dspace-tech at lists.sourceforge.net
 > Subject: Re: [Dspace-tech] Migrate Collection into new sub community
 >
 > Hello Lewatle,
 >
 > via the DSpace UI it is only possible to move items.
 >
 > You can achieve this on db level (usually warning about backup your db)
 > by changing community2collection and then run index-update.
 >
 > Hope that helps
 >
 > Claudia Jürgen
 >
 >
 > Am 08.10.2010 16:16, schrieb Lewatle Phaladi:
 >> Hi All
 >>
 >>
 >>
 >> Is that possible to migrate existing collection to new sub community in
 >> DSPace?
 >>
 >> Anyone who has done this or have idea please assist!
 >>
 >>
 >>
 >> Regards,
 >>
 >> Lewatle
 >>
 >>
 >> <html><p><font face = "verdana" size = "0.8" color = "navy">This 
communication is intended for the addressee only. It is confidential. If 
you have received this communication in error, please notify us 
immediately and destroy the original message. You may not copy or 
disseminate this communication without the permission of the University. 
Only authorized signatories are competent to enter into agreements on 
behalf of the University and recipients are thus advised that the 
content of this message may not be legally binding on the University and 
may contain the personal views and opinions of the author, which are not 
necessarily the views and opinions of The University of the 
Witwatersrand, Johannesburg. All agreements between the University and 
outsiders are subject to South African Law unless the University agrees 
in writing to the contrary.</font></p></html>
 >>
 >>
 >>
 >> 
------------------------------------------------------------------------------
 >> Beautiful is writing same markup. Internet Explorer 9 supports
 >> standards for HTML5, CSS3, SVG 1.1,  ECMAScript5, and DOM L2&   L3.
 >> Spend less time writing and  rewriting code and more time creating great
 >> experiences on the web. Be a part of the beta today.
 >> http://p.sf.net/sfu/beautyoftheweb
 >>
 >>
 >>
 >> _______________________________________________
 >> DSpace-tech mailing list
 >> DSpace-tech at lists.sourceforge.net
 >> https://lists.sourceforge.net/lists/listinfo/dspace-tech
 >

-- 
Claudia Juergen
Universitaetsbibliothek Dortmund
Eldorado
0231/755-4043
https://eldorado.tu-dortmund.de/

------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1,  ECMAScript5, and DOM L2 & L3.
Spend less time writing and  rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
DSpace-tech mailing list
DSpace-tech at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
 >>>>

Cheers

hg

On 10/02/2011 17:00, Klapwijk, WOUTER <wklap at sun.ac.za> wrote:
>
> Hi,
>
> The only way I know of is to directly manipulate the data rows in the 
> database with SQL.  Although a reasonably safe method, I wouldn’t 
> recommend it unless absolutely necessary.
>
> Regards,
>
> Wouter
>
> ________________________________________________________
>
> Wouter Klapwijk
>
> Senior software specialist
>
> Library and Information Service, Stellenbosch University
>
> Tel: +27 21 808-4378, Fax: +27 21 808-3723, Mobile: 083 3888 270
>
> http://library.sun.ac.za <http://library.sun.ac.za/>
>
> *From:*irtalk-bounces at lists.lib.sun.ac.za 
> [mailto:irtalk-bounces at lists.lib.sun.ac.za] *On Behalf Of *Van der 
> Westhuizen, Ansie
> *Sent:* 10 February 2011 15:29
> *To:* irtalk at lists.lib.sun.ac.za
> *Subject:* [Irtalk] Moving a subcommunity to another community
>
> This message (and attachments) is subject to restrictions and a 
> disclaimer. Please refer to http://www.unisa.ac.za/disclaimer for full 
> details.
>
> ------------------------------------------------------------------------
>
> Dear colleagues
>
> Is it possible to move a sub community to another community?
>
> Regards
>
> *Ansie van der Westhuizen*
>
> Non-commercial Digital Developer
>
> IR Content Management: Collection Development
>
> Unisa Library
>
> PO Box 392
>
> Unisa
>
> 0003
>
> Phone: +27 12 429 3426
>
> Fax: +27 12 429 2925
>
> cid:image001.jpg at 01C8BBE2.161F6B60cid:image002.png at 01C8BBE2.161F6B60
>

-- 
Hilton Gibson
Systems Administrator
JS Gericke Library Room 1025
Stellenbosch University
Private Bag X5036
Stellenbosch
7599
South Africa

Tel: +27 21 808 4100 | Cell: +27 84 646 4758

"Simplicity is the ultimate sophistication"
	Leonardo da Vinci

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lib.sun.ac.za/pipermail/irtalk/attachments/20110210/577a54be/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 1798 bytes
Desc: not available
URL: <http://lists.lib.sun.ac.za/pipermail/irtalk/attachments/20110210/577a54be/attachment-0001.jpe>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 4746 bytes
Desc: not available
URL: <http://lists.lib.sun.ac.za/pipermail/irtalk/attachments/20110210/577a54be/attachment-0001.png>


More information about the Irtalk mailing list