+ Post New Thread
Results 1 to 10 of 10
MIS Systems Thread, Exporting Pupil Data From SIMS in Technical; I have a couple of questions with regards to exporting Pupil Data from SIMS. 1) How can you export the ...
  1. #1

    Join Date
    Mar 2007
    Location
    England
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Exporting Pupil Data From SIMS

    I have a couple of questions with regards to exporting Pupil Data from SIMS.

    1) How can you export the information

    2) Is it possible to automate the export. Can a schedule be setup so that the export happens either when pupil data is changed in SIMS or by simply setting up a schedule to export this daily.

    I would be grateful for any help.

  2. #2
    Heebeejeebee's Avatar
    Join Date
    Nov 2006
    Location
    Intergalactic Cruise
    Posts
    1,036
    Thank Post
    68
    Thanked 74 Times in 58 Posts
    Rep Power
    34

    Re: Exporting Pupil Data From SIMS

    You haven't told us what information you want to export but:

    Open SIMS. Go to "Reports" then "Run Reports" or "Design Reports" if a generic one doesn't fit the bill. Make sure all the reports are imported from the latest updates though.

    As for the scheduling - I don't think it can be done. It would be nice though.

    HBJB

  3. #3

    elsiegee40's Avatar
    Join Date
    Jan 2007
    Location
    Kent
    Posts
    10,039
    Thank Post
    1,680
    Thanked 2,019 Times in 1,493 Posts
    Rep Power
    673

    Re: Exporting Pupil Data From SIMS

    Quote Originally Posted by Heebeejeebee
    Open SIMS. Go to "Reports" then "Run Reports" or "Design Reports" if a generic one doesn't fit the bill. Make sure all the reports are imported from the latest updates though.
    HBJB
    To add to this, once you have the report, you can export it to a csv which is handy for excel, mail merge, etc

    It's a couple of years since I used SIMS, but I don't remember being able to schedule reports

  4. #4

    Join Date
    Feb 2006
    Posts
    1,187
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Exporting Pupil Data From SIMS

    Quote Originally Posted by elsiegee40
    To add to this, once you have the report, you can export it to a csv which is handy for excel, mail merge, etc

    It's a couple of years since I used SIMS, but I don't remember being able to schedule reports
    SIMS.net now has Excel and Word Mailmerge as report types (actually SIMS does a temporary CSV export in the background for this).

    As for automation Capita has made availible two command line tools availible so that report genration can be scripted.

    The programs are actually availible on every SIMS client but you have to contact Capita directly for the documentation.

  5. #5
    Heebeejeebee's Avatar
    Join Date
    Nov 2006
    Location
    Intergalactic Cruise
    Posts
    1,036
    Thank Post
    68
    Thanked 74 Times in 58 Posts
    Rep Power
    34

    Re: Exporting Pupil Data From SIMS

    Quote Originally Posted by NetworkGeezer
    [As for automation Capita has made availible two command line tools availible so that report genration can be scripted.

    The programs are actually availible on every SIMS client but you have to contact Capita directly for the documentation.
    Oooh, I've not heard about that, what's the tool called?

    HBJB

  6. #6

    Join Date
    Mar 2007
    Location
    England
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Exporting Pupil Data From SIMS

    Quote Originally Posted by Heebeejeebee
    Quote Originally Posted by NetworkGeezer
    [As for automation Capita has made availible two command line tools availible so that report genration can be scripted.

    The programs are actually availible on every SIMS client but you have to contact Capita directly for the documentation.
    Oooh, I've not heard about that, what's the tool called?

    HBJB

    Yes if any has more information about these Report Scripts I would be grateful

  7. #7

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,372
    Thank Post
    624
    Thanked 949 Times in 651 Posts
    Blog Entries
    2
    Rep Power
    317

    Re: Exporting Pupil Data From SIMS

    C:\program files\sims\sims .net\CommandReporter.exe

    You have to make the report first in SIMS, and pass the name of the report to this app.

    Code:
    SIMS.net Command Line Report Exporting Utility 7.30
    Parameters :
    /USER:ABCD       - ABCD is the SIMS user name 
                       (not the SQL Server user name)
    /PASSWORD:ABCD   - ABCD is the SIMS password 
                       (not the SQL Server password)
    /REPORT:"ABCD"   - ABCD (quotes optional) is the name of the report 
                       seen in this users My Reports screen in SIMS.net
    /PARAMS:"ABCD"   - ABCD (quotes optional) is a string containing xml 
                       which defintes the parameters for the report. 
                       See the Third Party Access to SIMS.net SDK for details on 
                       the format of this xml string.
    /OUTPUT:"ABCD"   - ABCD (quotes optional) is the name of the output file 
                       to write the report contents or parameter definitions to.
                       The OUTPUT Parameter is optional, if left out the system 
                       will output the results in standard xml to the console.
    /PARAMDEF        - Output the parameter list for the specified report. 
                       If OUTPUT is not provided the results will be written in 
                       standard xml to the console. See the Third Party Access 
                       to SIMS.net SDK for details on the format of this xml 
                       string.
    /PARAMFILE:"ABCD" - ABCD (quotes optional) is the filename of an xml file
                          which contains the parameters for the report. 
                          See the Third Party Access to SIMS.net SDK for details on 
                          the format of this xml string.
    /QUIET	         - Switch to quiet mode, this mode will not write any log 
                       messages to the console.
              
    If the system is not run in QUIET mode and no OUTPUT is specified then 
    the result data will be proceeded with <CommandReporterResults> and followed by </CommandReporterResults>.
    
    /HELP or /? - Display this help information

  8. #8
    Heebeejeebee's Avatar
    Join Date
    Nov 2006
    Location
    Intergalactic Cruise
    Posts
    1,036
    Thank Post
    68
    Thanked 74 Times in 58 Posts
    Rep Power
    34

    Re: Exporting Pupil Data From SIMS

    Nice one !

    Thanks

    HBJB

  9. #9

    Join Date
    Feb 2006
    Posts
    1,187
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Exporting Pupil Data From SIMS

    Do bear in mind that Capita do not offer free support for the third party tools. You have to pay extra, over and above the standard yearly fee.

    That's probably why they don't make documentation genrally availible. They want to give you the disclaimer first before they send you the help file.

    Basically, you're on your own unless you can find a helpful EduGeek member.

  10. #10

    Join Date
    Jan 2007
    Location
    Midlands
    Posts
    45
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    15

    Re: Exporting Pupil Data From SIMS

    Quote Originally Posted by NetworkGeezer
    Do bear in mind that Capita do not offer free support for the third party tools. You have to pay extra, over and above the standard yearly fee.

    That's probably why they don't make documentation genrally availible. They want to give you the disclaimer first before they send you the help file.

    Basically, you're on your own unless you can find a helpful EduGeek member.
    and of course these tools are for school use only. Any third party wanting to use them will require a licence agreement with Capita. Not that we get any companies on this board - only humble school techies. :P

SHARE:
+ Post New Thread

Similar Threads

  1. Programatic data extraction from SIMS.net Data Base
    By NetworkGeezer in forum MIS Systems
    Replies: 108
    Last Post: 16th February 2010, 09:22 PM
  2. Exporting your Sims.net Diary to Outlook 2003
    By the.damon in forum MIS Systems
    Replies: 1
    Last Post: 5th November 2008, 02:55 PM
  3. Data Integrity Check SIMs
    By tony82 in forum MIS Systems
    Replies: 1
    Last Post: 2nd December 2007, 01:40 PM
  4. Replies: 7
    Last Post: 11th October 2007, 10:18 AM
  5. SIMS/MIS Data Manager
    By SpecialAgent in forum Educational IT Jobs
    Replies: 0
    Last Post: 10th July 2007, 11:49 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
  •