XLS with Groups and Dates

Exports ::: gradeexport_xlsgd
Maintained by Carina Martinez
Grade export derived from XLS file. Adds Groups and Dates columns
Latest release:
33 sites
13 downloads
5 fans
Current versions available: 1

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

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 July 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.
  • Vicente Herrera
    Tue, 10 Sept 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()
  • Vicente Herrera
    Wed, 11 Sept 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...
  • Carina Martinez
    Fri, 13 Sept 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
  • Daniel Lombardo
    Sun, 15 Sept 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.
  • Daniel Lombardo
    Sun, 15 Sept 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.
  • Carina Martinez
    Mon, 16 Sept 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
  • 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
  • time!
    Mon, 4 Sept 2017, 9:13 AM
    Would love to see this work for version 3.1 as well! Beloved plug-in for our group.
  • Juan Eladio Sánchez Rosas
    Fri, 6 Oct 2017, 8:13 AM
    Hi, I patched the last release of this plugin and I managed to make it work in Moodle 3.2. I publish the source code at https://github.com/juaneladio/gradeexport_xlsgd but feel free to hack it and test it in other Moodle versions.

    The plugin needs to be refactored in order to apply changes made in Moodle exports in version 2.8 (MDL-46548).
  • Krisha Moeller
    Sat, 2 Dec 2017, 5:21 AM
    Hello! I am trying to install this plugin, but I keep getting the following error:

    Validating gradeexport_xlsgd ... Error
    [Error] Plugin does not declare its component name [null]
    Installation aborted due to validation failure

    What should I do? Thank you for your help!
  • John Frymire
    Sun, 24 Mar 2019, 1:31 AM
    I just got the giithub version above to work on 3.5 with no editing, thank you Juan Eladio Sanchez Rosas!
  • Muhammad Awais
    Thu, 14 Oct 2021, 6:08 PM
    Hello Everyone !
    After installation of this plugin in moodle 3.10 i exported grade in xlsx file. But when i tried to open this in Excel it is not opening and i am getting the following error:

    "Couldn't Open the Workbook
    This workbook couldn't be opened because the file format may not be matching with the file extension."

    But after downloading the extension of this file is xlsx then why it is not opening in excel and generating error.
    Anybody help me to solve this error i will be very grateful.
    Thanks.
Please login to post comments