MIS Systems Thread, Future tutor groups in Technical; I am attempting to get a list of reg groups out of SIMS.net, with the effective date being next term.
4th August 2010, 11:58 AM #1
Future tutor groups
I am attempting to get a list of reg groups out of SIMS.net, with the effective date being next term.
I am using the Staff focus, with all staff, and have selected the staff member's ID number, and then added the Groups with sub items of 'Reg Group' and 'ID'.
No matter what I do, I always end up with last term's groups (and, a huge list of blank items).
Any hints as to whether or not I'm actually ever going to be able to do this? Or is it a case of 'wait until the new year roll-over'?
Peaking in the DB (yes, I know, bad, but all i'm doing is looking), I can see the data exists as it should in the group table but when I look at the group view (which I am assuming is where SIMS.net actually gets its data), it doesn't appear.
(Note: I can get the data I want, but the way to do it is a cludge and I don't like doing it this way - I want a simple report which can be ran, exported into XML and then imported into my app).
Last edited by localzuk; 4th August 2010 at 12:06 PM.
IDG Tech News
4th August 2010, 08:50 PM #2
There is a standard report that delivers this data. I am not in work this week so cannot point you in the exact direction but try looking at the standard reports in the Group Focus. You may have to copy and re-save with the choice of an effective date.
I cannot remember whether there is the option to change this date in the standard report.
8th August 2010, 04:36 AM #3
If you don't want the standard report, then based on the route you are taking, you most likely need to use the group membership date field if there is one. The effective date will only affect the first focus. The blanks will be either because duplicates are suppressed and / or the data you are requesting is doing a cross-product instead of bringing back unique results.
14th August 2010, 11:46 PM #4
It may also be worth chaning your academic year to next year within SIMS.
I think this is under Tools | Academic Management (I think) | Set Academic year.
Just an idea.
Last edited by superfletch; 14th August 2010 at 11:46 PM.
By James2k in forum Network and Classroom Management
Last Post: 2nd March 2010, 09:08 AM
By rad in forum Network and Classroom Management
Last Post: 31st January 2010, 11:15 PM
By onder in forum General Chat
Last Post: 18th March 2008, 04:29 PM
By localzuk in forum *nix
Last Post: 11th February 2007, 09:57 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)