+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, Updating student records in Bulk - NOT Bulk Update in Technical; Hope this isn't a stupid question! We've got CTFs now for most of our Y9 and Y12 starters for next ...
  1. #1

    Join Date
    Dec 2011
    Posts
    93
    Thank Post
    35
    Thanked 21 Times in 14 Posts
    Rep Power
    12

    Updating student records in Bulk - NOT Bulk Update

    Hope this isn't a stupid question!

    We've got CTFs now for most of our Y9 and Y12 starters for next year. We use the information from these to mail merge an application form on which they can confirm that the information is correct, mark any changes, plus provide us with extra information, permission tick boxes etc.

    Is there a quick way to load in changes and extra information without having to manually go through each student record? I know the Bulk Update will cover some things, and I'm looking at @matt40k 's utility for updating our UDFs, but am I missing a trick here (or several tricks maybe?!)

    Thank you

  2. #2

    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
    The short answer is no.
    If you used the admissions module, that would be the ideal place to import an application form if it was filled in online, but i don't even think the SIMS admissions module can do that.

  3. #3

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,387
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Currently it only imports single line of text UDFs. I've been looking at adding more as part of the next release which is pretty much a complete overhaul, but I'm losing motivation with it if I'm being honest. Is it just UDFs you want to import and what are they defined as in SIMS .net? If it's boolean \ true\false I think I can add that quickly enough and do a preview build for you.

  4. #4

    Join Date
    Dec 2011
    Posts
    93
    Thank Post
    35
    Thanked 21 Times in 14 Posts
    Rep Power
    12
    Thanks both for your replies. Un fortunately it's one of those things that sounds really simple but isn't possible - "can't we just export the pupil data into a spreadsheet, update it, then load it back in?"
    @vikpaw, importing application forms that have been filled in online is another thing I've been asked about. We don't have the application and registration module. I was wondering whether we could use the inputted data from the web form to build our own ATF files for import into SIMS. Do you know if anyone here has tried something similar?

  5. #5

    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
    There is no custom import facility for pupil data, so unless it's in a standard format, not gonna happen. However, @LosOjos did some work on creating a CTF from a spreadsheet, so, so long as the fields you want to update are included in the CTF specification, perhaps that would be one avenue, but i wouldn't think it's easy. Plus he's only gone and lost his files on it

    Importing from a web form would be great, but i don't think SIMS does this, i know other software can. We don't have the full module. We just manually input all data from our forms.

  6. #6

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,447
    Thank Post
    1,438
    Thanked 1,168 Times in 797 Posts
    Rep Power
    707
    As @vikpaw said, I did have a utility to make a CTF out of a spreadsheet which I'm trying to find on my HDD at the moment but I don't think that would help here. The problem is, a CTF will never overwrite data, so although they're great for adding missing data en masse, you can't use them to update existing data I'm afraid

  7. Thanks to LosOjos from:

    vikpaw (7th June 2013)

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] HOW-TO: Bulk Update Result Set in Individual Reports (AM7)
    By LosOjos in forum MIS Systems
    Replies: 7
    Last Post: 19th December 2012, 10:15 AM
  2. WSUS downloading some but not all updates
    By gaz350 in forum Windows
    Replies: 4
    Last Post: 29th February 2008, 10:35 AM
  3. Personnel info not being updated in FMS
    By Oops_my_bad in forum MIS Systems
    Replies: 5
    Last Post: 23rd November 2007, 12:34 PM
  4. Replies: 1
    Last Post: 31st October 2007, 12:10 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
  •