+ Post New Thread
Page 1 of 4 1234 LastLast
Results 1 to 15 of 50
MIS Systems Thread, Importing Email Addresses into Sims.NET in Technical; I've become more involved in the Sims/PARs side of things lately. I've noticed that PARs can Email Pupils/Staff about various ...
  1. #1

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,803
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224

    Importing Email Addresses into Sims.NET

    I've become more involved in the Sims/PARs side of things lately. I've noticed that PARs can Email Pupils/Staff about various incidents and I'd like to implement it. However to do so requries that the Email field is filled in for the Staff/Pupils in question. I'm new at this, but is there any way to bulk upload this sort stuff into Sims?

  2. #2
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    929
    Thank Post
    56
    Thanked 162 Times in 114 Posts
    Rep Power
    67
    hi geoff,

    The simple answer is no.
    If you were able to use SIMS.net business objects to writeback SIMS.net then it's possible.

    The easiest way is to ask for the parental email as part of your data collection process in september then your admin staff can update all the records in the same process.

    On a side note where are you parental emails currently stored?

    We are currently testing a email parent system i have created in moodle that also allows parental access.

  3. Thanks to penfold_99 from:

    Geoff (19th June 2009)

  4. #3
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    41
    So annoying I've looked into trying to import data into SIMS .Net before and the short answer is I can't.

  5. #4

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,803
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224
    Darn. So manual data entry is the only way to do it then?

  6. #5
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,485
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    75
    If you could persuade Capita to let you have a database map, you could presumably script a bulk update - doubt they'd give it up though...

  7. #6
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    929
    Thank Post
    56
    Thanked 162 Times in 114 Posts
    Rep Power
    67
    Quote Originally Posted by NickJones View Post
    If you could persuade Capita to let you have a database map, you could presumably script a bulk update - doubt they'd give it up though...
    Just get them to release plain English documentation with an example on how to get data when using there business object, that would be great!! but this is even less likely than the above option

  8. #7

    Join Date
    Feb 2006
    Location
    Dorset/Hants
    Posts
    87
    Thank Post
    2
    Thanked 13 Times in 10 Posts
    Rep Power
    20
    Quote Originally Posted by penfold_99 View Post
    Just get them to release plain English documentation with an example on how to get data when using there business object, that would be great!! but this is even less likely than the above option
    Coincidentally I created a supportnet ticket with SIMS on Friday 19th, asking about the rumoured "Business Objects", and received what I assume is the stock reply, that they would not want any of their customers editing the database directly.

    We are a school completely new to SIMS having used an in-house system for years and I was looking at a method for getting SIMS to email (sets of) students, which our old system could do. I managed to create a report which uses Outlook to send mails, so now need to get all of the student email addresses into SIMS.

    I used student email address as an example of what we want to enter but there are several other bits of data that need to be entered.

    We have basic student info entered via ctf, assessment data via csv but lots of stuff has no magic method for import, we are having to do a heck of a lot of manual data entry.

    If anyone know of any shortcuts to entering anything, I'd love to know - when I try to find out about such things google usually leads to the various threads on edugeek !

  9. #8

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158

  10. #9

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,621
    Thank Post
    1,239
    Thanked 777 Times in 674 Posts
    Rep Power
    235
    Quote Originally Posted by TimH View Post
    If anyone know of any shortcuts to entering anything, I'd love to know
    Spare dedicated workstation dedicated to running SIMS tucked away in your server room somewhere running an AutoIt script to fake mouse moves and keyboard entries to enter data.

    --
    David Hicks

  11. Thanks to dhicks from:

    TimH (22nd June 2009)

  12. #10

    Join Date
    Feb 2006
    Location
    Dorset/Hants
    Posts
    87
    Thank Post
    2
    Thanked 13 Times in 10 Posts
    Rep Power
    20
    Quote Originally Posted by matt40k View Post
    Thanks for that, trying to make contact and find out more.

    Anyone, as a school, using this ("business objects")?

  13. #11

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,401
    Thank Post
    637
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    319
    Quote Originally Posted by dhicks View Post
    Spare dedicated workstation dedicated to running SIMS tucked away in your server room somewhere running an AutoIt script to fake mouse moves and keyboard entries to enter data.
    Twenty-first century educational software at its best.

  14. #12

    Join Date
    Feb 2006
    Location
    Dorset/Hants
    Posts
    87
    Thank Post
    2
    Thanked 13 Times in 10 Posts
    Rep Power
    20
    Quote Originally Posted by dhicks View Post
    Spare dedicated workstation dedicated to running SIMS tucked away in your server room somewhere running an AutoIt script to fake mouse moves and keyboard entries to enter data.
    <Snigger> bit scary, would it really work (reliably) ?

    Tim

  15. #13

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,621
    Thank Post
    1,239
    Thanked 777 Times in 674 Posts
    Rep Power
    235
    Quote Originally Posted by Geoff View Post
    I've noticed that PARs can Email Pupils/Staff about various incidents and I'd like to implement it.
    You could take the opposite approach - get SIMS to export a report about incidents, then have a script parse that report and send emails off.

    --
    David Hicks

  16. #14

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,803
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224
    That doesn't work because we're using PARs. There is insufficent space allocated in the SIMS database for PARS to record all the incident data. Thus it uses it's own fields and tables. So if I do an incident export from SIMS, stuff is missing.

  17. #15

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,631
    Thank Post
    514
    Thanked 2,442 Times in 1,890 Posts
    Blog Entries
    24
    Rep Power
    831
    Quote Originally Posted by TimH View Post
    Thanks for that, trying to make contact and find out more.

    Anyone, as a school, using this ("business objects")?
    I had a look at it, but decided the NDA was far too restrictive and didn't use them in the end.

    I would advise looking at it from the angle mentioned by dhicks - export and use your own software to do what you want.

SHARE:
+ Post New Thread
Page 1 of 4 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
  •