+ Post New Thread
Results 1 to 9 of 9
MIS Systems Thread, Batch Import Staff Email Addresses in Technical; Hi guys, We're trialling AlfiSoft, and aong the data this system needs from SIMS is staff email addresses which we ...
  1. #1

    Join Date
    May 2011
    Location
    London
    Posts
    89
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Batch Import Staff Email Addresses

    Hi guys,

    We're trialling AlfiSoft, and aong the data this system needs from SIMS is staff email addresses which we don't store in SIMS.

    Does anyone know if this can be batch imported, or do we have to add them one by one?

    We're using SIMS 7.114

    Cheers guys,

    Tom

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    Funny, just had someone else ask about doing the same thing - SIMS Bulk Import - Download: SIMS Bulk Import - 2.0.0.0 Preview

    I wrote tool to do it. It uses the SIMS Business Objects to import, so you need to have SIMS Applications installed for it to work.

  3. #3

    Join Date
    May 2011
    Location
    London
    Posts
    89
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Ta! Very grateful thanks will check it out

  4. #4

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,161
    Thank Post
    403
    Thanked 623 Times in 569 Posts
    Rep Power
    181
    @matt40k Does this tool still work with the latest SIMS? It just keeps prompting me for the database login.

  5. #5

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    Not sure, I'll test it tonight. I assume your running 1.7.22 and SIMS is working on workstation ok?

  6. #6

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,161
    Thank Post
    403
    Thanked 623 Times in 569 Posts
    Rep Power
    181
    That is correct. I've tried servername\SIMS2008 and also just servername then the database name SIMS both times.

  7. #7

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    Just tested it and it's working ok.

    SIMS .net - Pulsar.exe - 7.156.31.0
    SIMS Bulk Import - SIMSBulkImport.exe - 1.7.22.0
    OS: Win8.1Pro

    Send me the log file if your still having trouble.

  8. #8

    Join Date
    Jun 2007
    Location
    South West
    Posts
    1
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I found that if you are using a redirected connect.ini, it doesn't work. Copy the contents from the remote connect.ini to the local one in the SIMS.net directory and it works.

    On a separate note, I have found that it crashes at around 20 records on my Windows 8 machines. Works fine on XP tho..

    Very useful tool. Thanks @matt40k

  9. #9

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    Quote Originally Posted by stupascoe View Post
    On a separate note, I have found that it crashes at around 20 records on my Windows 8 machines. Works fine on XP tho..
    I suspect it's just not reporting back to the UI correctly, if you open the logs you should still see it processing the import. Failing that, could you send me the logs

SHARE:
+ Post New Thread

Similar Threads

  1. 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
  2. [SIMS] Importing Email Addresses into Sims.NET
    By Geoff in forum MIS Systems
    Replies: 49
    Last Post: 27th September 2012, 02:07 PM
  3. [SIMS] Importing Email Addresses into SIMS
    By boffinson in forum MIS Systems
    Replies: 24
    Last Post: 29th April 2012, 02:48 PM
  4. Staff Email Address Policy
    By Mr.Ben in forum General Chat
    Replies: 21
    Last Post: 1st April 2012, 01:32 PM
  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
  •