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?