+ Post New Thread
Results 1 to 11 of 11
MIS Systems Thread, SIMS backend in Technical; Has anyone tapped into the backend of SIMS or know any nifty SQL statements to get any data? I know ...
  1. #1

    TechMonkey's Avatar
    Join Date
    Dec 2005
    Location
    South East
    Posts
    3,286
    Thank Post
    225
    Thanked 405 Times in 302 Posts
    Rep Power
    162

    SIMS backend

    Has anyone tapped into the backend of SIMS or know any nifty SQL statements to get any data?
    I know it's frowned upon by Capita, but I want to create a reporting (as in behaviour) web app to allow staff to quickly send a form to tutors, HoH and Pastoral but don't want to have to keep exporting CSV data from SIMS.
    Have looked within the database and it is very nasty and no real way to tell what is what without a map!

    So anyone been where no sane foot has trod before?

  2. #2
    woody's Avatar
    Join Date
    Jun 2005
    Location
    Carlisle, Cumbria
    Posts
    617
    Thank Post
    3
    Thanked 17 Times in 15 Posts
    Rep Power
    22

    Re: SIMS backend

    I have thought of this although I have no sql knowledge. My brother has written his own web front ends to their MIS which is Facility. But when it comes to SIMS, well that's a whole different story!

  3. #3
    StewartKnight's Avatar
    Join Date
    Jun 2005
    Posts
    1,587
    Thank Post
    2
    Thanked 27 Times in 21 Posts
    Rep Power
    30

    Re: SIMS backend

    your poor brother! is he having to use CMIS Mark!!!

  4. #4
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,427
    Thank Post
    10
    Thanked 488 Times in 428 Posts
    Rep Power
    111

    Re: SIMS backend

    Quote Originally Posted by TechMonkey
    Has anyone tapped into the backend of SIMS or know any nifty SQL statements to get any data?
    I know it's frowned upon by Capita, but I want to create a reporting (as in behaviour) web app to allow staff to quickly send a form to tutors, HoH and Pastoral but don't want to have to keep exporting CSV data from SIMS.
    Have looked within the database and it is very nasty and no real way to tell what is what without a map!

    So anyone been where no sane foot has trod before?
    Don't you need a special license from Capita to access the database? Even Bromcom have to use the sims client api calls (thats why you need to keep .net updated on your bromcom server).

  5. #5

    Join Date
    Oct 2005
    Location
    Solihull
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: SIMS backend

    The only real way of doing it is to use the api's as capita make changes based on everybody using the api's. If you go in via another route you WILL loose any support you get for sims so be warned.

  6. #6
    woody's Avatar
    Join Date
    Jun 2005
    Location
    Carlisle, Cumbria
    Posts
    617
    Thank Post
    3
    Thanked 17 Times in 15 Posts
    Rep Power
    22

    Re: SIMS backend

    @Stewart

    Why do you think My brother has re-written the front end? It would be interesting to see how The owners of facility feel about such a thing.

  7. #7

    TechMonkey's Avatar
    Join Date
    Dec 2005
    Location
    South East
    Posts
    3,286
    Thank Post
    225
    Thanked 405 Times in 302 Posts
    Rep Power
    162

    Re: SIMS backend

    Well I take it that it is our data on our servers so shouldn't be held back from us. Maybe simplistic though. I am currently using the enterprise front end to have a poke around but the table structures and views are a nightmare!
    Also I am not wanting to change any data, just retrieve it to display in a form I want, again seems ludicrous that we can't access our data. I know it is possible as I got given a web page system that could retrieve timetables for staff and kids by referencing the AD against the database. Works wonderfully after a few changes.
    Maybe I'll get the sims guy here to ask a question up the support line.

    Ta though.

  8. #8
    woody's Avatar
    Join Date
    Jun 2005
    Location
    Carlisle, Cumbria
    Posts
    617
    Thank Post
    3
    Thanked 17 Times in 15 Posts
    Rep Power
    22

    Re: SIMS backend

    Well, if anyone comes across anything that can be used to pull of timetables etc in a browser, that would be really useful.

  9. #9

    TechMonkey's Avatar
    Join Date
    Dec 2005
    Location
    South East
    Posts
    3,286
    Thank Post
    225
    Thanked 405 Times in 302 Posts
    Rep Power
    162

    Re: SIMS backend

    The timetable one I got given was OK but relied on you going through and adding the Unique SIMS ID into an AD field. I managed to adjust the Staff timetable one to pull out staff code, which is in SIMS and our AD but Students weren't going to be as easy.
    But you really don't want to see the SQL needed to do all that! 8O

  10. #10
    projector1's Avatar
    Join Date
    Nov 2005
    Posts
    460
    Thank Post
    70
    Thanked 1 Time in 1 Post
    Rep Power
    18

    Re: SIMS backend

    create a reporting web app? take a loook at seagate crystal report writer, this will sit on top of any database and extract the data and create simple to very complex reports.
    i think capita use crystal report writer for their reporting function

  11. #11
    u8dmtm's Avatar
    Join Date
    Feb 2006
    Posts
    231
    Thank Post
    7
    Thanked 13 Times in 12 Posts
    Rep Power
    20

    Re: SIMS backend

    SIMS.Net is just an SQL Server database but they say you must use Business Objects to integrate from your own .Net applications. That said, you can see the SQL database from any .Net project - but this is unsupported and risky. I have always wanted to do the above but have in the end resorted to the annoying but acceptable method of doing reports from Sims.net for the data I want and then importing that data into my own system. I am looking into the possibility of doing scheduled XML reports linked to a system that then subsequently schedules an import from those XML reports - a kind of stepping stone which assures you don't break SIMS.

SHARE:
+ Post New Thread

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
  •