+ Post New Thread
Page 3 of 4 FirstFirst 1234 LastLast
Results 31 to 45 of 50
MIS Systems Thread, Importing Email Addresses into Sims.NET in Technical; Originally Posted by p858snake Ask for a student number The user interface would let you select a user by name, ...
  1. #31

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,664
    Thank Post
    1,263
    Thanked 786 Times in 683 Posts
    Rep Power
    237
    Quote Originally Posted by p858snake View Post
    Ask for a student number
    The user interface would let you select a user by name, but naturally you would store scanned documents linked to a unique ID, i.e. the student number produced by SIMS.

    You would also want to run the scan in though a automated system that ads a white area at the bottom to stamp the date, time and staff member id (of the person that scanned it in) for extra protection.
    Probably better to store that data as proper data somewhere so you can search through it later.

    --
    David Hicks

  2. #32

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,664
    Thank Post
    1,263
    Thanked 786 Times in 683 Posts
    Rep Power
    237
    Quote Originally Posted by localzuk View Post
    A webpart is just a compartmentalised web application
    Like a Java servlet?

    But it has to be in a .net language
    IronPython?

    --
    David Hicks

  3. #33

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,966
    Thank Post
    519
    Thanked 2,503 Times in 1,943 Posts
    Blog Entries
    24
    Rep Power
    841
    Quote Originally Posted by dhicks View Post
    Like a Java servlet?



    IronPython?

    --
    David Hicks
    Not quite like a servlet, but similar. A webpart is a dll file on a Windows machine, and it gets loaded wherever you place it on a sharepoint page.

    And, so long as 'IronPython' works as CLR code when compiled, I don't see why not.

  4. #34

    Join Date
    May 2009
    Location
    Sheffield
    Posts
    258
    Thank Post
    23
    Thanked 38 Times in 29 Posts
    Rep Power
    20
    Quote Originally Posted by dhicks View Post
    I'm now writing some charting software to take exam results and spew out pie charts and so on, if that's any help.
    Charting is OK - it's the issue of not being able to access the data within SIMS in the right way, and not being able to access it outside of SIMS without having to export it first...

  5. #35

    Join Date
    Feb 2006
    Location
    South Cumbria
    Posts
    199
    Thank Post
    26
    Thanked 29 Times in 24 Posts
    Rep Power
    22
    I'm not very expert on this but I wondered if something couldn't be done using the CTF. We just imported all our ULNs via CTF so it ought to be possible to create an XML file with the appropriate fields for email address and import a via CTF or am I being naive

  6. #36
    jenny_urey's Avatar
    Join Date
    Nov 2007
    Location
    Home: Telford Office: Wolverhampton Work Travel: all over UK!
    Posts
    124
    Thank Post
    33
    Thanked 11 Times in 10 Posts
    Rep Power
    18
    Quote Originally Posted by TimH View Post
    Yes, thanks, I noticed that, was going to visit when I need to do something complicated - our old system would email students their timetables, so it would be nice to do so with SIMS - but as we don't yet have a timetable in our SIMS then I'll have to wait !

    Plus, someone is going to say can we get it to talk to moodle at some point !

    tim

    We can talk to Moodle

  7. #37

    Join Date
    Sep 2012
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi

    I know this is an old thread, but I need to import about 1000 e-mails into SIMs and would like not to have to ask one of our admin staff to do this! I've downloaded AutoIt having come across this thread and although I have some programming skills, I don't have the time to play with it (thought it would be more like a macro recording, so I could cheat and actually do the first one, then check the script to see what commands to use)....does anyone have an AutoIt script (or at least something to get me started) that they would be prepared to share?

    Cheers (hopefully) in advance

    Kate

  8. #38
    MicrodigitUK's Avatar
    Join Date
    May 2007
    Location
    Wiltshire
    Posts
    336
    Thank Post
    37
    Thanked 55 Times in 51 Posts
    Rep Power
    24
    Quote Originally Posted by KateEChappell View Post
    Hi

    I know this is an old thread, but I need to import about 1000 e-mails into SIMs and would like not to have to ask one of our admin staff to do this! I've downloaded AutoIt having come across this thread and although I have some programming skills, I don't have the time to play with it (thought it would be more like a macro recording, so I could cheat and actually do the first one, then check the script to see what commands to use)....does anyone have an AutoIt script (or at least something to get me started) that they would be prepared to share?

    Cheers (hopefully) in advance

    Kate
    What about this? Never tryed it myself.

    SIMS Bulk Import

  9. Thanks to MicrodigitUK from:

    matt40k (26th September 2012)

  10. #39

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,089
    Thank Post
    378
    Thanked 387 Times in 313 Posts
    Blog Entries
    8
    Rep Power
    179
    Quote Originally Posted by MicrodigitUK View Post
    What about this? Never tryed it myself.

    SIMS Bulk Import
    +1 for matt's solution in the link.

  11. Thanks to GREED from:

    matt40k (26th September 2012)

  12. #40

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,682
    Thank Post
    692
    Thanked 1,408 Times in 1,166 Posts
    Rep Power
    354
    If you do want the patches from Capita, you can request them from your support. You'll need #17188, a script, then #17195

  13. #41

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,439
    Thank Post
    368
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    Is that the one where you need a D: drive with a csv file? Or the one that generates it based on the admission number?

  14. #42

    Join Date
    Nov 2011
    Location
    Cambridgeshire
    Posts
    522
    Thank Post
    141
    Thanked 75 Times in 67 Posts
    Rep Power
    19
    Welcome Kate
    @MicrodigitUK's solution is popular and has an excellent reputation , but haven't tried it myself.

    I got grumpy a couple of weeks ago because I had a big csv file of contact details referenced against admission numbers to input and wrote to Capita and told them so! After telling me several times that it wasn't possible I got a response from one of their Sys Analysts with the patches "#17188, a script, then #17195" @vikpaw mentions above and instructions on how to use them. If you'd like a copy as an alternative solution, let me know and I'll send them across. Don't know if it works as I haven't had time to try them.......

  15. #43

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,682
    Thank Post
    692
    Thanked 1,408 Times in 1,166 Posts
    Rep Power
    354
    Quote Originally Posted by matt40k View Post
    Is that the one where you need a D: drive with a csv file? Or the one that generates it based on the admission number?
    CSV , but it will also work on root of C: drive now, and if required it's trivial to alter the .sql to add another IF clause or just hard code it, if indeed you have a PC without either C or D drives
    I have another one that does it by admission number that was custom written for me, but locked to a particular version and when i asked for the version to be 999'ised as i like to refer to it, they sent me this new method.

  16. #44

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,439
    Thank Post
    368
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    Quote Originally Posted by vikpaw View Post
    it's trivial to alter the .sql to add another IF clause or just hard code it
    Ooo... what a nice way to void your warranty

    If you want a patch altered, get them to do it, then it'll have a signature so it'll apply via dbupgrade.

  17. #45

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,682
    Thank Post
    692
    Thanked 1,408 Times in 1,166 Posts
    Rep Power
    354
    It's okay, that will only happen if i find myself without a C or D drive in which case, there's probably no SIMS either and if that happened on the server, i'll be on the next flight out.

  18. Thanks to vikpaw from:

    matt40k (26th September 2012)

SHARE:
+ Post New Thread
Page 3 of 4 FirstFirst 1234 LastLast

Similar Threads

  1. [SIMS] Infopath Forms submitting into SIMS.net
    By J_Worth in forum MIS Systems
    Replies: 3
    Last Post: 30th June 2012, 09:50 AM
  2. [SIMS] Importing Email Addresses into SIMS
    By boffinson in forum MIS Systems
    Replies: 24
    Last Post: 29th April 2012, 02:48 PM
  3. [SIMS] Import into sims.net diary
    By philjones2000 in forum MIS Systems
    Replies: 9
    Last Post: 9th March 2011, 10:57 AM
  4. [SIMS] Bulk import staff email address
    By matt40k in forum MIS Systems
    Replies: 16
    Last Post: 31st October 2010, 10:59 PM
  5. Import Staff into Sims.net via a CSV
    By stephen.loader in forum MIS Systems
    Replies: 2
    Last Post: 14th January 2008, 11:32 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
  •