Hi Sisay, On 31/03/11 20:32, Webshet, Sisay (ILRI) wrote: > In dspace 1.6. I want to move a collection(3377) from a community(231) > to another community(310) > > I used a dspace command sudo /home/dspace/bin/dspace community-filiator > --set --parent=10568/310 --child=10568/3377. > > But Error, child community cannot be found: 10568/3377.
The documentation states that the community filiator works only to re-parent a *community*, not a collection. Whenever I have to move a collection to a new parent community, I do it directly in the database. The following sql statement should work (make a backup of your database first!): update community2collection set community_id = (select resource_id from handle where handle = '10568/310') where community_id = (select resource_id from handle where community_id = resource_id and handle = '10568/231') and collection_id = (select resource_id from handle where collection_id = resource_id and handle = '10568/3377'); This assumes that collection 10568/3377 is currently a direct child of community 10568/231 and you want it to be a direct child of 10568/310 instead. I've found that on xmlui, this change won't be reflected in the breadcrumb trail at the top of the page (probably due to Cocoon caching). Editing the description of the collection (eg adding a space to the end of the description) resolves that problem. I've been meaning to write code that allows an administrator to do this via the web interface but I haven't had the time for that yet. Again, make sure to have a current backup of your database before you try this on a production machine! cheers, Andrea -- Andrea Schweer IRR Technical Specialist, ITS Information Systems The University of Waikato, Hamilton, New Zealand ------------------------------------------------------------------------------ Create and publish websites with WebMatrix Use the most popular FREE web apps or write code yourself; WebMatrix provides all the features you need to develop and publish your website. http://p.sf.net/sfu/ms-webmatrix-sf _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
