+ Post New Thread
Page 1 of 4 1234 LastLast
Results 1 to 15 of 54
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 ...
  1. #1

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,445
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160

    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.

    http://simsbulkimport.codeplex.com/

    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.

  2. 7 Thanks to matt40k:

    Ephelyon (5th March 2013), FragglePete (31st October 2012), GeneralDreedle (8th May 2014), localzuk (1st August 2012), Rawns (5th December 2013), splattthecat (1st August 2012), vikpaw (27th August 2012)

  3. #2

    Join Date
    Sep 2007
    Location
    Somerset
    Posts
    63
    Thank Post
    6
    Thanked 18 Times in 13 Posts
    Rep Power
    18
    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

  4. #3

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,132
    Thank Post
    522
    Thanked 2,542 Times in 1,976 Posts
    Blog Entries
    24
    Rep Power
    876
    Wow, so you got your head around the nightmare documentation that is the BO API then?

  5. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,445
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    Indeed I have, would happy give it to Capita in exchange for more Capita pens

  6. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,782
    Thank Post
    715
    Thanked 1,438 Times in 1,191 Posts
    Rep Power
    359
    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

  7. #6
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    985
    Thank Post
    58
    Thanked 165 Times in 117 Posts
    Rep Power
    68
    Quote Originally Posted by vikpaw View Post
    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
    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.
    Good idea though.

  8. #7

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,445
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    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.

  9. #8

    Join Date
    Dec 2008
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    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?

  10. #9

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,445
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    Don't know, will have a look tonight. Been thinking of removing the license stuff as it's pretty pointless.

  11. #10

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,782
    Thank Post
    715
    Thanked 1,438 Times in 1,191 Posts
    Rep Power
    359
    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.

  12. #11

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,445
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    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.

  13. #12

    Join Date
    Sep 2012
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    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.

    Cheers

    Steve

  14. #13

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,445
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    Have a look at the logs and see what it says. I assume you've got SIMS working ok on that machine?

  15. #14

    Join Date
    Sep 2012
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    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?

  16. #15

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,445
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    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.

SHARE:
+ Post New Thread
Page 1 of 4 1234 LastLast

Similar Threads

  1. [SIMS] Bulk import staff photos
    By MicrodigitUK in forum MIS Systems
    Replies: 3
    Last Post: 28th November 2010, 06:21 AM
  2. [SIMS] Bulk import staff email address
    By matt40k in forum MIS Systems
    Replies: 16
    Last Post: 31st October 2010, 10:59 PM
  3. [SIMS] Sims - CTF Import Queries
    By cgilmour in forum MIS Systems
    Replies: 13
    Last Post: 9th September 2010, 03:36 PM
  4. Bulk Import Contacts into Exchange 2003
    By TheFopp in forum Windows
    Replies: 4
    Last Post: 6th May 2010, 07:01 PM
  5. Sims CTF Import - Aspect not Found
    By mmuk08 in forum MIS Systems
    Replies: 1
    Last Post: 16th September 2008, 09:53 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
  •