+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 25
MIS Systems Thread, Importing Email Addresses into SIMS in Technical; Hi We have been asked to import all the student email addresses into SIMS, as they want to send out ...
  1. #1

    Join Date
    Jul 2011
    Location
    Milton Keynes
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Importing Email Addresses into SIMS

    Hi

    We have been asked to import all the student email addresses into SIMS, as they want to send out emails via InTouch.
    Is there any easy way to do this, as we have about 1200 kids on roll...

    Cheers

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,562
    Thank Post
    1,469
    Thanked 1,221 Times in 830 Posts
    Rep Power
    752
    to EduGeek

    Unfortunately, I don't believe there is a quick way of doing this. Email addresses aren't included in a CTF so you can't get it in that way and the only other way of importing data is in to assessment manager aspects - I think you're going to have to do what I did recently and enter them all manually I'm afraid!

  3. #3

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,562
    Thank Post
    1,469
    Thanked 1,221 Times in 830 Posts
    Rep Power
    752
    Actually, looking at the full CTF schema here: http://www.education.gov.uk/schools/...-november-2011

    I can see that email addresses can be inserted in to CTF, it just appears that SIMS doesn't (EDIT: wrong again, it does!)... perhaps it will still import them...

    Off to do some testing, back with results soon!
    Last edited by LosOjos; 26th January 2012 at 12:44 PM.

  4. #4

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,562
    Thank Post
    1,469
    Thanked 1,221 Times in 830 Posts
    Rep Power
    752
    Right, it appears you can import email addresses on a CTF, you simply need to put it between <Email></Email> tags within the <Pupil> node. Unfortunately, you can't set it to the main/primary email address from the CTF and I can't see a routine in SIMS to do this en masse, so I'm not sure InTouch will automatically pick it up... as we don't use InTouch, I'm afraid I can't test that for you.

    What format is your data currently in? Are you able to knock something together to generate a CTF from your data or would you like a bit of help with it?

  5. #5
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    There is a Bulk Update Tool within InTouch but you still have to copy and paste the email address. It does ave having to go into each pupil's record though!
    I think you can also get Capita to do it for you but you would have to pay for the service!

  6. #6

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,562
    Thank Post
    1,469
    Thanked 1,221 Times in 830 Posts
    Rep Power
    752
    Quote Originally Posted by Sivadam View Post
    you still have to copy and paste the email address
    Not if you script together a CTF

    Wish I'd thought of this before I input a load manually

  7. #7
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    I bow to your superior knowledge on this one!

  8. #8

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,562
    Thank Post
    1,469
    Thanked 1,221 Times in 830 Posts
    Rep Power
    752
    Quote Originally Posted by Sivadam View Post
    I bow to your superior knowledge on this one!
    You could have warned me to take a seat Mike!

  9. #9
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 491 Times in 375 Posts
    Rep Power
    0
    I'd wait for a reply from @matt40k - I believe he's been looking at bulk importing e-mail's into SIMS .net. He may be able to assist here.

  10. #10

    Join Date
    Jul 2011
    Location
    Milton Keynes
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Cheers Guys, We will give it a shot and get back to you...

  11. #11
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    Quote Originally Posted by LosOjos View Post
    You could have warned me to take a seat Mike!
    I must be mellowing in my old age!

    Then again - we ain't had any malicious posts recently!

  12. #12

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,445
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    Yer I can bulk import staff, student and contact email address and telephone numbers directly into SIMS .net using the SIMS API. Unfortunately it's only licensed with Capita for the schools we support

    Sniff.

  13. #13

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,445
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    Quote Originally Posted by Sivadam View Post
    we ain't had any malicious posts recently!
    SIMS smells of rotten fish, I blame that dodgy looking guy Sivadam who voted for it

  14. #14

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,562
    Thank Post
    1,469
    Thanked 1,221 Times in 830 Posts
    Rep Power
    752
    Quote Originally Posted by matt40k View Post
    Yer I can bulk import staff, student and contact email address and telephone numbers directly into SIMS .net using the SIMS API. Unfortunately it's only licensed with Capita for the schools we support

    Sniff.
    Ah the elusive SIMS API. I've been trying to get access to that for about 18 months now

  15. #15

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,782
    Thank Post
    715
    Thanked 1,438 Times in 1,191 Posts
    Rep Power
    359
    Quote Originally Posted by boffinson View Post
    Hi

    We have been asked to import all the student email addresses into SIMS, as they want to send out emails via InTouch.
    Is there any easy way to do this, as we have about 1200 kids on roll...

    Cheers
    What format are they in? Is it easily formulated? Mine are just their admission number, and i had a patch created that will do it for you. It's Capita made and approved. But unfortunately they made it for a version of the software i'm not running yet! It worked on a test server

    I'm sure it could be tweaked. It pulls them in as Work address for student and also, manages updates and marking them as MAIN.

    I can dig out the number tomorrow when back in office.

    @LosOjos - pm / email me and i may have some info for you

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

Similar Threads

  1. [SIMS] Importing Email Addresses into Sims.NET
    By Geoff in forum MIS Systems
    Replies: 49
    Last Post: 27th September 2012, 02:07 PM
  2. [SIMS] Batch Import Formatted Excel Marksheets into SIMS?
    By tben2505 in forum MIS Systems
    Replies: 10
    Last Post: 15th November 2011, 02:31 PM
  3. [SIMS] SIMS Reporting on Email Address contents
    By pete in forum MIS Systems
    Replies: 8
    Last Post: 15th July 2011, 12:10 PM
  4. [SIMS] Import into sims.net diary
    By philjones2000 in forum MIS Systems
    Replies: 9
    Last Post: 9th March 2011, 10:57 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
  •