<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<font face="Segoe">Hi<br>
<br>
This was on the DSpace tech mailing list not long ago.<br>
Use at your own risk.<br>
>>>><br>
Hello Lewatle,<br>
<br>
this is not part of any documentation as it is on database level.
But <br>
the db schema is in the docs see<br>
<a class="moz-txt-link-freetext" href="http://scm.dspace.org/svn/repo/dspace/tags/dspace-1.6.2/dspace/docs/image/db-schema.gif">http://scm.dspace.org/svn/repo/dspace/tags/dspace-1.6.2/dspace/docs/image/db-schema.gif</a><br>
<br>
Make sure you got a proper update of your database befor
manipulating <br>
it. The sql command would be:<br>
<br>
update community2collection set community_id=NewCommunityID where
<br>
collection_id=CollectionID and community_id=OldCommunityID;<br>
<br>
Replace NewCommunityID with the ID of the target community and so
on.<br>
<br>
Then run index-update to update the browse indices.<br>
<br>
Hope that helps<br>
<br>
Claudia Jürgen<br>
<br>
<br>
Am 11.10.2010 09:59, schrieb Lewatle Phaladi:<br>
> Hi Claudia<br>
><br>
> 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.<br>
><br>
> Regards,<br>
> Lewatle Johannes Phaladi<br>
> Institutional Repository (WIReDSpace)<br>
> Library Website<br>
><br>
> How is our service ?<br>
> If you wish to comment on our service or offer suggestions on
service issues, please email <a class="moz-txt-link-abbreviated" href="mailto:service.admin@wits.ac.za">service.admin@wits.ac.za</a> .
Confidentiality will be respected, but anonymous complaints will
not be followed up.<br>
><br>
><br>
><br>
><br>
><br>
><br>
> -----Original Message-----<br>
> From: Claudia Jürgen
[<a class="moz-txt-link-freetext" href="mailto:Claudia.Juergen@ub.tu-dortmund.de">mailto:Claudia.Juergen@ub.tu-dortmund.de</a>]<br>
> Sent: 08 October 2010 04:47 PM<br>
> To: <a class="moz-txt-link-abbreviated" href="mailto:dspace-tech@lists.sourceforge.net">dspace-tech@lists.sourceforge.net</a><br>
> Subject: Re: [Dspace-tech] Migrate Collection into new sub
community<br>
><br>
> Hello Lewatle,<br>
><br>
> via the DSpace UI it is only possible to move items.<br>
><br>
> You can achieve this on db level (usually warning about
backup your db)<br>
> by changing community2collection and then run index-update.<br>
><br>
> Hope that helps<br>
><br>
> Claudia Jürgen<br>
><br>
><br>
> Am 08.10.2010 16:16, schrieb Lewatle Phaladi:<br>
>> Hi All<br>
>><br>
>><br>
>><br>
>> Is that possible to migrate existing collection to new
sub community in<br>
>> DSPace?<br>
>><br>
>> Anyone who has done this or have idea please assist!<br>
>><br>
>><br>
>><br>
>> Regards,<br>
>><br>
>> Lewatle<br>
>><br>
>><br>
>> <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><br>
>><br>
>><br>
>><br>
>>
------------------------------------------------------------------------------<br>
>> Beautiful is writing same markup. Internet Explorer 9
supports<br>
>> standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM
L2& L3.<br>
>> Spend less time writing and rewriting code and more time
creating great<br>
>> experiences on the web. Be a part of the beta today.<br>
>> <a class="moz-txt-link-freetext" href="http://p.sf.net/sfu/beautyoftheweb">http://p.sf.net/sfu/beautyoftheweb</a><br>
>><br>
>><br>
>><br>
>> _______________________________________________<br>
>> DSpace-tech mailing list<br>
>> <a class="moz-txt-link-abbreviated" href="mailto:DSpace-tech@lists.sourceforge.net">DSpace-tech@lists.sourceforge.net</a><br>
>> <a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/dspace-tech">https://lists.sourceforge.net/lists/listinfo/dspace-tech</a><br>
><br>
<br>
-- <br>
Claudia Juergen<br>
Universitaetsbibliothek Dortmund<br>
Eldorado<br>
0231/755-4043<br>
<a class="moz-txt-link-freetext" href="https://eldorado.tu-dortmund.de/">https://eldorado.tu-dortmund.de/</a><br>
<br>
------------------------------------------------------------------------------<br>
Beautiful is writing same markup. Internet Explorer 9 supports<br>
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 &
L3.<br>
Spend less time writing and rewriting code and more time creating
great<br>
experiences on the web. Be a part of the beta today.<br>
<a class="moz-txt-link-freetext" href="http://p.sf.net/sfu/beautyoftheweb">http://p.sf.net/sfu/beautyoftheweb</a><br>
_______________________________________________<br>
DSpace-tech mailing list<br>
<a class="moz-txt-link-abbreviated" href="mailto:DSpace-tech@lists.sourceforge.net">DSpace-tech@lists.sourceforge.net</a><br>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/dspace-tech">https://lists.sourceforge.net/lists/listinfo/dspace-tech</a><br>
>>>><br>
<br>
Cheers<br>
<br>
hg<br>
</font><br>
On 10/02/2011 17:00, Klapwijk, WOUTER <a class="moz-txt-link-rfc2396E" href="mailto:wklap@sun.ac.za"><wklap@sun.ac.za></a> wrote:
<blockquote
cite="mid:DAC382A967F51842B525F7077C454FAF4273A29FD7@STBEVS06.stb.sun.ac.za"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta name="Generator" content="Microsoft Word 12 (filtered
medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Lucida Calligraphy";
panose-1:3 1 1 1 1 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
p.Balloon, li.Balloon, div.Balloon
{mso-style-name:"Balloon\,Text";
mso-style-link:"Balloon1\,Text1\,Char1";
margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.Balloon1
{mso-style-name:"Balloon1\,Text1\,Char1";
mso-style-priority:99;
mso-style-link:"Balloon\,Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle24
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
-->
</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">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.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Wouter<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size: 8pt; font-family:
"Verdana","sans-serif"; color: black;">________________________________________________________<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 8pt; font-family:
"Verdana","sans-serif"; color: black;">Wouter
Klapwijk<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 8pt; font-family:
"Verdana","sans-serif"; color: gray;">Senior
software specialist<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 8pt; font-family:
"Verdana","sans-serif"; color: gray;">Library
and Information Service, Stellenbosch University<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 8pt; font-family:
"Verdana","sans-serif"; color: gray;">Tel:
+27 21 808-4378, Fax: +27 21 808-3723, Mobile: 083 3888
270<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 12pt;
font-family: "Times New
Roman","serif"; color: rgb(31, 73, 125);"><a
moz-do-not-send="true" href="http://library.sun.ac.za/"><span
style="font-size: 8pt; font-family:
"Verdana","sans-serif"; color:
maroon;">http://library.sun.ac.za</span></a><br>
<br>
<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<div>
<div style="border-right: medium none; border-width: 1pt
medium medium; border-style: solid none none; border-color:
rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color;
padding: 3pt 0cm 0cm;">
<p class="MsoNormal"><b><span style="font-size: 10pt;
font-family:
"Tahoma","sans-serif";">From:</span></b><span
style="font-size: 10pt; font-family:
"Tahoma","sans-serif";">
<a class="moz-txt-link-abbreviated" href="mailto:irtalk-bounces@lists.lib.sun.ac.za">irtalk-bounces@lists.lib.sun.ac.za</a>
[<a class="moz-txt-link-freetext" href="mailto:irtalk-bounces@lists.lib.sun.ac.za">mailto:irtalk-bounces@lists.lib.sun.ac.za</a>] <b>On
Behalf Of </b>Van der Westhuizen, Ansie<br>
<b>Sent:</b> 10 February 2011 15:29<br>
<b>To:</b> <a class="moz-txt-link-abbreviated" href="mailto:irtalk@lists.lib.sun.ac.za">irtalk@lists.lib.sun.ac.za</a><br>
<b>Subject:</b> [Irtalk] Moving a subcommunity to
another community<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size: 7.5pt; font-family:
"Arial","sans-serif"; color: blue;"
lang="EN-ZA">This message (and attachments) is subject to
restrictions and a
disclaimer. Please refer to
<a class="moz-txt-link-freetext" href="http://www.unisa.ac.za/disclaimer">http://www.unisa.ac.za/disclaimer</a> for full details.</span><span
style="font-size: 12pt; font-family: "Times New
Roman","serif";" lang="EN-ZA"><o:p></o:p></span></p>
<div class="MsoNormal" style="text-align: center;"
align="center"><span style="font-size: 12pt; font-family:
"Times New Roman","serif";" lang="EN-ZA">
<hr size="2" align="center" width="100%">
</span></div>
<p class="MsoNormal"><span style="font-size: 12pt; font-family:
"Times New Roman","serif";" lang="EN-ZA"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span lang="EN-ZA">Dear colleagues<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-ZA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-ZA">Is it possible to move
a sub community to
another community?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-ZA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-ZA">Regards<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-ZA"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size: 14pt;
font-family: "Lucida Calligraphy"; color:
rgb(31, 73, 125);" lang="EN-ZA">Ansie van der Westhuizen<o:p></o:p></span></b></p>
<p class="MsoNormal"><span lang="EN-ZA">Non-commercial Digital
Developer<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-ZA">IR Content Management:
Collection
Development<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-ZA">Unisa Library<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-ZA">PO Box 392<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-ZA">Unisa <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-ZA">0003<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-ZA">Phone: +27 12 429 3426<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-ZA">Fax: +27 12 429 2925<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(0, 112, 192);"
lang="EN-ZA"><img id="Picture_x0020_1"
src="cid:part1.08010805.00050501@sun.ac.za"
alt="cid:image001.jpg@01C8BBE2.161F6B60" border="0"
height="58" width="85"><img id="Picture_x0020_2"
src="cid:part2.05050909.06050502@sun.ac.za"
alt="cid:image002.png@01C8BBE2.161F6B60" border="0"
height="35" width="145"></span><span lang="EN-ZA"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-ZA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-ZA"><o:p> </o:p></span></p>
</div>
</div>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
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
</pre>
</body>
</html>