+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, Report data from SIMS... in Technical; Could someone an example of an exported (end of term) school report file from SIMS? Also does there exist a ...
  1. #1
    ComputingData's Avatar
    Join Date
    Nov 2008
    Location
    Preston
    Posts
    117
    Thank Post
    9
    Thanked 12 Times in 12 Posts
    Rep Power
    14

    Report data from SIMS...

    Could someone an example of an exported (end of term) school report file from SIMS? Also does there exist a method in SIMS to import a school report file?

  2. #2
    Bev
    Bev is offline

    Join Date
    Oct 2009
    Posts
    158
    Thank Post
    13
    Thanked 5 Times in 5 Posts
    Rep Power
    11
    I do all my end of year reports in SIMS. What are you looking for? Are you wanting to see a printed report, or the setup?

  3. #3
    ComputingData's Avatar
    Join Date
    Nov 2008
    Location
    Preston
    Posts
    117
    Thank Post
    9
    Thanked 12 Times in 12 Posts
    Rep Power
    14
    An exported file, plus can you re-import exported files?

  4. #4

    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
    @ComputingData - you're not really making much sense. I don't think you understand how SIMS reports work. I see that you work for a reports software company, are you looking to integrate some how? The best thing to do is to contact Capita about becoming a partner.

    If you're looking to do something for a particular school, then you'll need to give us more details about how they use SIMS. There are two modules that will allow reports to be formulated, Assessment Manager which allows comment and grade inputs, into a spreadsheet like format, and Profiles which is the dedicated module which has comment banks and more of a structure / work flow to it. Both allow some degree of import / export. It's not easy to just import a whole file, you would need to import sections / comments etc.

    Exporting the individual bits of data from SIMS is easy enough as is the end report. Re-importing is not straight forward. You can however take a completed file and attach it manually to a student's record, but this is a slow, lengthy process.

    Let us know what you are trying to do, and maybe we can advise a bit better.

  5. Thanks to vikpaw from:

    ComputingData (10th February 2013)

  6. #5
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,185
    Thank Post
    839
    Thanked 372 Times in 288 Posts
    Blog Entries
    60
    Rep Power
    284
    I'm guessing you are a company and not a school. A school will typically create a Word template with tags that are replaced with a pupil's data when exported as a Word XML file. Schools can also fetch grades in the Reporting module that can export to Excel, RTF, Word or just preview it. For automated reports, there is a tool called CommandReporter that can run a pre-made report and output a CSV file (I think? Or XML one of the two). I've not used CommandReporter myself.

    You cannot access the SQL database directly. A) Good luck trying to work it out in the first place. B) Unless Capita have authorised you to access SQL directly, any school doing so could net themselves a 4-figure repair bill from Capita.

    To enter data back in, schools must use the Data In routines in the software itself, typically from a CSV or XML file.
    Last edited by CAM; 10th February 2013 at 11:12 AM.

  7. Thanks to CAM from:

    ComputingData (10th February 2013)

  8. #6
    ComputingData's Avatar
    Join Date
    Nov 2008
    Location
    Preston
    Posts
    117
    Thank Post
    9
    Thanked 12 Times in 12 Posts
    Rep Power
    14
    Thanks for both of your replies. I didn't want to have to go down this route, but I might see what's involved becoming a capita partner.

  9. #7

    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 depends what you want to do. Let us know and we can help.
    If you prepare a finished report there are other ways to pull the data back semi automatically. Look into existing sims partners recordlinkwriter I think it's called from cohesion.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Exporting a report definition from SIMS
    By iceman in forum MIS Systems
    Replies: 30
    Last Post: 22nd May 2012, 02:59 PM
  2. Programatic data extraction from SIMS.net Data Base
    By NetworkGeezer in forum MIS Systems
    Replies: 108
    Last Post: 16th February 2010, 09:22 PM
  3. Writing a custom app to pull data from SIMS?
    By robinm in forum MIS Systems
    Replies: 8
    Last Post: 17th September 2009, 08:24 AM
  4. Exporting Attendance Data from SIMS.Net
    By u8dmtm in forum MIS Systems
    Replies: 7
    Last Post: 8th September 2009, 02:27 PM
  5. Exporting Pupil Data From SIMS
    By David_Paylor in forum MIS Systems
    Replies: 9
    Last Post: 23rd March 2007, 03:16 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
  •