+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, Exporting data about one student in Technical; The person who normally deals with SIMs requests isn't here this week so I said I'd do this, thinking it ...
  1. #1
    Sng
    Sng is offline

    Join Date
    May 2013
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Exporting data about one student

    The person who normally deals with SIMs requests isn't here this week so I said I'd do this, thinking it would be straightforward! Maybe it is...

    What I need to do is export all data about one student - Attendance and results from when they first started. I can see it all in SIMs but they need it in Excel. I can't see any export options though.

    What's the quickest way of doing this?

    Thanks.

  2. #2

    Jawloms's Avatar
    Join Date
    Aug 2007
    Posts
    793
    Thank Post
    157
    Thanked 102 Times in 71 Posts
    Rep Power
    178
    A way of doing it is - Routines - Data Out - CTF - Export CTF. Choose General and export the record to your own school. Gives you an XML, but everything should be in there.

  3. #3
    Sng
    Sng is offline

    Join Date
    May 2013
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Cheers! Looks like it's done the trick.

    Is this considered an ok way of doing it? Not likely to be frowned upon by Capita or anyone? I take it if I just delete the generated CTF after I'm done then it's all good?

  4. #4

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,182
    Thank Post
    1,285
    Thanked 1,029 Times in 729 Posts
    Rep Power
    658
    CTF (Common Transfer File) is the standard way of sharing data between schools, usually when a student leaves one school to join another.

    What exactly are you doing with the CTF? Whether it's "frowned upon" really depends what use you're putting it to... if, for instance, you were sending it via email to somebody, that would not only be frowned upon but a massive data protection risk, with a potential fine if you're caught...

  5. #5
    Sng
    Sng is offline

    Join Date
    May 2013
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Well the CTF contains all the attendance and result marks so I was just pulling that data out. Once I did that the CTF was deleted. I assume that's fine?

  6. #6

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,182
    Thank Post
    1,285
    Thanked 1,029 Times in 729 Posts
    Rep Power
    658
    Quote Originally Posted by Sng View Post
    Well the CTF contains all the attendance and result marks so I was just pulling that data out. Once I did that the CTF was deleted. I assume that's fine?
    Yes that's fine, all I was trying to point out really is to be aware of the data protection issues involved, as quite often people don't. It's what you do with the data that's the issue, not the CTF itself

  7. #7
    Sng
    Sng is offline

    Join Date
    May 2013
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Cool, cheers!

SHARE:
+ Post New Thread

Similar Threads

  1. Exporting data from RM Integris
    By MikeBostock in forum MIS Systems
    Replies: 4
    Last Post: 4th September 2010, 08:47 AM
  2. Replies: 0
    Last Post: 20th May 2010, 08:30 AM
  3. Replies: 7
    Last Post: 13th March 2008, 03:52 PM
  4. Exporting data from the AD
    By faza in forum Wireless Networks
    Replies: 6
    Last Post: 8th February 2008, 06:54 PM
  5. Replies: 1
    Last Post: 15th October 2007, 07:44 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
  •