Hi!

I've been working closely with my company to add a survey/reporting structure to our business and have finally convinced them to dip their toe in the open source water!

We propose to use LimeSurvey as our survey engine as in its current state Lime Survey 1.7x does exactly what we require.

We would however like to develop some reports based on results and so I have two questions:

1) Is there a database structure recorded anywhere so that we can look at pulling results out and using them in live reports?! We would like to create some live reports for a "dashboard" over the company intranet, and plan on documenting these developments so that they may help others. Database structure is also required by the head of IT because he likes to know exactly whats going on (sensible!)

2) Is it possible to use the response summary pages to summarise responses made between specific dates? Currently I can check responses x to y but not Day X to Day Y as far as i can tell. This is not massively important if we can pull the data out of the database anyway but it would be nice to know if its possible!

Have checked the wiki, searched the forum and we are using 1.7x latest. I've seen structure for ls2 but we intend on using 1.7....

Thanks!

1. I have documented the 1.53 database. You can download it here:


2. Right now the interface is not able to show results depending on a certain period. But this would be a very nice feature and shouldn't be hard to implement. Just take care that there might be no timestamps depending on your survey settings (anonymous/non-anonymous).

Thanks Mazi,

1) Great - i assume this isn't disimilar to 1.7x? It certainly looks like what i can see in phpmyadmin!

2) I'm not too sure what you mean in regards to timestamps? Are they only recorded for certain settings?

Finally, as a couple of our possible surveys will be recording the date of an activity (eg When did it happen, was it good) as well as the date of the survey is it possible within limesurvey to:
1) Populate a date question type automatically with todays date.
2) Lock the editing of this date in some situations.

Thanks for the help!

limpsharp wrote:
2) I'm not too sure what you mean in regards to timestamps? Are they only recorded for certain settings?
When setting a survey anonymous there won't be any timestamps for the questions. I have attached a document in which I have documented the databseactions which take place when creating a survey. Maybe this is helpful to you.

@1. No.
@2. No.
In both cases I would recommend to create a new table to store this information and to create a new PHP script that stores the information when needed.

Thanks for this - you've been a star!

Very helpful!

If we could help you and you enjoy limesurvey please consider a donation to the team.