+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 17
MIS Systems Thread, Bulk import staff email address in Technical; Anyone know how to bulk import staff email addresses into SIMS? No? Just add 256 email addresses in about 5 ...
  1. #1

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,425
    Thank Post
    368
    Thanked 642 Times in 524 Posts
    Rep Power
    159

    Bulk import staff email address

    Anyone know how to bulk import staff email addresses into SIMS?

    No? Just add 256 email addresses in about 5 mins. Wonder if I should say it took me all week and have a holiday?

    (If you haven't realised, I'm a bit impressed with myself... and the Capita business objects)

  2. #2

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,057
    Thank Post
    375
    Thanked 375 Times in 306 Posts
    Blog Entries
    8
    Rep Power
    177
    hang on, you have done this or want to know? If the former... do tell!

  3. #3

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,425
    Thank Post
    368
    Thanked 642 Times in 524 Posts
    Rep Power
    159
    I've done it, I wrote a little app that does it.

  4. #4
    steve's Avatar
    Join Date
    Oct 2005
    Location
    West Yorkshire
    Posts
    1,043
    Thank Post
    22
    Thanked 177 Times in 123 Posts
    Rep Power
    52
    You should sell this to capita as they say its not possible!

    We manually did staff emails. We now need to do student emails - all 1800

  5. #5
    scholarpack's Avatar
    Join Date
    Jul 2010
    Location
    UK
    Posts
    191
    Thank Post
    12
    Thanked 30 Times in 20 Posts
    Rep Power
    38
    Is XML import not possible?

  6. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,425
    Thank Post
    368
    Thanked 642 Times in 524 Posts
    Rep Power
    159
    @scholarpack - nope, not natively, you would have to write something.

    Quote Originally Posted by steve View Post
    You should sell this to capita as they say its not possible!

    We manually did staff emails. We now need to do student emails - all 1800
    Anything possible, if you pay for it, I'm sure they could send someone out for day to import them.

  7. #7

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,057
    Thank Post
    375
    Thanked 375 Times in 306 Posts
    Blog Entries
    8
    Rep Power
    177
    So I'm guessing it searches for the unique record and inserts directly into the SQL record... interesting!

  8. #8

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,425
    Thank Post
    368
    Thanked 642 Times in 524 Posts
    Rep Power
    159
    Basically. Uses Capita business objects, if it finds more then one record for the name, it won't import. It's pretty basic app, but it does the job.

  9. Thanks to matt40k from:

    GREED (29th October 2010)

  10. #9
    rpwillis's Avatar
    Join Date
    Aug 2007
    Location
    SalamanderSoft Ltd
    Posts
    178
    Thank Post
    43
    Thanked 61 Times in 49 Posts
    Rep Power
    26
    Quote Originally Posted by steve View Post
    You should sell this to capita as they say its not possible!
    It certainly is possible. I recently had this requirement for one of my customers. In fact it was a bit more complex than that. They are using Sims Learning Gateway and the email address which is inserted into AD is non-deterministic amongst those which are set as Main. We think it's the first email address created (whether home, work or other) which has the main flag set, but aren't sure. So in the end the requirement was to:

    1. Unset the main flag from any existing home email addresses.
    2. Delete any existing work email addresses.
    3. Enter the school email address as the main work email.

    Didn't turn out to be too hard and they've now got up to date email address for all their staff and students.

    In fact I would actually recommend, that if you are using Sims Learning Gateway, not setting any home addresses as Main or they might end up in Active Directory and potentially accessible through SharePoint or Exchange.

  11. #10

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,057
    Thank Post
    375
    Thanked 375 Times in 306 Posts
    Blog Entries
    8
    Rep Power
    177
    Quote Originally Posted by matt40k View Post
    Basically. Uses Capita business objects, if it finds more then one record for the name, it won't import. It's pretty basic app, but it does the job.
    I never got the chance to use Capita BO (!) before I stopped working with it, but sounds like it has loads of potential!

  12. #11

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,007
    Thank Post
    679
    Thanked 1,396 Times in 1,156 Posts
    Rep Power
    353
    Quote Originally Posted by matt40k View Post
    @scholarpack - nope, not natively, you would have to write something.
    Anything possible, if you pay for it, I'm sure they could send someone out for day to import them.
    There was a thread about this on SupportNet and i suggested that Capita would do it for a fee, but nobody followed it up as far as i'm aware.

    Quote Originally Posted by matt40k View Post
    I've done it, I wrote a little app that does it.
    I'm impressed. Is it something that you would be willing to share, if that is even allowed? Also, now you've got your head around the business objects how easy would it be to modify it to import student emails.

    All this would be simple if we could hack into SQL, but doing it with the BO would be cool and legal

  13. #12

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,425
    Thank Post
    368
    Thanked 642 Times in 524 Posts
    Rep Power
    159
    Students wouldn't be too much trouble. Sharing is a no-no, two reasons, firstly I coded it at work, so my work would want to charge for it and secondary, Capita would charge for non-Suffolk schools.

  14. #13

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,007
    Thank Post
    679
    Thanked 1,396 Times in 1,156 Posts
    Rep Power
    353
    i see. why would capita charge? nevermind. what if someone here wanted to pursue a similar app, is helping someone else allowed? if it's offline...?

  15. #14

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,057
    Thank Post
    375
    Thanked 375 Times in 306 Posts
    Blog Entries
    8
    Rep Power
    177
    Matt.

    I fully agree that is the way it should be. Intellectual property rights etc.

    However, could I ask you to put up on here a piece of sample code (not anything to do with your creation) so I can understand the language used and how things fit together, I am very interested in this! (or PM)

  16. #15

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,425
    Thank Post
    368
    Thanked 642 Times in 524 Posts
    Rep Power
    159
    It's pretty much what you would expect. Searching\browsing\etc is like in SIMS and the business objects are like you would expect.

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

Similar Threads

  1. italc bulk import?
    By AntiThesis in forum Network and Classroom Management
    Replies: 2
    Last Post: 18th November 2011, 02:13 PM
  2. Anyone know how to bulk import into glpi
    By reggiep in forum Network and Classroom Management
    Replies: 3
    Last Post: 14th May 2010, 07:28 AM
  3. Bulk Import Contacts into Exchange 2003
    By TheFopp in forum Windows
    Replies: 4
    Last Post: 6th May 2010, 07:01 PM
  4. Bulk import of 'sites' in Sharepoint 2007
    By bandgeekmafia78 in forum Windows Server 2000/2003
    Replies: 0
    Last Post: 4th September 2009, 11:09 AM
  5. Replies: 11
    Last Post: 22nd May 2008, 08:23 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
  •