CGI Setup
Contents
Setting up CGI Services for CrossRoad
This is a brief overview of the setup for CGI services for CrossRoad, including Services for Students, Services for Faculty, and Electronic Applications.
General process
- Setup underlying OS. This can be Windows 2000, or 2003.
- Install Apache.
- Apache runs under a particular Win2K user. Ensure that this user can:
- Connect to the network which has the Advantage Database Server on it
- Can see the folders which hold the data for CrossRoad
- Has appropriate rights to the cgi-bin folder under Apache.
- Install a certificate and change apache’s settings to enable SSL. All of CrossRoad’s CGI processes expect https: calls.
- Use the CGISetup.exe to install the various CGI programs, images and javascript files.
- In the cgi-bin folder add a text file called webini.txt. The contents of that should be a UNC path to the folder that holds the current CrossRoad databases.
- In the current data folder ensure that three data tables and associated support files exist: webini.dbf, relfile.dbf (relfile.ntx), and htmlfile.dbf (htmlfile.dbt, htmlfile.ntx).
- Correctly populate webini.dbf. It uses only record numbers to refer to data, and these are outlined below. Note that this is probably best edited with the DBU utility.
- Correctly populate relfile.dbf. Relfile grants access to many different aspects of these services. These are outlined below. This can be edited with the EAS program that is installed with CrossRoad.
- Correctly populate htmlfile.dbf. This provides quite a bit of html text that is used by these services. The kind’s of contents are outlined below. This can be edited with the EAS program that is installed with CrossRoad.
- Ensure that subsidiary databases that support the on-line application system are available and up to date. Most of these are directly maintained in CrossRoad but some are outside. There are WEBDATES.DBF CCINVAL.DBF MINORS.DBF WEBAID.DBF. These are described below.
Webini.dbf Contents
The sample below indicates the contents as used by King’s. Note that EAS refers to the on-line application system.
LINE | DESCRIPTIO |
\\kingsnet\reg\apps\sis\dbf.mm\ | Current Database location |
\\kingsnet\reg\apps\sis\arc.mm\ | ArchiveDatabase location |
https://registry.kingsu.ca/cgi-bin/login.exe | Student login URL |
https://registry.kingsu.ca/kinglogo.gif | Institution Logo URL |
https://registry.kingsu.ca/cgi-bin/weblkup.exe? | Student Advising Available Courses URL |
https://registry.kingsu.ca/cgi-bin/webadvis.exe | Faculty Advising URL |
C- | Threshold Mark for inclusion in major for transfer credit |
https://registry.kingsu.ca/cgi-bin/webadvis.exe | Faculty Advising URL |
https://registry.kingsu.ca/cgi-bin/weblkup.exe? | Faculty Advising Available Courses URL |
https://registry.kingsu.ca/cgi-bin/mainmenu.exe | Student Mainmenu |
<a href=mailto:registrar@kingsu.ca>The Registry @ 465-8330</a> |
Trouble mailto setting |
https://registry.kingsu.ca/cgi-bin/classlst.exe | Faculty Classlist URL |
https://registry.kingsu.ca/cgi-bin/easkuc_a.exe | EAS Admissions URL |
https://registry.kingsu.ca/cgi-bin/easkuc_r.exe | EAS Rez URL |
https://registry.kingsu.ca/cgi-bin/easkuc_f.exe | EAS Financial Aid URL |
http://luke.kingsu.ca/cgi-bin/easkuc_s | EAS Submissions URL |
http://luke.kingsu.ca/cgi-bin/easkuc_m | EAS Menu URL |
http://www.alis.gov.ab.ca/cgi-bin/eas_main.pl | EAS Main Callback URL |
Glenn.Keeler@kingsu.ca,Registry.EAS@kingsu.ca | EAS Applications Email Addresses |
Registry.EAS@kingsu.ca,Glenn.Keeler@kingsu.ca | EAS Rez Applications Email Addresses |
glenn.keeler@kingsu.ca,Registry.EAS@kingsu.ca | EAS FinAid Applications Email Addresses |
http://luke.kingsu.ca/eas/easkucerr.html | EAS Error Url |
1~2~ | Web Advising "<st1:place w:st="on">Normal</st1:place>" Terms |
300 | Web Advising Senior Course Threshold |
3.5 | Web Advising With Distinction GPA |
http://luke.kingsu.ca/cgi-bin/CGImail | Email handler for address changes |
x:\apps\pmail\winpm-32 | |
mailgate1.kingsu.ca | Email server for CrossRoad on the Road |
admissions@kingsu.ca | Enrollment Services Email for CrossRoad on the Road |
registrar@kingsu.ca | Email address for address changes |
https://registry.kingsu.ca/cgi-bin/WebReg.exe | URL for Web Registration |
registrar@kingsu.ca | Web Registration Email Address |
https://registry.kingsu.ca/cgi-bin/WebAdvis.exe | Student Advising URL |
https://registry.kingsu.ca/cgi-bin/ChgFPW.exe | Web Password Change URL |
https://registry.kingsu.ca/cgi-bin/FacMenu.exe | Faculty Menu |
https://registry.kingsu.ca/cgi-bin/WebReview.exe | Faculty On-line Registration Review and Approval |
registrar@kingsu.ca | From Address for most communication |
registrar@kingsu.ca | Academic Warning Address |
https://registry.kingsu.ca/cgi-bin/CourseEval.exe | Course Evaluation URL |
\\kingsnet\app\apps\evalsys\ | Course Evaluation File Path |
https://registry.kingsu.ca/cgi-bin/WebContact.exe | New Advisee Contact URL |
Relfile.dbf Contents
Here are the contents of this file. Entries appear in the file in the order of the RELFILE field, but below are grouped by applications that are affected.
Application Related
Admission Application
ADMFEE.REL |
2006/0750.00;2007/0850.00~2006/07100.00;2007/08100.00~2006/07100.00;2007/08100.00~ |
|
ADMTAB.REL |
|
|
APPLDDAT.REL |
2006/072:20070112~2006/073:20070501~2006/074:20070525~2007/081:20070815~2007/082:20071201~ |
|
APPLDEAD.REL |
|
|
APPLIC.REL |
2006/073~2006/074~2007/081~ |
|
APPLNOTE.REL |
|
|
CARDTYPE.REL |
|
|
LANGREQ.REL |
|
|
SOURCE.REL |
|
|
SPECIAL.REL |
|
|
SPECTERM.REL |
|
|
STDSTAT.REL |
FT|Full-Time~PT|Part-Time~VS|Visiting~SS|Unclassified~ |
|
SUBAPPS.REL |
|
|
REQMINOR.REL |
|
|
Residence Application
CLUBS.REL |
|
|
MEALPLAN.REL |
|
|
OCCUPANC.REL |
|
|
REZDEAD.REL |
15 August |
|
REZFEE.REL |
2004/05400.00~2005/06400.00~2006/07400.00~2007/08400.00~ |
|
REZINTER.REL |
|
|
REZMUSIC.REL |
|
|
Financial Aid
FINAID.REL |
01/02/2007~31/03/2007~ |
|
FINSTMT.REL |
|
|
Student Services
There are several sub services here. The items are clustered by those services.
STUMENU.REL | FINALEXAM~MARKS~ADVISOR~ACCOUNTS~CHANGEADDRESS~REGISTER~COURSEEVAL~ | These items define the various possible student menu entries. At the time of the writing of this document the options are (*d items are in development):
|
Reminders
CHECKLST.REL | REG2010/112~DEP2010/11~REZ2010/11~FIN2010/11~JOB2010/11~DEC2010/11~WEBAPPT2010/112~ | REGyyyy/yyt Registration reminder for a specific year and term DEPyyyy/yy Tuition Deposit reminder for a specific year |
What are my Final Exams?
FINAL.REL |
2006/071~2006071~2006072~2006/072~ |
|
What are my Grades?
MARK.REL |
2004054~2004053~2005061~2005062~2005063~2005064~2006071~2006072~ |
|
On-line Registration
REGISTER.REL |
2006/073~2006/074~2007/081~2007/082~ |
|
CONFIRM.REL |
2006/073~ |
|
NOAUDIT.REL |
*~ |
|
NODROP.REL |
INST*~ENGL2*~ |
|
On-line Course Evaluation
CRSEVCRS.REL |
PSYC492*~ |
|
CRSEVYR.REL |
2006/072~ |
|
Alumni Services
Faculty Services
Class Lists/Grade Submission
ACADWARN.REL |
2006/072~ |
|
WARNCAT.REL |
|
|
GRADESUB.REL |
|
|
MARKSAU.REL |
AU~ |
|
MARKSCR.REL |
A+~A~A-~B+~B~B-~C+~C~C-~D+~D~F~ |
|
MARKSMT.REL |
M~ |
|
MARKSNC.REL |
N~ |
|
MARKSPA.REL |
PA~FA~ |
|
MTCRS.REL |
BIOL395~BIOL495~BIOL497~CHEM395~CHEM495~CHEM497~ENGL398~ENGL498~MUSI376~THEO376~ |
|
PFCRS.REL |
INST200~INST210~INST300~INST310~INST400~INST410~BIOL395~BIOL495~EDUC305~ENVS490~ |
|
New Advisee Contact
WEBCONT.REL |
2007/081FA~IA~ |
|
Web Payment
ADMITFEE.REL | Defines admission fee in webpay | |
ATHLCAMP.REL | Defines athletics camp fee in webpay | |
DONACODE.REL | Defines donation code in webpay (deprecated) | |
DONATION.REL | Defines donation "fee" in webpay | |
GRADFEE.REL | Defines grad fee in webpay | |
LIBFINE.REL | Defines library fine in webpay | |
LIBLIMIT.REL | Defines the "lost book" limitation in webpay | |
PAYPURP.REL | Defines the various payment items that may be selected in webpay | |
REZDEP.REL | Defines the residence deposit in webpay |
Htmlfile.dbf Contents
Htmlfile contains a number of html formatted fragments for insertion at various points for on-line services. These have no <head> or <body> tags, but are otherwise correct html.
HTMLFILE |
HTMLTEXT |
StdDecl.htm |
Declaration for Admission Applications |
BEdDecl.htm |
Declaration for King's BEd applications |
FinDecl.htm |
Declaration for Financial Aid Application |
RezDecl.htm |
Declaration for Residence Application |
StdRec.htm |
Personal Recommendation |
BEdRec.htm |
|
LangReq.htm |
English language proficiency statement |
SupDoc.htm |
|
Redirect.htm |
Redirection to institutional homepage |
ApplProc.htm |
Application Procedure statement |
RezApp.htm |
Residence Applicant introductory text |
FinApp.htm |
|
RezAddr.htm |
|
RegAddr.htm |
|
MarkList.htm |
|
CalUrl.htm |
HREF for the Academic Calendar on the Web |
CalFnUrl.htm |
|
FacMenu.htm |
Faculty Menu static text and links |
RezChoic.htm |
Residence choice listing |
RegnoteX.html
These are htmlized versions of the RegnoteX.rtf files that are used by windows CrossRoad. They are appended to course/fee sheets produced by on-line registration. Conversion utilities can be recommended by Keeler Services.