## Exports: XLS with Groups and Dates

gradeexport_xlsgd
Maintained by Carina Martinez
Grade export derived from XLS file. Adds Groups and Dates columns
1k
124
2
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

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

### Comments

Show comments
• Fri, Jul 26, 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.
• Tue, Sep 10, 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()
• Wed, Sep 11, 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...
• Fri, Sep 13, 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
• Sun, Sep 15, 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.
• Sun, Sep 15, 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.
• Mon, Sep 16, 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....
Please login to post comments