Import Questions and create quiz from excel into DB

[ravisingh1704]

hi team, Can you please answer below questions as we want to import questions from an excel sheet which has below column

1. EXAM NAME

2. QUESTION

3. OPTION A

4. OPTION B

5. OPTION C

6. RIGHT ANSWER

  Can you please answer below

1. How do we import about 11,000 questions from excel sheet having 60 exams (column A)?

2. If not from front end, in which all tables do i need to insert values for creating questions? any table referances/dependencies?

3. How to create multiple quiz using these questions as exam name is present in COLUMN A of excel sheet?

4. In which field/database table, correct answer need to be uploaded?

5. Any other dependencies to be taken care of?

[H.K. Latiyan]

Hi, Importing 11000 questions at once is not possible, it will put load on your server and it may crash. We have an import export feature in wplms which you can refer here: https://wplms.io/support/knowledge-base/bulk-importexport-wplms-via-csv/ Particularly for importing bulk questions, please refer : https://wplms.io/support/knowledge-base/import-bulk-questions-via-csv-file/

[ravisingh1704]

This reply has been marked as private.

[H.K. Latiyan]

This reply has been marked as private.

[ravisingh1704]

This reply has been marked as private.

[H.K. Latiyan]

This reply has been marked as private.

[Author]

Posts