Form Wizard Pro - Email notification - processable form results

This is a forum to suggest new features for mojoPortal. 

This thread is closed to new posts. You must sign in to post in the forums.
11/24/2010 10:00:09 AM
Gravatar
Total Posts 4

Form Wizard Pro - Email notification - processable form results

Hi,

I am not sure whether this is a feature request, might be included already. I didn't manage to test it in the demo portal so I just post it here.

I am wondering if I can use Form Wizard Pro to start an automated workflow.

Is it possible to have Form Wizard Pro attach the form results as csv file to the email notification? So that, when a user submits the form, an email is sent to a server where the csv can be processed. I am not relying on csv, anything that allows for automated extraction of the answers would be fine, could as well be the key to fetch the data via sql or any other format.

Best regards,
Lars

11/24/2010 11:46:27 AM
Gravatar
Total Posts 1203
Proud member of the mojoPortal team

Help support mojoPortal!
Add-on modules

Re: Form Wizard Pro - Email notification - processable form results

Hi Lars, Form Wizard Pro does save all submissions in the database, and they can be manually retrieved in CSV or Word format. There are two problems I see with an automated mailing and processing idea. First is the general unreliability of email these days, and the second is that the generated CSV file from Form Wizard Pro contains all submissions until it's cleared, so you'd be receiving duplicates in that email, until someone went in and cleared the submissions. This one could probably be worked around, however (keying on submitted date/time, for instance).

In any case, if you are hosting your own mojoPortal server (or have database access through your hosting service), and depending on your mojoPortal database of choice, you might be able to set up a direct connection from your processing server to the mojoPortal database, and periodically check for new posts and pull the form submission data straight from the database. That would offer a lot of advantages and is the method I would use, if possible.

As a really advanced idea, you might even be able to use replication to duplicate that form submission data automatically on your processing server.

Jamie

11/25/2010 7:58:19 AM
Gravatar
Total Posts 4

Re: Form Wizard Pro - Email notification - processable form results

Hi Jamie, thanks for your reply.

the email reliability issue would not bother me too much, we are using Mojo Portal as our Intranet, so if Mojo Portal is up chances are that the Mail Server works also.

The second problem you mention is worse for me. I would like the email to include a way to get to the results of the submission that caused the email to be sent. Like including a key in the subject of the email or attaching the results as csv.

If there is no real need for a feature like that, I will use the Email to trigger a program that checks for new results. Not as nice as having the email point to the data because i need to keep track of what I already processed somewhere in the Mojo Portal Database but it will work. 

Thanks again for your help.

regards Lars

11/25/2010 8:08:40 AM
Gravatar
Total Posts 18439

Re: Form Wizard Pro - Email notification - processable form results

I think to meet this kind of scenario what is really needed is for me to implement an event and a plugin system so you can write a plugin to handle the event, like a FormSubmittedEvent. Something similar to what we have in mojoPortal currently for UserRegisteredEventHandlers.

I do think trying to process it from an email notification is a messy solution prone to problems, with an event you can get access to the submitted form object and its questions/responses and do whatever processing you need.

I will add a wish list item for this in my project tracker for Form Wizard Pro.

Best,

Joe

11/25/2010 10:50:26 AM
Gravatar
Total Posts 4

Re: Form Wizard Pro - Email notification - processable form results

Hi Joe, thanks for your reply.

Processing the email would not have been fail-save that's for sure. An event is the smoothest solution. Thanks a lot.

Will you post here when the event is ready for use?

regards Lars

5/12/2011 11:54:12 AM
Gravatar
Total Posts 18439

Re: Form Wizard Pro - Email notification - processable form results

Hi Lars,

fyi, Form Wizard Pro 2.6 is now available and includes a new event handler plugin system that allows developers to easily implement custom handlers to do additional processing on the submitted form data.

Best,

Joe

You must sign in to post in the forums. This thread is closed to new posts.