+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 25 of 25
MIS Systems Thread, Importing data from FFT live into CMIS Facility in Technical; Woo hoo! Upns, at last. I'll put something together tomorrow - what format do you want?...
  1. #16

    Join Date
    May 2009
    Location
    Sheffield
    Posts
    242
    Thank Post
    21
    Thanked 35 Times in 26 Posts
    Rep Power
    20
    Woo hoo! Upns, at last. I'll put something together tomorrow - what format do you want?

  2. #17
    kealey's Avatar
    Join Date
    Nov 2008
    Location
    Derbyshire
    Posts
    9
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Importing FFT data

    Hi has anyone got any further with this. It is something we would like to do but what do you download to mimic the data that used to be provided? The amount of data available is boggling, where do you start

  3. #18

    Join Date
    May 2009
    Location
    Sheffield
    Posts
    242
    Thank Post
    21
    Thanked 35 Times in 26 Posts
    Rep Power
    20
    I'd imagine someone's done this now, but if anyone knows what format "works" for CMIS, lemme know and I'll make an access converter script.

    To be honest, the export format is very much improved now from FFT Live and it's pretty close to what many people would like as an import format, I should imagine.

  4. #19
    kealey's Avatar
    Join Date
    Nov 2008
    Location
    Derbyshire
    Posts
    9
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks for that. But I am still confused as to which report you go for, or do you have to export the lot? (That's a frightening thought!)
    As I understand it CMIS has a standard routine for importing FFT data which is why we used to get the specialy formatted CSV files but which file has this form evolved into and would you have to set up custom fields in CMIS to accommodate this data?

  5. #20

    Join Date
    Dec 2009
    Location
    Derbyshire
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    has anyone solved this yet?

  6. #21

    Join Date
    Nov 2009
    Location
    Bournemouth
    Posts
    8
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    FFT into CMIS

    Hi,

    Your local authority should provide you with the FFT access database populated with data for your school. If you run the database then there is a menu which allows you to export your data into the appropriate files in a directory structure on a drive of your choice. The CMIS administration programme has a built in import,Assessments/Advanced/Read Fischer Datawhich allows you to specify which files you wish to import (making sure unlike me the first time I did this that you have noted carefully what you named the directory - never again). The process is then automated but a bit like watching paint dry. Be warned however, the latest version of FFT does not provide KS4 subject grades based on the probability, just the probabilities of 5A* to C etc. KS3 predictions for Maths, English and Science are given.

    I have attached (I think) a PDF file called FFT Export.pdf which I prepared for one of the other admin people at the school I am at which explains the process of exporting from the FFT access database which might help
    Attached Files Attached Files

  7. #22
    robk's Avatar
    Join Date
    Nov 2005
    Location
    Ashbourne
    Posts
    672
    Thank Post
    170
    Thanked 126 Times in 105 Posts
    Blog Entries
    1
    Rep Power
    47
    @specs That PDF looks great but not all LAs provide the access file, hence the problem.

  8. #23
    kealey's Avatar
    Join Date
    Nov 2008
    Location
    Derbyshire
    Posts
    9
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    The access database convertor would work a treat but who has a copy that we could use? Is it commercially available or should our LA provide it. As far as I know our LA has never mentioned anything like this which is a shame as it would help us a lot.

  9. #24

    Join Date
    Nov 2009
    Location
    Bournemouth
    Posts
    8
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Hi, as we have always had the data from the LA I have never had the problem of trying to get the data from FFT Live so I am not sure how it comes down. If you could let me know what the export from FFT live is like (Format, data headings etc. which is anonymised) then I might have something that could help.

  10. #25
    kealey's Avatar
    Join Date
    Nov 2008
    Location
    Derbyshire
    Posts
    9
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi
    I'm not sure of the format as it has changed but if you look at your last FFT filewe need data to match those headings. I will see if I can dig out an old (new) FFT file so that I can find the headings

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. Importing from Excel to CMIS templates
    By stevenwitthers in forum MIS Systems
    Replies: 1
    Last Post: 6th March 2008, 05:15 PM
  2. ePortal / Facility / CMIS
    By daveyboy in forum MIS Systems
    Replies: 2
    Last Post: 9th October 2007, 07:13 PM
  3. Importing SATS - CMIS
    By mark80 in forum MIS Systems
    Replies: 1
    Last Post: 24th August 2007, 11:08 AM
  4. Facility CMIS on Citrix
    By CyberNerd in forum Thin Client and Virtual Machines
    Replies: 6
    Last Post: 19th July 2007, 03:25 PM
  5. Serco CMIS Facility
    By bursar in forum MIS Systems
    Replies: 11
    Last Post: 22nd May 2007, 04:36 PM

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
  •