+ Post New Thread
Results 1 to 10 of 10
MIS Systems Thread, Accessing SIMS.Net database through ASP? in Technical; Hi, first of all can I say that I'm not a techy, I'm a teacher but I'm as much of ...
  1. #1

    Join Date
    Jun 2007
    Location
    Uttoxeter, Staffordshire
    Posts
    18
    Thank Post
    0
    Thanked 4 Times in 4 Posts
    Rep Power
    0

    Accessing SIMS.Net database through ASP?

    Hi, first of all can I say that I'm not a techy, I'm a teacher but I'm as much of a geek as you lot

    I've got a system set up at school that works as an assessment tracker for the kids - it's basically a series of ASP pages linked to an Access database so I can set up tasks for the GCSE kids to do and then add their marks to it. That's simplifying it a little bit, but it's an overview.

    A major problem looming is that in September I'm going to have to update all of the pupils in the database. The SIMs.NET database will be updated of course, so my plan is to somehow tap in to that...

    I don't want to write to the SIMs database, just read from it from my webserver. Unfortunately, I haven't got a clue where to start. Has this been done by anyone on here before? Any pointers for help???

  2. #2

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,413
    Thank Post
    642
    Thanked 964 Times in 664 Posts
    Blog Entries
    2
    Rep Power
    327

    Re: Accessing SIMS.Net database through ASP?

    Apparently we're not allowed to do that, a Capita restriction I believe. However you can use the Command Line Reporting Tool to export existing reports to CSV or XML format.

    There is very little documentation for this - the best you'll get is running C:\Program Files\SIMS\SIMS .net\CommandReporter.exe with the /? switch.

  3. #3

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,819
    Thank Post
    110
    Thanked 588 Times in 509 Posts
    Blog Entries
    1
    Rep Power
    226

    Re: Accessing SIMS.Net database through ASP?

    Your not allowed to touch the Sims Database directly. It's not allowed in the EULA. However you can generate a CSV file with the information you require using the reports functionality. It should be fairly simple to process this with ASP.

  4. #4

    Join Date
    Jun 2007
    Location
    Uttoxeter, Staffordshire
    Posts
    18
    Thank Post
    0
    Thanked 4 Times in 4 Posts
    Rep Power
    0

    Re: Accessing SIMS.Net database through ASP?

    Cheers for the info. Theoretically speaking then, although I'm not allowed to do it, would it be possible?

  5. #5

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,819
    Thank Post
    110
    Thanked 588 Times in 509 Posts
    Blog Entries
    1
    Rep Power
    226

    Re: Accessing SIMS.Net database through ASP?

    Yes, but your SIMS.NET license explodes.

  6. #6
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42

    Re: Accessing SIMS.Net database through ASP?

    Exactly what info do you want to get out that you might need direct access, the command line reporting tool should be enough to get info out shouldnt it? If not, could you not create a sims report.. even tho this is pretty much the same thing as command line version..

  7. #7

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,967
    Thank Post
    1,210
    Thanked 1,075 Times in 766 Posts
    Rep Power
    332

    Re: Accessing SIMS.Net database through ASP?

    Have you spoken to your network manager at the school or data manager to ascertain these facts which he would already know.

    Information especially the schools Sims database is very crucial to the every day to day running of the school and to be tampered with is a fate worse than death by a thousand cuts.

    Analogy: "If a teacher cries off sick then it is the Sims that generates the cover so in effect we can manage without a teacher but not without the Sims"

  8. #8

    Join Date
    Jun 2007
    Location
    Uttoxeter, Staffordshire
    Posts
    18
    Thank Post
    0
    Thanked 4 Times in 4 Posts
    Rep Power
    0

    Re: Accessing SIMS.Net database through ASP?

    All I really need to get is pupil names, classes, etc. The crucial part is that if a new kid gets entered onto SIMS or any data about them is changed, I need my system to automatically pick it up without any interaction from me.

    The network manager / technicians are very good and helpful, but don't know how to go with this, hence why I'm no here...

    I get you though about the importance of SIMs, If I messed it up I wouldn't bother coming into work the next day.

  9. #9

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,413
    Thank Post
    642
    Thanked 964 Times in 664 Posts
    Blog Entries
    2
    Rep Power
    327

    Re: Accessing SIMS.Net database through ASP?

    For your situation... create a report to get the info you need, schedule the command reporter to export the report every X hours/days (this will vary depending on how often data is updated in SIMS and how soon this is required in your app), and then another schedule to import that data into your app.

  10. #10

    Join Date
    Mar 2007
    Posts
    323
    Thank Post
    6
    Thanked 7 Times in 6 Posts
    Rep Power
    17

    Re: Accessing SIMS.Net database through ASP?

    Sounds like a nice little project you got yourself there. I've recently dived into looking into ASP and Microsoft SQL Server and it appears alot more confusing then MySQL which is my preferred DB Server.

    Im glad people actually look into doing things that most people wouldnt dream of. We have a teacher guy at my place that shows alot of interest in making his own little tools that tie into other applications.

    Good luck mate

SHARE:
+ Post New Thread

Similar Threads

  1. Scholaris accessing/writing to Sims: Legit?
    By mr_simonward in forum Virtual Learning Platforms
    Replies: 18
    Last Post: 20th November 2009, 11:52 AM
  2. SIMS - Accessing from Home
    By forcryingoutloud in forum MIS Systems
    Replies: 4
    Last Post: 29th November 2007, 10:40 PM
  3. Accessing Sims from home?
    By sparxx in forum MIS Systems
    Replies: 19
    Last Post: 6th September 2007, 09:41 AM
  4. New Sims Database
    By SimAda00 in forum MIS Systems
    Replies: 0
    Last Post: 9th January 2007, 11:27 PM
  5. ASP connect to SIMS database
    By ryan_powell in forum MIS Systems
    Replies: 1
    Last Post: 26th October 2006, 06:31 PM

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
  •