corriganc

Yeah, we've started using Salamander's Net2 integration this past week, and it seems to solve all of our problems with user add/remove besides the Trust Central Team. It will automatically provision and expire staff based on their contract end dates in SIMS, so our school staff just need to link their ID badges up to Net2 for them. I did ask them about what we're looking for with the Central Team staff, but because they don't exist in the MIS at any of the sites, they can't do anything with them (their Net2 integration seems to rely on the MIS rather than AD). Unfortunately, we're currently running separate AD/Azure for each site, but this is something else that should be consolidated into one over the next 18 months.

The long term solution is to have a single server, but that's not the setup we currently have, or will be able to have for at least 18 months due to other factors at play. As such, I'm looking for a method to sync the departments between sites for the next 18 months.

Hi all, We have a Paxton Net2 server at each of our sites. Within this, there is a department for that site's staff (managed by Salamander) and another for Trust staff. This means whenever a member of the Trust Central Team joins/leaves, we have to make the changes 7 times. I'd like to try and automate this by using our Trust's Net2 server as the 'master department' and then keeping the other sites in sync. In my head, I'm wondering if there is some way to script the export of the department as a CSV (we only populate name and token) which I can then push to the other servers and have them go through the list and add anyone not already on their server, update anyone who has had a new token or got married and expire anyone who exists on the server but not in the CSV. Does anyone know if this is possible or, even better, have a solution for such a scenario? Thank you in advance. Kind Regards, Callum

Afternoon all, Just looking for some advice on the most efficient way to import behaviour data into SIMS. Currently, for various reasons, form tutors input a total amount of behaviour points for the previous week into a spreadsheet (has columns for the types of behaviour incidents). Our Data Team have to then take these spreadsheets and one by one go into each student and add a new behaviour incident and adjust the 'points' value to reflect the total number in the spreadsheet. Is there a way to construct a spreadsheet similar to the following: [TABLE=class: grid, width: 1500, align: center] [TR] [TD]Student Name[/TD] [TD]Student Form[/TD] [TD]Student UPN[/TD] [TD]Behaviour Type 1 (Matches SIMS Name)[/TD] [TD]Behaviour Type 2(Matches SIMS Name)[/TD] [TD]Behaviour Type 3(Matches SIMS Name)[/TD] [/TR] [TR] [TD]John Doe[/TD] [TD]7AAA[/TD] [TD]0123456789[/TD] [TD]8[/TD] [TD]5[/TD] [TD]0[/TD] [/TR] [TR] [TD]Jane Doe[/TD] [TD]7ABC[/TD] [TD]987654321[/TD] [TD]0[/TD] [TD]0[/TD] [TD][/TD] [/TR] [/TABLE] If we were to then save this as a whole-school spreadsheet, is there any way in SIMS to import this spreadsheet and SIMS automatically adds new behaviour events with the specified points values for each student? This would save our data team literally days of time as they could just download the spreadsheet from our shared area, stick it in SIMS and press go, rather than doing it by hand? We're running an on-site SIMS server and access SIMS using the SIMS.NET Desktop Application for Windows. Any and all help is greatly appreciated! Cheers.