SAM V2

From AMACWiki
Revision as of 14:03, 8 October 2008 by Gwolfe (Talk | contribs)

Jump to: navigation, search

Student Accommodations Manager Version 2 (SAM V2)

The Student Accommodations Manager Version 2 (SAM V2) is an easy-to-use database software that helps postsecondary Disability Service Providers manage student data, accommodaitons, exams, forms, letters, reports, and more.


Log in to the SAM V2 Demo


SAM V2 allows disability service providers to manage and report on:

Getting Started

  • The Disability Service Provider needs to identify a campus Information Technology (IT) Professional who will oversee the installation of SAM V2 and manage persmissions and implementation

Architecture and Features

SAM V2 is functionally similar to SAM V1 in terms of data tracking, but differs in terms of architecture, user interface, and reporting. While SAM V1 follows a software as a service model, SAM V2 requires that the software be installed on computers owned and managed by the user. Please review the SAM descriptions and pricing document for a comparison between SAM V1 and SAM V2.

SAM V2 was developed using the leading open source solutions of PHP and MySQL. For an overview of PHP and MySQL and why these products where used, see Why PHP and MySQL.

Other features of SAM V2 include:

  • Web-based
  • Accessible
  • Custom, printable reporting
  • Access control via logins
  • Data encryption
  • Data export

Knowledge of SQL is required to create custom reports using the SAM V2 interface. Additionally, SQL can be used to import or manipulate data.

Terminology

SAM V2 is a relational database application, and as such, an understanding of the following database terms and concepts is essential:

Access

Demo

Log in to the SAM V2 Demo.

Login and Password

Access to SAM V2 requires a login and password. Users are provided with their own login and password that are maintained by the application administrator within the SAM V2 application.

Multiple logins with the same login are allowed.

Passwords are case sensitive.

Permissions

Within SAM V2, permissions are setup per user for each table. It is possible to control if the user can add, edit, delete, or view records within the table. There is no field or record level permission in SAM V2, so if a user can view a table, they can view all records and all fields within the table.

Tables

SAM V2 is comprised of the following tables:

For each table, records can be added, edited, deleted, or viewed, depending on the user’s permission. To view table descriptions, relationships, process flows, and detailed field information, click on a table name listed above.

Installation

The installation of SAM V2 is peformed by the customer.

SAM V2 requires the customer to have a web server with PHP installed. The PHP installation must also have the MySQL extension installed. MySQL should also be installed, either on the web server or another computer that can communicate with the web server. For information on installing Apache, PHP, and MySQL, read this recommended PHP MySQL Tutorial.

Once the above software is installed and configured, SAM V2 is installed as follows:

  1. Create the MySQL sam database using the sam_shema.sql script. Typically this database is created by running the following MySQL command: mysql -u root -p[root password] < sam_schema.sql.
  2. Create a MySQL user and grant all schema privleges for the sam database to this user. Typically, the easiest way to do this is to use the MySQL Administrator logged in as root.
  3. Install the SAM V2 PHP source code onto the web server by unzipping and extracting the samv2.zip file. Be sure to extract the files to the location you intend to use as the URL. If your web server address is 128.192.60.163 and you extract samv2.zip to the projects directory, then your SAM V2 software URL will be 128.192.60.163/projects/samv2.
  4. Modify the following programs:
    • dbconnect.php - Change the MySQL connection parameters to be IP address of the machine running your MySQL database, the port number (typically 3306), and the username and password you setup in step 2.
    • header.php - Change the $institution variable to be the name of your institution.
    • index.php - Change the $institution variable to be the name of your institution.
    • notification.php and notification2.php - Change the name of the institution and address lines to be accurate for your institution.
  5. Place a JPEG image file of your institution logo in the samv2 directory on the web server. The file name should be logo.jpg. The logo image should be approximately 180 by 180 pixels.
  6. Log into the SAM V2 application as the administrator. Before any users can access the application, you must define users and permissions. Tools to create users and configure permissions are located under the Administration menu.

Implementation

The customer is reponsible for configuring the SAM V2 application once it is installed. Configuration is peformed by adding or modifying records in the database located under the Administration menu.

To help with implementation, AMAC has provided a SAM V2 implementation guide. This Microsoft Word document helps the customer identify:

  • The users who will have access
  • The user permissions
  • The multiple-choice field values
  • The list of available accommodations

Licensing

Pricing, Services, and Technical Support

Initial Application Fee and Training

One Payment of $950, AMAC Members $750 (Reduced)

  • Source code for the SAM V2 application and database.
  • Access to the SAM V2 online application documentation.
  • One phone training and one follow-up phone training within 14 days of the purchase. Training may be conducted via web conferencing based on the user(s) needs.
Hosting/User Fees

None

  • PHP and SAM V2 PHP source code are installed on web server owned and managed by institution.
  • MySQL and SAM V2 MySQL database are installed on server owned and managed by institution.
  • PHP and MySQL are open source.
Support Fee

$500/year

  • Estimated ten hours of support per month.
  • Covers application questions and assistance with report creation.
Customization Fee

$125/hour

  • Covers application customization, import of legacy data, and integration with external systems (i.e. Banner).
On-Site Customer Training

$1,200/day plus travel costs