This is quite a common problem with sites that run WordPress but have their homepage made as landing page with other plugin or just built as static page. Arigato PRO has a “Squeeze page” option and we strongly recommend it. But if for some reason you use a a static squeeze page, or other squeeze page that does not run the normal WordPress routines you may have a problem with Arigato form sign-ups not being processed.

The solution to this is very simple: point the Arigato PRO form action attribute to a post created with your WordPress blog instead to the homepage.

So your Arigato PRO form opening HTML tag will look something like:

<form action=”https://blog.calendarscripts.info/test-post” method=”post”>

That’s it.

By default WatuPRO stores every user’s answer to every question in your database. This allows us to show you this data any time and perform useful reports on it. As the time goes and you are collecting a lot of data from many users and quizzes, your database can become really big. This might be a problem if you are using a shared host or other way limited resources.

So here is what you can do. Have in mind that any solution that reduces data means this data will no longer be available to you and will no longer participate in reports.

When Your Database Is Already Large

If you have not prevented the database from growing and already have too much of it, you will need to clean it up. There are several options:

a) Deleting whole quizzes. If there are quizzes you no longer need, and don’t need the stats from them, you can simply delete them. This will save most space but obviously isn’t ideal in most cases.

b) Delete user submitted data on the quiz. You can save a lot of space by doing this. Go to Quizzes -> View Results and you’ll see a checkbox at the bottom: “Show me a button to cleanup all submitted data on this quiz.”. Click on it, then click on “Cleanup all data” button.
You can do this on every quiz on which you don’t need the data.

c) Blank out data on a quiz. Blanking out the data will save less DB space, but will leave the points, grades, percentage correct answers etc. This way most of your reports and stats will remain unchanged and you’ll still have less used DB space.

Preventing Too Much Data

As usual prevention is easier than cure. Depending on how much of the user submitted data you need, you have several options to reduce DB space usage:

a) Don’t store any data. This is configurable on per-quiz basis. You need to go to Edit Quiz -> Advanced Settings tab and select the following option:

” Don’t store any data / results of this quiz in the database. “

That’s it.

b) Automatically cleanup or blank out data. This option is global and affects all quizzes so be careful with it. It’s available on your WatuPRO Settings page:

You can for example choose to cleanup only data older than 30 days, or 180 days etc.

If you use the certificates feature in WatuPRO you have probably noticed that not all variables available in the “Final Page / Quiz Output” box are available in the certificate.

Why? The answer is very simple: many variables are calculated on the fly when user submits the quiz. They cannot be calculated at a later stage without having all the detailed POST-data that we have while submitting the quiz.

Certainly we could store all this variable content in the database and pull them in the certificate but this means that with or without certificates you will have a lot of unnecessary data taking space in your database. You don’t want this.

There is very simple trick to handle this:

Include any “final page” variables in the grade description of the grade that assigns the certificate. If you don’t use grading just create one “catch all” grade from 0% to 100% correct answer so it catches every submitted quiz.

Once done, use the variable %%GRADE%% or %%GDESC%% in your certificate (which is the grade title + grade description). All the variables will be processed at the time of calculating the grade description and then this unique description will be shown in the certificate. Voila, you can have all variables arranged in any way you wish in the certificate. And without wasting any database space.

This trick will however not work if you are manually editing user’s results of the already submitted quiz through the administration.

Note: from WatuPRO version 5.8.4.5 you can use the bolded variables from “Manually craft the output” section here directly in the certificates.