+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 18
MIS Systems Thread, SIMS 3rd Party Access Documentation in Technical; hi there i would really love to get some the documentation for the 3rd party access commands. specifically commandreporter and ...
  1. #1

    Join Date
    Jun 2007
    Location
    St Marylebone School
    Posts
    13
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    SIMS 3rd Party Access Documentation

    hi there

    i would really love to get some the documentation for the 3rd party access commands. specifically commandreporter and osql. the osql uses sql and so a the spec of the tables and their relationships would be absolutely tops.

    anybody any ideas? i think these seem to be so hard to come by, but would so useful and powerful if they were used

    thanks

    pete

  2. #2

    Join Date
    Mar 2007
    Posts
    323
    Thank Post
    6
    Thanked 7 Times in 6 Posts
    Rep Power
    17
    Sorry, im not sure what your trying to do?

  3. #3

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,653
    Thank Post
    1,258
    Thanked 781 Times in 678 Posts
    Rep Power
    236
    i would really love to get some the documentation for the 3rd party access commands. specifically commandreporter and osql. the osql uses sql and so a the spec of the tables and their relationships would be absolutely tops.
    There really isn't all that much to document. The CommandReporter tool should give you a list of parameters when you run it with no commandline options. You need to set up a report in SIMS for it to run beforehand - you can import existing reports with the CommandReporterImporter tool. I've written a couple of SIMS reports and server-side Perl scripts (the scripts literally call CommandReporter to run a report, then spew the XML data received back over the requesting HTTP connection) to help us synch our SIMS database with our LDAP server, i.e. a simple script that turns CommandReporter into a get-XML-report-X REST function call. I've also got a semi-finished client-side Perl script that parses the information it gets from SIMS to match up with LDAP (I've got it adding records, I need to get it to update them properly).

    I'm sorry, I don't know what OSQL is, but the structure of the SQL database that SIMS uses is propriatory, and Capita don't like you examining it. After 15 or 20 years of moving from platform to platform and implementation to implementation, I'm sure the word "hairy" doesn't do the SIMS database structure justice.

    --
    David Hicks

  4. #4
    fooby's Avatar
    Join Date
    Dec 2005
    Posts
    351
    Thank Post
    0
    Thanked 5 Times in 4 Posts
    Rep Power
    19
    let me get a shovel.... i have that documentation somewhere.....

    please see attached zip with CHM compressed inside. Remember to extract it to a local drive as a CHM will not run from a UNC path or mapped drive letter.

    @David
    I would be interested to see the results of your sims > ldap work. We are investigating this but would want class groups created as security / distribution groups in active directory.

    Edit - Removed due to request received. Anyone school wanting a copy should contact their LEA Support Team. Companies should contact the original poster. We apologise for any inconvenience cause - Diello.
    Last edited by Diello; 30th December 2008 at 04:36 PM. Reason: OP Request

  5. #5

    Join Date
    Feb 2008
    Posts
    23
    Thank Post
    3
    Thanked 4 Times in 4 Posts
    Rep Power
    14
    Hi

    I am trying to use Third Party Reporting to fetch XML data from SIMS and then display it on our intranet using asp/php.

    I'm not brilliantly up on networking stuff, is this possible, how would I go about it?

    Will SIMS need to installed on the intranet server?

    Thanks,

    Will

  6. #6

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,653
    Thank Post
    1,258
    Thanked 781 Times in 678 Posts
    Rep Power
    236
    Quote Originally Posted by Willzzz View Post
    I am trying to use Third Party Reporting to fetch XML data from SIMS and then display it on our intranet using asp/php.
    First, there should be a special user in SIMS just to run with the CommandReporter tool. It's something obvious like user "commandreporter" or something. Log in as that user, create a report that produces whatever information you want. Then use the commandreporter command-line tool to run that report - you'll see it spew a bunch of XML out to the console. Next, wrap that command line in a program that takes that output from the command line and sends it over the network somehow - easieest way to do it is probably write some kind of web-based script so that visiting http://yourSIMSServer/theReportName.asp or whatever simply gets you that XML returned from the CommandReporter tool. Then write software that calls that URL appropriately.

    I'm currently very busy trying to sort this exact problem out on our system, I'll probably move the data extraction tool to a small self-contained Python web server. It'll be a little while until I can get this all neatly packaged and sorted out, though.

    --
    David Hicks

  7. #7

    Join Date
    Aug 2006
    Posts
    5
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Corrupt ZIP

    Hi,

    Came across this and thought it would be a good method for us to link our Active Directory sync utility to SIMS. Can you repost the zip file again, as this version appears to be corrupt.

    Thanks!

  8. #8

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    Extract it to your desktop, then open it, it needs to be locally saved.

  9. #9

    Join Date
    Aug 2006
    Posts
    5
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Corrupt Zip

    Thanks for the quick response. I understood the instructions in the previous posts. My problem is that the zip file once downloaded will not unpack. On two different systems using winrar, winzip and XP built in, errors in the zip file are reported.

    Can anyone let me have a clean up-to-date copy of this SDK?

    Thanks

  10. #10

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    Try this.

    Remember, you can't distribute it outside of your school without expressed written consent from Mr Capita. You have been warned!

    Edit - Removed due to request received. Anyone school wanting a copy should contact their LEA Support Team. We apologise for any inconvenience cause - Diello.
    Last edited by Diello; 30th December 2008 at 04:38 PM. Reason: Request Received

  11. #11

    Join Date
    Jul 2009
    Posts
    3
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hey,

    I try to access sims database but cannot find documentation for it. Can you help with that?

    Nick

  12. #12

    russdev's Avatar
    Join Date
    Jun 2005
    Location
    Leicestershire
    Posts
    6,930
    Thank Post
    709
    Thanked 552 Times in 367 Posts
    Blog Entries
    3
    Rep Power
    204
    You need to contact Capita or your local support team...

    Commandline reporter stuff is free but the business objects requires a license which you pay for.

    Russ

  13. #13

    Join Date
    Jul 2009
    Posts
    3
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi Russ,
    thank you for your replay.

    where can I find more info about command line reporter stuff?
    Do you know some links?

    Nick

  14. #14

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    Ask your Local SIMS Support Team for the SIMS.net Third Party Reporting SDK. If your not a school then: SIMS partners introduction - Capita Children's Services

  15. Thanks to matt40k from:

    niki_yakov (30th July 2009)

  16. #15

    Join Date
    Jul 2009
    Posts
    3
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi matt40k,

    thank you very much. This will help.

    Regards,
    Nick

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

Similar Threads

  1. SIMS SQL access and capita problems
    By the_travisty in forum MIS Systems
    Replies: 6
    Last Post: 29th August 2008, 11:53 AM
  2. SIMS: Third Party access SDK documentation
    By peterteckhokgoh in forum MIS Systems
    Replies: 1
    Last Post: 14th August 2007, 10:50 AM
  3. SIMS - VPN Access
    By Buzz in forum Educational Software
    Replies: 6
    Last Post: 12th July 2007, 04:46 PM
  4. GPO or Third Party Solution
    By edsa in forum Network and Classroom Management
    Replies: 7
    Last Post: 16th April 2007, 08:09 PM
  5. Sims Documentation
    By Pear in forum MIS Systems
    Replies: 16
    Last Post: 23rd January 2006, 02:47 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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