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 10 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)
RE: AMC data from raw sqlite to excel - Added by To Cau about 1 year ago
I tried the plugin to today (version 1.5 on Linux Mint 20.3) and AMC does not start any more :
Can't locate object method "new" via package "Gtk2::Table" (perhaps you forgot to load "Gtk2::Table"?) at /home/xxxxxx/.AMC.d/plugins/rawcsv/perl/AMC/Export/register/rawcsv.pm line 55.
Do I missed something?
RE: AMC data from raw sqlite to excel - Added by Alexis Bienvenüe about 1 year ago
The plugin has not been updated for new AMC versions, and is now broken.
You can remove the
/home/xxxxxx/.AMC.d/plugins/rawcsv directory to restore AMC.