Astra Schedule Help (7.5)

Implementation and Installation Notes

Hide Navigation Pane

Implementation and Installation Notes

Previous topic Next topic  

Implementation and Installation Notes

Previous topic Next topic JavaScript is required for the print function  

Implementation and Installation Notes

Astra Schedule VII interfaces with Colleague on UniData through the creation of SQL tables and virtual attributes for use as a translation layer between Astra Schedule and the Colleague UniData database files.  A .NET library provided by Rocket Software called UniObjects is utilized for making SQL queries for imports and performing updates during export.

 

The creation of the SQL tables and configuration of virtual attributes must be performed by an administrator at the institution prior to the implementation of the interface.  This task can be achieved using VSG to convert UniData files to SQL base tables.

 

For details on creating virtual attributes, you may want to reference the following UniData Documentation:

 

Creating Virtual Attributes - UniData Documentation V7.3.0/UniData Manual Set: UniData Commands, Concepts, and Query Languages/Using UniData/Chapter 5: Creating Virtual Attributes

 

noteNOTE: Make sure to assign single or multivalued fields as noted below.  Also, make sure virtual attribute notation and syntax matches the help examples exactly (ex:  STU_TYPES instead of STU.TYPES).

Interface Preparation

The following steps must be performed to configure the interface between Colleague on UniData and Astra Schedule:

 

1.Create the required SQL base tables from UniData files.
 
The creation of the base tables can be achieved using VSG.
 
See Astra Schedule Tables and/or Platinum Analytics Tables for a list of the tables and fields that must be created.
 
noteNOTE:  The following columns must be explicitly made multi-value in UniData to work correctly with the import spokes.  All other columns should be single value.

 

Multi-Valued Columns

 

DatatelUniObjectsCourseImport.xml

 

COURSES_1

CRS_DEPTS

CRS_LOCATIONS

CRS_EQUATE_CODES

CRS_COREQ_COURSES

 

 

DatatelUniObjectsPgmRuleImport.xml

 

ACAD_REQMTS

ACR_CATALOGS

ACAD_PROGRAM_REQMTS

ACPR_ACAD_REQMTS

ACAD_REQMT_BLOCKS

ACRB_BUT_NOT_SUBJECTS

ACRB_BUT_NOT_COURSES

ACRB_COURSES

ACRB_FROM_SUBJECTS

ACRB_FROM_CRS_LEVELS

ACRB_FROM_DEPTS

ACRB_FROM_COURSES

 

 

DatatelUniObjectsPgmStudentImport.xml

 

STUDENT_PROGRAMS

X_STPR_ACPG_MAJORS

PERSON_ST

PST_ADMISSIONS_TESTS

STUDENT_PROGRAMS

X_STPR_ACPG_MAJORS

ACPG.MAJORS

 

 

2.Create the required virtual attributes.
 
The table detail provided in step 1 includes the virtual attributes that must be created for each table.
 
Following is an example for the virtual attribute called “ASTRA_SEC_ACTUAL_ENROLLMENT” for the COURSE_SECTIONS table:

 

:AE DICT COURSE_SECTIONS ASTRA_SEC_ACTUAL_ENROLLMENT
Top of "ASTRA_SEC_ACTUAL_ENROLLMENT" in "DICT COURSE_SECTIONS", 9 lines, 147 characters.

001: I
002: DCOUNT(SEC_ACTIVE_STUDENTS,@VM)

003:
004: ACT. ENROL.

005: 3R
006: S
 

3.Install Astra Schedule.  During the installation process you will select Colleague UniData as the SIS Type and provide the following connection information:
 

Host Name  (ex:  datatel.school.edu)

User Name

Password

Account  (directory of account)

Service  (ex: udcs)

 

Install_SIS_ColleagueSettings