Hi Tieku, I think I see where the issue may be. There is a yes/no flag that controls whether the Attainment Total Mark is active, so you’d need to make sure to import both columns to enable the total mark via a spreadsheet:
I am trying to update the Term value for a number of markbook columns using the Date Added column in DataStructure-markbookColumns file.
The date is updating, but the Term drop down value remains blank. The date value falls in the current Term (renamed to Quarter in my case using String Replacement)
I always wondered why, when importing DataStructure-markbookColumns, I try to assign a column to a term using the new Term Added field, the Term was not updating properly.
The spreadsheet is looking for the nameShort. When I specify T3, in the database, I see it is using T3 from the previous year (ID = 025), but not from the current year (ID = 026).