ADT Posted January 25, 2019 Author Share Posted January 25, 2019 But just to clarify @pconkie your script in layman's terms just pulls all the useful data from the original worksheet, changes its orientation and adds the Exam No to the end of each row!! Link to comment Share on other sites More sharing options...
ADT Posted January 28, 2019 Author Share Posted January 28, 2019 It seems we add "Special Arrangements required" onto our candidate timetables below the other data... this throws those timetables out by 1 column!! Mint! Link to comment Share on other sites More sharing options...
pconkie Posted January 28, 2019 Share Posted January 28, 2019 1 hour ago, ADT said: It seems we add "Special Arrangements required" onto our candidate timetables below the other data... this throws those timetables out by 1 column!! Mint! We do this too. The macro takes care of that. I think the issue must be the final step to turn the xls to keyed Json? Link to comment Share on other sites More sharing options...
ADT Posted January 28, 2019 Author Share Posted January 28, 2019 I’ll give it another go tomorrow... Link to comment Share on other sites More sharing options...
ADT Posted January 31, 2019 Author Share Posted January 31, 2019 Once again @pconkie has come up trumps and sorted me out with a bespoke macro to fix our "dodgy" SiMS data!! Thanks again!! 1 Link to comment Share on other sites More sharing options...
ADT Posted February 13, 2019 Author Share Posted February 13, 2019 So @adamw a parent version of this???? Link to comment Share on other sites More sharing options...
gbligh Posted February 22, 2019 Share Posted February 22, 2019 @pconkie - we have been using this really well for Year 11 and Year 13 and they love it. Thanks for creating. I got the attached email from a parent though and wonder if you can shed any light on it? I've heard this from a few kids too .... FW Mock Exam Timetables.pdf Link to comment Share on other sites More sharing options...
pconkie Posted February 23, 2019 Share Posted February 23, 2019 12 hours ago, gbligh said: @pconkie - we have been using this really well for Year 11 and Year 13 and they love it. Thanks for creating. I got the attached email from a parent though and wonder if you can shed any light on it? I've heard this from a few kids too .... FW Mock Exam Timetables.pdf Yeah - that's a bug that didn't appear when we used it because we didn't put on as many exams as you. I'm using a library to create the pdf and assumed that a new page would be automatically added if needed. What is actually happening is that all exams are getting printed to the pdf but some are outside the range of the viewable area of the page. I have fixed this so that if we reach the bottom on the page a new page is added. I have also added a widget preference so that the pdf button can be hidden. Hopefully @Graham Quince can update your server with the new version. Paul Link to comment Share on other sites More sharing options...
gbligh Posted February 23, 2019 Share Posted February 23, 2019 24 minutes ago, pconkie said: Yeah - that's a bug that didn't appear when we used it because we didn't put on as many exams as you. I'm using a library to create the pdf and assumed that a new page would be automatically added if needed. What is actually happening is that all exams are getting printed to the pdf but some are outside the range of the viewable area of the page. I have fixed this so that if we reach the bottom on the page a new page is added. I have also added a widget preference so that the pdf button can be hidden. Hopefully @Graham Quince can update your server with the new version. Paul Amazing thank you Paul. @Graham Quince if you could do the honours Link to comment Share on other sites More sharing options...
ADT Posted February 25, 2019 Author Share Posted February 25, 2019 @pconkie as usual we are in your debt!! And us @Graham Quince!!! Link to comment Share on other sites More sharing options...
Graham Quince Posted February 26, 2019 Share Posted February 26, 2019 The new version is live on the Community: https://www.frogeducation.com/community/frogcode/frogcode-showcase/examtimetables Link to comment Share on other sites More sharing options...
gbligh Posted February 26, 2019 Share Posted February 26, 2019 How do I update a current widget with a new version? Link to comment Share on other sites More sharing options...
adamw Posted February 26, 2019 Share Posted February 26, 2019 10 minutes ago, gbligh said: How do I update a current widget with a new version? If you have access to package manager, you can upload the new version and then press 'check for updates' from the cog menu. You should then see that the widget get's a little icon above it to show that an update is available. Select it and press 'update' and that should do it. That's from memory, pretty sure I didn't miss any steps 1 Link to comment Share on other sites More sharing options...
ADT Posted March 29, 2019 Author Share Posted March 29, 2019 @Graham Quince @adamw Any idea of how we can get Conkies widget to work for parents... this would help me cross off one of the reasons to keep using TASC Insight for parent data! Link to comment Share on other sites More sharing options...
adamw Posted March 29, 2019 Share Posted March 29, 2019 2 hours ago, ADT said: @Graham Quince @adamw Any idea of how we can get Conkies widget to work for parents... this would help me cross off one of the reasons to keep using TASC Insight for parent data! I've not had a lot of time to look into this widget, why doesn't it work for parents? Link to comment Share on other sites More sharing options...
gbligh Posted March 29, 2019 Share Posted March 29, 2019 I thought it already did Link to comment Share on other sites More sharing options...
ADT Posted March 29, 2019 Author Share Posted March 29, 2019 22 minutes ago, gbligh said: I thought it already did Does it???? Have you tested it??? Link to comment Share on other sites More sharing options...
Graham Quince Posted March 29, 2019 Share Posted March 29, 2019 44 minutes ago, ADT said: Does it???? Have you tested it??? I'm sure Paul rewrote it on George's request to work with the User Select widget Link to comment Share on other sites More sharing options...
ADT Posted March 29, 2019 Author Share Posted March 29, 2019 4 hours ago, Graham Quince said: I'm sure Paul rewrote it on George's request to work with the User Select widget Must have missed that... reading through this thread I can see gblyth asking... Conkie saying would need tweeking maybe frog could... then later on gblyth saying something about a parent email!! Guess I should give it a go then!! ? Link to comment Share on other sites More sharing options...
pconkie Posted March 29, 2019 Share Posted March 29, 2019 3 hours ago, Graham Quince said: I'm sure Paul rewrote it on George's request to work with the User Select widget I did! It should! 1 Link to comment Share on other sites More sharing options...
ADT Posted April 1, 2019 Author Share Posted April 1, 2019 Sorted!! Thanks!! Link to comment Share on other sites More sharing options...
ADT Posted April 1, 2019 Author Share Posted April 1, 2019 OK now how do i change the style of the user widget??? Whos idea was it to make it purple and black text? @Graham Quince Link to comment Share on other sites More sharing options...
ADT Posted April 5, 2019 Author Share Posted April 5, 2019 Erm.... sorry to be a pain again....... Anyone else had issues with putting this summers exams in..... some of our kids have two pages worth of exam entries... and it doesnt like it!!! And its messed up with kids with Special Requirements!!! Why does nothing work for us out of the box @pconkie Update.... looks like they are one in the same issue..... when it goes over to another page it knacks!!! Basically some kids second sheets start with a random Component Title - P2f (some science exam) over hanging from the first page or Room - only (which we use for the special arrangements) Hmmmmmmmmm Link to comment Share on other sites More sharing options...
pconkie Posted April 5, 2019 Share Posted April 5, 2019 2 hours ago, ADT said: Erm.... sorry to be a pain again....... Anyone else had issues with putting this summers exams in..... some of our kids have two pages worth of exam entries... and it doesnt like it!!! And its messed up with kids with Special Requirements!!! Why does nothing work for us out of the box @pconkie Update.... looks like they are one in the same issue..... when it goes over to another page it knacks!!! Basically some kids second sheets start with a random Component Title - P2f (some science exam) over hanging from the first page or Room - only (which we use for the special arrangements) Hmmmmmmmmm Make sure you have the latest version of the widget as I made some changes for George to fix the "more than one page" problem. As for the other issue, your format must have changed since your mock exams!!! Why would that be? I take it you used the *special* version of the macro i sent you? Don't suppose the original version of the macro now works for you?! Link to comment Share on other sites More sharing options...
ADT Posted April 5, 2019 Author Share Posted April 5, 2019 17 minutes ago, pconkie said: Make sure you have the latest version of the widget as I made some changes for George to fix the "more than one page" problem. As for the other issue, your format must have changed since your mock exams!!! Why would that be? I take it you used the *special* version of the macro i sent you? Don't suppose the original version of the macro now works for you?! Hi Conkie..... I'm not even onto the widget bit this is just sorting formatting the data!! It because the data over hangs onto a second page on the report so when you export it from SIMs it give them two entries... and on the second one it sometimes starts with the data from the one above..... 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