+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 27
MIS Systems Thread, [SIMS] Java API for Command Reporter in Technical; I don't think it's been mentioned here yet, but for those of you that don't frequent SupportNet, something of interest... ...
  1. #1

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349

    [SIMS] Java API for Command Reporter

    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

  2. 2 Thanks to vikpaw:

    dhicks (13th June 2010), LosOjos (14th June 2010)

  3. #2
    rh91uk's Avatar
    Join Date
    Sep 2008
    Location
    UK
    Posts
    871
    Thank Post
    137
    Thanked 132 Times in 114 Posts
    Rep Power
    35
    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!)

  4. #3

    Join Date
    Jun 2010
    Posts
    66
    Thank Post
    1
    Thanked 6 Times in 5 Posts
    Rep Power
    16
    Hi,

    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.

  5. Thanks to bantonia from:

    LosOjos (14th June 2010)

  6. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    bill :O)
    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.

  7. #5

    Join Date
    Jun 2010
    Posts
    66
    Thank Post
    1
    Thanked 6 Times in 5 Posts
    Rep Power
    16
    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

  8. #6

    Join Date
    Jun 2010
    Posts
    66
    Thank Post
    1
    Thanked 6 Times in 5 Posts
    Rep Power
    16
    Just tested the "Ping" method to Moodle using:
    https://secure.linuxbox.com/tiki/tik...=moodle_xmlrpc

    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.

  9. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    Quote Originally Posted by bantonia View Post
    Just tested the "Ping" method to Moodle using:
    https://secure.linuxbox.com/tiki/tik...=moodle_xmlrpc

    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.
    welcome to the joys of edugeek, you're fitting in nicely

  10. #8

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,432
    Thank Post
    1,432
    Thanked 1,160 Times in 794 Posts
    Rep Power
    705
    This definitely looks interesting, bit swamped at the minute but I will get around to having a look at it soon

  11. #9

    Join Date
    Jun 2010
    Posts
    66
    Thank Post
    1
    Thanked 6 Times in 5 Posts
    Rep Power
    16
    Hi,

    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.

    I used:
    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.

  12. #10

    Join Date
    Jun 2010
    Posts
    66
    Thank Post
    1
    Thanked 6 Times in 5 Posts
    Rep Power
    16
    Changed tack, working on SIMS->Moodle 2 using the REST protocol embedded in Moodle 2. Thought why develop for Moodle 1.9.x

  13. #11

    Join Date
    Feb 2010
    Location
    Bedforshire
    Posts
    20
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi,
    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)

  14. #12
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    922
    Thank Post
    56
    Thanked 161 Times in 113 Posts
    Rep Power
    67
    You can write databack into SIMS.net if you used SIF. You could have data following between systems using one common API.

  15. #13

    Join Date
    Jun 2010
    Posts
    66
    Thank Post
    1
    Thanked 6 Times in 5 Posts
    Rep Power
    16
    Hi cgilmour
    Are you running the server side part of the RMI software and modified the environment paths as in the instructions?

  16. #14

    Join Date
    Jun 2010
    Posts
    66
    Thank Post
    1
    Thanked 6 Times in 5 Posts
    Rep Power
    16
    Quote Originally Posted by penfold_99 View Post
    You can write databack into SIMS.net if you used SIF. You could have data following between systems using one common API.
    Could you point me to SIF.

  17. #15
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    922
    Thank Post
    56
    Thanked 161 Times in 113 Posts
    Rep Power
    67
    Quote Originally Posted by bantonia View Post
    Could you point me to SIF.
    The SIF community is here 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.

  18. Thanks to penfold_99 from:

    bantonia (25th June 2010)

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. [SIMS] Command reporter paramters [Solved]
    By browolf in forum MIS Systems
    Replies: 5
    Last Post: 19th August 2011, 11:02 AM
  2. [SIMS] SIMs and Command Reporter
    By RuAware in forum MIS Systems
    Replies: 43
    Last Post: 25th February 2011, 06:57 PM
  3. [Sims] Command reporter working examples
    By browolf in forum MIS Systems
    Replies: 3
    Last Post: 1st July 2010, 12:45 PM
  4. command reporter permissions
    By browolf in forum MIS Systems
    Replies: 5
    Last Post: 21st May 2010, 03:56 PM
  5. urgent: Sims.net command line reporter (CLR)
    By russdev in forum MIS Systems
    Replies: 2
    Last Post: 20th September 2007, 02:00 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •