+ Post New Thread
Results 1 to 12 of 12
MIS Systems Thread, Bulk update staff email addresses in Technical; Hi, I think I already know the answer but I thought I'd ask just in case someone has done this.... ...
  1. #1

    Join Date
    Nov 2011
    Location
    Rayleigh
    Posts
    119
    Thank Post
    23
    Thanked 21 Times in 21 Posts
    Blog Entries
    1
    Rep Power
    9

    Bulk update staff email addresses

    Hi, I think I already know the answer but I thought I'd ask just in case someone has done this....

    Our school email address (the domain part) has changed so we would like to update the details held in each staff record, i.e. g.winn@hahc.org.uk becomes g.winn@haaf.org.uk, for example.

  2. #2
    MrMat's Avatar
    Join Date
    Jul 2013
    Location
    Solihull
    Posts
    169
    Thank Post
    18
    Thanked 37 Times in 28 Posts
    Rep Power
    28
    I assume you're using SIMS?

    If so, as far as I'm aware, that isn't a way of bulk updating staff records. I think it's going to be a nice, exciting data input jobby. Unless of course someone much smarter than I can advise otherwise

  3. #3
    rob_coles's Avatar
    Join Date
    Mar 2007
    Location
    Hull
    Posts
    107
    Thank Post
    15
    Thanked 14 Times in 10 Posts
    Rep Power
    18
    There is a bulk update tool https://simsbulkimport.codeplex.com

  4. Thanks to rob_coles from:

    winng (12th August 2014)

  5. #4
    rob_coles's Avatar
    Join Date
    Mar 2007
    Location
    Hull
    Posts
    107
    Thank Post
    15
    Thanked 14 Times in 10 Posts
    Rep Power
    18
    Just to add I've not used it yet but intend to in September to add student emails

  6. #5

    Join Date
    Dec 2005
    Posts
    536
    Thank Post
    34
    Thanked 89 Times in 79 Posts
    Rep Power
    39
    If I read the description right on the simsbulkimport it will only import into udf fields (user defined fields)

    This wouldn't work if you are using the official sims email field.

    I'm guessing they do not allow access to official fields using the business objects utility

  7. #6
    rob_coles's Avatar
    Join Date
    Mar 2007
    Location
    Hull
    Posts
    107
    Thank Post
    15
    Thanked 14 Times in 10 Posts
    Rep Power
    18
    I tested adding email address to a single student. Worked fine

  8. #7

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,425
    Thank Post
    368
    Thanked 642 Times in 524 Posts
    Rep Power
    159
    Quote Originally Posted by siuko View Post
    If I read the description right on the simsbulkimport it will only import into udf fields (user defined fields)

    This wouldn't work if you are using the official sims email field.
    What??

    SIMS .net is the most popular MIS system used by schools across the UK. This tool allows you to bulk import email addresses and information into UDF fields.

    • Uses the Capita SIMS Business Objects
    • Imports from CSV, TXT and XML files
    Quote Originally Posted by siuko View Post
    I'm guessing they do not allow access to official fields using the business objects utility
    The business object allows you do everything the SIMS .net application can do, it is the same logic \ api \ objects \ libraries \ whatever you want to call it as the SIMS .net uses.

    Just to be clear.

    - You can import UDF fields - single line of text.
    - You can import email addresses.
    - Version 2 you can import telephone numbers - https://simsbulkimport.codeplex.com/documentation
    - You can not bulk delete email addresses.
    - You can not currently override the current primary \ main option. This would require a two step process of first changing the current primary \ main, then adding the new address - like you have to in SIMS. However this will occur in future release.

  9. #8

    Join Date
    Dec 2005
    Posts
    536
    Thank Post
    34
    Thanked 89 Times in 79 Posts
    Rep Power
    39
    Sorry matt40k

    I just read it wrong I guess lol - it just reads that you can import email and information into udf fields.

    I'm just trying to use it now - it connects to my sims ok (7.156 on SQL 2012) but when I read the csv and choose a few options like admission number, surname etc it does not come up with anyone?

  10. #9

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,425
    Thank Post
    368
    Thanked 642 Times in 524 Posts
    Rep Power
    159
    If your using a unique id like admission number or Person ID, just use that and the field you want to enter. It basically replicates the browse logic in focus > students (or staff or whatever), so check that will find it ok.

  11. #10

    Join Date
    Oct 2010
    Posts
    4
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I have used this successfully on my test database and a couple of the schools we support have used it too. It is a bit fiddly but once you get it all in the order it needs it in it runs fine. If you PM me your email address I can share my guidance notes with you if you'd like.

  12. #11

    Join Date
    Dec 2005
    Posts
    536
    Thank Post
    34
    Thanked 89 Times in 79 Posts
    Rep Power
    39
    @matt40k I have just tried it with the admission number field and email address - it still doesnt seem to update the preview window with details of the student I'm looking for - guess I must be doing something wrong lol
    @Skelacia I will pm you now thank you

  13. #12

    Join Date
    Nov 2011
    Location
    Rayleigh
    Posts
    119
    Thank Post
    23
    Thanked 21 Times in 21 Posts
    Blog Entries
    1
    Rep Power
    9
    Thanks @matt40k, I've managed to successfully import a few email address changes to prove the process works. Now I just need some admin support to prepare the import file for all staff and thereafter to make it the main address, for InTouch, etc.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Batch Import Staff Email Addresses
    By tben2505 in forum MIS Systems
    Replies: 8
    Last Post: 8th April 2014, 01:25 PM
  2. Bulk import of email address for whitelist in exchange 2010
    By wickit in forum Enterprise Software
    Replies: 2
    Last Post: 10th May 2013, 02:33 PM
  3. Staff Email Address Policy
    By Mr.Ben in forum General Chat
    Replies: 21
    Last Post: 1st April 2012, 01:32 PM
  4. script to update email address
    By swys in forum Windows Server 2008
    Replies: 3
    Last Post: 27th May 2011, 04:59 AM
  5. [SIMS] Bulk import staff email address
    By matt40k in forum MIS Systems
    Replies: 16
    Last Post: 31st October 2010, 10:59 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
  •