{"id":248,"date":"2012-10-11T14:01:03","date_gmt":"2012-10-11T14:01:03","guid":{"rendered":"http:\/\/psws.glenbard.org\/index.php\/2012\/10\/11\/importing-load-constraints\/"},"modified":"2016-02-05T08:48:50","modified_gmt":"2016-02-05T14:48:50","slug":"importing-load-constraints","status":"publish","type":"post","link":"https:\/\/docs.glenbard.org\/index.php\/ps-2\/admin-ps\/scheduling\/importing-load-constraints\/","title":{"rendered":"Importing Load Constraints"},"content":{"rendered":"

Note: The constraint import is final and cannot be automatically reversed.\u00a0 If errors are imported, the importer will have to manually delete out errors one by one.<\/strong><\/span><\/p>\n

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

    Example Load Constraint Imports<\/h2>\n

    Teacher Avoid<\/h3>\n\n\n\n\n\n
    Buildid<\/th>\nCatalogid<\/th>\nTermid<\/th>\nYearid<\/th>\nSchoolid<\/th>\nStudentid<\/th>\nConstraintcode<\/th>\nTeacherid<\/th>\nConstraintFlagField1<\/th>\n<\/tr>\n<\/thead>\n
    1052<\/td>\n602<\/td>\n2201<\/td>\n22<\/td>\n142662<\/td>\n937682<\/td>\n05<\/td>\n4755<\/td>\nTRUE<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    Student Preference<\/h3>\n\n\n\n\n\n
    Buildid<\/th>\nCatalogid<\/th>\nTermid<\/th>\nYearid<\/th>\nSchoolid<\/th>\nStudentid<\/th>\nConstraintcode<\/th>\nCourseNumber<\/th>\nTeacherid<\/th>\nConstraintFlagField1<\/th>\n<\/tr>\n<\/thead>\n
    1052<\/td>\n602<\/td>\n2201<\/td>\n22<\/td>\n142662<\/td>\n937682<\/td>\n05<\/td>\nAR2113<\/td>\n4755<\/td>\nFALSE<\/td>\n<\/tbody>\n<\/table>\n

    Student Free<\/h3>\n\n\n\n\n\n
    Buildid<\/th>\nCatalogid<\/th>\nTermid<\/th>\nYearid<\/th>\nSchoolid<\/th>\nStudentid<\/th>\nConstraintcode<\/th>\nExpression<\/th>\n<\/tr>\n<\/thead>\n
    1052<\/td>\n602<\/td>\n2201<\/td>\n22<\/td>\n142662<\/td>\n937682<\/td>\n06<\/td>\n2(A)<\/td>\n<\/tbody>\n<\/table>\n

    Student Avoid<\/h3>\n\n\n\n\n\n
    Buildid<\/th>\nCatalogid<\/th>\nTermid<\/th>\nYearid<\/th>\nSchoolid<\/th>\nStudentid<\/th>\nConstraintcode<\/th>\nStudentid2<\/th>\n<\/tr>\n<\/thead>\n
    1052<\/td>\n602<\/td>\n2201<\/td>\n22<\/td>\n142662<\/td>\n937682<\/td>\n07<\/td>\n926734<\/td>\n<\/tbody>\n<\/table>\n

    Balance Adjustment<\/h3>\n\n\n\n\n\n
    Buildid<\/th>\nCatalogid<\/th>\nTermid<\/th>\nYearid<\/th>\nSchoolid<\/th>\nConstraintcode<\/th>\nCourseNumber<\/th>\nSectionNumber<\/th>\nTeacherId<\/th>\nPreloadCount<\/th>\n<\/tr>\n<\/thead>\n
    1052<\/td>\n602<\/td>\n2201<\/td>\n22<\/td>\n142662<\/td>\n20<\/td>\nBU2311<\/td>\n1<\/td>\n1857<\/td>\n3<\/td>\n<\/tbody>\n<\/table>\n

    Section Link<\/h3>\n\n\n\n\n
    Buildid<\/th>\nCatalogid<\/th>\nTermid<\/th>\nYearid<\/th>\nSchoolid<\/th>\nConstraintcode<\/th>\nCourseNumber<\/th>\nSectionNumber<\/th>\nCourseNumber2<\/th>\nSectionNumber2<\/th>\n<\/thead>\n
    1052<\/td>\n602<\/td>\n2201<\/td>\n22<\/td>\n142662<\/td>\n92<\/td>\nBU2311<\/td>\n2<\/td>\nBU2312<\/td>\n2<\/td>\n<\/tbody>\n<\/table>\n<\/div>","protected":false},"excerpt":{"rendered":"

    Note: The constraint import is final and cannot be automatically […]<\/p>\n","protected":false},"author":1,"featured_media":247,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[97],"tags":[205,133],"class_list":["post-248","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scheduling","tag-constraints","tag-powerschool-imports"],"acf":[],"_links":{"self":[{"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/posts\/248","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/comments?post=248"}],"version-history":[{"count":3,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/posts\/248\/revisions"}],"predecessor-version":[{"id":1893,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/posts\/248\/revisions\/1893"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/media\/247"}],"wp:attachment":[{"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/media?parent=248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/categories?post=248"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/tags?post=248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}