Myvcccd Term Load Procedure

MyVCCCD Term Load Procedure
Updated: 9/18/2009 MDR
The following procedure should be followed 2 Weeks before the start of each term. There should only be two active primary terms, so, for instance, 200807 and 200903 can be active, or 200903, 200905, and 200907 can be active.

1.  Pause the LMG on the resource server.

A.  Use the following command from the resource server:
$CP_ROOT/products/lmg/Events/bin/stopevents
Make sure to enter a CAPITAL Y when prompted

2.  Activate the new term for LDI synchronization.

A.  In Banner, open the GORICCR job

B.  Set Process to ELEARNING and Setting to ACTIVE_TERM then Nextblock (ctrl-pagedown)

C.  Add a new record and set the fields to:

§  Setting: ACTIVE_TERM

§  Value: <the new term> Example: 200903

§  Description: <new term description> Example: Spring 2009

D.  Save your changes using F10

3.  Update all user roles. - (Takes about an hour)

A.  In Banner, open the GURIROL job

B.  NextBlock (ctrl-pagedown) to the Submission block (leave all parameters empty except 05: INTCOMP)

C.  F10 to run the job

D.  Wait until the job is complete before continuing.

4.  Extract Terms, Sections, and Faculty Assignments (Student Enrollments when student comes up) to an xml file.

A.  In Banner, open the ICGORLDI job

B.  NextBlock (ctrl-pagedown) to the Parameters block and set the following params:

§  01: <EMPTY>

§  02: <EMPTY>

§  03: <EMPTY>

§  04: <EMPTY>

§  05: <New Term> Example: 200903

§  06: N

§  07: N

§  08: N

§  09: Y

§  10: N

§  11: Y

§  12: ALL

§  13: Y

§  14: N

§  15: Y

§  16: <EMPTY>

§  17: N

§  18: <EMPTY>

C.  NextBlock to the Submission block and use F10 to run the job.

D.  Be sure to note the 1up number at the bottom of the screen.

E.  Wait until the process is finished to continue. You should receive an email.

5.  Import the xml file created in step 4.

A.  Import the xml file using the following command:
cptool import ims icgorldi_<1up number from step 4-D>.xml > icgorldi_<1up number from step 4-D>.xml.log

B.  Examine the import results for errors. Ignore duplicate email errors for now (see step 7).

.  Restart the LMG to allow queued events to be processed.

A.  Use the following command from the resource server (it may take a few minutes):
$CP_ROOT/products/lmg/Events/bin/runevents

7.  Examine the import results for errors.

A.  Use following grep command to look for errors.
grep ERROR icgorldi_<1up number from step 4-D>.xml.log > import_errors_<datestamp>.txt

B.  Fix Enrollments for Dupe-Email People
Run Script to populate pos-sel: fix_email_ldi_popsel.sql
Run ICGORODM with the following params:

§  01: STUDENT

§  02: FIX_EMAIL_LDI

§  03: <USERNAME>

§  04: <USERNAME>

§  <ALL OTHER PARAMS ARE EMPTY>