+ Post New Thread
Results 1 to 13 of 13
MIS Systems Thread, SIMS SQL Databse Tables in Technical; Hi all, Long shot I know, but would any of you have a list of the Tables in the SIMS ...
  1. #1
    Grazza's Avatar
    Join Date
    Jun 2010
    Location
    Walsall
    Posts
    34
    Thank Post
    2
    Thanked 4 Times in 1 Post
    Rep Power
    9

    SIMS SQL Databse Tables

    Hi all,

    Long shot I know, but would any of you have a list of the Tables in the SIMS SQL database and what they are used for?

    Regards

    Graham

  2. #2
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 490 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by Grazza View Post
    Hi all,

    Long shot I know, but would any of you have a list of the Tables in the SIMS SQL database and what they are used for?

    Regards

    Graham
    I doubt anyone apart from Capita has as there are hundreds and hundreds of them!

    Connect to a SIMS database via Management Studio and you can see all the tables, their names may give hints as to what they are for.

  3. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    It doesn't always make sense. I've knocked together a few select statements and joined tables together, but it's not easy.
    Depends what you want to do. I'm sure their technical partners have a good idea for their particular area.

  4. #4

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,990
    Thank Post
    114
    Thanked 506 Times in 341 Posts
    Blog Entries
    2
    Rep Power
    286
    Don't use tables directly. We've seen recently how they can be reorganised and change with upgrades. Tables come and go, and change: If you base queries on tables expect to have the rug pulled from under your feet at any upgrade,

    Views, however, are a safer bet. A view is a kind of virtual table, which appers like a table but can be made up of one table, or many tables joined together. These tend to change infrequently, so are a much more stable way of looking at data. As an added bonus, SIMS have named the views sensibly (by and large) so you can get the gist of what they represent from their names.

    Be aware that there's a lot of obsolete junk in there too. Core Integrator tables, anyone?
    Last edited by jinnantonnixx; 11th December 2013 at 09:53 AM.

  5. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    The problem I've had with views is that you can't modify data. Obviously not an issue with SIMS cos you wouldn't dare touch it.

  6. #6

    Join Date
    Feb 2009
    Location
    Oldham, UK
    Posts
    50
    Thank Post
    21
    Thanked 4 Times in 3 Posts
    Rep Power
    12
    Capita don't allow to touch the tables and it is very hard naming structure. Every update make changes as well. I think you need developer licence to work on SIMS database directly someone mentioned in past not sure.

  7. #7

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,498
    Thank Post
    1,456
    Thanked 1,201 Times in 814 Posts
    Rep Power
    712
    Depending on what it is you're trying to do, you may find that CommandReporter is enough. It's not live data I know, but it is at least a Capita approved extraction method that won't land your school a huge consultancy bill should things go wrong. I have seen you're already usin g it, but maybe some of these threads will help you get what you want from it:

    SIMS.net Reporting
    executing CommandReporter from scripts
    Command Reporter and Filtering Reports
    CLR /Params String

    (I really need to start keeping an index of the best CLR threads!)

  8. #8
    Grazza's Avatar
    Join Date
    Jun 2010
    Location
    Walsall
    Posts
    34
    Thank Post
    2
    Thanked 4 Times in 1 Post
    Rep Power
    9
    I've had an issue with Command Line Report.
    I have a report that is TAB delimited, which worked fine in SIMS itself.
    When I use CommandLine Reporter it extracts it as a CSV which is useless to me!

    I've sent an email to the Capita Business Manager to try and get this sorted.
    All I need to do is read Students, Staff, Classes they are in and The students SEN info.

    I've already managed to load the SIMS Database into Visual Studio, but the Tables are endless ! Was much easier in dBase :-)

  9. #9

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    What does it need to end up in?

  10. #10

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,498
    Thank Post
    1,456
    Thanked 1,201 Times in 814 Posts
    Rep Power
    712
    Quote Originally Posted by Grazza View Post
    I've had an issue with Command Line Report.
    I have a report that is TAB delimited, which worked fine in SIMS itself.
    When I use CommandLine Reporter it extracts it as a CSV which is useless to me!
    Did you try the script I posted in that thread? If you just change the file tpye on the SaveAs line to TSV, that should do it. It's an extra step you could do without I know, but it's worked well for me when I've had problems with the format of CLR's output

  11. Thanks to LosOjos from:

    Grazza (11th December 2013)

  12. #11
    Grazza's Avatar
    Join Date
    Jun 2010
    Location
    Walsall
    Posts
    34
    Thank Post
    2
    Thanked 4 Times in 1 Post
    Rep Power
    9
    TAB delimited it's because the text I need contains commas.

  13. #12
    Grazza's Avatar
    Join Date
    Jun 2010
    Location
    Walsall
    Posts
    34
    Thank Post
    2
    Thanked 4 Times in 1 Post
    Rep Power
    9
    Quote Originally Posted by LosOjos View Post
    Did you try the script I posted in that thread? If you just change the file tpye on the SaveAs line to TSV, that should do it. It's an extra step you could do without I know, but it's worked well for me when I've had problems with the format of CLR's output
    Yes I did thank you, it was very easy and stripped out the "

    I will alter the script and see what I can do, thanks

  14. #13
    Grazza's Avatar
    Join Date
    Jun 2010
    Location
    Walsall
    Posts
    34
    Thank Post
    2
    Thanked 4 Times in 1 Post
    Rep Power
    9
    Sorted, got the script saving as Tab now, so I'm going to run CommandLine Reporter and then your Script for now, until I can get some table information.

    Thanks
    Graham

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS SQL 2008 Migration
    By Nik in forum MIS Systems
    Replies: 8
    Last Post: 13th February 2011, 10:26 PM
  2. [SIMS] SIMS SQL Version...
    By IKWeb in forum MIS Systems
    Replies: 30
    Last Post: 12th February 2011, 08:25 AM
  3. [SIMS] SIMS SQL 2008 - How much memory do you have allocated?
    By Max_Power in forum MIS Systems
    Replies: 15
    Last Post: 5th December 2010, 09:02 AM
  4. [SIMS] SIMS SQL 2005 --> 2008 migration
    By cookie_monster in forum MIS Systems
    Replies: 7
    Last Post: 29th July 2010, 02:24 PM
  5. SIMS SQL Server Table Documentation
    By peterteckhokgoh in forum MIS Systems
    Replies: 7
    Last Post: 23rd May 2008, 11:36 AM

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
  •