Exporting Pupil Data From SIMS

[David_Paylor]

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.

[Heebeejeebee]

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

[elsiegee40]

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

[NetworkGeezer]

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.

[Heebeejeebee]

[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

[David_Paylor]

[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

[webman]

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.

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

[Heebeejeebee]

Nice one !

Thanks

HBJB

[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.

[StArbiter]

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