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 ...
10th September 2013, 12:49 PM #1
- Rep Power
Batch Import Staff Email Addresses
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
10th September 2013, 12:58 PM #2
Funny, just had someone else ask about doing the same thing - SIMS Bulk Import - Download: SIMS Bulk Import - 184.108.40.206 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.
10th September 2013, 01:01 PM #3
- Rep Power
Ta! Very grateful thanks will check it out
3rd April 2014, 10:14 AM #4
@matt40k Does this tool still work with the latest SIMS? It just keeps prompting me for the database login.
3rd April 2014, 10:51 AM #5
Not sure, I'll test it tonight. I assume your running 1.7.22 and SIMS is working on workstation ok?
3rd April 2014, 11:49 AM #6
That is correct. I've tried servername\SIMS2008 and also just servername then the database name SIMS both times.
3rd April 2014, 10:03 PM #7
Just tested it and it's working ok.
SIMS .net - Pulsar.exe - 220.127.116.11
SIMS Bulk Import - SIMSBulkImport.exe - 18.104.22.168
Send me the log file if your still having trouble.
4th April 2014, 03:38 PM #8
- Rep Power
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
8th April 2014, 01:25 PM #9
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
Originally Posted by stupascoe
By wickit in forum Enterprise Software
Last Post: 10th May 2013, 02:33 PM
By Geoff in forum MIS Systems
Last Post: 27th September 2012, 02:07 PM
By boffinson in forum MIS Systems
Last Post: 29th April 2012, 02:48 PM
By Mr.Ben in forum General Chat
Last Post: 1st April 2012, 01:32 PM
By matt40k in forum MIS Systems
Last Post: 31st October 2010, 10:59 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)