Difference between revisions of "CGI Setup"

From CrossRoad
Jump to: navigation, search
(→‎Student Services)
Line 458: Line 458:
  
 
<table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0>
 
<table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0>
−
<tr><td width=103 valign=top>
+
<tr><td valign=top>
 
<br />STUMENU.REL</td>
 
<br />STUMENU.REL</td>
−
<td width=533 valign=top>
+
<td valign=top>
 
<br />FINALEXAM~MARKS~ADVISOR~ACCOUNTS~CHANGEADDRESS~REGISTER~COURSEEVAL~</td>
 
<br />FINALEXAM~MARKS~ADVISOR~ACCOUNTS~CHANGEADDRESS~REGISTER~COURSEEVAL~</td>
−
<td width=359 valign=top>
+
<td valign=top>
 
<br />These items
 
<br />These items
 
define the various possible student menu entries. At the time of the writing
 
define the various possible student menu entries. At the time of the writing
Line 492: Line 492:
  
 
<table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0>
 
<table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0>
−
<tr><td width=332 valign=top>
+
<tr><td valign=top>
 
<br />FINAL.REL</td>
 
<br />FINAL.REL</td>
−
<td width=300 valign=top>
+
<td valign=top>
 
<br />2006/071~2006071~2006072~2006/072~</td>
 
<br />2006/071~2006071~2006072~2006/072~</td>
−
<td width=364 valign=top>
+
<td valign=top>
 
<br />This is a tilde
 
<br />This is a tilde
 
delimited list of final exam schedules that have been released to be seen
 
delimited list of final exam schedules that have been released to be seen
Line 505: Line 505:
 
==== What are my Grades? ====
 
==== What are my Grades? ====
  
−
<table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0 width=995>
+
<table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0>
−
<tr><td width=103 valign=top>
+
<tr><td valign=top>
 
<br />MARK.REL</td>
 
<br />MARK.REL</td>
−
<td width=528 valign=top>
+
<td valign=top>
 
<br />2000011~2000012~2000013~2001021~2001022~2001023~2002031~2002032~2002033~2003041~2003042~2003043~2003044~2004051~2004052~2004054~2004053~2005061~2005062~2005063~2005064~2006071~2006072~</td>
 
<br />2000011~2000012~2000013~2001021~2001022~2001023~2002031~2002032~2002033~2003041~2003042~2003043~2003044~2004051~2004052~2004054~2004053~2005061~2005062~2005063~2005064~2006071~2006072~</td>
−
<td width=364 valign=top>
+
<td valign=top>
 
<br />This is a tilde
 
<br />This is a tilde
 
delimited list of the grades that have been released to be viewed through
 
delimited list of the grades that have been released to be viewed through
Line 520: Line 520:
  
 
<table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0>
 
<table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0>
−
<tr><td width=103 valign=top>
+
<tr><td valign=top>
 
<br />REGISTER.REL</td>
 
<br />REGISTER.REL</td>
−
<td width=528 valign=top>
+
<td valign=top>
 
<br />2006/073~2006/074~2007/081~2007/082~</td>
 
<br />2006/073~2006/074~2007/081~2007/082~</td>
−
<td width=364 valign=top>
+
<td valign=top>
 
<br />This is the tilde
 
<br />This is the tilde
 
delmited list of terms open for registration. This should be set when a term
 
delmited list of terms open for registration. This should be set when a term
Line 530: Line 530:
 
at least.</td>
 
at least.</td>
 
</tr>
 
</tr>
−
<tr><td width=103 valign=top>
+
<tr><td valign=top>
 
<br />CONFIRM.REL</td>
 
<br />CONFIRM.REL</td>
−
<td width=528 valign=top>
+
<td valign=top>
 
<br />2006/073~</td>
 
<br />2006/073~</td>
−
<td width=364 valign=top>
+
<td valign=top>
 
<br />This is the tilde
 
<br />This is the tilde
 
delimited list of terms for which a student may confirm registration (that
 
delimited list of terms for which a student may confirm registration (that
 
is, have the charges made against the accounts receivable account).</td>
 
is, have the charges made against the accounts receivable account).</td>
 
</tr>
 
</tr>
−
<tr><td width=103 valign=top>
+
<tr><td valign=top>
 
<br />NOAUDIT.REL</td>
 
<br />NOAUDIT.REL</td>
−
<td width=528 valign=top>
+
<td valign=top>
 
<br />*~</td>
 
<br />*~</td>
−
<td width=364 valign=top>
+
<td valign=top>
 
<br />This defines
 
<br />This defines
 
course codes (using wildcards) for courses that cannot be audited. As written
 
course codes (using wildcards) for courses that cannot be audited. As written
 
in the example, no courses may be selected for audit.</td>
 
in the example, no courses may be selected for audit.</td>
 
</tr>
 
</tr>
−
<tr><td width=103 valign=top>
+
<tr><td valign=top>
 
<br />NODROP.REL</td>
 
<br />NODROP.REL</td>
−
<td width=528 valign=top>
+
<td valign=top>
 
<br />INST*~ENGL2*~</td>
 
<br />INST*~ENGL2*~</td>
−
<td width=364 valign=top>
+
<td valign=top>
 
<br />These are courses
 
<br />These are courses
 
which may not be dropped on the
 
which may not be dropped on the
Line 563: Line 563:
  
 
<table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0>
 
<table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0>
−
<tr><td width=103 valign=top>
+
<tr><td valign=top>
 
<br />CRSEVCRS.REL</td>
 
<br />CRSEVCRS.REL</td>
−
<td width=528 valign=top>
+
<td valign=top>
 
<br />PSYC492*~</td>
 
<br />PSYC492*~</td>
−
<td width=364 valign=top>
+
<td valign=top>
 
<br />This states the
 
<br />This states the
 
courses, using wildcards, that are available for evaluation.</td>
 
courses, using wildcards, that are available for evaluation.</td>
 
</tr>
 
</tr>
−
<tr><td width=103 valign=top>
+
<tr><td valign=top>
 
<br />CRSEVYR.REL</td>
 
<br />CRSEVYR.REL</td>
−
<td width=528 valign=top>
+
<td valign=top>
 
<br />2006/072~</td>
 
<br />2006/072~</td>
−
<td width=364 valign=top>
+
<td valign=top>
 
<br />This is the list
 
<br />This is the list
 
of terms available for evaluation. Normally only one term would be entered
 
of terms available for evaluation. Normally only one term would be entered

Revision as of 15:45, 4 February 2011

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

  1. Setup underlying OS. This can be Windows 2000, or 2003.
  2. Install Apache.
  3. Apache runs under a particular Win2K user. Ensure that this user can:
    1. Connect to the network which has the Advantage Database Server on it
    2. Can see the folders which hold the data for CrossRoad
    3. Has appropriate rights to the cgi-bin folder under Apache.
  4. Install a certificate and change apache’s settings to enable SSL. All of CrossRoad’s CGI processes expect https: calls.
  5. Use the CGISetup.exe to install the various CGI programs, images and javascript files.
  6. 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.
  7. 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).
  8. 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.
  9. 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.
  10. 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.
  11. 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.

LINEDESCRIPTIO
\\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~


This field specifies the application fee based on year applied for. The structure is that the first set is the standard fee (years are distinguished by semi-colons) the second is the late application fee, and the third is the

international application fee.

ADMTAB.REL


NM|Name~AD|Address~EM|Emergency Contact~BG|Biographical~HS|High School~L30|Grade 12 Courses~PS|Previous Post-Secondary~KUC-1|Program Information~KUC-4|Further

Information~KUC-2|Reference~KUC-3|Declaration~KUC-5|Payment~


This determine which tabs from the application process are available. The coded name appears

before the pipe character with the display name after that.

APPLDDAT.REL
2006/072:20070112~2006/073:20070501~2006/074:20070525~2007/081:20070815~2007/082:20071201~


These are the

deadeline dates for each year and term.

APPLDEAD.REL


Fall Term 15 August~ Winter Term 12 January~BEd Applications 2007/08 will release

decisions on approximately 31 March 2007 and 15 May 2007.~


This is a text statement of the application dates for fall,winter and a special statement.

This would need to be customized for users other than King’s.

APPLIC.REL
2006/073~2006/074~2007/081~


This is a

definition of the available application year and terms.

APPLNOTE.REL


This allows the insertion of a special note about applications, such as the extension of a

deadline.

CARDTYPE.REL


MASTERCARD|MasterCard~VISA|Visa~CHEQUE|Cheque to be mailed~FUNDSTRANSFER|Funds Transfer~INPERSON|Will pay in person at

TKUC~


These are the definitions of acceptable payment types, with the code followed by a pipe

character followed by the text displayed.

LANGREQ.REL


TOEP|TOEFL (paper-based version)~TOEC|TOEFL (computer-based version)~TOEI|TOEFL iBT (internet based)~MELA|MELAB~IELT|IELTS~ASPE|ASPECT~ELTC|The English Language Training College Program with a score of 9~EN30|Alberta English 30~IBHL|International Baccalaureate Higher Level English~APEN|Advanced Placement English~HERE|I have three years of formal full-time study in Canada or at an approved institution outside Canada as outlined above~TKUC|I have already taken TKUC's ENGL204 or 205~KEST|I am requesting the King's English

Language Studies Assessment Test~


This defines the

acceptable English proficiency demonstrations.

SOURCE.REL


BILLBOARD|Billboard Ad~FACSTAFF|Faculty or Staff Member~FAMILY|Family~FRIEND|Friend~NEWS|News coverage~ALUM|Previous King's Student~PRINT|Print Ad~RADIO|Radio or TV

Ad~SCHOOL|School Contact~INTERNET|Internet~


This defines the

accepted categories for the responses to the “I first heard about” question.

SPECIAL.REL


This allows the

definition of “Special” programs. Currently unused.

SPECTERM.REL


This defines valid

terms for the special program.

STDSTAT.REL
FT|Full-Time~PT|Part-Time~VS|Visiting~SS|Unclassified~


This defines the

possible student status types for the application.

SUBAPPS.REL


AIDAPP|Financial

Aid*~EMPAPP|Campus Employment*~MUSAPP|Music~APPATH|Athletics~


This defines

additional applications that can be requested.

REQMINOR.REL


BA4

ENVS~BSC4ENVS~


This defines

programs that has a required minor.

Residence Application


CLUBS.REL


ISA|International Student's Association~MSA|Mature Student Association~AAA|Action and Awareness Club~TKK|The King's Keepers/The Environmental Club~KEA|The King's Education Association~KGH|The King's Hands~KPH|The King's Players/Drama Club~KHC|TKUC Hockey Club~KMS|TKUC Men's Soccer Club~KWS|TKUC Women's Soccer Club~PHC|The Philosophy Club~PSC|The Political Studies Club~PYC|The Psychology Club~PSP|The Peer Support Program~SCC|The King's Science Society~SSC|The Snowboarding/Ski Club~IFC|The International Films Club~LDC|Liturgical

Dance Club~


This defines the

various student clubs that might be selected on the residence application.

MEALPLAN.REL


BASIC|Basic ($2600 deposit per year)~OPT1|Limited ($2200 deposit per

year)~APT1|Apartment, no meal plan required~


This defines the

available mealplans.

OCCUPANC.REL


2F|Tower Full Year Double occupancy : ($2200 for the full year)~1F|Tower Full Year Single occupancy : ($4000 for the full year)~6F|Apartment Full Year occupancy : ($2400 for the full

year)~


This defines the

available occupancies.

REZDEAD.REL
15 August


This defines the text

for the application deadline.

REZFEE.REL
2004/05400.00~2005/06400.00~2006/07400.00~2007/08400.00~


This defines the

required deposit by year of application.

REZINTER.REL


T|Team sports (volleyball, basketball, soccer, etc)~E|Extreme sports (mountain biking, snowboarding, skiing, etc)~M|Music~C|Computers~R|Reading and

Writing~O|Outdoor activities (hiking, camping, etc)~


This defines the

different interests that might be selected on the residence application.

REZMUSIC.REL


A|Alternative~P|Punk/ska~C|Country~H|Heavy

metal~L|Classical~J|Jazz~O|Pop~X|I am tolerant of all types of music~


This defines the

different

Financial Aid


FINAID.REL
01/02/2007~31/03/2007~


This defines the

period during which applications for financial aid will be accepted.

FINSTMT.REL


XTNCMT|Statement of Christian Commitment
Speak of your commitment to Christianity or your faith. What does your faith mean to you?~INVOLV|Statement of Involvement in University Activities
Tell the effect you have had on the King's student community in past years of study. What activities have you been involved in?~MUSICACH|Statement of Musical Achievement
Speak of your musical achievements, including all awards, recognition, honours and activities.~DISABILITY|Statement of Disability
In order to award the Mephiboschet Scholarship, the awarding committee must be aware of your condition and its limitations on your studies.~STEWARD|Statement of Commitment to Stewardship of God's Creation
Tell of your commitment to the environment and its stewardship. Have you beeninvolved in environmental programs in your community? Have you implemented any programs to increase/impact stewardship?~CAREERINT|Statement of Career Intent and/or Activities Post-Graduation
Explain your plans after graduation. What will you be doing with the degree you will receive from The King's <st1:place w:st="on"><st1:PlaceType w:st="on">University</st1:PlaceType> <st1:PlaceType w:st="on">College</st1:PlaceType></st1:place>?~GRADINT|Statement of Graduation Intentions
What are your goals for your studies? Do you intend to graduate from The King's <st1:place w:st="on"><st1:PlaceType w:st="on">University</st1:PlaceType> <st1:PlaceType w:st="on">College</st1:PlaceType></st1:place>? Will you further your studies elsewhere?~MRWCRS|List of Courses taken through ADLC
Please list high school courses you have taken through the

Alberta Distance Learning Centre.~


This defines the code and the text description of the various possible statements that might

be requested.

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):
REGISTER = What Am I Registered In? and On-line Registration
FINALEXAM = What is My Final Exam Schedule?
MARKS = What are My Marks?
ADVISOR = Program Advisor Report
ACCOUNTS = What is the status of my Account?
CHANGEADDRESS = Change Address Information
COURSEEVAL = On-line Course Evaluation
*TRANREQ = Request your Academic Transcript
*LETTERREQ = Request a letter of confirmation
*PROGCHANGE = Request

a change in program

What are my Final Exams?


FINAL.REL
2006/071~2006071~2006072~2006/072~


This is a tilde delimited list of final exam schedules that have been released to be seen

through web services.

What are my Grades?


MARK.REL
2000011~2000012~2000013~2001021~2001022~2001023~2002031~2002032~2002033~2003041~2003042~2003043~2003044~2004051~2004052~2004054~2004053~2005061~2005062~2005063~2005064~2006071~2006072~


This is a tilde delimited list of the grades that have been released to be viewed through

these services.

On-line Registration


REGISTER.REL
2006/073~2006/074~2007/081~2007/082~


This is the tilde delmited list of terms open for registration. This should be set when a term is ready for registration and not removed until after the withdraw deadline

at least.

CONFIRM.REL
2006/073~


This is the tilde delimited list of terms for which a student may confirm registration (that

is, have the charges made against the accounts receivable account).

NOAUDIT.REL
*~


This defines course codes (using wildcards) for courses that cannot be audited. As written

in the example, no courses may be selected for audit.

NODROP.REL
INST*~ENGL2*~


These are courses which may not be dropped on the web –

usually theses are mandatory courses for all students.

On-line Course Evaluation


CRSEVCRS.REL
PSYC492*~


This states the

courses, using wildcards, that are available for evaluation.

CRSEVYR.REL
2006/072~


This is the list of terms available for evaluation. Normally only one term would be entered

here at a time.

Faculty Services

Class Lists/Grade Submission


ACADWARN.REL
2006/072~


This “releases” a term or terms to have instructors issue academic warnings for individual

students.

WARNCAT.REL


This defines the

communication log category for academic warnings.

GRADESUB.REL


This “releases” a

term or terms to have instructors submit grades.

MARKSAU.REL
AU~


This defines

grades for audit registrations.

MARKSCR.REL
A+~A~A-~B+~B~B-~C+~C~C-~D+~D~F~


This defines

grades for credit registrations.

MARKSMT.REL
M~


This defines

grades for midterm courses (ie the first half of full year courses).

MARKSNC.REL
N~


This defines

grades for non-credit registrations.

MARKSPA.REL
PA~FA~


This defines

grades for pass/fail courses.

MTCRS.REL
BIOL395~BIOL495~BIOL497~CHEM395~CHEM495~CHEM497~ENGL398~ENGL498~MUSI376~THEO376~


This defines

courses that should be marked as mid-term.

PFCRS.REL
INST200~INST210~INST300~INST310~INST400~INST410~BIOL395~BIOL495~EDUC305~ENVS490~


This defines

courses that should be marked pass/fail.

New Advisee Contact


WEBCONT.REL
2007/081FA~IA~


Defines the term applied for and the file status codes that determine which advisees appear on

the list for faculty to contact.

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


Personal Recommendation for BEd

Applications

LangReq.htm
English language proficiency statement

SupDoc.htm


List of supporting documents required for

application

Redirect.htm
Redirection to institutional homepage

ApplProc.htm
Application Procedure statement

RezApp.htm
Residence Applicant introductory text

FinApp.htm


Financial Aid Application Procedure

statement

RezAddr.htm


Application Address for Residence

Applications

RegAddr.htm


Application Address for Admission

Applications

MarkList.htm


Text describing offer of notification when grades are released (requires that the institution run such an email

list).

CalUrl.htm
HREF for the Academic Calendar on the Web

CalFnUrl.htm


HREF for Financial Aid information on the

web

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.

Retrieved from "https://registry.kingsu.ca/mediawiki/index.php?title=CGI_Setup&oldid=563"