Have you done this with limesurvey and by editing data directly in the database?

it's a crude way to do it but it works.

i would expect the data to be loaded with sql statements, so by changing the gid in the questions table to a gid that doent exist in the parent table, you end up with orphan records.

Once more, I don't really understand what you did:
Have you done this with limesurvey and by editing data directly in the database?
If so do you think it's worth to put this to the workarounds so other users can benefit from your solution?

Sure thing I'll get something together for early next week.

it might take me a day or so, having probelms registering for the wiki

Steve

workaround, for anyone with a wiki login

Here is a simple solution to create question pools for Limesurvey.

It will require access to the backend database. I'm not going to explain how to do this, as if you don;t understand it, then you shouldn't really do it. Hopefully an option will appear in a new version.

Basically 3 tables exist that we care about

lime_surveys - id field = sid
lime_groups - id field = gid
lime_questions id field = qid

In order to show the questions correctly the id field from the lime_groups table exists in the lime_questions table. This then is used to create the parent/child relationship.

However, if you want to create a pool of questions all you need to do is to amend the gid field in the LIME_QUESTIONS table to a value that doesn't exist in the lime_groups table. I would use 0 or a something silly like 10000. Try this with one question and you will notice it doesnt appear in the question list.

It's a crude workaround, but allows you to create as many questions as you want, without having them visible.

This could also be applied for groups as well just by using the sid field in the lime_groups table.

I have added this to the manual. Thank you very much for your help and cooperation!

thx,

I take it from that, you understand where I was coming from?

I have an idea of how it can be implemented.

On the edit survey screen where you have the languages list boxes, use the same sort of screen as that.

grab all questions that aren't members of groups to form the contents of the list box.

hit add button to move them over

update button runs sql update query to amend the gid field to the currently selected group.

It's a shame my php is not so good, I could do it in VBA quite easily for you....

Steve

Steve

Thanks for these instructions. Problem is that all our developers suffer a huge workload.

Nevertheless I would like to ask you to add your solution as a feature request to the bugtracker so we might be able to implement this later.

BTW: Are you interested in joining the development team? We are always looking for fresh blood

thanks for the offer, whilst I enjoy developing access databases, I'm not sure if I can make the crossover to php. I'm self taught, complete with bad habits.

Steve