+ Post New Thread
Results 1 to 13 of 13
MIS Systems Thread, bulk csv import student details in Technical; is this possible in SIMS?...
  1. #1


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339

    bulk csv import student details

    is this possible in SIMS?

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,381
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    What like a CTF

    What you trying to bulk import specificy?

  3. #3


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    new yr 6 students.

  4. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,381
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    ATF from the LA if they manage admissions, then CTF's from the feeder primary school.

  5. Thanks to matt40k from:

    CyberNerd (19th January 2012)

  6. #5


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    Quote Originally Posted by matt40k View Post
    ATF from the LA if they manage admissions, then CTF's from the feeder primary school.
    yes thanks. Just wanted to check.

  7. #6
    ajp233's Avatar
    Join Date
    Jun 2009
    Posts
    19
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by CyberNerd View Post
    is this possible in SIMS?
    I did write a routine a few years ago that created a CTF file from a csv file of student details so yes it is possible. Unfortunately I don't have it lying around anymore but I do recall it being relatively straightforward.

  8. #7

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,381
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Quote Originally Posted by ajp233 View Post
    I did write a routine a few years ago that created a CTF file from a csv file of student details
    Is this a joke? SIMS (and all MIS that I know of) has a routine to export from the MIS to CTF.

  9. #8
    ajp233's Avatar
    Join Date
    Jun 2009
    Posts
    19
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Not a joke matt40k. The routine was written because I was passed a csv file of student details and they needed inputting into SIMS. Converting the csv into CTF format and importing was the quickest option

  10. #9

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,381
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Yer, CTF seems a pretty nice format.

    Would go back to the school who sent you the CSV and ask for a CTF. Pretty sure it's a legal requirement to send a CTF within a specific time frame.

  11. #10
    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
    Quote Originally Posted by CyberNerd View Post
    new yr 6 students.
    County will send an ATF file via the schools2schools website.
    Are you looking for getting the new year 6 details in for transition days etc, before they start in year 7?

  12. #11


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    Quote Originally Posted by penfold_99 View Post
    County will send an ATF file via the schools2schools website.
    Are you looking for getting the new year 6 details in for transition days etc, before they start in year 7?



    yes, but the ATF is sent too late for letters home....

  13. #12
    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
    Quote Originally Posted by CyberNerd View Post
    yes, but the ATF is sent too late for letters home....
    I would keep the details out of sims and use the csv as a mail merge data source for word until the ATF turns up.

  14. #13


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    Quote Originally Posted by penfold_99 View Post
    I would keep the details out of sims and use the csv as a mail merge data source for word until the ATF turns up.
    OK. thanks.
    Do you happen to know if the ATF and the data sent by LA are from the same source? i.e. why can't they send the ATF earlier if they already supply us the data of new students a month before?

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Bulk update future students?
    By LosOjos in forum MIS Systems
    Replies: 34
    Last Post: 29th June 2010, 02:46 PM
  2. Replies: 11
    Last Post: 22nd May 2008, 08:23 AM
  3. Bulk User Imports
    By Bezwick in forum Downloads
    Replies: 3
    Last Post: 8th May 2008, 08:04 AM
  4. QCA Online Testing - Import Pupil Details
    By Craig_W in forum Educational Software
    Replies: 1
    Last Post: 17th May 2007, 07:32 AM
  5. AD Bulk User Importer
    By ChrisH in forum Scripts
    Replies: 17
    Last Post: 9th May 2006, 07:50 PM

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
  •