Converting from Excel spreadsheet exported from Bilda to Canvas quiz

I have written a program that can take a question bank exported from PING PONG as a spreadsheet and insert the questions into Canvas a quiz questions. This is done as shown below:

./
    

Download insert_quiz_from_spreadsheet.py 11 questionbanks_KH1121.xlsx

Optionally you can give another argument to the command line (as the final argument) to specify a particular quiz_id (so that you can add questions to a particular quiz).

Thus far this has only be tested with 301 questions from the course KH1121 (thanks to Kaye Stern for providing the spreadsheet).

It does not automatically create question banks and set up a quiz with selected questions from the question bank using question groups. This remains to be done.

Should any one have any improvements to this program please let me know.

To run the program you need to make a config.json file as described at Making a config.json file to make life simpler .

Some corrections on 2018.04. from Magnus Våge <magnus@fourmation.se>:

I have found a few issues that I have corrected, and you said you wanted to know, so now I’m letting you know :)

Issue 1:

At first, I got a KeyError: ‘c3’ on line 712 where you check if a row is blank:
if (pd.isnull(row['c1']) and (pd.isnull(row['c2'])) and (pd.isnull(row['c3']))):

The xls file I got from PingPong (not xlsx as in your example) only contains two columns, so I simply modified the line to only check those columns:

if (pd.isnull(row['c1']) and pd.isnull(row['c2’])):

Issue 2:

When processing multiple choice questions, incorrect answers were incorrectly given a 100 answer_weight when it should have been given a 0 answer_weight (line 882):

current_choice={'answer_comments': '', 'answer_weight': 100, 'answer_text': clean_text(df.get_value(question_index+last_offset+2+choice, 'c2')) }

Corrected it by simply changing 100 to 0:

current_choice={'answer_comments': '', 'answer_weight': 0, 'answer_text': clean_text(df.get_value(question_index+last_offset+2+choice, 'c2')) }