Installation / Setup Instruction:

Following are the step by step instructions to setup LearnDash quiz import/export Addon.

Difference between LearnDash Default Quiz Import/Export VS LearnDash Single Quiz Import/Export Addon

 S.NO Default LearnDash quiz import/export LearnDash quiz import/export addon 1 Only import/export .wpq and .xml files that are not user friendly Import/export .xls files that are more user-friendly 2 Essay question type not supported All questions types are supported including essay 3 We have to import quiz first then its questions We can import a quiz and its questions in a single import

How To Export Quiz:

When Learndash Quiz Import/Export addon is activated then new Export button shows in the quiz columns. To export the quiz we can simply click on the export button it will download the quiz in the .xls file, which we can use to import in the other website with the help of this addon.

LD Quiz Import:

This tab shows the input area for the quiz file to be imported. Select the Microsoft Excel .xls file and click on the import quiz button.

Note: Only a single sheet will be imported and sheet name will be the given quiz name. Watch the video tutorial below of How to Import Quiz

Import/Export Settings:

All the default LearnDash quiz options are present here in different sorted tabs. Any new imported quiz will adopt these quiz options settings.

Status:

This tab shows the count of imported and exported quizzes.

Plugin Options:

This tab shows the option to discard previously imported questions of the same quiz.

If we import a quiz, let’s call it Final Quiz,with questions A, B, C and D, and if we want to import more questions  E, F and G of this quiz with the Discard Old Questions in Import option as checked, after importing the questions, the old questions i.e A, B, C and D will be discarded and only new questions i.e E, F and G will remain.

If the Discard Old Questions in Import option as unchecked, then all questions will be there in the quiz i.e A, B, C, D, E, F and G.

Quiz Title:

There are two options for the setting a quiz title

Sheet name:

Enabling this option will set the excel sheet name as the quiz title.

File name:

Enabling this option will set the excel file name as the quiz title.

How to Import Quiz:

Latex Text:

Added the latex text support for math equations in LearnDash quiz questions.

There are three steps to use latex in your learndash quiz.

1. Install the free MathJax LaTeX plugin
3. Create a quiz with latex text

This format should be needed to use the latex text $E=mc^2$

Note: Follow this article Using LaTeX in LearnDash to use the latex text in learndash quiz questions.

LearnDash Quiz Import/Export Template Guide

LearnDash Quiz Import/Export uses a standard template to import and export all LearnDash question types. This template should be followed in order to create your own templates for import/export. The standard template can be found in the plugin folder:

LearnDash-quiz-import-export > Documentation > Standard Template

The template contains the standard LearnDash question field names as columns names

.It contains the following columns which would translate to LearnDash quiz questions:

1. Question Type

The column represents the type of LearnDash question. This column can have the following values corresponding to the LearnDash question types.

Single                         =>        Single choice

Multiple                       =>        Multiple choice

cloze_answer             =>         Fill in the blank

essay                           =>         Essay / Open Answer

2. Category

The column should contain the value for the LearnDash question category field.

3. Title

This represents the question title for a LearnDash quiz question.

4. Total Points

The column represents total points for each answer. It can be left empty for all question types except the essay type questions. For all other question types, the total points are calculated from their individual answers. This column is only significant for essay type questions since it is used to assign points to each essay question.

5. Different Points for each answer

It should be set to yes if you need to set different points for each answer and no If you want to set a standard point for all answers.

6. Question Text

This column would fill up the question text area field for the question.

In LearnDash, there is an option to add media to the answers for some question types. If you want to display your answer with image and text then set the value as html for this column else set the value as text.

Note: If we select the value as html on matrix sorting question, then it will apply on both fields i.e element and criterion.

8. Answer # and Point # Columns

These columns should be set according to the maximum number of answers

present in any of the questions for the particular quiz import.

If a quiz contains 13 answers for a particular question inside it, there should be 13 columns in the template.

From:

Point 1 – Point 13

This column will contain all the answers which are available for a question. If a question has less number of answers than the maximum answer # column, then simply leave that column as empty. The point # column associates points with each answer (If different points for each answer is enabled).

Note:

1. For a matrix sort answer, the value inside these answer columns should be in

this format {criterion}{element}

2. To put an image as an answer, the value inside these answer columns should be

in this format [image_url]

After the individual answer and points column, there is again a column named Answer. This column serves multiple purposes.

Single choice

→ For a single choice answer, it represents the correct answer from all the choices.

Multiple choices

→ For a multiple choice answer, It represents the correct answer(s) from all the choices. The pattern to indicate the correct choice is as follow:

The pipe (|) sign is used to indicate the answer number and if the answer is not correct there is no value between the pipes. For the correct answer, answer # should be entered.

For.eg :

||2||4||6 → This indicates that answer # 2,4 and 6 are correct for this multiple choice question and answer # 1,3 and 5 are not correct.

Free choice

→ For a free choice answer, it represents the single answer for this question type, as there can only be one answer. The answers can, however, be separated through line break. To add multiple answers for a free choice using this column, you need to add line breaks in the cell for this column.

For.eg:

value1

value2

value3

(To add a line break in excel file use ALT + Enter to selected column cell)

Assessment

→ For an assessment answer, It represents the values for the single answer for this question type. The answer should be in the following format:

{[ans1][ans2][ans3]}

Fill In the Blank

→ For a close (fill in the blanks) answer, it represents value for the single answer for this question type. The answer should be in the following format:

This is a sample {cloze|5} question and It represents a sample cloze {type} question.

Note: A blank answer should be enclosed in {} and to enable separate points for each blank answer, the point has to be added after the pipe (|). If there is no separate point for each blank then there is no need to add the pipe (|) symbol.

Essay

→ For an essay answer, it represents the answer submit method and the grading criteria. The following combination of values can be added to set the above values for this answer type.

Text submit, not graded and full points

Text submit, graded and full points

Text submit, not graded and no points

This corresponds to the total number of answer columns in the sheet. Set this column value according to the maximum number of answers present in the sheet.

11. Message with the correct answer

This text will be visible if a question is answered correctly. It can be used as an explanation for complex questions.

12. Message with the incorrect answer

This text will be visible if a question is answered incorrectly. It can be used as an explanation for complex questions.

13. Hint

Here you can enter solution hint, for the answer.