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:
24 sites
7 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

显示评论
  • MD shot of me from his iphone4
    2013年07月26日 星期五 14:57
    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
    2013年09月10日 星期二 23:59
    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
    2013年09月11日 星期三 00:12
    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
    2013年09月13日 星期五 02:51
    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
    2013年09月15日 星期日 14:24
    Oh God Bless You. and i'm not religious... you just made our lives easier. Moodle 2.5.2 working fine.
  • Daniel Lombardo
    2013年09月15日 星期日 14:36
    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
    2013年09月16日 星期一 20:35
    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.... 微笑
  • frank weissman
    2016年11月1日 星期二 17:45
    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!
    2017年09月4日 星期一 09:13
    Would love to see this work for version 3.1 as well! Beloved plug-in for our group.
  • Juan Eladio Sánchez Rosas
    2017年10月6日 星期五 08:13
    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
    2017年12月2日 星期六 05:21
    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!
  • j f
    2019年03月24日 星期日 01:31
    I just got the giithub version above to work on 3.5 with no editing, thank you Juan Eladio Sanchez Rosas!
  • Muhammad Awais
    2021年10月14日 星期四 18:08
    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