moodleou / moodle-report_customsql

A Moodle report plugin that lets you easily create simple reports that can be expressed as a single SQL query
46 stars 100 forks source link

Import/Export of Reports #29

Open bbusschots-mu opened 6 years ago

bbusschots-mu commented 6 years ago

We run multiple Moodle instances, and it would be great to be able to export our reports from one, and import them into another.

If I were to code up a CLI script for exporting categories and reports to a JSON file, and importing such a JSON file and send a pull request, is that likely to be merged into the plugin?

timhunt commented 6 years ago

That is a feature I have wanted myself, so yes please :-)

I guess JSON is currently trendy, and perfectly fine, but lots of other bits of Moodle use XML, and YAML tends to be the most human-readable of these sorts of things, so perhaps you might like to think about the format.

bbusschots-mu commented 6 years ago

Cool — I'll go ahead so.

Just to set expectations, this will be a back-ground task for me, so don't be surprised if you don't see the PR until some time in the middle of the summer.

As for JSON -v- XML -v- YAML, I'll have a think about it before I start coding.

We are very heavy JSON users here because of how portable it is across languages and platforms, so that's always my go-to format for both config files and data files. Personally, XML makes me cringe, so I never default to it, but being consistent with other plugins has merit. I have no experience at all with YAML, so I'll do a little RTFMing before I make a decision.

timhunt commented 6 years ago

That's fine. I realise that writing JSON in PHP is really easy and does not require extra libraries. That may well be the decisive factor.