+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 23
MIS Systems Thread, SIMS export in Technical; We have recently acquired a school that used SIMS and they are trying to export their contacts for the pupils. ...
  1. #1
    scholarpack's Avatar
    Join Date
    Jul 2010
    Location
    UK
    Posts
    191
    Thank Post
    12
    Thanked 30 Times in 20 Posts
    Rep Power
    38

    SIMS export

    We have recently acquired a school that used SIMS and they are trying to export their contacts for the pupils. SIMS CTF only exports 2 contacts per student which became quite a problem for the school as they had 4 contacts per student. On exporting the additional contacts separately the export file has a UPN on the end to match up the students. The UPN has exported wrongly. A pupils UPN is for example B909522005023 (from the ctf which is fine and it is recorded as this in SIMS, edited so wont validate) however in the contacts export it is A909522004004.(edited so wont validate)

    Has anyone else had troubles with this issue or know how to fix SIMS to export the right contact information/upns?

    Kind Regards

    Jason

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,385
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Why not just run a SIMS report for the contacts with the UPN.

  3. #3
    scholarpack's Avatar
    Join Date
    Jul 2010
    Location
    UK
    Posts
    191
    Thank Post
    12
    Thanked 30 Times in 20 Posts
    Rep Power
    38
    Hi Matt,

    That's what the school did, and the UPN's came out different in the report to those stored in SIMS.

    Jason

  4. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,385
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Can you post the report?

  5. #5
    scholarpack's Avatar
    Join Date
    Jul 2010
    Location
    UK
    Posts
    191
    Thank Post
    12
    Thanked 30 Times in 20 Posts
    Rep Power
    38
    For data protection reasons i'm afriad I cannot provide the report. The school we are dealing with has manually done it as SIMS didn't want to play nice with them.

    Thanks for your time Matt.

    Kind regards

    Jason

  6. #6
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    929
    Thank Post
    56
    Thanked 162 Times in 114 Posts
    Rep Power
    67
    This could be down to how the report has been created, as the contact could have multiple students in the school. Do the upns belong to siblings?

  7. #7

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,385
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    I meant the report def not the actual export

  8. #8

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,385
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Quick one I boshed up works ok, I reckon they've selected the wrong field at a guess - ByUPN - Contacts.7z

  9. #9

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Maybe they pulled in temporary ones, local, former UPN, something else altogether.

  10. #10
    scholarpack's Avatar
    Join Date
    Jul 2010
    Location
    UK
    Posts
    191
    Thank Post
    12
    Thanked 30 Times in 20 Posts
    Rep Power
    38
    Ah right thanks for that Matt, ill get it across to the school. You may be right Vikpaw thanks for your time guys

  11. #11

    Join Date
    Oct 2009
    Location
    UK
    Posts
    41
    Thank Post
    6
    Thanked 7 Times in 6 Posts
    Rep Power
    11
    I know this isn't going to help you, but the CTF specification should allow any number of Contacts, so as your getting this problem this is either a SIMS problem or the export is not being done correctly by the school

    To SIMS users: Is this 'only two contacts' a standard feature when exporting a CTF file from SIMS

    The reason I'm asking is that our contract with our current supplier will be ending soon, and changing to SIMS would be an option (as would Scholarpack), but if this 'two contacts' issue is standard for all CTF files, then that would be a big black mark against choosing SIMS

  12. #12

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    I haven't used CTF for a while, but there is no config i can see, only tick boxes to choose the data you want out, so i think it's just fixed in SIMS to only deal with 2.
    Why is it such a black mark? I know it's a pain, but the import should be easy enough, as i would imagine, SIMS would help you with a transfer into their system, but helping pull in ALL the data you have.
    With the export, yes it may be limited, but you can use a standard report if you do want to get all the details out.

  13. #13

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,385
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Doesn't SIMS only export the contacts marked as main or something for CTF?

  14. #14

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Maybe only those marked with priority 1 / 2, or more likely those with parental responsibility ticked.

  15. #15

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,385
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Doubt it would be responsibility - as it's a field in the CTF

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

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. [SIMS] How do you export SIMS users into AD?
    By mcnallyfc in forum MIS Systems
    Replies: 16
    Last Post: 5th November 2010, 04:59 PM
  3. Replies: 3
    Last Post: 30th January 2010, 12:03 PM
  4. SIMS exporting new year 7 pupils to Fronter
    By adamf in forum MIS Systems
    Replies: 4
    Last Post: 8th August 2009, 01:22 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
  •