+ Post New Thread
Results 1 to 4 of 4
Coding Thread, Integration with SIMS.Net in Coding and Web Development; Hi everyone, Head of ICT here (so teacher, please be kind...) I have quite a few programming projects that I've ...
  1. #1

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

    Integration with SIMS.Net

    Hi everyone, Head of ICT here (so teacher, please be kind...)

    I have quite a few programming projects that I've done over the years to do various things in school, but they all rely on me exporting data from SIMS into another database. Many years ago, I tried to get data automatically out of the SIMS database (just things like students names and classes) but hit a brick wall. I tried contacting the company officially but they wanted an extortionate fee for developer access.

    Has anything moved on over the past few years? Is there any easy way to get data out of the SIMS database? Anyone done anything like this with their projects?

  2. #2

    Steve21's Avatar
    Join Date
    Feb 2011
    Location
    Swindon
    Posts
    2,689
    Thank Post
    334
    Thanked 515 Times in 483 Posts
    Rep Power
    179
    From my understanding it's basically 4 options,

    a) Use another product like groupCall who already have the license to export, then use that data for your stuff.
    b) Buy a license
    c) Do it by copying database etc, then taking data from your 2nd copy, aka not live one. (But not sure if that's only for testing, or officially ok)
    d) Make use of the export reports etc, and export XML which you then import, but a bit of a faff way

    Steve

  3. #3

    Join Date
    Apr 2007
    Location
    Cornwall
    Posts
    250
    Thank Post
    16
    Thanked 63 Times in 41 Posts
    Rep Power
    26
    Quote Originally Posted by Steve21 View Post
    d) Make use of the export reports etc, and export XML which you then import, but a bit of a faff way
    Steve
    I use the d option myself using commandreporter.exe found in the SIMS installation folder. As Steve says, it exports an XML file that you need to parse through, but I find it works a treat. I use this method to maintain a list of students and classes in a MySQL database syncronised with SIMS overnight. I then use that data to provide various web apps for staff here, eg email all students in a class, email all teachers of a student, etc.

    Meldrew

  4. #4

    Join Date
    Jun 2010
    Posts
    66
    Thank Post
    1
    Thanked 6 Times in 5 Posts
    Rep Power
    16
    You could use my webservice software to run reports remotely and receive the data as an XML soap message. Download from http://www.beaconhillcott.net. You do have to install Glassfish on a SIMS server or workstation and add a path in the environment variables to your SIMS .net directory. This is what I use. I know this thread is over a month old but I thought I'd add my contribution to this problem which doesn't appear to being made any easier.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] ID Card software for use with SIMS.net
    By localzuk in forum MIS Systems
    Replies: 8
    Last Post: 19th May 2014, 12:09 PM
  2. [SIMS] SIMS.Net Active Directory Integration
    By robknowles in forum MIS Systems
    Replies: 29
    Last Post: 4th October 2011, 02:54 PM
  3. [SIMS] Problems with SIMS and .Net Framework 4
    By happymeal in forum MIS Systems
    Replies: 3
    Last Post: 7th September 2011, 10:05 AM
  4. Issues with SIMS .net and thin clients
    By localzuk in forum MIS Systems
    Replies: 5
    Last Post: 13th October 2009, 01:12 PM
  5. Replies: 3
    Last Post: 7th July 2006, 02:21 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
  •