pconkie

Why has my markbook now got all of the students in the class listed twice?

Still not shown up. How long should I wait??

No sign of it after refreshing....

Hold on. Where does it go when downloaded? I've waited....I've logged out and back in.....I've closed the browser and re-opened - no Election 2019 site?

@ADT has the correct solution again. He should get commission or something. You do have to access the store from within frog - actually from within the local frog store app, which doesn't appear in search results with the following search terms "frog store" or "store" but is in frogdrive/applications or with search term "frogstore" (all one word). Downloaded now - thanks! Perhaps this can be made a little bit easier?

It’s break time (or was) I was drinking my cup of tea!

From within frog - yes - by clicking on the ribbit and following the links. Searched for frog store inside frog - didn’t find anything. didn't look in apps!

I’ve tried both @Connor Hutchinson

Ok, I give up! How do you actually get to download the election site from the frog store? I am logged into my VLE!

It worked. Thanks.

A few questions for the datastore experts @adamw We have been using datastore as a replacement to the SIMS behaviour module since September. It has been very well received by staff as our new system is so quick and easy to use. Parents love the fact that sanctions, detentions and rewards become instantly available in frog (rather then waiting for the overnight sync). We have incorporated the new email api to push notifications out to parents. Its working really well at the moment, In 8 weeks we have generated 3375 behaviour datastore records. With another thousand or so related records for detentions and time spent in our behaviour support room. There isn't a noticeable performance hit yet, but is there anything i should do / should be aware of to keep things working optimally? I did give staff the option of viewing records "for all time" initially, but have removed this now in favour of "this academic year" (which I think may eventually have to go as well). I've set records from "today" as the default filter option. I'm using incident category e.g "formal warning", "removal from lesson", "serious incident", "other" etc as the alias in the main datastore. 80% of records are warnings. Is there a way to filter alias in the api call along the lines of "NOT formal warning" or "everything except formal warning". This will certainly improve things further. If anyone is interested I attach the structure we are using for the frog datastore and our behaviour system flowchart. It needed to be a 'live' system and frog allows us to do this. Thanks Paul sanction data structure.docx Colour behaviour.drawio.pdf

@ADT As for your second request......why????

I just happened to have some similar code for working out the whole school attendance rate by going through the attendance of every mis linked student getAllStudents: function() { this.showLoader(); Frog.Model.api('users.getSummary', { mis: "mis", profile: "profile-student", sortBy: "surname", direction: "asc", group_types: "registration|year" }).done(function(response) { for (var x = 0; x < response.data.length; x++) { var student = response.data[x]; if (student.details.thumbnail == null) { console.log(student.displayname) } } this.hideLoader(); }.bind(this)).fail(function(e) { var error = JSON.parse(e.responseText); var error_msg = error.response.message + "<BR/>Failed to get user data" this.hideLoader(); this.modal("There has been an error", error_msg, "modal", null, false); }.bind(this)); }

A little bit of code could prepend a P_ (or similar) to the username of the primary contact for you...

This one isn't being shared at this stage - sorry. Reasons for not sharing at this stage - its not been tested enough its too bespoke to our school (which is a roundabout way of saying it would be too much work at the moment to make it work properly for your school context) Thanks

Clicking on the students name take's you to full certificate and interventions record...

That just leaves a sneak peek at our frog attendance tracker....

I'm using PowerShell to: check the param.xml file exists in the downloads folder if more than one exists then get the most recent run CommandReporter.exe and wait for the data to be returned if no error code delete the param.xml file open the correct word template From here a macro in the word template takes over to complete the merge and hide the template.

So CommandReporter.exe needs to be run with the following additional parameters: valid sims username (required) valid sims password (required) name of report to run (required) path to params.xml file (optional) output format (optional) The params.xml file is the key - this is what frog creates for me and contains the parameters in the correct format that will be used by the report at run-time. If the file is not provided the report parameters default values will be used.

On a workstation which has SIMS installed there is a folder: C:\Program Files\SIMS\SIMS .net Within this folder is a "remote control" for SIMS reports called the CommandReporter.exe I have set up a report in SIMS which gets address info for students that can be specified at run-time by their UPN: As you can see i can currently specify up to 20 UPNs - this means I can do a mail merge in batches of 20 letters max - but this isn't a hard limit and can modify my SIMS report to add more at any time. This is a rather useless SIMS report if the intention was to run it via the SIMS interface - I would need to know and type UPNs in to the report when it ran! However, it is perfect for an automated process where frog provides the UPNs.

No. It queries SIMS using the UPNs from frog (could also use pupil number) to get the address information, which gets sent back. There is no write back.

This sits on the client - it needs access to the file from frog and the SIMS.net program folder. The IT Techs like PowerShell as it is built right into Windows Group Policy - they can basically lock it down anyway they want.

Had a few ideas lately to further improve frog functionality and usage. However a stumbling block is often that the data required is not in frog (not pulled from the MIS). For example, like most schools we send attendance letters home when certain thresholds are triggered. It can be a painful experience working with SIMS even to get the data out in an easy to use format, let alone building a consistent system around it. What if we could build the system around frog?! Well it does have the attendance data, but not the address information that would be needed for the letters. Then I had another thought.... What if frog could 'talk' to SIMS 'live'? Information could then be requested 'on demand'. We are in a position where both frog and SIMS are hosted on site and on the same network too (I realise not everyone has that set-up), but maybe it's possible for us to get them talking. I set about trying to get a simple mail merge set up... The solution I have come up with is this: All the requests for letters from staff appear in frog in a simple list. A member of support staff ticks the letters they want to include in the merge and then presses the merge button Frog generates and triggers a download of a small file containing students UPN and which letter template to use. A powershell script then runs which reads the file generated by frog and sends it to SIMS 10 seconds later the letters appear! It seems to be working well so far and opens up the door to doing more with attendance in frog rather than SIMS.

I think there are two separate issues then: personally I’ve had no problems setting assignments nor have I had anyone else here say that they can’t set assignments. We just have reports from some users that they can’t see them after clicking on the indicator in the top right.

Here is the console error and the exception breakpoint stops from the relevant videos. Hopefully a fix can be issued as soon as possible.