Disambiguation of Gradebook Columns in Import Template

@Ali @sandra

In the Gradebook, it is currently possible to create multiple columns with the same name within a single course/class. This is a useful feature, as many schools reuse identical assessment names across different terms.

However, this creates ambiguity when importing marks using the DataStructure-markbookEntry.xlsx template, since there is no way to distinguish between columns that share the same name.

Request:
Add an additional field—such as “Term” (see attachment)—to the import template to help uniquely identify the target column during import.

While duplicate column names within the same term may still present an edge case, this enhancement would address the most common use case where assessments are repeated across terms.

Regards

Hi @tiekubd

Thank you for passing on the feature request. In order to be able to support this, a new importer file has been added to v31 which can be used to import marks into a Markbook Column by Term. Here is the PR: System Admin: added new Marks By Term importer for Markbook Column by ali-ichk · Pull Request #2080 · GibbonEdu/core · GitHub.

Thank you.

Thanks @Ali

Does this work in v30.0.01 when a copy of markbookEntryByTerm.yml is placed in /resources/imports?

Thanks.

Hi @tiekubd

Yes, it should support v30 as well. Thanks :))

I thought so, but I don’t see it. Am I missing a step?

Hi @tiekubd

Thanks for catching the issue. There was a small bug in the type name. Please update the type name as shown here fixed the bug in type name in marks importer by term file by ali-ichk · Pull Request #2082 · GibbonEdu/core · GitHub. That should fix the problem and the system can detect the new importer file. Thank you!!

Hi @Ali

That change worked. Thanks!

To keep things consistent with other import files that already include a Term column—such as markbookColumns.yml—I suggest that markbookEntryByTerm.yml also use the short name, even though my original screenshot displayed the full name.

Regards

Hi @tiekubd
Thanks for the suggestion. It has been changed to use the term short name.
Cheers!