ATutor

Learning Management Tools


  1. Home



Pages:1 2 3 4 5 6 7 8 9 10 11 12 13 14 15


Tests surveys



  • 2007-06-07 20:43:00

    Tests surveys

    I have a situation where a course had been restored from a full back- up. The quiz php number change, so now I can not find the previous test results submissions from users.

    Is there a way to recover to the previous test user data or link the new course to the previous test old user data?






    Things to describe:
    operating system - windows
    version of ATutor - 1.54
    versions of php - compatible
    version of mysq l -compatible
    webserver & version -
    copies of error messages -
    changes to default settings -
    web browser being used -
    and anything else relevant -


  • 2007-06-08 08:16:41

    Re: Tests @ surveys

    Backups contain only the content of a course, not any data generated in the course. You will need to go back to the old version and if you want to save test results.


  • 2007-06-08 12:33:09

    Re: Tests @ surveys

    Thanks so much for your response.

    Do you mean the old version ATutor or the course, as we restored the course to an older version that does not link and only contains the content not the old test results.

    Would there be a way to recover the previous test results data from mysql or somewhere?



    Things to describe:
    operating system -windows

    version of ATutor -1.54
    versions of php -compatible

    version of mysq l -compatible

    webserver & version -
    copies of error messages -
    changes to default settings -
    web browser being used -
    and anything else relevant -


  • 2007-06-11 11:04:35

    Re: Tests @ surveys

    Backups do not contain results.

    I would imagine the data is still in the database. If you know your way around mysql, you could probably dump out the data. Or you could go back to the old version of ATutor and use the tools in the test manager to dump data.


  • 2007-06-11 14:28:01

    Re: Tests @ surveys

    Hi Greg: I have no idea how I pay you back, other then a BIG Thank You.

    I do not have access to the database for legal reasons, so I have to pay a company to look for me. My first guess is to search by test ID # (I believe test id was php number 14 or 15).

    Before spending the time to search for the test data I would like to know how you would start to search for the test data from mysql?

    I could use as much direction as you could possibly give me to locate this data, as I am under the microscope for this painful back-up mistake and I could soon be restored by someone else...

    Thanks

    Bill


  • 2007-06-11 20:00:16

    Re: Tests @ surveys

    Perhaps it might be easier if you ask your provider to temporarily point ATutor to the old database. You can do this by changing a few values in include/config.inc.php. Its fairly self explanatory.

    You can also study the file that generates the test data dump at:
    http://atutorsvn.atrc.utoronto.ca/repos/atutor/trunk/docs/tools/tests/results_all_csv.php

    In particular look at the $sql = statements for the SQL you'll need to query the database, if you're going to write a script.


  • 2007-06-12 12:25:30

    Re: Tests @ surveys

    Hi Greg:

    Thanks for all your help in finding the lost data.

    Bill