Installation Instructions

RoboTutor 10 with an SQL database can take as little as 20 minutes to install and requires no special programming skills. The application must be installed on a WEB SERVER with WINDOWS NT, 2000, XP, or Vista as the operating system. For the email, you will need to have CDONTS or ASPmail.  And for the database, you need access to a server with Microsoft SQL Server software installed.

Notice: The software on this CD is Copyright Protected 2010 by RoboTutor Software. All rights reserved. You are authorized to install it on only once on 1 computer, whether that be a regular PC or a server. For additional installation rights or help, email: Support@RoboTutor.com.

Setup RoboTutor Files:

RoboTutor10: This folder contains all RoboTutor application files, help files, and graphics.

Setup your SQL Database:

Step 1.   Open Microsoft SQL Server Enterprise Manager.

  1. Expand SQL Server Group
  2. Right click on the name of your server and select Properties
    • Click on the Security Tab and under Authentication, select SQL Server and Windows.
    • Click OK.

Step 2.   Create a new database:

  1. Expand a server group, and then expand a server.
  2. Right-click Databases, and then click New Database.
  3. Enter a name for the new database. (For example: RoboTutor10)
  4. Click Data Files tab.
    • Select Automatically grow file. (To allow the file to grow as much as necessary)
    • Select Unrestricted file growth. (To allow the file to grow as much as necessary)
  5. Click Transaction Log tab
    • Select Automatically grow file. (To allow the file to grow as much as necessary)
    • Select Unrestricted file growth. (To allow the file to grow as much as necessary)
  6. Click OK button.

Step 3.   Create a new SQL Server Login:

  1. Expand a server group, and then expand a server.
  2. Expand Security, right-click Logins, and then click New Login.
    • In Name, enter a name for the Microsoft® SQL Server™ login. (For example: RT10)
    • Under Authentication, select SQL Server Authentication.
    • In Password, enter a password. (For example Pass10)
    • In Database, click the default database to which the login is connected (RoboTutor10) after logging into an instance of SQL Server.
  3. Click Database Access tab.
    • Check RoboTutor10 in the Permit column.
    • Check db_owner in the Remit in Database Role column.
  4. Click Ok button.
    • Confirm new password (Pass10) and click Ok button.

Step 4.    Change the database.asp file:

  1. From the RoboTutor10 folder, open database.asp in Notepad or any HTML editor.

    • On line 11 under the the function GetDBConnection(), you will see the following:

      con.ConnectionString = "PROVIDER=SQLOLEDB;NETWORK LIBRARY=DBMSSOCN;DATA SOURCE=server1;USER ID=RT10;PASSWORD=Pass10;DATABASE=RoboTutor10"
       
  2. Replace the 4 items shown in blue above:
    • DATA SOURCE =   IP address or server name
    • USER ID = new login name
    • PASSWORD = new login
    • DATABASE = new database name

Step 5.    To create the tables in the SQL database, run the Start page:

  1. Copy Start.asp and Start.sql from the Installation folder to the main RoboTutor10 folder.
    • Note, if you assigned a name to the folder other than Robotutor10, open Start.asp in Notepad and change "RoboTutor10" to the new name of the folder.
  2. Open your browser and type: http://localhost/RoboTutor10/start.asp
  3. After a couple of seconds, it should come back and say the following:
        Building SQL Database
        Success
        All tables have been successfully created.
  4. Delete Start.asp and Start.sql from the main RoboTutor10 folder, but do not delete them from the Installation folder.

Step 6.    Check to see if the database is SETUP properly:

  1. Open Microsoft SQL Server Enterprise Manager.
  2. Expand a Server Group, and then expand Server.
  3. Expand RoboTutor. Left click Tables.
    • Approximately two dozen table names should be displayed.
  4. Right click the Access table. Select Open Table/Select all rows.
    •  Access table is displayed with Anonymous user name and RoboTutor user password in it.
  5. Close the table.

After following the above steps, you can test the SQL version to see if it is WORKING properly:

  1. To start RoboTutor, open your browser and enter on the command line:
    http://localhost/RoboTutor10/Default.asp
    • If you get an error message, see Error Messages below.
  2. To initially setup users, enter the following:
    • User Name: Administrator
    • Password: RoboTutor
  3. Click the System Administration button to change the default password and setup other users.
  4. Once other users are setup, click the Navigate button to see how your users are organized and switch (log-in) to any of them.

Installation Using 2 Servers:

RoboTutor is often installed on a server other than the one on which the SQL database is located. The server on which you install RoboTutor must be setup properly to link to the SQL server.

  • To check to see if you are setup properly, go to Documents Control > Administrative Tools, then
  • Go to ODBC Data Source Administrator , click the System DSN tab, and see if SQL Server is listed.
  • If not, click Add, then select SQL Server and click Finish.
    • If SQL Server is not listed there, you can download it from Microsoft.
    • Download "Microsoft Data Access Components (MDAC) 2.7 Refresh"
  • Select "Windows NT Authentication using the network login ID" and check "Connect to SQL Server to obtain default settings". Click Next.
  • Select "RoboTutor" as the default database if that is the name you gave the SQL database. Click Next.
  • On the next screen select what values fit your application and click Finish.
  • On the test screen, click the "Test Data Source" button.

ERROR MESSAGES:

  1. If the RoboTutor home page displays code when you bring it up in your browser, then the ASP is not setup to run properly. See Start > Programs > Administrative Tools > Internet Services Manager and make sure that ASP is turned on.
     
  2. If you have Java related errors, open your browser, select Tools > Internet Options > Advanced and make sure the JIT compiler for virtual machine is enable.
     
  3. If your animations don't play, open your browser, select Tools > Internet Options > Advanced and make sure under Multimedia the Play Animations in web pages is checked, Play Sounds in web pages is check, and Play Videos in web pages is check.
     
  4. If you get errors when running the games, check the following IIS setup:
    • Go to Administrative Tools > Internet Information Services > Web Sites
    • Right click Properties
    • On the Virtual Directory tab, click the Configuration button
    • On the Application Configuration page, check the "Enable parent paths" box
       
  5. If you get an SQL Database Configuration Relationship error: Right click the "Tests" table and select "Design Table". When it opens, put the cursor on "Column Name," right click and select "Relationships." At the bottom, "Cascade Update Related Fields," and "Cascade Delete Related Fields" should be checked. If these fields are unchecked, then check them.
    • Do the same for the following tables: Answers1_3, Answers4_6, Category, Game_Player, Game_Temp_Category_Weight, Game_Temp_Questions, Game_Temp_Tests, Identification_Code, Questions, Students, Temp_Category_Weight, Temp_Questions, Temp_Tests.
       
  6. If you get an error message that says it cannot connect to the database. The problem may be improper SQL Server Network Utility settings: To check it:
    1. Go to Start > All Programs > Microsoft SQL Server > Server Network Utility
      Check if TCP/IP protocol is enabled
      • If it is, then select it, click Properties... , set 1433 in the Default port, and click OK. Click OK.
      • If it is not, then select TCP/IP from the Disabled protocols list and click Enable>> button. TCP/IP should appear in the Enabled protocols list. Select it, click Properties... , set 1433 in the Default port, and click OK. Click OK.
      • If this still does not resolve the connection problem, copy the files in the SQL folder under Installation to the SQL server and follow the instructions included.
    2. Check Connection: From the web server, do the following test:
      1. Go to Settings > Control Panel
      2. Click on Administrative Tools
      3. Click Data Sources
      4. Click the System DSN tab
      5. Click the Add button
      6. Scroll to bottom and select SQL Server
      7. Enter any name (it doesn't matter for this test)
      8. Click the down arrow by Server and locate the server name or type it in the field. This should be the same name as your "Data Source" in RoboTutor (Database.asp). Click Next.
      9. Click the "With SQL server authentication..." and enter your LogIn Id and Password. These should be the same as the User ID (RT) and Password (Pass1) fields from the connection string in database.asp. Click Next.
      10. Click Next, then Next again, then Finish.
      11. Click the Test Data Source button

      12. It should come back and say the following:

        Microsoft SQL Server ODBC Driver…  
        Running connectivity tests...
        Attempting connection
        Connection established
        Verifying option settings
        Disconnecting from server
        TESTS COMPLETED SUCCESSFULLY!

        Note, If it does not comes back with the message shown above, then there is a problem connecting to the SQL server. Look at the error message and make the necessary corrections.

  1. If you get an error that says: "The '..' Characters Are Not Allowed.."
    1. Open IIS Manager, right click and choose properties on your [SITE_NAME] virtual directory (or the website root if [SITE_NAME] is installed at the root.
    2. Click the Home Directory or Virtual Directory tab and choose the 'Configuration' button on that tab.
    3. Click the Options tab and make sure the "Enable parent paths" setting is enabled.
       
  2. Why does RoboTutor log me out within a few seconds after logging in?

    Windows 2003 Server has the ability to use multiple processes to handle the web requests, when this is turned on regular ASP sessions no longer function properly, according to microsoft the fix is to use ASP.net persistent sessions, or turn off the extra processes (which is what I did). This setting is set in the Application Pool section of the IIS admin - right click the app pool - probably DefaultAppPool and choose properties, the settings for this are under Performance and called web garden.

    Limiting Connections and Setting Connection Timeout:

    Limiting connections is a way to conserve bandwidth for other uses, such as e-mail or news servers, or for another Web site running on the same installation. All connection attempts beyond the connection limit are rejected. When a browser stops working unexpectedly or a connection is lost in midstream, the site continues to process data until the timeout value is reached. Setting a timeout value reduces loss of processing resources for broken connections. 

    To decide whether to limit connections: 

    Use System Monitor to log the Current Connections, Maximum Connections, and Total Connection Attempts counters in at least the Web Service and FTP Service objects. Continue logging until you have a good sense of the normal range; typically, this can take several days, to a week, or more.  

    To limit the number of connections:

    In the Internet Information Services snap-in, select the Web site and click the Properties button to display its property sheets. On the Web Site property sheet, select the Limited to option. Type the maximum number of simultaneous connections you want to allow in the Maximum Connections box. Note: The Unlimited option permits as many simultaneous connections as your bandwidth and processor can support. Type the connection timeout value in seconds in the Connection Timeout box.  

    Related Topics:

    For more information on capacity issues, see About Capacity Planning.
    For information on how to throttle bandwidth, which is another way to limit connections to your Web server, see Throttling Bandwidth.
    For information on setting the CGI timeout, see Caching Applications.
    For a list of counters provided by IIS, see Counters Reference.
    For a list of all timeout values that can be set by IIS, see Timeouts Reference

You still need to set email defaults . This is very important and if you don't set them properly, the program will not work properly:

Setting Special "Write" Permissions:

There is an option in RoboTutor 10 to import graphics and other files and save them in any of the following folders under RoboTutor 10: courses, images & rtdb9/tests.

Permissions for these folders must include "write".  To set them, right click on the folder and select Properties > Security. Then check the "Write" box for the appropriate users of the application.

Resetting the Session Variable Timer:

RoboTutor uses Session Variables to keep track of data. The default on most servers is 20 minutes. If you walk away from your computer for more than 20 minutes, when you come back, you may need to log in again. This does not effect students who take tests. We recommend you reset the session variable to 180 minutes. It puts little demand on server memory because it is only for administrators who log-in and therefore controls few variables. 
 
  1. From the Start menu, select Administrative Tools
  2. Select IIS
  3. Select the server name
  4. Select the folder
  5. Right click and select Properties
  6. Select the Virtual Directory tab
  7. Click the Configuration button
  8. Select the Option Tab
  9. Set the timeout to 180 minutes

Setup Export and Import from Access databases:

Domain Name:

RoboTutor assumes the Domain Name points to the level ABOVE the /RoboTutor10 folder. For example, if the domain name is http://www.robotutor.com/ then the link to RoboTutor10 should be: http://www.robotutor.com/robotutor10/.

Setup to send Email:

You can change Default Labels used in the program. By default, for example, RoboTutor uses "Students", "Password", and "Certification". You may want to change them to "Employees", "Payroll #" , and "Courses".

Log-In Defaults and Passwords:

Default Settings:

Change the parts in blue to the default you want. Be sure and use the same case and do not make them plural. That is automatically done in the program by adding an "s" where appropriate. Save the changes. The changes will apply throughout the program.

Format:
Set tMode=1 to put RT logo left, RT banner top, user logo in box left & user title box right
Set tMode=2 to put USER LOGOo left, USER TITLE & USER ROTATING PICTURES
Set tMode=3 to put RT logo left, RT banner top & RT rotating pictures.
Set tMode=4 to put USER LOGO left, USER BANNER & USER ROTATING PICTURES
Set tMode=5 to put RT logo left, user title top & USER ROTATING PICTURES
tMode=3

LOGO: s
hould not be larger than 100x100 px. Used only with modes 2 & 4. Set width <= 80px
tLogo="images/MyLogo.gif"

USER BANNER:
this is used with only with mode=4. Set to size 385 by 48px
tUserBanner="images/MyBanner.jpg"

USER TITLE:
used only with mode=2. To break into lines, insert <br>
tTitle="RoboTutor"

TITLE FONT:
set the size (4 to 7). Used only with mode=2
tFontSize="6"

FACE:
(Arial, Verdana, Times New Roman, etc.). Used only with mode=2
tFontFace="Arial"

BACKGROUND
of the tables (dark blue or #000080), darkgreen or #004F00, dark red or #790000, etc.) This is only an option if the MODE above is set for 2 or 5
tBkC="#000080"

ANIMATION / LOGO
to display when logging in to take a test
tAnimation="media/eyetronics.gif"

Add links to pictures in default_menu_pictures.asp

Setup Special Features:

RoboTutor 10 comes with the following optional special features:

  1. PayPal and Access Code: This enhancement is located in the /AccessCodes subfolder and provides sample code so students can purchase courses using PayPal, which then notifies RoboTutor when payment is accepted so an Access Code can be generated and sent via email to the student and to the administrator.
  2. Access Customer Information: This enhancement is located in the /AccessCustomerInfo subfolder and provides code so additional customer information such as mail address, etc. can be collected after students pass tests. This is then used to send out printed certificates, etc. 
  3. Access HR Database: This enhancement is located in the /AccessHRDatabase subfolder. It provides sample code so students when students log-in their passwords search the human resource database and automatically brings up the name.
  4. Training and Tutorials: This enhancement is located in the /presentation subfolder. It provides RoboTutor PowerPoint training modules in 3 formats with links to test questions at the end.
  5. Venture Game: This enhancement is located in the /VentureGame subfolder and lets teachers present various tests to students in a game format very similar to Jeopardy.

Knowledge of ASP and HTML coding is necessary to implement these options. Technical support is also available from RoboTutor to implement them and make any other custom changes to the application.

Setup Optical Mark Reader:

RoboTutor 10 can be optionally setup to use an optical mark reader to scan in student answers from tests. Underneath the main RoboTutor10 folder, there are two folders that have been created solely for this feature:

  1. RoboScan: It has the application. You don't need to do anything here
  2. WCF: This one is the Web Service needed to make the RoboScan application run. To make it work YOU NEED TO:
    1. Convert it to a Virtual Directory
    2. Configure it as an Application
    3. Set ASP.net settings for 2.0
    4. Install Dot Net 3.5 SP1 on your web server. You can download it free from Microsoft.

Notes for System Administrators:

Security:

Changing the Path to the Databases:

' Test Area location
const cTestLocation="rtdb9/tests/"

' Test Area location
const cStudentLocation="rtdb9/students/"

' Export Area location
const cExportLocation="rtdb9/tests/"

Changing default System Test Settings:

  1. max number of sub-options for any question
    Const maxNumberOption=10
  2. max number of questions can that be displayed on the screen at one time
    Const maxQuestionPageSize=30
  3. default page size
    Const defaultQuestionPageSize=30

SQL Database Settings:


Answers to Common Questions:

  1. Version 10 of RoboTutor will run on ANY computer with Windows 2000+, Window XP, or NT installed on it. It must also have the web server option installed that come on the CD with the operating system.
     
  2. The server can be a stand-alone PC, connected to the intranet, or on the world wide web.
     
  3. There are no required links to the RoboTutor site in order for it to work. It is completely self-contained.
     
  4. There is no Perl  or CGI scripts used. Instead, it uses HTML, ASP, Visual Basic, and JavaScript.
     
  5. It will work on both Macs and PCs, but not all browsers. Some older versions of Netscape and IE do not support special features the program uses. We recommend Version 6+ of both browsers. To get optimum viewing, use IE 6.0 or higher.

Notes for Instructors:

Browsers:

Operating Systems:

Display Settings:


If all of this went smoothly and the program is installed, you can start creating tests. If you experienced problems and cannot resolve them with the above instructions, please email Support@RoboTutor.com or call: 801-750-2722  and we will help you fix the problems.

Copyright 1998-2011 ROBOTUTOR - www.RoboTutor.com
ROBOTUTOR is a trademark of CAPE Associates, Inc.