dawsonz

Thank you for your responses. We have a demonstration booked in for mid december so will be interesting to see what they offer.

Hello My school is currently using Facility Administration and we're looking into changing our MIS. We've had a demonstration from Progresso but feedback from other schools is that it doesn't work well, we will also have a demo from SIMS in the near future. Has anyone else done the change from Facility (or others) to SIMS and if so what were the pros/cons? What can SIMS offer that Facility doesn't? Thanks Richard

Yours would work, however I created a query like so:

Hi Limbo Thanks for your response - I have finally got something working but have taken a different approach. The CMIS database is such a headache.

Hello I'm currently trying to take out data from the CMIS database as I want to be able to collate a gridview with all events. I've looked into the following tables: CMIS.dbo.APPAPPEVENT The above table stores the particular event with 'AppEventId'. The 'AppEventId' is then stored in CMIS.dbo.APPAPPFIELDS - this table holds one line per value. So for example a single event in APPAPPFIELDS would look like the following: [TABLE=class: grid, width: 500, align: center] [TR] [TD=align: center]SetId [/TD] [TD=align: center]AppCode [/TD] [TD=align: center]AppEventId [/TD] [TD=align: center]EventId [/TD] [TD=align: center]FieldId [/TD] [TD=align: center]ValueData [/TD] [/TR] [TR] [TD=align: center]2012/2013 [/TD] [TD=align: center]1000 [/TD] [TD=align: center]361616 [/TD] [TD=align: center]16 [/TD] [TD=align: center]1 [/TD] [TD=align: center]UNI [/TD] [/TR] [TR] [TD=align: center]2012/2013 [/TD] [TD=align: center]1000 [/TD] [TD=align: center]361616 [/TD] [TD=align: center]16 [/TD] [TD=align: center]2 [/TD] [TD=align: center]Isolation [/TD] [/TR] [TR] [TD=align: center]2012/2013 [/TD] [TD=align: center]1000 [/TD] [TD=align: center]361616 [/TD] [TD=align: center]16 [/TD] [TD=align: center]3 [/TD] [TD=align: center]DN [/TD] [/TR] [/TABLE] Has anyone had any luck retrieving the above information CMIS in a easy to read format such as: [TABLE=class: grid, width: 500, align: center] [TR] [TD=align: center]SetId [/TD] [TD=align: center]AppCode [/TD] [TD=align: center]AppEventId [/TD] [TD=align: center]EventId [/TD] [TD=align: center]FieldIf [/TD] [TD=align: center]ValueData1 [/TD] [TD=align: center]ValueData2 [/TD] [TD=align: center]ValueData3 [/TD] [/TR] [TR] [TD=align: center]2012/2013 [/TD] [TD=align: center]1000 [/TD] [TD=align: center]361616 [/TD] [TD=align: center]16 [/TD] [TD=align: center]1 [/TD] [TD=align: center]UNI [/TD] [TD=align: center]Isolation [/TD] [TD=align: center]DN [/TD] [/TR] [/TABLE] Any help greatly appreciated.

We have just recently purchased both 4Matrix and Go4Schools. 4Matrix We use 4Matrix to analyse KS4 data that has been taken from student reports. We analyse a students current grade, predicted grade and target grade. We import the report data, FFTD and SATS data as three separate spreadsheets. 4Matrix does seem more geared towards SIMS and appears to be easier to import data via SIMS. As we use CMIS a lot of the data has to be imported on a spreadsheet. The tool does work very well once setup correctly (setting up the maps for subjects and all other columns takes a while) - we recently rolled it out to SL and they liked it and the fact it's easy to navigate and everything is displayed clearly. We have setup access so that staff can use it both here and at school as it is installed on our Citrix servers. The only downside so far is setting up research groups, it would be nice to be able to import things like pupil premium and IMD within the spreadsheet - however you can't do this and you then have to select all the IMD students and add them to a 'research group'. Go4Schools We have literally just this week setup Go4Schools so it is still very new. However, so far so good. At a recent training session staff were impressed with Go4Schools - from what I can see at the moment it is VERY important to set it up correctly before staff start using it to input data. At the moment we're just importing data into Go4Schools as the system isn't live - once it does become live and we have started using it more I will be happy to add any further feedback. Richard