Importing subscribers in Arigato PRO is easy but entering field numbers can be a bit confusing. Especially if you have custom fields in the mailing list and the CSV file. This guide will clear it all up.

Note! If your file contains any non-English characters (for example Asian, Cyrillic, any French and Spanish accents etc.), you must encode it in Unicode / UTF-8 format! See how to do it.

Let’s make an example with a mailing list with 3 custom fields:

And a CSV file which doesn’t perfectly match the mailing list:

And when you click on “Import subscribers” in Arigato PRO, this is what you see:

So there are a few problems to deal with here:

• The CSV file does not contain “Name” column. It contains first name and last name columns and you want the name in your mailing list to contain first and last name.
• The CSV file has the columns ordered in a way that obviously isn’t the same as the order on the import page.
• The CSV file contains some columns you don’t need (Client ID, State, ZIp, Phone, Address) and lacks the Age data.

So how to import this? Let’s visually number the columns in the CSV file:

Now things become simpler and we just have to watch at the import page first, find the field we need in the CSV and enter its number. Because “name” is constructed by 2 column, we enter them both with “+”. Here you go:

Let’s explain:

• Email is column number 7 in the file so we enter it before the comma in the “Email,  Name” field.
• Name is constructed by columns 2 and 3 so we enter them as “2+3” after the comma. So the “Email, Name” field becomes “7, 2+3. Spaces do not matter.
• The CSV file does not contain fields for IP address, signup date and age. So we leave these blank.
• Company is column number 9.
• Gender is column number 10.

That’s it, import with “Skip first line (column titles) when importing” selected. And we are done:

This feature is available from WatuPRO version 5.4.1 and above.
It lets you include several groups of checkbox answers into one “multiple choice” question.
This lets you structure complicated questions like this:

Such question will be treated just like any regular “multiple choice” question: it can be calculated as a whole or not, it will be counted as one question in all the calculations for percentages, correct/incorrect answers, category based reports, etc. Grouping the checkboxes is a presentation feature, it’s not a change to the logic. If you want to calculate each group as different question, then you obviously don’t need the feature. Simply create several multiple-choice questions.

How does it work

Once you select “Multiple Choices” for question type, the following checkbox will appear and you need to select it:

After you select the checkbox the answers to the questions will receive an additional box where you can enter group number:

In the contents of the question use the {{{group-N}}} variable to mark where you want each group of checkboxes to appear. Replace N with the group number:

This results in the following output:

And after selecting some answers and answering the quiz:

And this is still just a single question! Nice.

Please note that this feature is available only for “Multiple Chocies” questions. It can’t be applied to single choice questions (radio buttons) because if you can select one choice in each group, it’s no longer a single choice but multiple choices.

This update of WatuPRO came a bit faster than usual. There are a lot of feature and improvement requests some of which quite good, so we implemented them:

• Certificates can have expiration period. After X months or years a configurable message that the certificate has expired will replace the original certificate contents.
• Added option to manually award certificates.
• Added strict exact match (case sensitive) mode on open-end questions.
• Added two more optional contact fields on the “Ask for contact details” section.
• Showing “Question X of Y” or “Page X of Y” text is now configurable from the quiz pagination settings.
• New option lets you mass update questions to: Required/Not required, Survey/Not survey and Important/Not important. These properties are also shown on the Manage Questions page under “Type” column.
• You can now enable Unselect button on single choice / multiple choice questions.
• New option lets you choose the text on the Submit button for each quiz.
• From the WatuPRO Settings page you can define what word to be used for “Quiz/Quizzes” within the plugin interface. Please note that we are slowly implementing the defined word usage on the pages so it’s currently only partial. This process may cause a bit of extra work to plugin translators as some of the previous strings will need to be translated again.
• Added variable %%SHORT_ANSWERS%% for the final screen. This variable will display the question along with user’s answer without checkmarks or feedback. The variable is suitable for surveys or similar tests that do not have correct or wrong answers.
• The design adjustments now allow you to choose buttons design and text sizes within the quizzes without editing CSS.
• You can also choose to use textual checkmarks when emailing results instead of graphics. Nowadays most email programs do not show graphics by default so this can be useful to avoid confusing the respondents.
• When question choices are displayed in 2, 3, or 4 columns you can set a fixed column width for achieving the best layout on the specific question.
• Added button to “Save & Add New Question” to save time when adding many questions.
• You can select WatuPRO user group also on the Add New User page.
• Added variable %%WRONG%% to show number of wrong answers on the Final screen.
• Added “Save & Add New” button on the pages for managing question categories and test categories.
• [Intelligence module] New option: Let user choose what questions to answer (based on predefined criteria). Similar to the User Choice addon.
• [Intelligence module] Quiz bundles can now have expiration period of X days after purchasing the bundle.
• [Intelligence module] Updated the Stripe payment library.
• [Reporting module] Stats per category page now also includes per-question tag report. The reports can now be filtered by user login / email address.
• Fixed bug: the variable %%MAX-POINTS%% was not properly calculated on checkbox questions.
• Fixed bug: The setting “Do not show correct / incorrect checkmarks on unresolved questions to avoid right answers being revealed.” did not work without the Intelligence module.
• Fixed bug: the {{{points}}} variable in the question feedback area was not properly calculating the cases when points should be discarded in some question types.
• Fixed CSS issue: when showing multiple-line answers in bullet lists the bullets were aligning bottom to the text.
• Fixed the CSS on compact format questions.

Eligible customers will receive the upgrades with the newsletter. If your free upgrades subscription has expired you will receive 60% discount code for optional renewal.