Exports: XLS with Groups and Dates

gradeexport_xlsgd
Maintained by Picture of Carina Martinez Carina Martinez
Grade export derived from XLS file. Adds Groups and Dates columns
99 sites
559 downloads
3 fans
Moodle 2.1, 2.3, 2.4, 2.5, 2.6

This plugin exports grades in xls file, adding two type of columns:


1. Group column,  shows groups' name which students are enroled. In the "All participants" export (without selection of group), you'll see a row for each student-group couple, it means that for the same student could have as many rows as groups which he was affiliated.


2. Date columns, for each grade item, shows the last modification date for this item grade (Y.m.d  format)


Install
**********

Copy the plugin directory "xlsgd" into moodle\grade\export\.
Check admin notifications to install.

Contributors

Picture of Carina Martinez
Carina Martinez (Lead maintainer)
Please login to view contributors details and/or to contact them

Comments RSS

Show comments
  • MD shot of me from his iphone4
    Fri, 26 Jul 2013, 2:57 PM
    Hi Carina,
    Thanks for your submission.

    It would be good to share this properly so here is some feedback in how we can go about that :
    - It is better to include some urls here in the 'useful links' section:
    -- public code repository (eg: github)
    -- issue tracker (e.g: tracker.moodle.org or github.com//issues)
    -- if you have any additional documentation you can create a link for it as well.

    Generally, this feels like it could become a generalised feature and become included in core so you might want to consider improving XLS report with a patch in an MDL.
  • Picture of Vicente Herrera
    Tue, 10 Sep 2013, 11:59 PM
    Doesn't work on Moodle 2.3, after selecting report options, when clicking "download" it gives error:

    Debug info:
    Error code: nopermissions
    Stack trace:
    line 704 of /lib/accesslib.php: required_capability_exception thrown
    line 41 of /grade/export/xlsgd/export.php: call to require_capability()
  • Picture of Vicente Herrera
    Wed, 11 Sep 2013, 12:12 AM
    It seems that there is a typo on roles capabilities names. Administrator role never gest capability "gradeexport/xlsdate:view", but "gradeexport/xlsdg:view", etc.

    To fix this, change line 41 of /grade/export/xlsgd/export.php from:
    require_capability('gradeexport/xlsdate:view', $context);
    to:
    require_capability('gradeexport/xlsgd:view', $context);

    And it should work just fine...
  • Picture of Carina Martinez
    Fri, 13 Sep 2013, 2:51 AM
    Gracias Vicente!
    Se había colado el error, en el archivo de la carpeta lang en realidad.
    Está corregido y subido.

    Agradezco feedback en este foro:
    https://moodle.org/mod/forum/discuss.php?d=238046
  • Picture of Daniel Lombardo
    Sun, 15 Sep 2013, 2:24 PM
    Oh God Bless You. and i'm not religious... you just made our lives easier. Moodle 2.5.2 working fine.
  • Picture of Daniel Lombardo
    Sun, 15 Sep 2013, 2:36 PM
    It would also be great to enable or disable the dates. We have a lot of graded items to export at once sometimes, exporting the dates may occasionally put too much load on the server.
  • Picture of Carina Martinez
    Mon, 16 Sep 2013, 8:35 PM
    Thanks Daniel for your feedback. Yes, it would be great some working around this. Well, I hope have some time for think about Aparup suggestions too.... smile
  • Picture of frank weissman
    Tue, 1 Nov 2016, 5:45 PM
    Dear Carina
    Are you planning to create an update for moodle version 3.1 we would like that very much. At the moment we can not use the export module anymore
Please login to post comments