| blob | 64dbcbc814552be5b2f8ea524c9070d18115e045 |
4 It is no longer being actively developed by Course Technology. It has been replaced by
5 a new test manager called ExamView. However, there has never been a migration path to allow
6 this format to be exported from CTM test banks to any other common test format. This is why this
7 module has been written.</p>
9 <p> In order to import questions from CTM, you must have CTM installed on a Windows machine, and
10 have access to the MS Access data files on that machine. Two data files are required in order to
11 access the data files:</p>
12 <ul><li>System.mda - This file is in the top directory of your CTM installation, and is referred to
14 <li>ctm.mdb - this is the database that contains the test bank questions. There is one of these databases
15 for each course installed in CTM. It is located in a directory one level below your CTM installation
16 directory.</li>
17 </ul>
19 </p>The import process is somewhat different based on whether you're running moodle on Windows or Linux.
20 Regardless of what platform moodle is running on, you must have a Windows system (Windows 2000 or Windows XP)
21 on the same network as your moodle system in order to host the Access database while importing test banks.</p>
23 <p>The process is somewhat easier on a <b>Windows-based</b> moodle system. All you need to do to use the CTM import
24 class is:</p>
26 <ol><li>upload the system.mda system database to moodle using the file manager. It doesn't matter what course you
27 upload the system.mda file to. Moodle will find it regardless.</li>
28 <li>Crete your quiz and go into the "import questions from file" process. Upload your chosen ctm.mdb
29 database as the file to import. If you did this correctly, you will see another screen that allows you
30 to choose the sub-category of questions to import from the database. The reason this step is here is that
31 CTM test banks often contain a large number of categorised questions, based on the chapters of the book or
32 sections of the course.</li>
33 </ol>
35 <p>The process on a <b>Linux-based</b> moodle system includes a third-party software component called the
36 <a href="http://odbcsock.sourceforge.net/" target="_new"><b>ODBC Socket Server</b></a>. In order to import CTM databases on Linux, you must first download and install
37 this small network program on the Windows system that hosts your CTM databases. <b>Do not</b> follow the installation
38 steps outlined in the ODBC Socket Server Installation. They're more complicated than they need to be!
39 Instead, follow these steps to install this program on your Windows system:</p>
41 <ol><li>Go to the windows system and unzip the install file you downloaded from
43 <li>Copy the binary ODBCSocketServer.exe to a permanent location, such as your system directory
44 (probably C:\WINNT\ or C:\Windows) or your Program Files directory. </li>
48 You may do this by typing this command from Start->Run... dialog, or from a command prompt.</li>
50 <li>Open the Service Manager by either going to
51 Start->Settings->Control Panels->Administrative Tools->Services or by right-clicking on
52 <b>My Computer</b>, choosing <b>Manage</b>, then choosing <b>Services and Applications->Services</b> from
53 the right panel. You may also access the Service manager by typing <b>services.msc</b> in the Start->Run...
54 dialog</li>
56 <li>In the Service manager, right-click the ODBC Socket Server item and choose the <b>Start</b> item. It's status
57 should change to "started" when you do this. Note that you may stop and/or disable this service completely after
58 you've completed the import process.</li>
60 <li>Make sure that the system.mda and ctm.mdb access data files are on the machine,
61 and that the MS Access ODBC driver is present. It is installed in a standard Windows installation. You can
62 determine if it installed by opening the "Data Sources" item in "Administrative Tools" and referring to the "Drivers"
63 tab. You're going to have to determine where CTM is installed and locate the system.mda file and the ctm.mdb database
64 or databases you're interested in importing data from. Make note of the full local paths to these files as well
65 as the IP address or hostname of the Windows server. You're going to need this information for the import process.</li>
67 <li>Now you may import the testbank or testbanks into moodle. Crete your quiz and go into the
69 YOU MUST SPECIFY A DUMMY FILE IN THE UPLOAD FIELD TO GET THE IMPORT PROCESS STARTED. THIS FILE <b>WILL NOT</b>
70 BE PROCESSED, IT'S JUST A PLACEHOLDER FOR THE IMPORT FORM. YOU WILL GET A PLACE TO SPECIFY THE WINDOWS SERVER
71 INFORMATION NEXT. Next, you will get a screen where you can type in the hostname for the Windows ODBC Socket Server
72 machine as well as the paths to the system and testbank databases. Type in the information you wrote down from the
73 previous step here and click "Connect to Server". If everything was set up correctly, you'll get another form to allow
74 you to choose the sub-category of questions to import from the database. The reason this step is here is that
75 CTM test banks often contain a large number of categorised questions, based on the chapters of the book or
76 sections of the course. IF YOU GET TO THIS STEP WITHOUT ERROR MESSAGES, YOU HAVE SET UP THE SOCKET SERVER CORRECTLY
77 AND YOU'RE ABOUT TO IMPORT QUESTIONS TO MOODLE!</li>
78 </ol>
80 <p>If you received error messages during this process, you may find this technical information useful.
81 The ODBC Socket server uses port 9628 to open a socket and trade and XML query for an XML result table of
82 the query results. The import class parses that XML and use it just like I use a local query to do the importing.
83 </p>