+ Post New Thread
Results 1 to 9 of 9
MIS Systems Thread, SIMS.net & CASPA in Technical; I hope someone can help. We use SIMs.net and Caspa. Caspa exports a report definitions file, which you load into ...
  1. #1
    JMB
    JMB is offline

    Join Date
    May 2011
    Location
    Exeter
    Posts
    155
    Thank Post
    23
    Thanked 11 Times in 9 Posts
    Rep Power
    9

    SIMS.net & CASPA

    I hope someone can help. We use SIMs.net and Caspa. Caspa exports a report definitions file, which you load into SIMS, and that lets you generate a report. The report definitions collates various data about the children (DOB, Special needs, etc.). Roughly 20 categories. However, when I run the report, it only actually picks up 3 (surname, ethnicity code and a count of some kind). It does this EVERY time. I've even redesigned the report and manually told it to look for the definitions Caspa produces, but it NEVER does. It's really doing my nut. It's done it before and after endless calls explaining CASPA (and sometimes SIMS) to ScoMIS, they did the report for me. But I hate being reliant on them and want to get this sorted. I can't believe I'm the only person having this issue. Can anyone help?!

  2. #2

    Join Date
    Mar 2010
    Location
    UK
    Posts
    166
    Thank Post
    0
    Thanked 16 Times in 15 Posts
    Rep Power
    16
    Yes its a pain, but then Capsa is buggy, don't get me started on how it converts (randomises) data from B-Squared into the assessment tables.

    We use CTF's to import the data into Caspa - much easier.

  3. #3
    JMB
    JMB is offline

    Join Date
    May 2011
    Location
    Exeter
    Posts
    155
    Thank Post
    23
    Thanked 11 Times in 9 Posts
    Rep Power
    9
    Glad it's not just me, Banjo. So...what's your method for getting data out of SIMS and into Caspa?

  4. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,408
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    Quote Originally Posted by JMB View Post
    when I run the report, it only actually picks up 3 (surname, ethnicity code and a count of some kind). It does this EVERY time. I've even redesigned the report and manually told it to look for the definitions Caspa produces, but it NEVER does
    Sounds either a permissions problem, or the report they've given you is majorly out of date. I'm guessing the latter. Don't suppose you could post the SIMS report definition? (IE export the report, not the report with the data).

  5. #5
    JMB
    JMB is offline

    Join Date
    May 2011
    Location
    Exeter
    Posts
    155
    Thank Post
    23
    Thanked 11 Times in 9 Posts
    Rep Power
    9
    Well, the definitions file for Caspa is brand new - I literally only updated it this afternoon. I do wonder about permissions. I suppose I could swallow my pride (and my deadline) and get ScoMIS to do it for me.

  6. #6

    Join Date
    Mar 2010
    Location
    UK
    Posts
    166
    Thank Post
    0
    Thanked 16 Times in 15 Posts
    Rep Power
    16
    Quote Originally Posted by JMB View Post
    Glad it's not just me, Banjo. So...what's your method for getting data out of SIMS and into Caspa?
    Just produce a CTF file from Sims (routines | data out | CTF) for all your pupils and import into Caspa.

    From what I remember when you install Caspa it asks you whether you are a Sims school or not and if you say 'no' it changes the options to allow you to import CTF files.

  7. #7
    speckytecky's Avatar
    Join Date
    May 2006
    Location
    UK
    Posts
    2,509
    Thank Post
    3,396
    Thanked 258 Times in 211 Posts
    Blog Entries
    3
    Rep Power
    110
    Found the generated file on our system on the C: drive of the SIMS server. Hope this helps.

  8. #8

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,970
    Thank Post
    673
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    A lot of third parties rely on the Third Party Reporting permissions group, should make sure you are in that group, or whoever is running the imported report, is, to rule out permissions.

  9. #9
    JMB
    JMB is offline

    Join Date
    May 2011
    Location
    Exeter
    Posts
    155
    Thank Post
    23
    Thanked 11 Times in 9 Posts
    Rep Power
    9
    Okay, so the saga continues. I've installed Caspa from scratch, upgraded it to Build 1.2.1.0 and re-exported the definitions file. I've loaded these into Sims.net and run the report. And, as before, I get Surname, Ethnicity and Count. I've tried to design a new report and load in the Data Fields from the Caspa file, but again, when I preview it I just get those 3 headings. I should be getting all these: [Student] Surname, Forename, DOB, Gender, Admission number (Adno), Admission date (DOA), Leaving date, UPN, Former UPN, Reg group (Reg), Eligible for free meals, Year taught in Code, In LEA Care, First Language code (Mother tongue code), Ethnicity Code, SEN Status, Special Needs, Ranking and Need type code. I've logged a call with ScoMIS, as last time (when I posted in November) they basically told me they couldn't help. Which seems odd, as before the summer that DID this report for me and just rang me to tell me where to find the output file. So I can't rely on them, obviously. Further to previous advice on here, I've had myself added to the Third Party Reporting permissions group, but that hasn't helped. I'm at a loss. SGA who make Caspa tell me it's down to Sims and ScoMIS, and ScoMIS won't help. So - anyone got any ideas to save what little hair I'll have left by lunchtime?

    EDIT: Put myself in the School Administrator permissions group, that's done the trick! Only suddenly occurred to me to try running a few other reports, and they all drop data because I don't have permission to view it. Problem solved. Will leave this here in case it helps others in a similar boat in the future! :-)
    Last edited by JMB; 9th January 2012 at 12:05 PM.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS.Net Active Directory Integration
    By robknowles in forum MIS Systems
    Replies: 29
    Last Post: 4th October 2011, 02:54 PM
  2. [SIMS] SIMS.net and multiple connect.ini files
    By NortyUK in forum MIS Systems
    Replies: 23
    Last Post: 9th September 2011, 12:05 PM
  3. [SIMS] Ecopy Toshiba SIMS.net Connector, AD login
    By ithelp in forum MIS Systems
    Replies: 2
    Last Post: 17th March 2011, 08:28 AM
  4. [SIMS] Import into sims.net diary
    By philjones2000 in forum MIS Systems
    Replies: 9
    Last Post: 9th March 2011, 10:57 AM
  5. [SIMS] IEP Writer 3 & Sims.net
    By LOUD in forum MIS Systems
    Replies: 9
    Last Post: 24th November 2010, 05:44 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •