MIS Systems Thread, SIMS Learning about SQL and Writing basic Scripts in Technical; Hi All
I'm currently a data manager but one of the things I will love to do is understand how ...
10th October 2013, 10:35 PM #1
SIMS Learning about SQL and Writing basic Scripts
I'm currently a data manager but one of the things I will love to do is understand how the SIMS SQL database work and possibly learn how to write basic scripts using commandreporter and maybe one day be able to write small scripts that enables me to do things I'm unable to do. Plus it would help me career wise as high paying Data Manager roles are asking for experience with SQL and I may end up changing careers and become a programmer.
I just wanted to ask:
* is there documentation/ what programming language do I need to write scripts in commandreporter
* do you think the SIMS Technical courses on Installing and Configuring the SQL database useful for me to attend with me only having data management knowledge
* What advice or stuff or training could I do if I'm interested in doing the more technical stuff with SIMS or looking to possibly become a programmer in the future
Thanks for your advice
IDG Tech News
11th October 2013, 09:01 AM #2
Command Reporter just runs a report designed in the SIMS system and outputs the results to CSV I think. You can't interact directly with the database though.
11th October 2013, 09:06 AM #3
Doesn't Capita jealously guard access to the actual database? $$$$$?
I have seen the database and I can't say it was structured or named in a way that would make it easy to figure out. I think you'd need Capita's API's and reference manuals to be able to do anything more than can already be done through the built in Reports system.
11th October 2013, 09:45 AM #4
You 'can' access the database through SQL management studio and run various queries against it, but any modifying of data, tables etc is a strict no no! If yo do this, cause problems and go to Capita, they will either not help or charge you a huge amount in consultancy fees to correct it!
Originally Posted by tmcd35
Capita do a programming course in C++ where they show you how to use their API's to create various little handy programs and the like. However I believe it's not cheap.
11th October 2013, 09:47 AM #5
If you want to access the database directly, you need to purchase a developer's contract (or whatever they call it). This gives access to the documentation and API details plus it covers the extra support given to developers by the Capita support teams.
11th October 2013, 10:23 AM #6
Work your way through the w3school course for a good grounding in SQL.
The key to understanding how the SIMS database is threaded together is by looking at the views they've built. These views draw together the underlying tables of the database. Examining the diagrams of these views will show you how the data is organised.
It goes without saying that you should never experiment with a live database.
Last edited by jinnantonnixx; 11th October 2013 at 10:25 AM.
11th October 2013, 10:30 AM #7
Within your role there will likely be plenty for scope for using VBA in excel to perform/automate data analysis. That is a reasonable way to learn some programming basics while you are at work. You will though develop bad habits.
Originally Posted by chrisateen
Have a look at something like Arduino and do a bit of low level interfacing. It will help consolidate your programming and give you some experience of development for embedded devices.
Consider the OU courses available and look to get a qualification that includes programming modules. (I would strongly urge you to do this if you seriously want a career in software development).
If you want to take an unqualified route, apply for jobs with software houses in support or testing. Those roles can be entry points into development. MIS suppliers might be a good target :-)!
11th October 2013, 04:25 PM #8
Yeah I read online that to be able to have read/write permissions you need to purchase a very expensive license from Capita. I'm sure they do this to limit the competition as being able to modify the database opens up a lot of opportunities to develop programs and have less of a need to purchase packages from SIMS. But still I won't mind learning how use command reporter to run certain queries. (For example I would like to create a program that exports student photographs in JPEG file and naming each photo file by the student name or admission number)
Originally Posted by CAM
What I would have done if I had access to the server is make a copy of the database and run SIMS on a standalone computer and do what i want to do with it without it affecting the live database. then if everything goes wrong I can delete it make another copy of the live database e.t.c
Originally Posted by Rawns
Is there a way I can access the SQL database on a Client Machine? (I'm guessing the answer to this is no)
Sound like a good course which i would love to do but i don't think I'm in a school where they will be willing to pay for it after what happened when I started here 2 months ago.
Thanks for the advice. I did learn VB at college and now I totally forgot how to write in VB. Recently I have started to learn VBA and SQL (I like how logical the sql language is and its so easy to read and understand) but i have heard that coding in VBA leads to bad habits. I even wanted to apply for an MSc in Computer Science for people with a degree in a completely different subject and was hoping that my new job will sponsor it but with what happened when I first started and with me not being happy in my new job I'm now reluctant to ask.
Originally Posted by pcstru
I'm starting to think that schools are not open to change and well behind on modern technology plus most managers I work with have no clue and too stuck in their own ways and hate ideas that make sense. I'm starting to doubt whether I should continue as a data manager but the fact I had a 2.2 degree, will have to do a Masters (which costs £9k) plus I will have to take a salary cut to break into the industry is making me question if i should change careers. Plus if I can find right school that allows Data Managers to do more technical stuff then I will be happy (hoping to do this in my new role but i don't think it's happening anymore)
14th October 2013, 11:11 AM #9
I think in this case Capita do genuinely stop people from tinkering with the database directly because it does have potential to utterly trash the system. The dev licences aren't targeted at schools anyway but at industry where the money from the finished product will exceed the licence cost.
I know how you feel as I wouldn't mind a bit of raw database experience for a possible future industry move. But TBH, data managers tend to be left to their own devices giving lots of room for self-CPD which makes work easier as a bonus when you apply it to the job.
14th October 2013, 12:00 PM #10
Have you tried SQL Reporting Services in BIDS (Business Intelligence Development Studio) - that is what we use to access the iSAMS SQL database. If you are not comfortable writing from scratch, you can take an existing extract / report and clone it, alter it and deploy it.
14th October 2013, 12:18 PM #11
SSRS is awesome, if you've got a proper dimensional warehouse. I did write SIMS Bulk Import - Home - which needs someone to show it some love if anyone's got any C# skills.
14th October 2013, 12:52 PM #12
Student (and staff) photos are stored in SQL as base64 encoded text. I wrote a little utility app that takes an XML document (the SIMS RptDef to produce that file is included) and outputs all the photos contained within it as JPG to a specified folder, with options to resize them all on-the-fly, select between name, unique ID or admission number for the file name and also add the name to the bottom of the image if necessary.
Originally Posted by chrisateen
I'd be happy to share it with you if you're interested, source code too if you want it (it was written in C# - quick and easy)
14th October 2013, 01:04 PM #13
Like this - Sims.Net Photo Extractor - SalamanderSoft Limited - Free Utilities
14th October 2013, 01:08 PM #14
Yes just like that but with added options I personally needed, plus the offer of source code to look at. I'm not trying to compete with anyone, don't worry
Originally Posted by matt40k
Thanks to LosOjos from:
chrisateen (14th October 2013)
14th October 2013, 01:49 PM #15
I tried that but every time I tried running the command line it opens for a few seconds then closes again not giving me a chance to write the command to run the programme
Originally Posted by matt40k
If you could share it with me that would be great . As I have done a few small stuff in C# I could sit down learn a bit more and then could try and understand what you wrote as well.
Originally Posted by LosOjos
By Oops_my_bad in forum MIS Systems
Last Post: 28th September 2011, 10:29 AM
By duxbuz in forum Virtual Learning Platforms
Last Post: 19th October 2010, 03:59 PM
By reggiep in forum MIS Systems
Last Post: 5th May 2009, 11:55 PM
By Marvintpa in forum Windows
Last Post: 20th August 2007, 12:22 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)