penfold_99 Posted February 11, 2009 Posted February 11, 2009 Hi all, I am currently in the process of re-writing the sims2ad vb script and changing it to a moodle block. The question i have could people supply the format of their usernames ie [intake Year][initial First Name][initial Middle Name][surname] i would like to include as many formats as possible.
Gatt Posted February 11, 2009 Posted February 11, 2009 [First Initial][Middle Initial][surname] Though not all kids/staff have a middle initial!
penfold_99 Posted February 11, 2009 Author Posted February 11, 2009 @Gatt, Thanks Another question to add. Does you ad structure mirror the following structure? OU=[school Name] +=Year [intake Year] ie OU=School += Year 07 += Year 08 etc
Gatt Posted February 11, 2009 Posted February 11, 2009 OU=School +=Users ++=Pupils +++=Year 07 +++=Year 08 etc
penfold_99 Posted February 11, 2009 Author Posted February 11, 2009 [First Initial][Middle Initial][surname] Though not all kids/staff have a middle initial! What happen if you have two people with the same name?
Gatt Posted February 11, 2009 Posted February 11, 2009 we add an incremental number at the end jbloggs jbloggs1 jbloggs2 etc
Diello Posted February 11, 2009 Posted February 11, 2009 [2-digit-YoE]+[surname]+[FirstInitial] e.g. 08BloggsJ - if there is say a John & a Jane, then 08BloggsJo & 08BloggsJa OU=School +=Users +=Students +=?? Intake (?? being YoE)
webman Posted February 11, 2009 Posted February 11, 2009 Staff and students: (firstname).(lastname) joe.bloggs joe.bloggs1
Hightower Posted February 11, 2009 Posted February 11, 2009 [surname][initial] 08BloggsK 08BloggsK1 Staff are either [initial][surname] or [surname][initial] (Mix of both for some reason). CC3 network for AD Structure
User3204 Posted February 11, 2009 Posted February 11, 2009 You know that Capita to a AD provisioning plug in for SIMS ? And I think it lets you use some sort of regular expressions to assign usernames (it certainly let me do this for our SLG users). Staff: First 4 letters of firstname, first four letters of surname, so GordBrow, this is what we use for SIMS.net and AD domains. I was talking to a new member of staff who'd had logging on issues, due to the fact at his previous school they use first three of the forename and first 3 of the surname. For students it is just [surename][forename initial][as many middle name initials as I can get][numeric counter if more than one] (so how I managed to get SmithC5 is because, I have 6 students with no middle names, but the forenames start with a C). We have students in AD as [ /students/2009Entry/{username} ] If you want to confuse matters, we also store the users home folder in [ d:\users\09\{form}\{username} ] which we share out to the user as [ \\servername\{username} ] whereas staff are in [ d:\users\staff\{teachers or support}\{username} ].
penfold_99 Posted February 11, 2009 Author Posted February 11, 2009 You know that Capita to a AD provisioning plug in for SIMS ? And I think it lets you use some sort of regular expressions to assign usernames (it certainly let me do this for our SLG users). Staff: First 4 letters of firstname, first four letters of surname, so GordBrow, this is what we use for SIMS.net and AD domains. I was talking to a new member of staff who'd had logging on issues, due to the fact at his previous school they use first three of the forename and first 3 of the surname. For students it is just [surename][forename initial][as many middle name initials as I can get][numeric counter if more than one] (so how I managed to get SmithC5 is because, I have 6 students with no middle names, but the forenames start with a C). We have students in AD as [ /students/2009Entry/{username} ] If you want to confuse matters, we also store the users home folder in [ d:\users\09\{form}\{username} ] which we share out to the user as [ \\servername\{username} ] whereas staff are in [ d:\users\staff\{teachers or support}\{username} ]. Hi , Yes I am aware of the AD provisioning with SLG. Our LA is looking at hosting our SLG so the we will have to hand over control of our ad domain to allow single sign on. We prefer to use as little MS software as possible, save the continual upgrade cost. I will add your username format to the list, i will look into the folder creation part later on, we currently use a samba server to host out home folders as it creates the home directories on first logon.
Oops_my_bad Posted February 12, 2009 Posted February 12, 2009 students: 4 digit admission number (but changing these to 6 next year) staff: staff code in SIMS
jamesb Posted February 12, 2009 Posted February 12, 2009 Our LA is looking at hosting our SLG so the we will have to hand over control of our ad domain to allow single sign on. SLG accounts can be consolidated against different AD domains, so technically there's no reason that the LA shouldn't be able to provision to a domain of their own, then consolidate those accounts against your own internal domain for single sign-on. This does require trusts to be set up correctly.
penfold_99 Posted February 12, 2009 Author Posted February 12, 2009 CC3 network for AD Structure @Hightower, Could you expand? as i have never seen a CC3 network
Oops_my_bad Posted April 11, 2009 Posted April 11, 2009 Hi Penfold, Could you tell me how I could modify this script so I could use pupil admission numbers for their logins/home drives? Currently, I have setup the view in SQL which I've slightly modified to also select student admission number and strip out the leading zeros. It then puts these in another column, Expr1. Thanks chap
penfold_99 Posted April 14, 2009 Author Posted April 14, 2009 Make it use the commandreport tool rather then direct SQL I doubt that is possible from a linux box.
matt40k Posted April 14, 2009 Posted April 14, 2009 Well I assume your SIMS server is Windows, assume you can join the dots. (Also will save on network traffic)
penfold_99 Posted April 14, 2009 Author Posted April 14, 2009 Well I assume your SIMS server is Windows, assume you can join the dots. (Also will save on network traffic) I'm in the process of converting the sims2ad to a moodle module to allow for better administration.
jamesb Posted April 14, 2009 Posted April 14, 2009 I'm in the process of converting the sims2ad to a moodle module to allow for better administration. Could always use the commandreport tool to generate reports on a schedule, then link into those from your linux box.
penfold_99 Posted April 14, 2009 Author Posted April 14, 2009 Could always use the commandreport tool to generate reports on a schedule, then link into those from your linux box. can you point me in the direction of the command reporter documentation?
penfold_99 Posted April 14, 2009 Author Posted April 14, 2009 @matt40k: what rights does a user need apart from third party reporting? As currently i have created a user called SIMS2AD and it logs in fine but command reporter dies with an error of no permission on report.
matt40k Posted April 14, 2009 Posted April 14, 2009 Assuming the report is pulling only pupil data, something like class teacher, or such will do it. You might want to create a custom security group with just the required permissions (be (completely) better then UniServity then) . Latest list is on capita's supportnet - 15163
penfold_99 Posted April 21, 2009 Author Posted April 21, 2009 Assuming the report is pulling only pupil data, something like class teacher, or such will do it. You might want to create a custom security group with just the required permissions (be (completely) better then UniServity then) . Latest list is on capita's supportnet - 15163 @matt40k I had a look at your report, it currently only lists students, i can't find a away in sims to show students and teachers with there roles. Do you know of a way?
matt40k Posted February 19, 2014 Posted February 19, 2014 I think @penfold_99 released it as commercial product? - SchoolsICT Alternative is SalamanderSoft - SalamanderSoft Limited
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now