ADT Posted April 5, 2019 Author Share Posted April 5, 2019 Ahhhhhhh formatting.......Its took me blinking ages to manually delete the stupid extra lines... but i've uploaded Year 11 exam timetables....... now just counting down the days till they get revised........................................ 1 Link to comment Share on other sites More sharing options...
pconkie Posted April 9, 2019 Share Posted April 9, 2019 On 05/04/2019 at 14:23, ADT said: Ahhhhhhh formatting.......Its took me blinking ages to manually delete the stupid extra lines... but i've uploaded Year 11 exam timetables....... now just counting down the days till they get revised........................................ I’d write a strongly worded letter to Capita if I were you! Clearly there is a way for companies to pay money to capita and use an api to get this information out of Sims cleanly. Schools have to spen hours reformatting.... Link to comment Share on other sites More sharing options...
ADT Posted April 10, 2019 Author Share Posted April 10, 2019 On 09/04/2019 at 09:19, pconkie said: I’d write a strongly worded letter to Capita if I were you! Clearly there is a way for companies to pay money to capita and use an api to get this information out of Sims cleanly. Schools have to spen hours reformatting.... Don’t think they’d listen somehow..... even with my “charm”.... little fish in a huge ocean!!! ? Link to comment Share on other sites More sharing options...
pdurber Posted February 11, 2020 Share Posted February 11, 2020 This is great. As usual However, I seem to have a problem with creating a pdf. Nothing happens when I click the button? I'm using Chrome as my browser. Also, if I use the User select widget, it's not giving me anything, maybe I don't have the later version, I've tried updating in Package Manager, but it says I'm up to date. Link to comment Share on other sites More sharing options...
ADT Posted February 12, 2020 Author Share Posted February 12, 2020 If only this was something Frog could pull in without the need to for the "donkey work"!!! I mean its not like Exams are the bread and butter for secondary schools..... but..... Erm.......... @Graham Quince @lucy.evans @Gareth Davies (Frog) @SteveH Link to comment Share on other sites More sharing options...
pdurber Posted February 17, 2020 Share Posted February 17, 2020 On 12/17/2018 at 10:16 AM, adamw said: @pconkie glad you managed to get something out of SIMS that was useful! I'll happily have a look at the widget when I get the opportunity. Also, I'd be interested in seeing the raw output of that CSV from Exams organiser. I assume other people who have SIMS also use this add on for exam timetables?n Or do you use something else? We use Sims, but our data/exams manager is so fed up with its "quirks" that she has written her own database. She uses the "Exams Organiser" module to make sure that her team don't miss any entries through "Human Error", but exports the info to be manipulated in her own database. Rooming (we don't have an exam hall)/special access arrangements etc. This means it takes seconds to output the file for use in Paul's widget, she now has a query set up which creates the csv file with the correct headings etc. She was absolutely delighted with the result as it has cut out a massive amount of effort on her team's part as well as saving a small forest! 1 Link to comment Share on other sites More sharing options...
pdurber Posted February 24, 2020 Share Posted February 24, 2020 Do we know why the "PDF" button isn't working/have a workaround? Link to comment Share on other sites More sharing options...
ADT Posted February 24, 2020 Author Share Posted February 24, 2020 56 minutes ago, pdurber said: Do we know why the "PDF" button isn't working/have a workaround? Check higher up the thread.... have you got the right version? Link to comment Share on other sites More sharing options...
pdurber Posted February 24, 2020 Share Posted February 24, 2020 Yes, I've downloaded and updated today, so assuming there isn't an old link kicking around, I should be bang up to date. Exams_Widget.mp4 Link to comment Share on other sites More sharing options...
pconkie Posted February 27, 2020 Share Posted February 27, 2020 @pdurber I can't replicate this issue. At first I thought it might be related to not having seats in the imported data, but i tried it on my platform with no seats and the pdf was created as expected. What error messages are in the console window? In Chrome click on the three dots top right --> more tools --> developer tools. Switch to the console tab. Click the pdf button and then post a screen shot of any message(s) that appear. Link to comment Share on other sites More sharing options...
pdurber Posted February 28, 2020 Share Posted February 28, 2020 Thanks for the excellent instructions. Below is the screenshot. Link to comment Share on other sites More sharing options...
pconkie Posted February 28, 2020 Share Posted February 28, 2020 1 hour ago, pdurber said: Thanks for the excellent instructions. Below is the screenshot. Interesting. Can you paste a small sample of the data pasted into the widget? (Maybe the first student will be enough - you can change the upn to keep it anonymous). Still think it is to do with the seat.... 1 Link to comment Share on other sites More sharing options...
pdurber Posted February 28, 2020 Share Posted February 28, 2020 Here's the first 2 students data { "Q933202808019": [ { "Date": "24/02/2020", "Time": "09:00", "ClassCode": "En", "CompTitle": "English Literature paper 1 - Shakespeare and the 19th Century novel", "Duration": 105, "Room": "Futures Exam Hall", "Seat Number": "" }, { "Date": "25/02/2020", "Time": "09:00", "ClassCode": "Fr", "CompTitle": "French - French Writing", "Duration": 120, "Room": "Northcote Exam Hall", "Seat Number": "" }, Link to comment Share on other sites More sharing options...
pconkie Posted February 28, 2020 Share Posted February 28, 2020 (edited) 39 minutes ago, pdurber said: Here's the first 2 students data { "Q933202808019": [ { "Date": "24/02/2020", "Time": "09:00", "ClassCode": "En", "CompTitle": "English Literature paper 1 - Shakespeare and the 19th Century novel", "Duration": 105, "Room": "Futures Exam Hall", "Seat Number": "" }, { "Date": "25/02/2020", "Time": "09:00", "ClassCode": "Fr", "CompTitle": "French - French Writing", "Duration": 120, "Room": "Northcote Exam Hall", "Seat Number": "" }, When i paste this into an Exam Timetable widget i don't get the same as what is shown in your video. The Code and Seat columns show "undefined". Which is the same as the pdf error message, which I can now replicate. In the data above 'ClassCode' should be 'CompCode' and 'Seat Number' should be 'Seat'. Also the duration's need to be treated like text. This means they need to be wrapped in quotation marks, Once i make these changes the pdf is produced despite the seats being blank! Edited February 28, 2020 by pconkie 1 Link to comment Share on other sites More sharing options...
ADT Posted February 28, 2020 Author Share Posted February 28, 2020 2 hours ago, pconkie said: When i paste this into an Exam Timetable widget i don't get the same as what is shown in your video. The Code and Seat columns show "undefined". Which is the same as the pdf error message, which I can now replicate. In the data above 'ClassCode' should be 'CompCode' and 'Seat Number' should be 'Seat'. Also the duration's need to be treated like text. This means they need to be wrapped in quotation marks, Once i make these changes the pdf is produced despite the seats being blank! He shoots... he scores!! Conkies back!! ? Link to comment Share on other sites More sharing options...
pdurber Posted March 1, 2020 Share Posted March 1, 2020 Thanks for all the help. Whatever I did with our data I was still getting the same problem, until I changed the Duration to Hrs & Mins. The JSFON conversion was removing the " however I formatted the data. Then it all worked perfectly. ? 1 Link to comment Share on other sites More sharing options...
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