+ 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,523
    Thank Post
    375
    Thanked 677 Times in 551 Posts
    Rep Power
    166

    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,289
    Thank Post
    406
    Thanked 417 Times in 337 Posts
    Blog Entries
    8
    Rep Power
    191
    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,523
    Thank Post
    375
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    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,047
    Thank Post
    22
    Thanked 178 Times in 124 Posts
    Rep Power
    53
    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
    39
    Is XML import not possible?

  6. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,523
    Thank Post
    375
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    @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,289
    Thank Post
    406
    Thanked 417 Times in 337 Posts
    Blog Entries
    8
    Rep Power
    191
    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,523
    Thank Post
    375
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    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
    183
    Thank Post
    53
    Thanked 66 Times in 52 Posts
    Rep Power
    27
    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,289
    Thank Post
    406
    Thanked 417 Times in 337 Posts
    Blog Entries
    8
    Rep Power
    191
    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
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    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,523
    Thank Post
    375
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    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
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    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,289
    Thank Post
    406
    Thanked 417 Times in 337 Posts
    Blog Entries
    8
    Rep Power
    191
    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,523
    Thank Post
    375
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    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, 03: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, 08:28 AM
  3. Bulk Import Contacts into Exchange 2003
    By TheFopp in forum Windows
    Replies: 4
    Last Post: 6th May 2010, 08: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, 12:09 PM
  5. Replies: 11
    Last Post: 22nd May 2008, 09: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
  •