trunten

Nice one. Thank you.

I currently have a SQL query that I use to create a spreadsheet for use in another program I use, however, I need to some how make an identical result set but using SIMS instead of CMIS. If there is anybody out there with knowledge of both that could take a look at my query and let me know if it is transposable to SIMS and also how to do that. SQL: select lecturer.displectid as [staff_ID], 'TT_Time' = (Case a.weekday when '1' then 'Monday' when '2' then 'Tuesday' when '3' then 'Wednesday' when '4' then 'Thursday' when '5' then 'Friday' else '' end + case left(a.starttime,2) when '08' then 'REG' when '09' then '1' when '10' then '2' when '11' then '3' when '13' then '4' when '14' then '5' else '' end), a.moduleid as [TT_Subject], a.roomid as [TT_Room], f.GroupCode as [TT_Group], d.StudentId as [iD], d.Surname, d.Forename, c.classgroupid as [Class], d.stusex as [Gender], e.slascgiftedtalented as [G&T], 'N' as [sEN], e.fsmeligible as [FSME] from lecturer right join (timetable a left join (teachinggroups f inner join (stugroups b inner join (students c inner join (nstupersonal d inner join ukstustats e on d.studentid = e.studentid and d.setid = e.setid) on c.studentid = d.studentid and c.setid = d.setid) on b.studentid = c.studentid and b.setid = c.setid) on b.groupid = f.groupid and f.setid = b.setid) on a.groupid = b.groupid and a.setid = b.setid) on a.lecturerid = lecturer.lecturerid and a.setid = lecturer.setid where a.setid = '2011/2012' and (d.leftschool = 'n' or a.moduleid != '') order by lecturer.displectid, [TT_Time] Headings: Rec num - Record number Staff_ID - CMIS Staff ID TT_Time - Time of the period TT_Subject - Subject of the timetable period TT_Room - Room of the timetable period TT_Group - Group code of the timetable period ID - Student ID Surname - Student Surname Forename - Student Forename Class - Student Class/Form group Gender - Student Gender G&T - Is the student G&T? (Y/N) SEN - Student's SEN category (A,P,S,N) FSME - Is the student FSM? (Y/N) For each timetbale period I am pulling through the staff and pupils associated so there are multiple rows (1 for each pupil / staff member) for each timetable event. Any help would be greatly appreciated.

See this thread for the main application and description: http://www.edugeek.net/forums/coding/90000-cmis-simple-results-visualiser-data-managers-etc.html Attached is the code as a zipped netbeans project. If anybody does decide to work on it and make it bettter please share. THanks -Jonathan ExamVisualiser Project.zip

I'd go with 2

Hi, I recently started learning how to program in Java and though I'd try and create something that was actually useful. Attached is the fruit of my labours. It's only the very first version but I'm releasing it into the wild with the hope that other may find it useful and perhaps improve on it and share those improvement with the rest of the community. I've attached the main jar file and the CMIS report which pull out the results data. The report will probably need tweaking for your particular setup as it uses study levels to determine the "weighting" of a qualification (Certificates are 2 diplomas 4 etc.). But once this is done export to a csv and you're away. I'll be posting the code in the group project thread for those of you interested in imporving it. -Jonathan ps. The reason the calculation for the weight of a qualification is done in CMIS rather than the program itself is because of the changes coming in 2014 which will mean everything is worth 1 gcse anyway. Exam Visualiser.zip