Monthly Archives: May 2014

How To Copy WatuPRO Data from One Site To Another?

This is a frequently asked question about the quiz plugin WatuPRO.

If you want to copy only a single quiz it might be easier to export and import questions from the “Manage Questions” page. More info about export/import formats is available here.

On the other hand, if you want to copy all your quizzes, takings data, and so on, it’s much better to do it through phpMyAdmin. (See how to access phpMyAdmin on your host. If your hosting control panel is different you may need to ask your hosting support.). Here are the steps you need to do assuming WordPress is already installed on your new site.

  1. In your old site go to phpMyAdmin and export all tables that contain “watupro” in their name. When exporting, include structure and data. See how.
  2. Go to your new site, load phpMyAdmin and import the exported file there.
  3. Install WatuPRO on the new site. It will recognize the imported data.

Using WatuPRO for Polls (New Shortcodes From Reporting Module)

From version 4.3.7 the quiz plugin WatuPRO supports “poll-like” shortcodes through the Reporting module. The shortcodes render a simple bar chart showing how all users have answered a given question. Here’s an example from our open demo quiz: (note that it pulls random 3 of 5 questions so the frog question will not always be loaded) frog-question In this example the chart is shown immediately after answering the quiz. It can however be used everywhere, including in some custom made pages. The shortcode can show either how each answer distributes (for “single choice” and “multiplce choice” questions), or the distribution of correct / incorrect answers (for all other question types). You can get the shortcode for each question from add / edit question page: frog-question-edit Clicking on “How to configure” will take you to the help page which explains how you can change the colors or show “correct/incorrect” chart instead of distribution per answer. Note that this functionality requires the Reporting module.

An SQL Query

You like this so much that you want to add it in the optional “answer explanation” are of all your existing thousands of questions? You can do it with an SQL query:

UPDATE wp_watupro_question SET explain_answer = CONCAT(explain_answer, '<br>[', 'watupror-poll question_id="', ID, '"]');

Note that you may need to change “wp_watupro_question” depending on how the table prefix is named in your installation.