+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, Problem with SIMS CTF Import in Technical; Got a problem when attempting to import CTF files received via S2S from Feeder Primary Schools. Primary schools are running ...
  1. #1

    Join Date
    Jul 2005
    Location
    South Wales
    Posts
    7
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Problem with SIMS CTF Import

    Got a problem when attempting to import CTF files received via S2S from Feeder Primary Schools. Primary schools are running Integris. Error message goes something along these lines :-

    "An application fault has occurred. 9871-5157-9000. Cannot insert the value NULL to column..."

    After which SIMS crashes out.

    Import works ok for CTF files sent from other secondaries (running Integris and SIMS) so assuming it's a problem related to feeder schools only but......

    Any one else seen this error?

    Thanks in advance for any ideas ('cos SIMS ain't got many... and I really don't want to send them a sample CTF via e-mail).

  2. #2

    GrumbleDook's Avatar
    Join Date
    Jul 2005
    Location
    Gosport, Hampshire
    Posts
    9,930
    Thank Post
    1,337
    Thanked 1,781 Times in 1,105 Posts
    Blog Entries
    19
    Rep Power
    594
    Capita have an upload facility and you can zip/encrypt the file too and let them phone you for the password once they have received it.

    It sounds like one of the fields have been exported with naff data (ie empty) when it requires an entry. An example would be UPN where a temporary / local UPN can be generated if it is blank. I think the problem is more with that school's setup of integris and it may be worth getting the school to call RM about it.

  3. #3

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,381
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    I think this is welsh problem, I think patch 12996 solves it. Something about EALAcquisition ?

  4. Thanks to matt40k from:

    appleman (21st April 2009)

  5. #4

    Join Date
    Jul 2005
    Location
    South Wales
    Posts
    7
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    GrumbleDook

    It sounds like one of the fields have been exported with naff data (ie empty) when it requires an entry. An example would be UPN where a temporary / local UPN can be generated if it is blank. I think the problem is more with that school's setup of integris and it may be worth getting the school to call RM about it.

    Yup, thought that would be the case as we've had this problem before.....

    Matt40k

    I think this is welsh problem, I think patch 12996 solves it. Something about EALAcquisition ?

    Is this patch available through SOLUS or do I have to hunt for it?

    Thanks to Both

  6. #5
    BatchFile's Avatar
    Join Date
    Aug 2007
    Location
    Cumbria
    Posts
    948
    Thank Post
    544
    Thanked 128 Times in 106 Posts
    Rep Power
    60
    Through the dim mists of time, I seem to remember that CTFs from other MIS's (to SIMS) have different address tags that those from SIMS... they use <Line1>, <Line2> etc rather than <HouseName>, <StreetName> or whatever SIMS uses.

    It could be that... worth a shot. There's a "CTF Address line Converter" gadget available from Supportnet to fix it http://support.capitaes.co.uk/user/d...DB%E6%E1%A3%DC (or just put CTF Address in the search box if that link doesn't work)

  7. #6

    Join Date
    Jul 2005
    Location
    South Wales
    Posts
    7
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by TonyRidal View Post
    Through the dim mists of time, I seem to remember that CTFs from other MIS's (to SIMS) have different address tags that those from SIMS... they use <Line1>, <Line2> etc rather than <HouseName>, <StreetName> or whatever SIMS uses.

    It could be that... worth a shot. There's a "CTF Address line Converter" gadget available from Supportnet to fix it http://support.capitaes.co.uk/user/d...DB%E6%E1%A3%DC (or just put CTF Address in the search box if that link doesn't work)
    Thanks

    Yup, I remember that one, 'twas many moons ago though.... Problem now is that worked for CTF 7 but we are using CTF 8. Will check the CTF files manually for this though....

  8. #7

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,316
    Thank Post
    35
    Thanked 351 Times in 237 Posts
    Rep Power
    78
    We do have an issue on importing Key Stage data from other systems - there is a database patch to the March release that solves this.

SHARE:
+ Post New Thread

Similar Threads

  1. SIMS AM7 -Export and Import Marksheet
    By LittleRedFoot in forum MIS Systems
    Replies: 4
    Last Post: 20th October 2008, 07:52 PM
  2. Export/Import into SIMS Marksheets
    By Sleepmaster in forum MIS Systems
    Replies: 1
    Last Post: 24th September 2008, 12:55 PM
  3. Sims CTF Import - Aspect not Found
    By mmuk08 in forum MIS Systems
    Replies: 1
    Last Post: 16th September 2008, 09:53 AM
  4. Submit CTF to NAA using SIMS
    By penfold_99 in forum MIS Systems
    Replies: 9
    Last Post: 15th July 2008, 06:29 AM
  5. Import Staff into Sims.net via a CSV
    By stephen.loader in forum MIS Systems
    Replies: 2
    Last Post: 14th January 2008, 11:32 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
  •