I don't think it's been mentioned here yet, but for those of you that don't frequent SupportNet, something of interest...
A java based API for SIMS Command Reporter just published.
Schools forums --> Technical (67) --> Direct access to SQL database (26375)
SourceForge.net: SIMS CommandReporter Java API - Project Web Hosting - Open Source Software
I speak to Bill quite a lot (who wrote that) ..... hes a good guy and willing to help out. Got some good ideas. Will point him to this thread!
I plan to try this sometime next week (been wanting to for ages but haven't had the time!)
Just joined edugeek, hello all.
If you have any questions about the software please do not hesitate to contact me.
I know the software has been downloaded but as yet I have had no feedback of any successes or otherwise, all I know it works for me.
LosOjos (14th June 2010)
good to have you here.
i've downloaded it, but having the time to do something with it is something completely different.
i think @losojos: may be interested as he has a little tool for making a photo database, that uses commandreporter, so this could fit in nicely to make it more easily shared.
Last edited by vikpaw; 14th June 2010 at 09:27 AM.
Just a thought, obviously CommandReporter.exe only gets data from SIMS, wouldn't it be nice if Capita would write command line tools which would write data to SIMS, at least to "Assessment" and "UDF" anyway, areas which were already set up such as as aspects, resultsets and udf. Should not be too difficult and it would alleviate some dissatisfaction for those wanting to integrate their systems.
Also, haven't tried to use my software to download images so that aspect is untested, hmmmmm........ Let me know if it works or otherwise.
Last edited by bantonia; 12th June 2010 at 05:13 PM. Reason: Added text
Just tested the "Ping" method to Moodle using:
together with Java xml-rpc library from:
ws-xmlrpc - Apache XML-RPC
So, connecting to commandreporter.exe and using the above I should be able to create Classes and Users in Moodle directly from SIMS. Also, the software I've written could be cut down to be able to execute any .bat or .exe file remotely, in fact that's where it started, so new accounts can be created within the MS Windows domain. I think there is some work to do here.
This definitely looks interesting, bit swamped at the minute but I will get around to having a look at it soon
Just an update:
In the early stages but have created Java software which reads the SIMS database via the commandreporter tool which transfers data to Moodle. It currently creates courses with the same name as those in SIMS, creates user accounts and adds roles to the users of "student" and "teacher" within those courses.
Moodle XMLRPC module | The Linux Box
as the basis for the Moodle server end of the xmlrpc calls but have had to edit the code fairly extensively to get it working due to deprecated calls.
Still have to add the code to un-enrol users from the courses created from SIMS which are no longer in that class.
Overall, the idea is to use these as child courses which can be added to the main courses for enrolment. It may also be possible later, once child courses have been added to the main courses to automatically add populated groups of the same name within the main courses. I hope this makes sense!
My only addition to the SIMS database is to create UDF's for both students and staff to contain their username for the network.
Gradual progress, but does exercise the brain cells.
Changed tack, working on SIMS->Moodle 2 using the REST protocol embedded in Moodle 2. Thought why develop for Moodle 1.9.x
I've gone through the instructions for installing the SDK and netbeans software then amended and compiled the java code but and ran the CommandReportServer without exceptions ...not sure what parameter to pass in for the simple report I created so
I've created in SIms under "My Reports" a report called christest but with the relevant line amended as follows:-
cr.setCommandReport("commandreporter /user:myuid /password:mypass /report:christest /quiet");
but when I clean compaile and then run I get the following error - any ideas where I should be looking?
Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
at net.beaconhillcott.CommandReportServerImpl.execute Command(CommandReportServerImpl.java:136)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
at sun.rmi.transport.Transport$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport.handleMessages( Unknown Source)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandl er.run0(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandl er.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source)
at java.lang.Thread.run(Unknown Source)
at sun.rmi.transport.StreamRemoteCall.exceptionReceiv edFromServer(StreamRemoteCall.java:255)
at sun.rmi.transport.StreamRemoteCall.executeCall(Str eamRemoteCall.java:233)
at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:1 42)
at java.rmi.server.RemoteObjectInvocationHandler.invo keRemoteMethod(RemoteObjectInvocationHandler.java: 178)
at java.rmi.server.RemoteObjectInvocationHandler.invo ke(RemoteObjectInvocationHandler.java:132)
at $Proxy0.executeCommand(Unknown Source)
at net.beaconhillcott.CommandReporter.execute(Command Reporter.java:229)
at net.beaconhillcott.CommandReportViewer.<init>(Comm andReportViewer.java:30)
at net.beaconhillcott.CommandReportViewer$1.run(Comma ndReportViewer.java:89)
at java.awt.event.InvocationEvent.dispatch(Invocation Event.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java: 597)
at java.awt.EventDispatchThread.pumpOneEventForFilter s(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(E ventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarch y(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispa tchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispa tchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThre ad.java:122)
You can write databack into SIMS.net if you used SIF. You could have data following between systems using one common API.
Are you running the server side part of the RMI software and modified the environment paths as in the instructions?
Welcome to the SIF Association there are currently 2 moodle SIF agents for moodle avaliable, one does basic course creation and enrolment and the other does course creation, enrolment, groups management and parental egagement.
bantonia (25th June 2010)
There are currently 1 users browsing this thread. (0 members and 1 guests)