+ Post New Thread
Page 2 of 4 FirstFirst 1234 LastLast
Results 16 to 30 of 48
MIS Systems Thread, Accessing the SIMS database and querying it to retrieve information in Technical; Originally Posted by matt40k To be fair to them, it's one of those areas not many people use and unless ...
  1. #16

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,674
    Thank Post
    1,484
    Thanked 1,268 Times in 861 Posts
    Rep Power
    804
    Quote Originally Posted by matt40k View Post
    To be fair to them, it's one of those areas not many people use and unless you've used it, you won't know about it.
    That's fair enough - but it doesn't help me get hold of the documentation!

  2. #17

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,489
    Thank Post
    372
    Thanked 657 Times in 537 Posts
    Rep Power
    162
    One would hope they would be clever enough to go find out and get back to you - just like I had to do.

  3. #18

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,893
    Thank Post
    751
    Thanked 1,469 Times in 1,220 Posts
    Rep Power
    364
    So there are secret hidden commands within command reporter? I do hope they involve fixing dates, and time periods.

  4. #19

    Join Date
    Nov 2007
    Location
    Capita
    Posts
    19
    Thank Post
    15
    Thanked 11 Times in 9 Posts
    Rep Power
    16
    Losojos - ask your local support team to contact me directly and we will get it resolved quickly for you.

  5. Thanks to David_Grashoff from:

    LosOjos (10th October 2011)

  6. #20

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,674
    Thank Post
    1,484
    Thanked 1,268 Times in 861 Posts
    Rep Power
    804
    Quote Originally Posted by David_Grashoff View Post
    Losojos - ask your local support team to contact me directly and we will get it resolved quickly for you.
    Thanks David but I've got CLR sussed now. If you could possibly provide some info on the "Business Objects" however, that'd be incredibly useful...

  7. #21

    Join Date
    Nov 2007
    Location
    Capita
    Posts
    19
    Thank Post
    15
    Thanked 11 Times in 9 Posts
    Rep Power
    16
    same applies - ask your local support team to contact me directly with the SIMS areas that you wish to read or write.

  8. Thanks to David_Grashoff from:

    LosOjos (10th October 2011)

  9. #22

    Join Date
    Oct 2011
    Location
    United Kingdom
    Posts
    15
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by dunc View Post
    Hi all,

    Looking to develop a system (using PHP, which I'm confident with) which queries the SIMS database to retrieve attendance information.

    Does anyone have any suggestions as to where I can start? A tutorial, or the like? Or is it simply a case of finding the DB that SIMS is running on, getting a username&password, and querying it as you would with any other DB?

    Cheers,
    Duncan
    You should contact Capita and use one of their existing mechanisms (Command Line Reporter and Capita Business Objects I think) rather than querying the database directly - the database schema is susceptible to change and any changes could break your queries.

  10. #23

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,893
    Thank Post
    751
    Thanked 1,469 Times in 1,220 Posts
    Rep Power
    364
    Quote Originally Posted by LosOjos View Post
    Thanks David but I've got CLR sussed now. If you could possibly provide some info on the "Business Objects" however, that'd be incredibly useful...
    Quote Originally Posted by David_Grashoff View Post
    same applies - ask your local support team to contact me directly with the SIMS areas that you wish to read or write.
    I'd like all the documentation you have got please (for all areas) . . .

    Quote Originally Posted by hsimpson View Post
    You should contact Capita and use one of their existing mechanisms (Command Line Reporter and Capita Business Objects I think) rather than querying the database directly - the database schema is susceptible to change and any changes could break your queries.
    That is the direction being taken now (CLR).

  11. #24

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,489
    Thank Post
    372
    Thanked 657 Times in 537 Posts
    Rep Power
    162
    Quote Originally Posted by vikpaw View Post
    I'd like all the documentation you have got please (for all areas) . . .
    HAHAHA!!! That's like the head asking for all your documentation on your network - including that "Windows" thing. It's simply not possible. The document they send out about getting a connection and doing basic tasks is great, but completely pointless unless you invest the time learning. Capita provide good examples if you ask about doing a specific task, but again, you need to send the time fitting the bits together and smoothing the edges.

  12. #25

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,893
    Thank Post
    751
    Thanked 1,469 Times in 1,220 Posts
    Rep Power
    364
    Quote Originally Posted by matt40k View Post
    HAHAHA!!! That's like the head asking for all your documentation on your network - including that "Windows" thing. It's simply not possible. The document they send out about getting a connection and doing basic tasks is great, but completely pointless unless you invest the time learning. Capita provide good examples if you ask about doing a specific task, but again, you need to send the time fitting the bits together and smoothing the edges.
    It was offered so i asked. Nobody has ever said there is any documentation at all in the past.
    Maybe the lack of documentation hinders them as much as it hinders us!

  13. #26

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,489
    Thank Post
    372
    Thanked 657 Times in 537 Posts
    Rep Power
    162
    It documentated so a programmer would understand, the rest of us mere mortals have to ask for help.

  14. #27

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,674
    Thank Post
    1,484
    Thanked 1,268 Times in 861 Posts
    Rep Power
    804
    Quote Originally Posted by matt40k View Post
    It documentated so a programmer would understand, the rest of us mere mortals have to ask for help.
    No offence, but you shouldn't assume that because you don't understand it the rest of us won't either...

    EDIT: that's not to say that I'll understand it, but I'd at least like the chance! I'll be contacting my local support and asking them to contact @David_Grashoff for details soon
    Last edited by LosOjos; 11th October 2011 at 11:41 AM.

  15. #28

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,489
    Thank Post
    372
    Thanked 657 Times in 537 Posts
    Rep Power
    162
    I'm not saying you won't, I'm just saying it's not easy. It's not like most Capita stuff where they've got loads of documentation and great simple examples - it's not aimed at end-users it's aimed (C#) programmers, scripters (ie me) will need help and this isn't something you can post in the public domain - ie here. More then anything I'm saying good luck.
    Last edited by matt40k; 11th October 2011 at 02:18 PM.

  16. #29

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,893
    Thank Post
    751
    Thanked 1,469 Times in 1,220 Posts
    Rep Power
    364
    I think you underestimate how many programmers we have here, it may be difficult, but we've got a pretty good little clique of scripters here who i'm sure could muddle through things. I would imagine, anything that we produce here that helps access to the software is a good thing overall. I do see howerver, it needs keeping in check, so we aren't running around writing tools to hack into the system, which is then picked up by a mortal and it corrupts their system.

  17. #30

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,489
    Thank Post
    372
    Thanked 657 Times in 537 Posts
    Rep Power
    162
    I agree. Alot of people do repeat alot of work and we do need to get people grouped together and organised so we have a single "free" solution that uses the best method rather then having a lot of crooked methods. I don't think a public forum would be best place for this as you would be posting copyright material that isn't allowed in the public domain. If EduGeek\SupportNet had a private area so we could have a community effort, where people are vetted, I would be happy to help out and I'm sure a lot of others would. No one wants to work on a project that gets shutdown midway through because of copyright.

    Ideally I would see it as a private forum which someone has to approve the user (so we know who they really are and they will actually help the community project), a private SVN\Git repository (and ideally a build server), a ticket system for logging bugs\problems and a public forum. And of course Edugeek to host the final install files I would hope Capita would commit some sort of resource towards this, such as a x no of dev hours beyond support and ideally a separate support contract - indepent of our individual schools\la - just so they could track how much resources we've used more than anything.

    Ideally we want to move away from people using SQL scripts to pull data right out of the database and the first option should be, and always be, the report engine followed by the business objects. SIMS reports are easy, quick and safe to edit by all SIMS users and therefore business objects should be used as a last resort, not because you can.

    Sorry if it sounds like I'm negative towards the idea, I'm really not, I'm really pro a community idea it's just I want to do it right and not a half heart attempt which only serves a few individual agendas.



SHARE:
+ Post New Thread
Page 2 of 4 FirstFirst 1234 LastLast

Similar Threads

  1. script to rename computer and join it to domain ...
    By RabbieBurns in forum Scripts
    Replies: 22
    Last Post: 2nd May 2013, 12:08 PM
  2. [SIMS] move sims db and log files to different partitions
    By ful56_uk in forum MIS Systems
    Replies: 7
    Last Post: 28th April 2011, 06:16 PM
  3. Script Help - Query AD and add it to a reg key
    By Stuart_C in forum Scripts
    Replies: 6
    Last Post: 14th May 2010, 07:04 PM
  4. Creating Home Folder.. and getting it to map for users
    By dgrams in forum How do you do....it?
    Replies: 16
    Last Post: 26th February 2010, 06:15 PM
  5. Restrict where student from accessing the C drive and Server
    By laputa01 in forum How do you do....it?
    Replies: 2
    Last Post: 1st May 2009, 11:56 AM

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
  •