Simple XLSX Import Limit to Only Five Possible Answers

  • Resolved xyzBrian123

    (@xyzbrian123)


    1 year, 7 months ago

    When importing questions of the Radio type using the Simple XLSX format, the number of possible answers seems to be limited to only five (one correct answer and four incorrect answers).

    I’ve tried adding additional columns titled “Answer 5”, “Answer 6”, etc., to the import spreadsheet.

    And I’ve also tried increasing the “Answer default count” in the “Default parameters for Quiz” section under “General Settings”.

    Both of those attempts did not work, and only five possible answers are still displayed in the quiz.

    Some of my questions have six, seven, or eight possible answers. Is it possible to use the Simple XLSX format to import questions with that many possible answers? And how do I do that?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Jasmine

    (@hyenokian)

    1 year, 7 months ago

    Dear @xyzbrian123,

    Thank you for the topic. 

    We have tested the case with the latest version of the plugin and noticed that everything works correctly with the import feature on our end. 
    We have added 4 more answers (8 answers overall) and all of them were normally exported.

    I want to mention, that there is no need to change the Answer default count.
    Please let us know whether you have ticked the checkbox for the Simple XLSX when importing or not. 
    If not, please tick it and check the case again.

    See the screenshot: https://ibb.co/mvYqztN

    By the way, as you are currently using the Pro version of the plugin, please contact us via this form for premium support. Our customer care specialists are ready to provide you with the solution as soon as possible. 

    Commercial products are not supported in these forums.

    Thank you.

    • This reply was modified 1 year, 7 months ago by Jasmine.
    Thread Starter xyzBrian123

    (@xyzbrian123)

    1 year, 7 months ago

    I have it now. I made a mistake by assuming that the answers I put in the column titled “Correct Answer” will be imported along with answers that I put in the columns titled “Answer 1”, “Answer 2”, etc.

    But that’s not how it works. The correct answer must be in two columns. It needs to be in the column titled “Correct Answer” to designate it as such, and it also needs to be in one of the columns titled “Answer 1”, “Answer 2”, etc. to be imported.

    Plugin Support Jasmine

    (@hyenokian)

    1 year, 7 months ago

    Dear @xyzbrian123,

    Thank you for your response.

    Please let me explain this.

    Please check out the screenshots below to see the answer options for the questions.

    The following part is the Index of the Correct Answers.

    Each row/line belongs to one question.
    You can find the answers to the particular question in one row.

    Let’s concentrate on the concrete example so that everything can be clear for you.
    You need to write the number of the correct answer, that is which one is the correct one.

    See the screenshot below:

    So, for the first question (5*40), the correct answer is 200, right?
    The answer option 200 has Index 3. So, you need to write 3 under the Correct Answers column.
    By this, the system can understand that the 3rd answer option is the correct one.

    By the way, as you are a Pro user, please contact us via this form for premium support. Our customer care specialists will always be happy to help you.

    Commercial products are not supported in these forums.

    Thank you.

    Thread Starter xyzBrian123

    (@xyzbrian123)

    1 year, 7 months ago

    Thank you for taking the time to explain that last detail to me. I fully have it now. I like the plugin and the support is great.

    Plugin Support Jasmine

    (@hyenokian)

    1 year, 7 months ago

    Dear @xyzbrian123,

    Thank you for your response and kind attitude.
    Glad to hear that our guide was of help to you.

    If your query is resolved please take a moment to rate and review the plugin or support.

    Thank you.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Simple XLSX Import Limit to Only Five Possible Answers’ is closed to new replies.