+ 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 3 Times in 1 Post
    Rep Power
    8

    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 487 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
    5,589
    Thank Post
    638
    Thanked 1,305 Times in 1,088 Posts
    Rep Power
    336
    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,826
    Thank Post
    104
    Thanked 449 Times in 308 Posts
    Blog Entries
    2
    Rep Power
    262
    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
    5,589
    Thank Post
    638
    Thanked 1,305 Times in 1,088 Posts
    Rep Power
    336
    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
    48
    Thank Post
    18
    Thanked 4 Times in 3 Posts
    Rep Power
    11
    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,182
    Thank Post
    1,285
    Thanked 1,029 Times in 729 Posts
    Rep Power
    658
    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 3 Times in 1 Post
    Rep Power
    8
    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,134
    Thank Post
    352
    Thanked 577 Times in 474 Posts
    Rep Power
    142
    What does it need to end up in?

  10. #10

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,182
    Thank Post
    1,285
    Thanked 1,029 Times in 729 Posts
    Rep Power
    658
    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 3 Times in 1 Post
    Rep Power
    8
    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 3 Times in 1 Post
    Rep Power
    8
    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 3 Times in 1 Post
    Rep Power
    8
    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
  •