CyBeRkId2002

Hi all, I used sign in app in a previous trust and had nothing but an outstanding experience. This time around things are different and I am struggling to get timely (or any) response to support tickets. I get a reply from Vizzy (AI?) but when I respond it doesn't seem to go anywhere. Are others having the same difficulties? Is support@ the best way to log tickets? Is there a phone number?

Did you ever get around to putting this on Github... would be very keen to take a look. We have Salamander but struggling to get out documents stored under Fees Communication (unless anyone can advise otherwise)

Does anyone here sync ParentPay from iSAMS (via Groupcall)??? If so would you be able to provide us with which field it uses as the unique identifier for the pupil? At present I can see from the API it could be three options: Pupil ID Person ID Person GUID SchoolID I suspect it is SchoolID but want to make 100% certain first as we are going through a mapping exercise (changing MIS) and I am not filled with confidence we have the correct info! Don't want to be in a position we have 100's (or possibly 1000's) or duplicates!

Hi all, We have been using Salamander Document Exporter as we transition away from SIMS, but I believe the latest update has broken it! Really bad timing for us as we were hoping to have it all extracted over the next few days. If anyone has it and is on the latest Summer release I would be extremely appreciative if you could give it a go and see if it works.

We would love to speak to someone. We have called multiple times (which has raised multiple tickets which has subsequently been closed) been promised call backs several times and are getting nowhere. Current open ticket is CS0290268

As title, has anyone who has undergone a merger managed to successfully combine two schools under one ParentPay? At present we have 2 Sims Servers > 2 ParentPays We will (hopefully) have 1 iSAMS tenency > 1 ParentPay It is important to have 1 ParentPay tenency for our future shared catering platform. I am getting nowhere with support and wondered if anyone has done this and what the process is like. ParentPay don't have an API integration with iSAMS so will be a manual upload so getting all students on shouldn't be an issue... I just have no idea what it will do with Parents who have existing accounts. Can they setup from scratch? Can they merge in the new pupil account? Will they see the old one and can this be avoided by removing that from the old tenency?

Hi all, Does anyone have any good free / open source seating plan software they use? Currently we use Edulink but moving to iSAMS we will lose this functionality. Have seen ClassCharts has this, but you need to buy the full package. Is there any other cheaper alternatives out there?

Sorry, I should have added that I have the login details, and a link to the db which has allowed me to create my own reports - but downloaded ones don't seem to use this data source. Is there something I need to do to link the two?

Managed to make a couple of reports myself after setting up a connection to the iSAMS database, but now I would like to tweak a couple of pre-created ones. I find Visual Studio easier than the cloud editor and have downloaded the templates, but when I try to run locally I get: An error occured during local report processing. An error has occured during report processing. I presume it is something to do with the connection to the database. Does it need to be in a certain format?

Sorry - for some reason it won't let me post it... even as code

Managed to get it sorted a few days after I posted this. I couldn't explain what the code does not, but if you are interested here is the query that pulled in everything I needed

Thanks TechMonkey... some really useful tips and pointers. Unfortunately I am still struggling and think this report writing malarkey may be beyond me. All I am trying achieve is the below: Name P1 P2 P3 Bob Smith 7Ar1 7Te3 7Fr1 At the minute my report brings in multiple rows for pupils with an N for the current day, each listing the additional lessons they are in. This is great and I will filter the output to the correct periods in the report view (or transpose the periods... not decided yet. SELECT TOP (1000) RegNCodes.[intRegistrationDateTimeID] ,CONVERT(Date,RegNCodes.[dtRegistrationDateTime]) As Date ,RegNCodes.[txtRegistrationName] ,RegNCodes.[intRegistrationPupilsID] ,RegNCodes.[txtRegistrationGroupName] ,RegNCodes.[txtRegistrationStatus] ,RegNCodes.[txtCode] ,RegNCodes.[txtSchoolID] ,PupilDetails.[txtPreName] ,PupilDetails.[txtPreferredSurname] ,RegAllPeriods.txtRegistrationGroupName ,RegAllPeriods.txtRegistrationName FROM [iSAMS_LGST].[dbo].[VwRegistrationSchoolRegistrationAttendance] AS RegNCodes --This Joins Pupil Information to pull in name -- JOIN [iSAMS_LGST].[dbo].[TblPupilManagementPupils] AS PupilDetails ON PupilDetails.[txtSchoolID] = RegNCodes.[txtSchoolID] --This is a self-join on Registration Attendance to pull in the additional classes for the day JOIN [iSAMS_LGST].[dbo].[VwRegistrationSchoolRegistrationAttendance] AS RegAllPeriods ON PupilDetails.[txtSchoolID] = RegNCodes.[txtSchoolID] -- This filters to ensure only N codes are for AM Registration. GetDate needs tidying to reformat the date field and remove date/time for a better comparison not relying on -1 -- WHERE RegNCodes.txtCode= 'N' AND RegNCodes.dtRegistrationDateTime > GETDATE() - 1 AND RegAllPeriods.dtRegistrationDateTime > GETDATE() - 1 AND RegNCodes.txtRegistrationName = 'AM Register' What I am really struggling with is matching up the classcode that is brought out with any kind of timetable information to show where the lesson is happening! Is there a table that holds ALL class information, a row for every period along with rooms and teachers? The closest I have found is called something like TimetableImport but I worry that this isn't the information used by the system and if manual changes to the timetable happen from within iSAMS this wont be 100% correct. I may put this down for now and come back to it over half-term!!!

Hi all, We are just migrating to iSAMS and hoping to up-skill a bit on SSRS to be able to pull some reports that we cannot find already included in iSAMS. I have tried starting on what I thought would be an easy-ish one. Our attendance team would like a simple spreadsheet that shows 'N' for the AM reg, and which lessons pupils should be in following that for the day (so the attendance team can quickly visit classrooms to check they are not marked incorrectly),. I have found the VwRegistrationSchoolRegistrationAttendance and filtered on N which shows who has received an N for the day but am really struggling to find how to bring in Timetable information. Could anyone help with the below: What are some of the best tables to pull timetable information in? Am I right in thinking it is going to be a really complicated lookup of the below (hoping there is a much easier way): Finding the period identifiers for the current day Getting a list of all classes for pupils with an N code Cross referencing these two to find out a unique session id that relates to that very specific lesson Looking up the room in another table Somehow presenting the above in SSRS What I am really struggling with on the above is that there seems very little consistency to Primary Keys within the database? I keep finding what I think are unique identifiers (and they must be somewhere to make it all work!!!) but everytime i cross-reference these to another table where logically they should match it is not correct and I assume there is another matching table somewhere... for someone with limited database knowledge it really is like a spiders web! More widely, can anyone recommend any SQL / SSRS e-learning so I can really get to grips with things? Thanks, Michael

We have, over the last couple of weeks, been migrating over from V3 (PCL) drivers to v4 drivers but are having nothing but issue after issue. Reason behind the move is to better support Arm devices which are becoming an increasingly attractive proposition. Main issues are: Significantly slower print jobs (and occasional lockups of the workstation) Having to push drivers out to the client manually first (not an issue but a bit of a nuisance) Settings not sticking, and even on occasion switching mid job Poor handling of some documents (enlarging embedded images etc) I wondered if others had similar experiences? I am on the verge of rolling back and writing off Snapdragons for another year or so to see if the situation improves.

Yeah, we do use Papercut but have been trying to avoid paying more buying the 'zones' add-on. If you don't mind me asking, how many zones are you typically using, and how much are they per annum. Think we could possibly get away with 10. Back to the original problem, it seems the printers are added and availble in print management really quickly (seconds) so don't think it is drivers, but the adding printer prompt doesn't disappear for a little while which I think is what is adding to the printer delay. Assume this is related to some kind of communication between client and printer after being added. Anyone else have this issue with Konica Minolta printers?

I am currently trying to speed up our logon process (particularly on shared laptops) and at the minute GPP Printers seem to be delaying logon. Before I look at scripting the whole thing (isn't massively complex so should be fairly straight forward) could I check - how are drivers handled for printers deployed using GPP? Are they redownloaded each time? That is the only thing I can think of that is adding a delay. If I script driver install on the devices does this speed things up? I imagined as we have Point and Print to allow non-admin installs they get installed at first connection and then are available on the workstation for all users, but this wouldn't explain why it takes time to process at every login. Logon time is around 1-2 minutes on a laptop (slightly longer if lots logging on at once), around 80% of this is sat on the Group Policy Printers step.

Yes - the above definitely fixes things and was something we needed to do a couple of weeks back. Out of interest, does anyone know the correct way to provision using powershell these days to avoid this issue?

Wow! I was literally about to post about this topic! My experience is that we had cracked it, but the latest update seems to have undone all of our work. I believe something has changed in the W11 build that has dropped ours from 20ish seconds (total time, inc. profile) to about 1 minute 30 seconds. Have others had this experience. If you were experiencing this prior to the latest update the best advice I can offer is cleaning out windows. Removing the unecessary Appx files makes a huge improvement and was how we got fast logons. Doesn't seem to work now though

Sorry for not replying sooner - I totally missed the notification! @dhicks - Is there any chance you could spare 30 minutes for a Teams call at ANY point over the summer break to show us a little bit about how this looks... how the data is pulled, organised etc. Would be massively beneficial to us and hugely appreciated. Regarding the tooling - I am fairly familiar with PowerBI and reasonably adept at manipulating data with it, producing dashboards etc. What I am less familiar with is using it as a tool to produce more traditional reports for dissemination. I suspect this is what you mean regarding a more Open Tool... are there recommendations on others out there?

Dear all, We are currently investigating iSAMS and I am keen to understand the complexities involved in making tweaks to the reports (both small and large) in-house using SSRS or similar. I wondered if anyone who is currently doing this would be kind enough to let me visit (more than happy to travel a few hours) and see how it all works and have a chat to the data team so I have a better understanding of the process and skillset needed. I have used SQL very basically before, and more recently PowerBI, but not touched SSRS yet. Any offers most gratefully received.

Hi all, As the title, are there any Independent Schools out there using Bromcom as their MIS, and if so how have you got around the quite glaring issues of Fee Billing. I am led to believe it is possible but I just can't understand how My findings so far are: Bromcom (and Arbor for that matter) do not generate Fee Invoices inside the MIS - quite understandably as they are not targeting (or quite ready for) the Independent sector as it stands. The only fit for purpose Financial Management system that does the billing process (working out how much to invoice based on parental relationships, discounts etc.) inside the finance package, rather than the MIS, is PASS Finance PASS Finance have a manual import facility which is fairly complex (as it understandably needs to be) which will be prone to failure if anything on the MIS reporting or PASS import changes (unlikely but possible). The larger issue is that... As we use Admissions+ (I believe) to collect Direct Debit details and Bromcom / Arbor do not have anywhere to store the information then some kind of matching is going to be needed between all three systems prior to import to get this into PASS Finance. This means almost constantly as we all know details change over time. This makes it, in my eyes, almost infeasible. I am just curious if anyone has got around this huge hurdle as we would like to at least investigate Bromcom as an option.

We have had a few users recently working on different computers around the school and files not syncing well. They are typically non-Microsoft Files (text and html is the Biggie) and I am fairly sure it is due to logging off too quickly before the file has synced (I suspect pupils may be clicking log-out, potentially with files saved but still open, or possibly not saved and relying on the "Do you want to save this file" prompt). This means files sometimes do not sync, and sometimes they create duplicates (with the computers file names) Other than user education is there anything we can do to minimise this? We are early in moving to OneDrive as our primary storage and think issues like this could hinder progress

We are currently considering Unifi wireless (among others) and I wondered if anyone had any recommendations on how to streamline the adoption process of Unifi Access Points across VLANs. At present we have Unifi Controller running on a VM in a VLAN (lets say VLAN5), with the aim of having all access points on the same VLAN. What options do I have for streamlining the process so I can plug the AP into ANY switch port and have it ready for adoption? So far my thinking is: Manually configure switch ports for the correct VLAN. This is what I have done historically and would like to avoid it if possible. Use LLDP to dynamically assign the VLAN on the switchport. I am not 100% whether our current switch supports this and, more importantly, if memory serves me correctly - at least on the older AP's - they pickup their IP before the VLAN has changed and refuse to switch over when it has Add a second virtual network card to the VM on the default VLAN. This would allow devices to see the controller as soon as they connect to the default VLAN. It could then be changed by defining the Mgmt Vlan in Unifi Have I missed any options? Can you setup any kind of Pointer / Forwarder on the default VLAN so it can find it on an alternate VLAN?

Thanks all for the responses - extremely useful to know that this approach (whilst far from ideal) is feasible although ideally will be targeting a 2-3 week window.

Thanks very much for all the responses! All really useful. Doesn't seem to be a standout so going to have to look at all options very carefully indeed.