+ Post New Thread
Results 1 to 2 of 2
MIS Systems Thread, Merging data from two cmis datasets in Technical; Hi, We have an interesting situation at our school. The head wanted to move all years up one in June ...
  1. #1

    Join Date
    Jun 2007
    Location
    Sheppey, Kent
    Posts
    9
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Merging data from two cmis datasets

    Hi,

    We have an interesting situation at our school. The head wanted to move all years up one in June (Y9 - Y10 etc). The people here created a new dataset, timetable etc etc for the change. However, we have fallen foul of rules regarding attendance data, because the data ends at the end of may and starts again in June. They are insisting on reports for the complete school yar (Sept - July) for legal attendance issues.

    Is there a way of merging the two datasets (for attendance only) so we can report on full (standard) academic year attendance using CMIS? Or perhaps reporting across two datasets?

    I'd appreciate any pointers anyone can give.

    Regards


    Gary

  2. #2

    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    50
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Merging data from two cmis datasets

    Erm... sounds like good planning...

    It isnt possible to report on attendance across datasets at present. Without using some fairly complex SQL scripts to 'attempt' to merge data I dont see how this can be done.

    Perhaps Serco would be able to merge the data for you?

SHARE:
+ Post New Thread

Similar Threads

  1. Assessment Data(CMIS)
    By Kained in forum How do you do....it?
    Replies: 7
    Last Post: 2nd April 2011, 12:47 PM
  2. Extracting data automatically from CMIS
    By danIT in forum MIS Systems
    Replies: 39
    Last Post: 26th March 2010, 08:13 PM
  3. Using multiple Datasets for reporting in CMIS?
    By gskelton in forum MIS Systems
    Replies: 0
    Last Post: 25th June 2007, 10:29 AM
  4. CMIS DATA MANAGER
    By SpecialAgent in forum Educational IT Jobs
    Replies: 0
    Last Post: 9th May 2007, 11:10 AM
  5. CMIS Data Manager
    By SpecialAgent in forum Educational IT Jobs
    Replies: 0
    Last Post: 23rd February 2007, 10:54 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •