New Limesurvey entry triggers database build and redeploy.

[ColmMassey]

Design an implement a method for triggering database rebuilds after approving new survey entries.

[ColmMassey]

Limesurvey

• Enable email notification to a dedicated address for survey administrators, so they know that a new survey entry has been made.
• Extend the Limesurvey template to include a hidden boolean question indicating if the submission has been approved yet.

Sausage Factory

• Add to [first script] to only use entries with a TRUE Approved entry.
• Periodically, or in response to some other trigger
  • call Limesurvey to see if there have been any updates since last enquiry
    • request export of survey data
    • move csv file to appropriate location
    • call database build and redeploy

[ColmMassey]

What options do we have for a third party, like the person approving new entries to a Limesurvey, to trigger a rebuild, so the rebuild is not periodic but on request?

[wu-lee]

* Enable email notification to a dedicated address for survey administrators, so they know that a new survey entry has been made.

According to Lime Survey's manual this can be done, and is configured per-survey. We can use the placeholder {ADMINEMAIL} to send an email to the currently configured admin, or enter an email explicitly.

Should I do this, if so:

• for which surveys?
• to which emails?
• are there any other notification settings which we need?

[ColmMassey]

Should I do this, if so:

An email notification is set up for the Newbridge project.

[wu-lee]

You seem to be implying I don't need to change anything with respect to notifications. Right?

[ColmMassey]

Probably worth a voice call.

[wu-lee]

Not much time right now; may have time between 10 and 12 if we stick the kids in front of the TV, then busy again with exercise/lunch until about 2. Do any of these slots fit in with you?

[ColmMassey]

A quick call at 10 would be great.

[wu-lee]

Sorry, kids didn't want to do that so I got caught up in something else. Feeling slightly wild now. Maybe after 2, let's say 2.15 because children.

[wu-lee]

I've asked how to tell when there is new survey response data here:

https://forums.limesurvey.org/forum/can-i-do-this-with-limesurvey/122433-how-to-check-if-a-survey-s-has-new-or-modified-responses-programmatically

The answers which might help all seem to require writing a plug-in for limesurvey, but on our current hosting we can't install 3rd party plugins.

One thing which might still work is a notification email, which could be sent to the server running the autobuild code. I can't see these so I don't know exactly what they contain or when they get sent. @ColmMassey - perhaps you could comment on that? Do the modifications we're interested in result in an email notification?

The only other thing seems to be to inspect the web UI and API more carefully looking for hints. The difficulty seems to be that although limesurvey has a response state signifying "completion", modifications after that will not be visible as any state change.

[ColmMassey]

One thing which might still work is a notification email, which could be sent to the server running the autobuild code. I can't see these so I don't know exactly what they contain or when they get sent. @ColmMassey - perhaps you could comment on that? Do the modifications we're interested in result in an email notification?

The notification is sent when a survey has been submitted, but the admin then needs to approve them. So we'd an email sent after that.