Sorry, im not sure what your trying to do?
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
Sorry, im not sure what your trying to do?
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 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.
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.
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.
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
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?
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.
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.
Extract it to your desktop, then open it, it needs to be locally saved.
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?
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
I try to access sims database but cannot find documentation for it. Can you help with that?
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.
thank you for your replay.
where can I find more info about command line reporter stuff?
Do you know some links?
niki_yakov (30th July 2009)
thank you very much. This will help.
There are currently 1 users browsing this thread. (0 members and 1 guests)