Importing Load Constraints

Note: The constraint import is final and cannot be automatically reversed.  If errors are imported, the importer will have to manually delete out errors one by one.

  1. Create an import file with the following fields
  2. Click Special Functions
  3. Click Importing & Exporting
  4. Click Quick Import
  5. On the Quick Import page, select Schedule Constraints from the Select a table drop-down menu
  6. Select your file and click the Import button

Example Load Constraint Imports

Teacher Avoid

Buildid Catalogid Termid Yearid Schoolid Studentid Constraintcode Teacherid ConstraintFlagField1
1052 602 2201 22 142662 937682 05 4755 TRUE

Student Preference

Buildid Catalogid Termid Yearid Schoolid Studentid Constraintcode CourseNumber Teacherid ConstraintFlagField1
1052 602 2201 22 142662 937682 05 AR2113 4755 FALSE

Student Free

Buildid Catalogid Termid Yearid Schoolid Studentid Constraintcode Expression
1052 602 2201 22 142662 937682 06 2(A)

Student Avoid

Buildid Catalogid Termid Yearid Schoolid Studentid Constraintcode Studentid2
1052 602 2201 22 142662 937682 07 926734

Balance Adjustment

Buildid Catalogid Termid Yearid Schoolid Constraintcode CourseNumber SectionNumber TeacherId PreloadCount
1052 602 2201 22 142662 20 BU2311 1 1857 3

Section Link

Buildid Catalogid Termid Yearid Schoolid Constraintcode CourseNumber SectionNumber CourseNumber2 SectionNumber2
1052 602 2201 22 142662 92 BU2311 2 BU2312 2

You may also like...