MrGravell

Thanks for you concerns, Steve. Specifically I'm looking for testers to give feedback on the experience of using the tool itself - if your school has a heavy proofreading burden and might be interested in reducing it, let me know.

Hi all. I've recently added a bulk report proofreader to an AI-powered report writing tool I made. The proofreader offers same-day proofreading and correction of all your school reports (fixing typos, incorrect names/gender pronouns, etc). Here's a demo: If you're interested in testing it for free, please let me know - I'd really love to get some real-world feedback. PS for those concerned about data protection check out

My first time back on EduGeek in a long time! I need to help a school export class lists from SIMS to import them into https://realfastreports.com The data needed is: [TABLE=class: grid, width: 500] [TR] [TD]Class[/TD] [TD]Subject[/TD] [TD]Teacher Email[/TD] [TD]Preferred Name[/TD] [TD]Surname[/TD] [TD]Gender[/TD] [/TR] [TR] [TD]Y1GryfPot[/TD] [TD]Potions[/TD] [TD][email protected][/TD] [TD]Hermione[/TD] [TD]Granger[/TD] [TD]F[/TD] [/TR] [TR] [TD]Y1GryfPot[/TD] [TD]Potions[/TD] [TD][email protected][/TD] [TD]Harry[/TD] [TD]Potter[/TD] [TD]M[/TD] [/TR] [TR] [TD]Y1GryfPot[/TD] [TD]Potions[/TD] [TD][email protected][/TD] [TD]Ronald[/TD] [TD]Weasley[/TD] [TD]M[/TD] [/TR] [TR] [TD]Y1SlyTra[/TD] [TD]Transfiguration[/TD] [TD][email protected][/TD] [TD]Millicent[/TD] [TD]Bullstrode[/TD] [TD]F[/TD] [/TR] [TR] [TD]Y1SlyTra[/TD] [TD]Transfiguration[/TD] [TD][email protected][/TD] [TD]Gregory[/TD] [TD]Goyle[/TD] [TD]M[/TD] [/TR] [TR] [TD]Y1SlyTra[/TD] [TD]Transfiguration[/TD] [TD][email protected][/TD] [TD]Draco[/TD] [TD]Malfoy[/TD] [TD]M[/TD] [/TR] [/TABLE] Please can you let me know the easiest approach for exporting this data for all classes taught? Does anyone know of any tutorial videos that I can send their way to help them with this? The column headings don't need to be identical to these - it's the data that matters. The spreadsheet produced can be csv/xls/xlsx. demo-spreadsheet.xlsx

Fair enough. Events are, by comparison, relatively straightforward. Each event has one entry in APPAPPEVENT, and data for each field of each event is stored in APPAPPFIELDS. The only odd behaviour is that there's a lot of duplication of data in the two tables, and also that long comments get split into several entries in APPAPPFIELDS. But it's not terrible. I can see why you don't want to touch NSTURESULTS!

HA HA HA HA HA!!!!! Not laughing at you PyROm - am laughing at the prospect of adding serco firstline to my list of "trusted sites". As far as I can tell, firstline (which is by far and away the worst website I have EVER used) is storing my password as plain text in the database. Firstline in my list of trusted sites? I think not. It took about a week for them to sort my account out, and even now I don't have read permissions so I can't even read any forum posts. Utterly useless. Why is everyone so paranoid about writing to the database? People at my school are even afraid of reading from the database. Obviously I'd try it on a test server first, and also take a backup when I tried it for real. But really, how hard can it be? Is the database that crazy? It might be...

Thanks PyROm. Not sure how I actually access the document though - get a 'session expired' message. Not to worry though, I think I can get around all this crap by interacting with the database direct from PHP scripts. The database structure is a bit of a mess, but it's not totally indecipherable...

Yep it doesn't look like rocket science to edit the database direct, though there seems to be a big fear of it here. Especially no reason to be too worried if you test it on a duplicate installation first. In the end I'm not going to bother with the export/import though - I've written my own php script to access the database direct, collate events and email a spreadsheet to the required people - this quietly takes care of both the old and modified event types. I've also written a bit of javascript to hide the event types I don't want showing in ePortal - that should tide us over until next year when we can do things properly by deleting all the redundant definitions. Thanks for your help - will be useful next year... Pete

Thanks John. Two things: firstly, can I just confirm - is it possible to delete default event definitions (that are unused) from the current dataset? Our IT guy says you can't delete them. Secondly: essentially we've created a new version of an existing event definition, and added an extra field. This has occurred part way though the year, so there is data in the old event, and there will be data in the new event. I can work out how to export the old event data, but see no obvious way to import in to the new event. Do you have any ideas? I've started talking about importing here http://www.edugeek.net/forums/mis-systems/84178-cmis-importing-data-into-cmis-can-done.html so may be better to reply in that thread to keep things on topic... Thanks again, Pete

Sorry to drag up an old thread. The link from PyROm is now dead - any ideas where I can get instructions on importing? Also is it possible to import events? Event data is spread across two tables so this is likely to be more complex than just importing from a spreadsheet... Or am I better off just writing a script to enter it direct into the database using SQL?

Does anybody know how to hide old/redundant event types (detentions, merits, etc) from the select box on the event entry screen in ePortal? Can this be done through Facility? There are a whole load of event types we don't need (and also some we don't use any more but don't want to totally delete) - I just don't want them to show up as an option. Unfortunately you can't style s with css or I would just hide them that way. If there isn't a 'nice' solution I can hide them with javascript, but I'd rather not...