Our school uses Aeries School Information System for its online gradebook. Teachers are using Moodle for class pages, but not for grades.
It would be great if we could have Moodle gradebook sync with the Aeries gradebook, so that teachers could use Moodle to create assignments and they would appear on Aeries.
Question 1: Moodle gradebook export format compared to Blackboard export format.
Right now one possibility is a dump instead of a sync. Aeries does have a blackboard import feature, does anyone know the differences between a Moodle gradebook export and a blackboard gradebook export?
Question 2: Does anyone have any experience syncing the Moodle gradebook with an external database? I am a non coder, but our district could pay for coding.
It's 2012 - has anyone made any progress on this? Aeries now has Aeries analytics but moodle is way better. However, if moodle can not create an easy way to sync with Aeries then my users will want to use Aeries Analytics which would be too bad as I know moodle has far more to offer. Any ideas would be very much appreciated
From what I"m reading, this should not be too hard. It's easy to export grades from moodle and Aeries takes them in various formats csv is one of them. I am just working on the details of the format Aeries needs and a way to automate it from moodle. I'm thinking right now of using phpmyadmin and creating a querry for grades and then every night importing them in but I have not done that and so am muddling through this right now. Hopefully this will help someone else who want to do this or with another system. I've seen it done with blackboard, Haiku LMS. Here's a link to what Aeries wants: http://help.aeries.com/aerieshelp/images/2/2a/Import_Grades.pdf
here's a link in moodle for grade exporting which might help http://docs.moodle.org/22/en/Grade_export
with detailed info here http://docs.moodle.org/dev/Gradebook_export
Here's an old link but talks about replication by the last user who did it successfully. I'm not sure what that means. But the idea is the same today as then: they are exporting from Moodle mysql to a sql database (aeries is a sql database). So maybe this will help.
http://moodle.org/mod/forum/discuss.php?d=49665
he provides some links which led me to 3 ways to do it none of which I'm familiar with - check here for the comparison: http://msdn.microsoft.com/en-us/library/bb902818%28SQL.110%29.aspx
basically, Remote Data Access (RDA), Merge Replication, and Microsoft Sync Framework.
If anyone knows about using those let me know.
cool, great link here at moodle showing exactly the commands he uses in mysql to dump the data. link here http://moodle.org/mod/forum/discuss.php?d=129901
I just got external authentication finally working after three weeks of dead-ends. Frankly, I don't have a frame of reference to even begin considering getting GBA/GBK synchronized with Moodle.
Careful not to mix oranges with grapes: they're talking about an entire Moodle installation with that forum link, not just grade data. Either a plug-in to grab information from AERIES and place into Moodle is needed (with either a CSV Export or final grade transfer to Aeries Browser Interface/Client) is needed, or an ASP.NET based solution is needed like the rest of ABI which is not a language I'm fluent in. (Just learned barely enough PHP to ask how to find a bathroom in Sweden.)
Unless Eagle Software steps up, I don't like the odds.