TutorLMS Quiz Import/Export

With the TutorLMS Quiz Import/Export add-on, creating, updating, migrating, and backing up quizzes has never been this easy! Export your quizzes into a .xls or .xslx file with a single click. Create new quizzes or edit them directly from a simple template for a quick and easy import.

Video Tutorial

Watch the tutorial video below for a quick walkthrough of the add-on’s features and setup process.

For detailed instructions, please continue reading the full documentation. If you still have any questions, feel free to submit a support ticket.

Installation

• Install the TutorLMS plugin & activate it.
• Install TutorLMS Quiz Import/Export and activate it.
• A new Quiz Import/Export menu will appear under the TutorLMS menu.

Activate Your License Key

The license key can be configured from the License Settings tab, found on the main Quiz Import/Export menu. License keys will be sent to your email address when you purchase the addon.

Insert your license key in the field and then click on Activate.

Export Quizzes

Export Single Quiz

Navigate to Quiz Import/Export > Manage Quiz. This tab will show all of the quizzes. The export buttons will appear here next to every listed quiz. To export the quiz, simply click on the export button. The quiz will be downloaded as an .xls or .xlsx file, which can be imported to another site using this add-on.

Export Multiple Quizzes

Navigate to Quiz Import/Export > Manage Quiz. This tab will show all of the quizzes. To export multiple quizzes in bulk, simply select all of the quizzes that you want to export, and from the Bulk Actions WordPress dropdown, select Export xls or Export xlsx and click on apply. The quiz will be downloaded as a .xls or .xlsx file, which can be imported to another site using this add-on.

Import Quizzes

Download The Import Template

Download the standard template file from the Import Quiz tab by clicking on the Download Template button. Next, add or edit the content on the file and save your changes.

Import a Single Quiz

To import a quiz, go to the Import Quiz tab from the Quiz Import/Export menu located under the main TutorLMS plugin menu. Here, you will find the input area for the quiz file to be imported. To complete the import, click on Browse, select the Microsoft Excel .xls or .xlsx file containing the quiz and click on the Next button.

Import Multiple Quizzes

You can import several quizzes at once by adding a different quiz on each separate line of the Quizzes sheet of your spreadsheet file. Make sure to specify the individual Title for each quiz on each line. Then, to import a quiz, go to the Import Quiz tab from the Quiz Import/Export menu located under the main TutorLMS plugin menu. Here, you will find the input area for the quiz file to be imported. To complete the import, click on Browse, select the Microsoft Excel .xls or .xlsx file and click on the Next button.

After importing the file, you will see all imported quizzes listed on your screen, as seen in the following image:

Settings

Enable Debug Logs

Enabling the “Enable Debug Logs” toggle in the settings tab allows the system to generate import debug logs, which offer valuable information and insights for troubleshooting any potential import issues.

Once Debug logs are enabled, two new tabs will appear: “Debug logs” and “Systems Information“. The “Debug logs” tab displays detailed logs that provide a comprehensive overview of the import process, while the “System Information” tab showcases your system specifications.

Remove Duplicate Answers

Activating the Remove Duplicate Answers toggle in the settings tab empowers the system to eliminate duplicate answers from the imported quiz.

Update duplicate questions

Here, you can select whether you want the question with the same title that already exists in the quiz to be updated, instead of creating a new one. If the toggle is enabled, then the quiz questions that already exist will be updated. Similarly, if the toggle is disabled, then new quiz questions will be created during the importing process.

Enable Google Sheet Compatibility

Here, you can enable this option to import quiz(s) from a Google Sheet.

Google Sheet Schedule

Here, you can select the Google Sheet import schedule. Based on the interval, a cron job will run and create/update the TutorLMS quiz(s) based on the columns and records in the Excel sheet. You can select from the following options:

• Every minute
• Once Hourly              
• Twice Daily
• Once Daily
• Once Weekly 

Google Sheet Import

Here, you are supposed to provide the Google sheet import link from which you want to check and import/update the TutorLMS Quiz-related information. The URL link will be in the format:

“https://docs.google.com/spreadsheets/d/1nw/edit?usp=sharing” 

To create your own TutorLMS Quiz Importing Google sheet, the steps are as follows:

1- Navigate to the “Import Quiz” tab and click on the “Copy Default Template to Google Sheet” button. Here, you will be asked to make your own online copy of the quiz-importing Excel sheet into your Google account.

2- Finally, click the “Make a copy” button.

3- Once you have created your own quiz-importing Excel sheet. Click on the “Share” button. Provide restricted access to the Excel sheet with viewer role permissions.

4- Click the “Copy link” button to copy the Excel sheet URL. 

5- Finally, navigate back to the “Settings” tab and paste the Excel sheet URL in the “Google Sheet Import” option text field and click the “Update Settings” button.

Import Google Sheet Now

Here, you can click the “Import Scheduled Quizzes” button to manually run the Google Sheet import function to import/update quiz(s) from Google Sheet. After the function has been executed, your quiz-related information/content will be updated.

Associate Quizzes to Courses and Topics

Navigate to Quiz Import/Export > Manage Quiz. This tab displays a list of quizzes, with each row representing an individual quiz. For each quiz, you’ll find dropdown menus in the “Course” and “Topic” columns, allowing you to associate each quiz with specific courses and their corresponding topics.

TutorLMS Quiz Import/Export Template Guide

TutorLMS Quiz Import/Export uses a standard template to import and export all TutorLMS question types. This template should be filled in the given order to create your own templates for import/export.

Downloading The Template: The standard template can be found in the plugin folder:

TutorLMS-quiz-import-export > Sample-import-files > Standard-template.xls

Completing The Template:

Note that the TutorLMS Quiz Import/Export template supports special characters and has been tested with dozens of languages. If you need to import quizzes that contain special characters, please input your file encoded in UTF-8 format. This will ensure all quizzes are imported accurately and avoids the conversion of strings like “≤, ÷, ∑, ∛, µ” into unwanted characters.

The template contains the following 3 sub sheets:

• Quizzes > Add all of the Quiz settings.
• Questions > Add all of the Quiz questions.
• Answers > Add answers to all of the questions.

Quizzes

Quiz Title

This column will hold the quiz title for the quiz to be imported.

Quiz ID

This column will hold the quiz’s unique post ID.

Quiz Content

This column will hold quiz content/description in text/HTML format.

Course

Add the course title to associate the quiz with.

Course ID

This column will hold the quiz’s Course ID.

Topic

Add the topic title to associate the quiz.

Topic ID

This column will hold the quiz’s Topic ID.

Quiz Order

This column will hold the quiz’s order number.

Position in Topic

This column will hold the quiz’s position number in the topic.

Time Limit

Here you can add the time limit of the quiz. You can alter the list displayed by setting different parameters:

a:2:{s:10:”time_value”;s:1:”1″;s:9:”time_type”;s:7:”minutes”;}

Parameters

• “1”: This is the time limit and you can set it to any number. 0 means no time limit.
• “minutes”: Change the time limit to seconds, minutes, hours, days, or weeks.

Examples:
a:2:{s:9:”time_type”;s:7:”seconds”;s:10:”time_value”;s:1:”2″;}
a:2:{s:9:”time_type”;s:7:”minutes”;s:10:”time_value”;s:1:”4″;}
a:2:{s:9:”time_type”;s:5:”hours”;s:10:”time_value”;s:1:”5″;}
a:2:{s:9:”time_type”;s:4:”days”;s:10:”time_value”;s:1:”7″;}
a:2:{s:9:”time_type”;s:5:”weeks”;s:10:”time_value”;s:1:”8″;}

Hide Quiz Time Display

Add 1 to enable the “Hide quiz time – display” option. Here, you can set whether the toggle will be enabled or disabled. To enable, enter “1”; otherwise, enter “0” or leave the cell empty.

Feedback Mode

Add the feedback mode. You can select between “Default (default)”, “Reveal (reveal)”, or “Retry (retry)”.

Attempts Allowed

Add the Restriction on the number of attempts a student is allowed to take for this quiz. Set 0 for no limit. Use it when the “retry” option is used in the “Feedback Mode” column.

Passing Grade

Set the passing percentage for this quiz.

Max Questions For Answer

This amount of questions will be available for students to answer, and the question will come randomly from all available questions belonging to a quiz. If this amount is greater than the available questions, then all questions will be available for a student to answer.

Quiz Auto Start

If you enable this option, the quiz will start automatically after the page is loaded. To enable it, set the value to 1. Here, you can set whether the toggle will be enabled or disabled. To enable, enter “1”; otherwise, enter “0” or leave the cell empty.

Question Layout View

Here you can set different question layouts. Available layouts are: 

“Set_question_layout_view”, “single_question” or empty cell, “question_pagination”, and “question_below_each_other”.

Questions Order

Here you can set the question order. 4 types of orders are available; 

• For ascending order, add “asc”
• For descending order, add “desc”
• Random, add “rand”
• Sorting, add “sorting”

Hide Question Number Overview

Show/hide the question number during the attempt. To enable it, set it to 1.

Short Answer Characters Limit

Set the character limit in which the Student will place the answer in the short answer question type.

Open-Ended Answer Characters Limit

Set the character limit in which the Student will place the answer in the Open-Ended/Essay question type.

Questions

Associated Quiz 

Add the title of the Quiz with which the quiz will be associated.

Question Title

Add the title of the question.

Question ID

Add a unique post ID for the question.

Question Description

Add the question description.

Question Type

Add the question types. The following 10 types are available to add:

• true_false
• single_choice
• multiple_choice
• open_ended
• fill_in_the_blank
• short_answer
• matching
• image_matching
• image_answering
• ordering

Question Mark

Add the points for the answer. 

Answer Required

To give the answer compulsory, set the value to 1. Here, you can set whether the toggle will be enabled or disabled. To enable, enter “1”; otherwise, enter “0” or leave the cell empty.

Randomize Question

To enable randomization, set the value to 1. Use it only for the question types “multiple_choice” and “matching, image_matching”.

Show Question Mark

You can show/ hide the question marks on the front end. To enable, set the value to 1. Here, you can set whether the toggle will be enabled or disabled. To enable, enter “1”; otherwise, enter “0” or leave the cell empty.

Question Order

Here you can set the Question order/ priority level.

Is Image Matching

Here, you can set whether the toggle will be enabled or disabled. To enable, enter “1”; otherwise, enter “0” or leave the cell empty. Use this field for the “image_matching” and “matching” question types.

Has Multiple Correct Answer

Here, you can set whether the toggle will be enabled or disabled. To enable, enter “1”; otherwise, enter “0” or leave the cell empty. Use it for the “multiple_choice” question type.

Answer Explanation

Here, you can provide the question’s answer explanation text.

Answers

Associated Question

Add the title of the Question with which the answer will be associated.

Question Type

Add the question types. The following 10 types are available to add:

• true_false
• single_choice
• multiple_choice
• open_ended
• fill_in_the_blank
• short_answer
• matching
• image_matching
• image_answering
• ordering

Answer Title

Add the title of the answer.

Correct Answers

For the correct answers, set this field to 1, otherwise set “0” for the wrong answer.

Image

If the answer has an image, then you can add its link here.

Answer Two Gap Match

In this column, add the Answers of the “Fill in the Blank” and “Matching” type Questions. Also, for the “true_false” question type, provide “true” for the correct answer and  “false” for the wrong answer.

Answer View Format

The format of the answers is set to text.

Answer Order

Easily prioritize your answers with a simple numbering system. Assign “1” to place an answer on top, and “2” to position it below the first answer.

---

FAQ’s

Does the Add-On support all question types present in TutorLMS?

Yes. The add-on supports all question types present in TutorLMS.

Which excel extension does this add-on support?

This add-on supports the .xls and .xlsx file extensions.

Can I import or export multiple quizzes at a time?

Yes, you can import and export multiple quizzes at a time using this add-on.

Where can I find the standard XLS template?

The plugin zip file includes a standard XLS template for import, located at > tutorlms-quiz-import-export > sample-import-files.

Can I add both, images and text, in the sheet for an answer?

Yes, images and text both can be added to the answer.

Can we also import/export Courses Topics and Lessons with this addon?

This add-on is specifically for import export of Quizzes. For importing and exporting Courses, Topics, and Lessons, we recommend using our TutorLMS Course Import/Export add-on.

---

Changelogs

1.1.2

• Fix: Fixed google sheet not copying issue.

1.1.1

• Fix – Fixed sheet name not showing after selecting file for import.
• Fix – Resolved security and performance issues.

1.1.0

• New – Added Google Sheet import compatibility.
• Fix – Resolved quiz import answers issue.

1.0.13

• Fix – Resolved license URL issue.

1.0.12

• Fix – Resolved security and performance issues.

1.0.11

• Fix – Resolved an issue where imported quizzes were placed at the beginning of lessons instead of their original positions.
• Tweak – Improved consistency of quiz sorting order during import.

1.0.10

• Fix – Resolved an issue where imported quiz questions were not distributed to their respective quizzes.

1.0.9

• Fix – Resolved a compatibility issue between Php Spreadsheet and PHP 7.4.

1.0.8

• Fix – Resolved import/export functionality for the “Answer Explanation” option.

1.0.7

• Fix – Resolved “Multiple Correct Answer” option is correctly imported and exported.

1.0.6

• New – Added compatibility with the latest TutorLMS course builder feature.

1.0.5

• Fix – Resolved export quiz issue.

1.0.4

• Fix – Quiz Import URL parameters issue.

1.0.3

• Fix – Resolved questions answers visibility issues.
• Fix – Resolved minor issues related to quiz import functionality.

1.0.2

• Fix – Resolved minor issues related to quiz import/export functionality.
• New – Introduced a feature to eliminate duplicate answers from the website.
• New – Implemented a selection feature in the manage export tab for associating quizzes to courses and topics.

1.0.1

• Fix – Resolved problems related to quiz import/export functionality.
• New – Updated the plugin’s user interface for a better user experience.
• New – Implemented a logging system to track activities within the addon.

1.0.0

• Initial Release.