Known Issue - Problem when importing Google Assignments into a Gradebook with no Categories - Fixed 9/1/2020

Update: A fix for this issue was shipped on 9/1/2020


When a teacher has not yet setup their Categories in a new Gradebook, any attempt to import assignments from Google will result in an issue where assignments may not display in their Gradebook. This will require adding a category to their gradebook and updating those assignment with blank categories (GBA.AT) in either SQL or change query to resolve the issue.  


This sets a default category for all gradebooks where no categories exists, and updates all assignments which were imported with a blank category to the new default.


IF EXISTS(SELECT 1 FROM GBK WHERE GN NOT IN (SELECT GN FROM GBT WHERE GBT.DEL = 0) AND GBK.DEL = 0)
BEGIN
    INSERT INTO GBT (GN,AT,TD,PG,CL)
    SELECT GN,'0','Assignments','0','' FROM GBK WHERE GN NOT IN (SELECT GN FROM GBT WHERE GBT.DEL = 0) AND GBK.DEL = 0
    UPDATE GBA SET AT = '0' WHERE AT = ''
END


 
Login to post a comment