D2L API

D2L is interfaced to the Jenzabar SIS through the D2L Valence API.

The API Reference can be found at https://docs.valence.desire2learn.com/reference.html

The scripts that create data can be found on the EXJICSWEB server in D:\webapps\Scripts\ACCOUNT_AUTOMATION

0_AD_LOAD_ACCOUNT_LIST.vbs 

 Copies a list of users from AD to GC_Custom table AD_BACKLOAD

0_VALENCE_BASE.php            

 Copies D2L Org Structure into table D2L_VALENCE_ORG

1_VALENCE_TERMS.php

 Create terms in D2L from EX that start in the next 8 months

2_VALENCE_TEMPLATES.php       

Create Course templates for any new courses in EX that do not have a template created. Insert this template code into CATALOG_MSTR_UDF  

3_1_START_USERS.php      

Create Alternate Identifiers in EX for users 

3_2_GOOGLE_USERS.php    

 Create google accounts for students

3_3_VALENCE_USERS.php 

            Create new student users in D2L 

3_3_2_VALENCE_USER_UPDATE.php 

Find NAME_MSTR_HISTORY entries from the last 24 hours and update D2L with updated name, email, etc info.

 

3_4_AD_USERS.php

 Create Active directory users for students. This calls create.vbs which interacts with active directory.

3_5_VALENCE_FACULTY_USERS.php 

 Create d2l users for new faculty members

3_6_DISABLE_AND_MOVE.php 

 Disable AD accounts of non-active students

4_VALENCE_COURSES.php           

            Create new courses in D2L    

5_VALENCE_FACULTY.php       

 Assign Faculty Members to D2L Courses

 

6_VALENCE_STUDENTS.ph

 Assign Students to D2L Courses

7_AEROHIVE_CLEANUP.php      

 Remove Aerohive PPSK for non-active students

8_AD_EMPLOYEE_NUMBER.php     

 Update the AD accounts employeeid and employeenumber with EX idnum