SIMS Bulk Import Thread, SIMS Bulk Import in Projects:; SIMS .net is currently the most popular MIS system used by schools across the UK. Historically it has not been ...
29th July 2012, 10:28 PM #1
SIMS Bulk Import
SIMS .net is currently the most popular MIS system used by schools across the UK. Historically it has not been possible to bulk import email addresses into SIMS .net. Capita has however released two patches giving the end user two separate options. One generates email addresses into SIMS .net based on the pupils admission number, which isn't ideal for most scenarios. The other patch allows you to import from a CSV file that is located on your D: drive. This is hard-coded into the patch an cannot be changed. This is less then ideal also.
This utility has been developed to over come these short comings and allows you to bulk import email addresses from a wide range of file types and from any location. It also does not require any patches to be applied. It is completely unofficial and is no way endorsed by Capita Children Services. This utility does however use the Capita SIMS .net Business Objects in order to interface with the SIMS .net database. This means it does not breach the Capita rules with regards to writing data to the SIMS .net database.
In additional to import email address the utility can bulk import UDF data. UDF stands for User Defined Fields and allows the end user to create data fields beyond that of the standard SIMS .net fields, for example you can store Windows Active Directory usernames in the SIMS .net database. This utility would then allow you to bulk import that information from a flat text file directly into the SIMS .net database.
I strongly believe that the MIS system should be the central repository for information in the School and hopefully this utility will be a step forward to achieve this.
Please also not that EduGeek does not endorse this product, I'm just stealing their forum
Last edited by matt40k; 21st November 2012 at 01:07 PM.
5 Thanks to matt40k:
Ephelyon (5th March 2013), FragglePete (31st October 2012), localzuk (1st August 2012), splattthecat (1st August 2012), vikpaw (27th August 2012)
IDG Tech News
1st August 2012, 03:01 PM #2
- Rep Power
Thanks for this Matt, we will take a look at it. I hate the idea of a patch importing a CSV file, as one of the Academies we support requested this patch from Capita and ran it when moving to InTouch, and the import crashed and left the database locked in single user mode, which we then dad to sort out.
This seems a much more sensible approach - perhaps you could sell it to Capita to replace the patch
1st August 2012, 03:26 PM #3
Wow, so you got your head around the nightmare documentation that is the BO API then?
1st August 2012, 03:52 PM #4
Indeed I have, would happy give it to Capita in exchange for more Capita pens
27th August 2012, 01:27 PM #5
And it's okay to freely distribute this without infringing the rules?
I'd have thought your LA would take dibs on it and want to charge
27th August 2012, 11:40 PM #6
Given this writes back to sims, capita will be requiring a licence payment of about £50. Watch out that you don't get a large bill.
Originally Posted by vikpaw
Good idea though.
28th August 2012, 08:33 AM #7
I asked Phil Neal if I could release it on SupportNet FOC and he said it was ok. I don't offer paid support and I don't charge, if I did, it'll be a license cost and my LA would want a cut, so I wouldn't make much to make it worth while. You have to accept the risk of using a tool that comes with "no" support - well no SLA or guarantees etc etc. I personally can't see the point of charging, Capita offer a solution, limited as it is and it can't really be automated - if it could be automated, then it might be worth it. I won't however being doing that as @rpwillis - SalamanderSoft already could\does do this and he's doing better then I could.
31st August 2012, 09:32 AM #8
- Rep Power
We have been looking for something like this for years. Thanks, Matt.
Installation went smoothly, but when I request a licence I continually get the message "Error: updating database" - is there a problem?
31st August 2012, 09:46 AM #9
Don't know, will have a look tonight. Been thinking of removing the license stuff as it's pretty pointless.
1st September 2012, 01:24 PM #10
If you get rid of the licencing hassle, i'll give it a go.
I'll be wanting to bulk import UDF data, with an extra caveat that the data will be unicode. Does that make a difference. I've got a patch on my system to allow unicode data (i can give you the sql for testing if required), so i can use arabic characters in UDF fields. Would be highly useful to bulk import the data directly, based on admission number if possible.
5th September 2012, 11:24 PM #11
The tool uses the same search as SIMS, you can match on admission number - no idea about unicode, I guess it might be possible?? I've attached it to this post because, well look over - Matt40k - anyway, it'll disappear from my website and fade from my memory.
If anyone wants the code go bug @PhilNeal for permission from a Capita licensing perspective, then I'll give you access to the (git) source code repository.
7th September 2012, 01:55 PM #12
- Rep Power
trying to have a go at using your program and cannot get any further than it asking for the server and db details.
have entered them as they should in the boxes and it keeps telling me to enter the server and database.
I dont think im doing anything wrong. Wondered if you could help.
7th September 2012, 02:18 PM #13
Have a look at the logs and see what it says. I assume you've got SIMS working ok on that machine?
7th September 2012, 02:47 PM #14
- Rep Power
nothing comes up in the log file, all i do is enter the login details server name and db name, press login and it tells me to enter the server name and database name as if i havent entered them.
sims works fine on my machine.
does it make any difference that my pc is a windows 7 64bit machine?
7th September 2012, 03:17 PM #15
I've tested it on XP pro 32bit, Windows 7 32bit and 64bit, server 2003 r2 32bit and windows server 2008 r2 and it works fine.
If it's missing the servername and database some thing is wrong with that machine. Open sims.ini, check the SIMSApplicationDirectory path. In that path, check the connect.ini, ideally it doesn't want to have a redirect but just the server and database name.
Last edited by matt40k; 7th September 2012 at 03:21 PM.
By MicrodigitUK in forum MIS Systems
Last Post: 28th November 2010, 06:21 AM
By matt40k in forum MIS Systems
Last Post: 31st October 2010, 10:59 PM
By cgilmour in forum MIS Systems
Last Post: 9th September 2010, 03:36 PM
By TheFopp in forum Windows
Last Post: 6th May 2010, 07:01 PM
By mmuk08 in forum MIS Systems
Last Post: 16th September 2008, 09:53 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)