AMC data from raw sqlite to excel

Added by Juuso Tamminen over 11 years ago

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!

Juuso


Replies (3)

RE: AMC data from raw sqlite to excel - Added by Alexis Bienvenüe over 11 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 2 years 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 2 years 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.

(1-3/3)