AMC data from raw sqlite to excel
I guess this is more a SQL question than actual AMC question, but I would appreciate some help.
I need to convert the sqlite database to an cvs / excel file to use with a statistics program. In the spreadsheet I need each square as a column and sheet as a row. If the square is ticked the value of the cell should be 1, if not value should be 0.
Any ideas how to achieve this?
Thanks for any help!
RE: AMC data from raw sqlite to excel - Added by Alexis Bienvenüe over 7 years ago
If all questions and answers are given to all students, you can try to install the following plugin and then select the "raw-csv" export type.
rawcsv.zip - Plugin to get all boxes status in a CSV file (2.6 kB)