[Building Sakai] Same Wiki help across sites

[Daniel Merino]

Hi, Matthew. A few months ago, we changed all the wiki's help pages to 
be the same. Our steps were:

1) Change the file PrepopulatePages.properties to have the right 
template, in order to have it in the new created wikis.

2) Launching the SQL sentence:

update rwikicurrentcontent set content= 'Text of the wiki page"
        where rwikiid = any (select distinct id from rwikiobject where 
name like '%edit_right%')

so we changed all the existing help pages for our own page.

The step 2 was really quite much hard. As the content field must have 
the text with the wiki format, is a text very hard to replicate, so we 
created a new wiki, copied the generated help from the database field in 
a temporary table (because Mysql doesn't allow an update of a table with 
a subquery on the same table) and updated all the fields with that value.

I hope it helps, if you need a more detailed explanation, just tell me.

Best regards.

Matthew Buckett escribió:
> On 5 March 2010 17:06, Matthew Buckett <matthew.buckett at oucs.ox.ac.uk> wrote:
>   
>> Has anyone had a look at providing the same wiki help page across
>> sites? At the moment I think the wiki help is copied from a master
>> template when the wiki tool is created, this makes it tricky to update
>> everyones help and can lead to people have outdated help.
>>     
>
> I've had a little look at this and it seems that when a site is first
> looked the templates are pre-populated.
>
> uk.ac.cam.caret.sakai.rwiki.tool.service.impl.PopulateServiceImpl
>
> Is there any reason why I couldn't switch this so that no
> pre-population happens but when a page is requested that normally is
> pre-populated it gets loaded from the bundle/or somewhere else and
> only saved to the rwikiobjects table if it is modified.
>
>   

-- 
Daniel Merino
daniel.merino at unavarra.es
Gestor de teleformación - Centro Superior de Innovación Educativa.
Tfno: 948-168489 - Universidad Pública de Navarra.
--
Un egoísta es aquel que se empeña en hablarte de sí mismo cuando tú te 
estas muriendo de ganas de hablarle de ti. (Jean Cocteau)