bodington-developers — Mailing list for Bodington developers

[Bodington-developers] Changes to HEAD

[Matthew B. <mat...@co...>]

Just a small heads up. Stuff I've just pushed in:

- Notification Fix.
- Removing the dependancy on having the System property 
bodington.properties set before starting BuildingServer.
- Moved some of the startup functionality from SetupServlet to 
BuildingContextListener.
- Added the ability to specify default bodington properties in the 
servlet context.

NB: I havn't updated the old shib web.xml as it is scheduled for removal 
(so a shib build doesn't work at the moment).

-- 
+--Matthew Buckett-----------------------------------------+
| VLE Developer, Learning Technologies Group               |
| Tel: +44 (0) 1865 283660 http://www.oucs.ox.ac.uk/       |
+------------Computing Services, University of Oxford------+

Re: [Bodington-developers] Localisation issue

[Alistair Y. <ali...@sm...>]

The only change to the db schema is to store the user's language and to 
add a setLanguage method to something (can't remember which class!). 
Other tables, big_strings_xx are created on the fly when a Resource is 
localised in situ.

If Resource localisation is a bad idea then bin it, no probs. How to 
localise common Resources like a help facility though?

To disable Resource localisation you can remove the "Translate this 
resource" link from manage.html

Alistair

On 10 May 2005, at 12:41, Colin Tatham wrote:

>
> I agree with Matthew (I might even have nagged him into responding 
> ;-)...
>
> Although I can see that template internationalisation doesn't make a 
> huge
> difference to the UHI requirement, it seems odd to me to have the 
> facility
> to translate resources (especially when the translation can get out of 
> synch
> when the original is changed, as Matthew pointed out.) Is there no 
> other
> solution to the problem? Allowing the ability to tag/link a set of 
> resources
> which provide e.g. a help building, in multiple languages but only 
> display
> the one that uses the users chosen language?
>
> I think we need to resolve any issues before (doing the Big Template
> Shuffle) and releasing stuff... don't want to end up with a changed 
> database
> schema, etc that we're stuck with?
>
>
> Colin
>
>> -----Original Message-----
>> From: bod...@li...
>> [mailto:bod...@li...]On Behalf Of
>> Alistair Young
>> Sent: 10 May 2005 12:06
>> To: Matthew Buckett
>> Cc: Bodington Developers
>> <bod...@li...> >>
>> Bodington Developers
>> Subject: Re: [Bodington-developers] Localisation issue
>>
>>
>> it's in there now and it works so I'd say leave it. The reason it's
>> there is not a lot changes when you change the language as all the
>> Resource strings are in the db.
>>
>> We have help buildings etc which need to be translated to
>> Gaelic. When
>> you look at it, the templates don't provide much output when compared
>> with the resources.
>>
>> There will be Resources which don't need localised, such as language
>> specific content - no point translating a teach yourself
>> Gaelic course
>> to Russian but there will also be Resources that do need translated,
>> such as help buildings, navigation etc. If a Resource is
>> common to all
>> users then it'll need translated.
>>
>> Alistair
>>
>>
>> On 10 May 2005, at 11:58, Matthew Buckett wrote:
>>
>>> Alistair Young wrote:
>>>> On my travels in qLand I found a potential problem with
>> localisation.
>>>> Questionnaire responses are stored in the big_strings table. I
>>>> thought big_strings was for system entites, such as
>> Resources, rather
>>>> than user submitted data. Localising big_strings en masse via db
>>>> extract and translator is now much more complicated.
>>>
>>> Although I am keen on Bodington having i18n (ability to
>> translate the
>>> templates and outputted messages) I don't see that being able to
>>> localize the resources is a "big win". And some issues
>> didn't seem to
>>> get resolved:
>>>
>>> What happens if someone updates the English version of a
>> resource? Do
>>> you still display out of date translated version?
>>>
>>> Won't most installation be creating resources in their own locale?
>>>
>>> I think that the localization of resource is a aiming for a small
>>> market and significantly complicates the Bodington codebase.
>>>
>>> --
>>> +--Matthew Buckett-----------------------------------------+
>>> | VLE Developer, Learning Technologies Group               |
>>> | Tel: +44 (0) 1865 283660 http://www.oucs.ox.ac.uk/       |
>>> +------------Computing Services, University of Oxford------+
>>>
>>>
>>> -------------------------------------------------------
>>> This SF.Net email is sponsored by Oracle Space Sweepstakes
>>> Want to be the first software developer in space?
>>> Enter now for the Oracle Space Sweepstakes!
>>> http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click
>>> _______________________________________________
>>> Bodington-developers mailing list
>>> Bod...@li...
>>> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>>
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by Oracle Space Sweepstakes
>> Want to be the first software developer in space?
>> Enter now for the Oracle Space Sweepstakes!
>> http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click
>> _______________________________________________
>> Bodington-developers mailing list
>> Bod...@li...
>> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click
> _______________________________________________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers

Re: [Bodington-developers] Localisation issue

[Matthew B. <mat...@co...>]

Alistair Young wrote:
>> What happens if someone updates the English version of a resource?
>> > > Do you still display out of date translated version?
> 
> yes - but an event will be generated and sent to the translator as the 
> system will know who translated it.

How do you know who translated it?

-- 
+--Matthew Buckett-----------------------------------------+
| VLE Developer, Learning Technologies Group               |
| Tel: +44 (0) 1865 283660 http://www.oucs.ox.ac.uk/       |
+------------Computing Services, University of Oxford------+

RE: [Bodington-developers] Localisation issue

[Colin T. <col...@co...>]

I agree with Matthew (I might even have nagged him into responding ;-)...

Although I can see that template internationalisation doesn't make a huge
difference to the UHI requirement, it seems odd to me to have the facility
to translate resources (especially when the translation can get out of synch
when the original is changed, as Matthew pointed out.) Is there no other
solution to the problem? Allowing the ability to tag/link a set of resources
which provide e.g. a help building, in multiple languages but only display
the one that uses the users chosen language?

I think we need to resolve any issues before (doing the Big Template
Shuffle) and releasing stuff... don't want to end up with a changed database
schema, etc that we're stuck with?


Colin

> -----Original Message-----
> From: bod...@li...
> [mailto:bod...@li...]On Behalf Of
> Alistair Young
> Sent: 10 May 2005 12:06
> To: Matthew Buckett
> Cc: Bodington Developers
> <bod...@li...> >>
> Bodington Developers
> Subject: Re: [Bodington-developers] Localisation issue
>
>
> it's in there now and it works so I'd say leave it. The reason it's
> there is not a lot changes when you change the language as all the
> Resource strings are in the db.
>
> We have help buildings etc which need to be translated to
> Gaelic. When
> you look at it, the templates don't provide much output when compared
> with the resources.
>
> There will be Resources which don't need localised, such as language
> specific content - no point translating a teach yourself
> Gaelic course
> to Russian but there will also be Resources that do need translated,
> such as help buildings, navigation etc. If a Resource is
> common to all
> users then it'll need translated.
>
> Alistair
>
>
> On 10 May 2005, at 11:58, Matthew Buckett wrote:
>
> > Alistair Young wrote:
> >> On my travels in qLand I found a potential problem with
> localisation.
> >> Questionnaire responses are stored in the big_strings table. I
> >> thought big_strings was for system entites, such as
> Resources, rather
> >> than user submitted data. Localising big_strings en masse via db
> >> extract and translator is now much more complicated.
> >
> > Although I am keen on Bodington having i18n (ability to
> translate the
> > templates and outputted messages) I don't see that being able to
> > localize the resources is a "big win". And some issues
> didn't seem to
> > get resolved:
> >
> > What happens if someone updates the English version of a
> resource? Do
> > you still display out of date translated version?
> >
> > Won't most installation be creating resources in their own locale?
> >
> > I think that the localization of resource is a aiming for a small
> > market and significantly complicates the Bodington codebase.
> >
> > --
> > +--Matthew Buckett-----------------------------------------+
> > | VLE Developer, Learning Technologies Group               |
> > | Tel: +44 (0) 1865 283660 http://www.oucs.ox.ac.uk/       |
> > +------------Computing Services, University of Oxford------+
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by Oracle Space Sweepstakes
> > Want to be the first software developer in space?
> > Enter now for the Oracle Space Sweepstakes!
> > http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click
> > _______________________________________________
> > Bodington-developers mailing list
> > Bod...@li...
> > https://lists.sourceforge.net/lists/listinfo/bodington-developers
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click
> _______________________________________________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>

Re: [Bodington-developers] Bodington HEAD / i18n

[Alistair Y. <ali...@sm...>]

ok, sounds reasonable as ant runs the compiler out of context. I'll  
shift it to Facility but it'll take a while

Alistair

On 10 May 2005, at 11:45, Matthew Buckett wrote:

> It seems that ant template compilation is currently broken on  
> bodington HEAD. The problem is that the useroptions.html page has the  
> tag:
>
> <display_language_selection />
>
> Which in turn calls
>
> org.bodington.servlet.template.XmlTemplate.compileLanguageSelectionList 
> (Element)
>
> at the top of this method is:
>
> private void compileLanguageSelectionList(Element e) {
>       String[] langs =  
> BuildingContext.getProperty("supported_languages").split(",");
>
> which when running under ant returns null and causes the template to  
> fail to compile.
>
> Should the display_language_selection not be a method call in Facility  
> rather than a new tag? It doesn't seem that it will be used in many  
> places and so just seems to complicate the XML namespace.
>
> -- 
> +--Matthew Buckett-----------------------------------------+
> | VLE Developer, Learning Technologies Group               |
> | Tel: +44 (0) 1865 283660 http://www.oucs.ox.ac.uk/       |
> +------------Computing Services, University of Oxford------+
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click
> _______________________________________________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers

Re: [Bodington-developers] Wish List for new bod / Tetra?

[Alistair Y. <ali...@sm...>]

or just Tetra wishlist? how will dev be split between bod and Tetra? 
are we allowed to talk about tetra and the future of bod here?

Alistair

On 10 May 2005, at 11:57, mic...@bo... wrote:

> The wish list for the next bod/Tetra needs to be captured, so we don't 
> have to trawl through the mailing list history.
> Maybe one method of capturing the dev/users/etc... wishes, could be to 
> set up a 'bod/Tetra Wish List' forum on SF?
>
> Any other ideas are welcome.
>
> -- 
> mic...@bo...
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click
> _______________________________________________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers

Re: [Bodington-developers] Localisation issue

[Alistair Y. <ali...@sm...>]

it's in there now and it works so I'd say leave it. The reason it's 
there is not a lot changes when you change the language as all the 
Resource strings are in the db.

We have help buildings etc which need to be translated to Gaelic. When 
you look at it, the templates don't provide much output when compared 
with the resources.

There will be Resources which don't need localised, such as language 
specific content - no point translating a teach yourself Gaelic course 
to Russian but there will also be Resources that do need translated, 
such as help buildings, navigation etc. If a Resource is common to all 
users then it'll need translated.

Alistair


On 10 May 2005, at 11:58, Matthew Buckett wrote:

> Alistair Young wrote:
>> On my travels in qLand I found a potential problem with localisation. 
>> Questionnaire responses are stored in the big_strings table. I 
>> thought big_strings was for system entites, such as Resources, rather 
>> than user submitted data. Localising big_strings en masse via db 
>> extract and translator is now much more complicated.
>
> Although I am keen on Bodington having i18n (ability to translate the 
> templates and outputted messages) I don't see that being able to 
> localize the resources is a "big win". And some issues didn't seem to 
> get resolved:
>
> What happens if someone updates the English version of a resource? Do 
> you still display out of date translated version?
>
> Won't most installation be creating resources in their own locale?
>
> I think that the localization of resource is a aiming for a small 
> market and significantly complicates the Bodington codebase.
>
> -- 
> +--Matthew Buckett-----------------------------------------+
> | VLE Developer, Learning Technologies Group               |
> | Tel: +44 (0) 1865 283660 http://www.oucs.ox.ac.uk/       |
> +------------Computing Services, University of Oxford------+
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click
> _______________________________________________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers

RE: [Bodington-developers] Wish List for new bod / Tetra?

[Peter C. <Pet...@me...>]

> From: mic...@bo...=20
> Maybe one method of capturing the dev/users/etc... wishes,=20
> could be to set up a 'bod/Tetra Wish List' forum on SF?

Sounds good to me.

		- Peter

Re: [Bodington-developers] Localisation issue

[Matthew B. <mat...@co...>]

Alistair Young wrote:
> On my travels in qLand I found a potential problem with localisation. 
> Questionnaire responses are stored in the big_strings table. I thought 
> big_strings was for system entites, such as Resources, rather than user 
> submitted data. Localising big_strings en masse via db extract and 
> translator is now much more complicated.

Although I am keen on Bodington having i18n (ability to translate the 
templates and outputted messages) I don't see that being able to 
localize the resources is a "big win". And some issues didn't seem to 
get resolved:

What happens if someone updates the English version of a resource? Do 
you still display out of date translated version?

Won't most installation be creating resources in their own locale?

I think that the localization of resource is a aiming for a small market 
and significantly complicates the Bodington codebase.

-- 
+--Matthew Buckett-----------------------------------------+
| VLE Developer, Learning Technologies Group               |
| Tel: +44 (0) 1865 283660 http://www.oucs.ox.ac.uk/       |
+------------Computing Services, University of Oxford------+

[Bodington-developers] Wish List for new bod / Tetra?

[<mic...@bo...>]

The wish list for the next bod/Tetra needs to be captured, so we don't 
have to trawl through the mailing list history.
Maybe one method of capturing the dev/users/etc... wishes, could be to 
set up a 'bod/Tetra Wish List' forum on SF?

Any other ideas are welcome.

-- 
mic...@bo...

[Bodington-developers] Bodington HEAD / i18n

[Matthew B. <mat...@co...>]

It seems that ant template compilation is currently broken on bodington 
HEAD. The problem is that the useroptions.html page has the tag:

<display_language_selection />

Which in turn calls

org.bodington.servlet.template.XmlTemplate.compileLanguageSelectionList(Element)

at the top of this method is:

private void compileLanguageSelectionList(Element e) {
       String[] langs = 
BuildingContext.getProperty("supported_languages").split(",");

which when running under ant returns null and causes the template to 
fail to compile.

Should the display_language_selection not be a method call in Facility 
rather than a new tag? It doesn't seem that it will be used in many 
places and so just seems to complicate the XML namespace.

-- 
+--Matthew Buckett-----------------------------------------+
| VLE Developer, Learning Technologies Group               |
| Tel: +44 (0) 1865 283660 http://www.oucs.ox.ac.uk/       |
+------------Computing Services, University of Oxford------+

Re: [Bodington-developers] Questionnaire tool

[Alistair Y. <ali...@sm...>]

everything's fine apart from the question numbers but I suppose I can  
use sql "order by" ordinal to get the real order.

Alistair

On 10 May 2005, at 11:03, Paul Trafford wrote:

> Alistair,
>
> Co-incidentally, I'm doing something similar, though back-end using  
> Perl, primarily just to output table of results as a csv file, one row  
> per user, so this oriented around table questionnaire_results.
>
> For a given resource, my method with pseudo code is:
>
> 1. get list of question ids, basically:
> =# select questionnaire_question_id from questionnaire_questions where  
> resource_id=$id;
>
> 2. get list of user response (questionnaire_result_id), basically:
> =# select questionnaire_result_id from questionnaire_results where  
> resource_id=$id;
>
> 3. Loop through users and questions to get responses: -
> For each $questionnaire_result_id   {
>   for each $question_id {
>
> =# select big_strings.string,questionnaire_responses.item from  
> questionnaire_responses LEFT OUTER JOIN big_strings ON  
> big_strings.big_string_id=questionnaire_responses.comment_big_string_id 
>  WHERE  
> questionnaire_responses.questionnaire_result_id=$questionnaire_result_i 
> d AND questionnaire_responses.questionnaire_question_id=$question_id;
> }}
>
> This should give data for filling a table with all users' text  
> responses and the codes (0,1,2,..100) for the option responses.
>
> As long as you've got the qn_id's sorted, then hopefully you're sorted!
>
> - Paul T
>
> At 10:29 10/05/2005, Alistair Young wrote:
>> there isn't a problem with the front end - I just have to match a  
>> text string, such as "Question 8" with the question's text in the db.  
>> To do that I need to use the ordinal field, which can't handle  
>> localisation as I've just found out. e.g. "Question 8" could refer to  
>> an entry in the db anywhere between 701 and 799.
>>
>> Now, the real problem. Having sorted the questionnaire numbering in  
>> the front end, a user has then used this layout to create a Gaelic  
>> version of the questionnaire but as the numbering is already sorted,  
>> they don't have to mess about moving questions, so there is no 701.  
>> Everything in the Gaelic questionnaire is 100, 200, ... 2400 etc.
>>
>> I'll get there, evennwhalleeeee
>>
>> Alistair
>>
>> On 10 May 2005, at 10:18, Peter Crowther wrote:
>>
>>>> From: Andrew Booth [mailto:a.g...@le...]
>>>> The ordinal value simply sets the order in which the
>>>> questions appear.  By
>>>> default they are 100 apart, but you can set them to any
>>>> value. In your case,
>>>> question 9 would be presented before question 8.
>>>>
>>>> Aggie
>>>>
>>>> -----Original Message-----
>>>> From: [...] Alistair Young
>>>> in the questionnaire_questions table there's an "ordinal"
>>>> field, which
>>>> seems to be related to the question number, i.e. ordinal=100 means
>>>> question number 1.
>>>> However, Question 8 in the questionnaire shows as ordinal="701" and
>>>> Question 9 shows as ordinal="8".
>>>>
>>>> Is there any relation between ordinal and question number or
>>>> is it pure chance?
>>>
>>> Is the ordinal sorted as a string rather than as an integer, by any
>>> chance?  This would give the observed behaviour.
>>>
>>>                 - Peter
>>
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by Oracle Space Sweepstakes
>> Want to be the first software developer in space?
>> Enter now for the Oracle Space Sweepstakes!
>> http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click
>> _______________________________________________
>> Bodington-developers mailing list
>> Bod...@li...
>> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>> </x-flowed>
>
  

RE: [Bodington-developers] Questionnaire tool

[Peter C. <Pet...@me...>]

> From: Alistair Young [mailto:ali...@sm...]=20
> Now, the real problem. Having sorted the questionnaire=20
> numbering in the=20
> front end, a user has then used this layout to create a=20
> Gaelic version=20
> of the questionnaire but as the numbering is already sorted,=20
> they don't=20
> have to mess about moving questions, so there is no 701.=20
> Everything in=20
> the Gaelic questionnaire is 100, 200, ... 2400 etc.

Why not export the question ID, ask the user to keep it unchanged during
translation, and import based on that ID?  Or have I got the wrong end
of the process here (not for the first time)?

		- Peter

[Bodington-developers] RE: Questionnaire tool

[Paul D. <pau...@co...>]

Problem then being that if you want to change the numbering it's a hell of a
job -  in this instance you'd have to go to question 8, make it question 9,
then go to question 9 and make it question 8.  The current method allows for
questions to be moved to be more logical in order simply by changing the
ordinal.   The system shows the numbering required.  
If we are looking at wish lists, then randomising MCQs is one thing we get
asked for - this probably ties in the same thread here
Paul

Paul Davis
01865 283414



-----Original Message-----
From: Alistair Young [mailto:ali...@sm...] 
Sent: 10 May 2005 10:22
To: Paul Davis
Cc: 'Bodington Developers'
Subject: Re: Questionnaire tool

thanks Paul, that just made my life not worth living!

If only it would use ordinal in the same way that a user uses the 
questionnaire, i.e. question 8 is 8, rather than 800 or, well, who 
knows what else.

Alistair


On 10 May 2005, at 10:09, Paul Davis wrote:

> Alistair
>> From a user's perspective the ordinal should be the order that 
>> questions are
> sorted in.  Generally, by default, the first question is 100, second 
> 200
> etc.  However if you get to the ninth question and realise this would 
> be
> better after question 7 rather than Q8 you can number it 701 (or 
> anything
> 701 to 799 would work!)  When I number something with a single digit it
> appears at the top of the list, rather than lower down as you state.  
> Is
> there some extra code in there not showing - try deleting all of the 
> number
> and re-inserting 8 (or did you want 800?)
>
> On Internet Explorer it's possible to right-click in the summary 
> frame, view
> frame in own window and save that as a separate HTML.  Same 
> functionality in
> Firefox.
>
> Ed Hart had an Excel macro which went into the results and pulled them 
> all
> out into a graphical format in Excel spreadsheet using a macro.  An 
> upgrade
> to the system broke this, but if anyone is interested I can hunt for 
> the
> relevant info and forward on.
>
> Paul
>
> Paul Davis
> 01865 283414
>
>
>
> -----Original Message-----
> From: bod...@li...
> [mailto:bod...@li...] On Behalf Of
> Alistair Young
> Sent: 10 May 2005 09:51
> To: 'Bodington Developers'
> Subject: [Bodington-developers] Questionnaire tool
>
> I'm working on a tool that displays questionnaire results as html pages
> and am pulling me hair oot!
>
> in the questionnaire_questions table there's an "ordinal" field, which
> seems to be related to the question number, i.e. ordinal=100 means
> question number 1.
> However, Question 8 in the questionnaire shows as ordinal="701" and
> Question 9 shows as ordinal="8".
>
> Is there any relation between ordinal and question number or is it pure
> chance? Or does ordinal allow for sub-questions, such as 7a, 7b etc? if
> so, why would 7a show as Question 8? or is that a human fault (I didn't
> design the questionnaire)
>
> ta,
>
> Alistair
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click
> _______________________________________________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>
>

[Bodington-developers] Localisation issue

[Alistair Y. <ali...@sm...>]

On my travels in qLand I found a potential problem with localisation. 
Questionnaire responses are stored in the big_strings table. I thought 
big_strings was for system entites, such as Resources, rather than user 
submitted data. Localising big_strings en masse via db extract and 
translator is now much more complicated.

Can we start a wishlist for Tetra or whatever is coming? I have two:

DB questionnaire numbering to match user questionnaire numbering
User submitted text to go in user submissions tables

Alistair

Re: [Bodington-developers] Questionnaire tool

[Alistair Y. <ali...@sm...>]

there isn't a problem with the front end - I just have to match a text 
string, such as "Question 8" with the question's text in the db. To do 
that I need to use the ordinal field, which can't handle localisation 
as I've just found out. e.g. "Question 8" could refer to an entry in 
the db anywhere between 701 and 799.

Now, the real problem. Having sorted the questionnaire numbering in the 
front end, a user has then used this layout to create a Gaelic version 
of the questionnaire but as the numbering is already sorted, they don't 
have to mess about moving questions, so there is no 701. Everything in 
the Gaelic questionnaire is 100, 200, ... 2400 etc.

I'll get there, evennwhalleeeee

Alistair

On 10 May 2005, at 10:18, Peter Crowther wrote:

>> From: Andrew Booth [mailto:a.g...@le...]
>> The ordinal value simply sets the order in which the
>> questions appear.  By
>> default they are 100 apart, but you can set them to any
>> value. In your case,
>> question 9 would be presented before question 8.
>>
>> Aggie
>>
>> -----Original Message-----
>> From: [...] Alistair Young
>> in the questionnaire_questions table there's an "ordinal"
>> field, which
>> seems to be related to the question number, i.e. ordinal=100 means
>> question number 1.
>> However, Question 8 in the questionnaire shows as ordinal="701" and
>> Question 9 shows as ordinal="8".
>>
>> Is there any relation between ordinal and question number or
>> is it pure chance?
>
> Is the ordinal sorted as a string rather than as an integer, by any
> chance?  This would give the observed behaviour.
>
> 		- Peter

RE: [Bodington-developers] Questionnaire tool

[Peter C. <Pet...@me...>]

> From: Andrew Booth [mailto:a.g...@le...]=20
> The ordinal value simply sets the order in which the=20
> questions appear.  By
> default they are 100 apart, but you can set them to any=20
> value. In your case,
> question 9 would be presented before question 8.
>=20
> Aggie
>=20
> -----Original Message-----
> From: [...] Alistair Young
> in the questionnaire_questions table there's an "ordinal"=20
> field, which=20
> seems to be related to the question number, i.e. ordinal=3D100 means=20
> question number 1.
> However, Question 8 in the questionnaire shows as ordinal=3D"701" and=20
> Question 9 shows as ordinal=3D"8".
>=20
> Is there any relation between ordinal and question number or=20
> is it pure chance?

Is the ordinal sorted as a string rather than as an integer, by any
chance?  This would give the observed behaviour.

		- Peter

[Bodington-developers] Re: Questionnaire tool

[Alistair Y. <ali...@sm...>]

thanks Paul, that just made my life not worth living!

If only it would use ordinal in the same way that a user uses the 
questionnaire, i.e. question 8 is 8, rather than 800 or, well, who 
knows what else.

Alistair


On 10 May 2005, at 10:09, Paul Davis wrote:

> Alistair
>> From a user's perspective the ordinal should be the order that 
>> questions are
> sorted in.  Generally, by default, the first question is 100, second 
> 200
> etc.  However if you get to the ninth question and realise this would 
> be
> better after question 7 rather than Q8 you can number it 701 (or 
> anything
> 701 to 799 would work!)  When I number something with a single digit it
> appears at the top of the list, rather than lower down as you state.  
> Is
> there some extra code in there not showing - try deleting all of the 
> number
> and re-inserting 8 (or did you want 800?)
>
> On Internet Explorer it's possible to right-click in the summary 
> frame, view
> frame in own window and save that as a separate HTML.  Same 
> functionality in
> Firefox.
>
> Ed Hart had an Excel macro which went into the results and pulled them 
> all
> out into a graphical format in Excel spreadsheet using a macro.  An 
> upgrade
> to the system broke this, but if anyone is interested I can hunt for 
> the
> relevant info and forward on.
>
> Paul
>
> Paul Davis
> 01865 283414
>
>
>
> -----Original Message-----
> From: bod...@li...
> [mailto:bod...@li...] On Behalf Of
> Alistair Young
> Sent: 10 May 2005 09:51
> To: 'Bodington Developers'
> Subject: [Bodington-developers] Questionnaire tool
>
> I'm working on a tool that displays questionnaire results as html pages
> and am pulling me hair oot!
>
> in the questionnaire_questions table there's an "ordinal" field, which
> seems to be related to the question number, i.e. ordinal=100 means
> question number 1.
> However, Question 8 in the questionnaire shows as ordinal="701" and
> Question 9 shows as ordinal="8".
>
> Is there any relation between ordinal and question number or is it pure
> chance? Or does ordinal allow for sub-questions, such as 7a, 7b etc? if
> so, why would 7a show as Question 8? or is that a human fault (I didn't
> design the questionnaire)
>
> ta,
>
> Alistair
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click
> _______________________________________________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>
>

RE: [Bodington-developers] Questionnaire tool

[Andrew B. <a.g...@le...>]

The ordinal value simply sets the order in which the questions appear.  =
By
default they are 100 apart, but you can set them to any value. In your =
case,
question 9 would be presented before question 8.

Aggie

-----Original Message-----
From: bod...@li...
[mailto:bod...@li...] On Behalf Of
Alistair Young
Sent: 10 May 2005 09:51
To: 'Bodington Developers'
Subject: [Bodington-developers] Questionnaire tool

I'm working on a tool that displays questionnaire results as html pages=20
and am pulling me hair oot!

in the questionnaire_questions table there's an "ordinal" field, which=20
seems to be related to the question number, i.e. ordinal=3D100 means=20
question number 1.
However, Question 8 in the questionnaire shows as ordinal=3D"701" and=20
Question 9 shows as ordinal=3D"8".

Is there any relation between ordinal and question number or is it pure=20
chance? Or does ordinal allow for sub-questions, such as 7a, 7b etc? if=20
so, why would 7a show as Question 8? or is that a human fault (I didn't=20
design the questionnaire)

ta,

Alistair



-------------------------------------------------------
This SF.Net email is sponsored by Oracle Space Sweepstakes
Want to be the first software developer in space?
Enter now for the Oracle Space Sweepstakes!
http://ads.osdn.com/?ad_id=3D7393&alloc_id=3D16281&op=3Dclick
_______________________________________________
Bodington-developers mailing list
Bod...@li...
https://lists.sourceforge.net/lists/listinfo/bodington-developers

[Bodington-developers] RE: Questionnaire tool

[Paul D. <pau...@co...>]

Alistair
From a user's perspective the ordinal should be the order that questions are
sorted in.  Generally, by default, the first question is 100, second 200
etc.  However if you get to the ninth question and realise this would be
better after question 7 rather than Q8 you can number it 701 (or anything
701 to 799 would work!)  When I number something with a single digit it
appears at the top of the list, rather than lower down as you state.  Is
there some extra code in there not showing - try deleting all of the number
and re-inserting 8 (or did you want 800?)

On Internet Explorer it's possible to right-click in the summary frame, view
frame in own window and save that as a separate HTML.  Same functionality in
Firefox.

Ed Hart had an Excel macro which went into the results and pulled them all
out into a graphical format in Excel spreadsheet using a macro.  An upgrade
to the system broke this, but if anyone is interested I can hunt for the
relevant info and forward on.

Paul

Paul Davis
01865 283414



-----Original Message-----
From: bod...@li...
[mailto:bod...@li...] On Behalf Of
Alistair Young
Sent: 10 May 2005 09:51
To: 'Bodington Developers'
Subject: [Bodington-developers] Questionnaire tool

I'm working on a tool that displays questionnaire results as html pages 
and am pulling me hair oot!

in the questionnaire_questions table there's an "ordinal" field, which 
seems to be related to the question number, i.e. ordinal=100 means 
question number 1.
However, Question 8 in the questionnaire shows as ordinal="701" and 
Question 9 shows as ordinal="8".

Is there any relation between ordinal and question number or is it pure 
chance? Or does ordinal allow for sub-questions, such as 7a, 7b etc? if 
so, why would 7a show as Question 8? or is that a human fault (I didn't 
design the questionnaire)

ta,

Alistair



-------------------------------------------------------
This SF.Net email is sponsored by Oracle Space Sweepstakes
Want to be the first software developer in space?
Enter now for the Oracle Space Sweepstakes!
http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click
_______________________________________________
Bodington-developers mailing list
Bod...@li...
https://lists.sourceforge.net/lists/listinfo/bodington-developers

[Bodington-developers] Questionnaire tool

[Alistair Y. <ali...@sm...>]

I'm working on a tool that displays questionnaire results as html pages 
and am pulling me hair oot!

in the questionnaire_questions table there's an "ordinal" field, which 
seems to be related to the question number, i.e. ordinal=100 means 
question number 1.
However, Question 8 in the questionnaire shows as ordinal="701" and 
Question 9 shows as ordinal="8".

Is there any relation between ordinal and question number or is it pure 
chance? Or does ordinal allow for sub-questions, such as 7a, 7b etc? if 
so, why would 7a show as Question 8? or is that a human fault (I didn't 
design the questionnaire)

ta,

Alistair

Re: [Bodington-developers] package name on SF

[Matthew B. <mat...@co...>]

Colin Tatham wrote:
> Unless anyone can think of a reason why I shouldn't, I'm going to change the
> package name on the SF summary page (currently says 'bodington_2_1', will
> change to 'bodington'). Don't think it will break anything.

I've no objections. Although some people may have direct links to the 
download page which will break.

-- 
+--Matthew Buckett-----------------------------------------+
| VLE Developer, Learning Technologies Group               |
| Tel: +44 (0) 1865 283660 http://www.oucs.ox.ac.uk/       |
+------------Computing Services, University of Oxford------+

[Bodington-developers] ResourceTree Fixes

[Matthew B. <mat...@co...>]

I quickly hacked in changes to ResourceTree so that it doesn't allow
duplicate named resources at the same point in the tree. I'm not sure if
this is the best way to do it but it works.

Attached is the new ResourceTree.java

-- 
+--Matthew Buckett-----------------------------------------+
| VLE Developer, Learning Technologies Group               |
| Tel: +44 (0) 1865 283660 http://www.oucs.ox.ac.uk/       |
+------------Computing Services, University of Oxford------+

[Bodington-developers] package name on SF

[Colin T. <col...@co...>]

Unless anyone can think of a reason why I shouldn't, I'm going to change the
package name on the SF summary page (currently says 'bodington_2_1', will
change to 'bodington'). Don't think it will break anything.

Colin

[Bodington-developers] Button panel in graphic.html in UHI interface

[Andrew B. <a.g...@le...>]

I've just changed over to using the UHI look and feel and noticed that 
when a menu page opens, the button panels on the left are fully open 
until closed when the onLoad() function is called.  This gives a flash 
effect which can be quite irritating.  It would be better if the panel 
is closed when the page loads and no onLoad() would be needed.

Here's a replacement graphic.html.  The panels are closed as soon as 
they they load, rather than waiting for the whole page to load.  Seems 
to do the trick.

Aggie