Known Issue - Problem when importing Google Assignments into a Gradebook with no Categories - Fixed 9/1/2020
M
Minott Opdyke
started a topic
almost 3 years ago
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
Minott Opdyke
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