This application was developed using tools that are free to the public to use, and tools that most computers either have or can run without issue. You must have the following tools installed on the host computer before installing this web application. There is no support for MySQL and don't think there is a need for it since this application is meant to run on Windows machines.

1) Internet Information Service (IIS) - Windows XP, Vista, 7, Server 2003 or greater are needed on the host machine to run this application correctly. This must be installed and running. How to install IIS on Windows XP.

2) Microsoft SQL Server - Version 2005 (Express [free], Standard or Enterprise) are recommended. Version 2000 may work, but has not been tested. Version 2008 should work fine.
Note: For SQL Express users, please be sure to turn on TCP/IP and Named Pipes connections to your database [how to]. Also your database name will be [hostname]\SQLEXPRESS if installed with default instance name.

3) You must have a database already created with a sql user with db_owner, db_reader and db_writer access. You do not need to build any tables. The install script will do this. You will need the database name, username and password to install the tables. Please keep in mind that the password is stored in clear text format. So if someone gained access to the config file they would have the database password. Please ensure the username and password are unique and only used for access to this database.

4) When installing via the script page you will need to make sure that [inet_user] or Guest has read/write/create rights to the checkin/ folder. Otherwise the script will not be able to create the config file.

This Application was developed using Internet Explorer 8. Internet Explorer 7 may work. It has not been tested. Firefox 3.x works, however it cannot print any labels as it doesn't not have Active-X support.

This application use the 3 of 9 barcode font that is installed with the Brother label printer. It has been tested to work with this application using any barcode scanner and name tags printed on a Brother QL-570.

It is recommended that this application run internally (Intranet). Currently we do not have LDAP or Windows Authenticated support.

Modification Notes:

WARNING: Since this application is released under the NPOSL 3.0 license you can modify the source code. However do not expect that any person working on this project will help you in doing so, nor are we obligated to do so. It is upon you to modify this application at your own risk.

You could in theory modify this application to work with an existing database. [tableprefix]Parents is where the parents are. So you would need to change the view vw_[tableprefix]ParentLink to have the ParentID, PFname and PLname come from your existing database.
You could in theory do the same for children.

Since the name tags are keyed from the [tableprefix]Service table, which is also linked to Attendance, it is advised to NOT change this structure since there are needed fields in [tableprefix]Service for the name tags.