Miscellaneous

Where are previous answers stored?

Where are previous answers stored?

by Stephen Corwin -
Number of replies: 2
Hi--

I'm trying to automate something, and I'd like to export all previous answers (for everybody, for everything in a particular course). They don't seem to be in the DB that holds most course information (the one exported by wwdb); is there a way to get them into a file?

Thanks,

Steve
In reply to Stephen Corwin

Re: Where are previous answers stored?

by Michael Gage -
They are stored in the table: mycourseName_past_answer


and


I suspect that wwdb which is quite an old script is not exporting that table (which was only added two or three years ago). You can use the mysql client to get a complete readout of all of the tables associated with the course.