MIS Systems Thread, Importing data from FFT live into CMIS Facility in Technical; I am aware that Serco`s offical line is that since fischer family trust changed to the new FFT live website ...
20th September 2009, 08:26 PM #1
Importing data from FFT live into CMIS Facility
I am aware that Serco`s offical line is that since fischer family trust changed to the new FFT live website automatic importing of data was not possible due to the lack of a unique id in the data.
That said, I have been back and forth between our SMT,LA and Serco support to try to find a resolution to the issue, but seem to be getting absolutly nowhere!
Does anyone know of a solution to this problem, which does not involve manually entering all the data?
20th September 2009, 08:43 PM #2
We import FFT data via excel to a custom assessment we setup in Facility.
Does FFT live allow getting the data into Excel still? If so I am sure it would be possible to import still as long as UPN is still visible.
21st September 2009, 11:07 AM #3
And there is the issue, I don`t have a handy login for fftlive at the moment, but they seem to have removed UPN from the data, making any import process very painful.
Originally Posted by monkeyx
21st September 2009, 01:55 PM #4
It would appear that FFT Live will not support UPN until Autumn 2009. So hopefully not much longer.
You should be able to make a good vlookup for studentid from surname, forename and Gender though?
You would then be able to import using standard data transfer methods for Excel data, as we do now.
21st September 2009, 04:00 PM #5
A bit of fuzzy logic for matching name and gender against an export from CMIS[Yeah ... I know I put SIMS originally] containing the UPN? Can't remember whether DOB is available on FFTLive but that could be another handy match field.
Last edited by GrumbleDook; 21st September 2009 at 09:10 PM.
Reason: Edited to put in the correct MIS!
21st September 2009, 04:34 PM #6
Serco ~ SIMS are they the same thing now?!
A bit of fuzzy logic for matching name and gender against an export from SIMS containing the UPN?
With the old FFT data that was on an Excel spreadsheet, i'm sure we used to import to Assessment Manager in SIMS using forename, surname and DOB. I can't remember if it included UPN, the matching wasn't great but didn't involve much manual correction, maybe 5 in 100/150. Having the year helps.
In fact once we did a full manual matching, listing the names out of the MIS alphabetically and then lining it up against the data from FFT and just whizzing down the list to make sure they matched, and inserting spaces or moving things around if needed. Still better than a full manual input.
At least it might get you through until Autumn 09
21st September 2009, 06:34 PM #7
No, Facility and Sims are not the same - Facility is made by Serco Learning and SIMS by Capita - will just of been a very rare typo on Tony's part i'm sure :-)
All i can think of is as suggested, get it into an excel spreadsheet and do a VLOOKUP on a string like forename and surname.
21st September 2009, 09:11 PM #8
Don't worry Michael ... Vik is just pointing out that I am so used to typing SIMS when talking about an MIS that I did it again!
21st September 2009, 10:13 PM #9
Was going to say Tony, take the Sims and Serco being the same back I love my Serco but don't want Sims
Our LEA Provided us with our FFT data on some whizzy CD with a MS Access DB, we select what we want I beleive and that makes a spreadsheet which is then imported into Serco ( I think that was the process the Data Manager told me about).
22nd September 2009, 08:26 AM #10
All you need is a file with name, sob, gender and upn and you can match to the fft file to get the upns before import - access or excel can do it. Your la might help if you're stuck and ask em nicely!
22nd September 2009, 08:26 AM #11
@John That sounds like the older database format, which my la only distributed the xls exports from. Good to hear fft have not stopped doing it completly! Just need to see if I can convince our la of that fact.
22nd September 2009, 12:03 PM #12
SIMS MIS it's all the same really!
Originally Posted by GrumbleDook
What's the plural of an MIS? MISs?
you're right Matt, MIS and tears always go together!
Originally Posted by MattMitchell
23rd September 2009, 12:15 AM #13
Hope so, time to badger them I'd say then I know its defo an access database we get from the LEA but as I didn't do anything with it I avoided that bit.
Originally Posted by robk
23rd September 2009, 01:13 AM #14
Misses, of course!
Originally Posted by vikpaw
No comment on the SOB bit... ;-)
13th October 2009, 07:46 PM #15
Well it appears that FFT have now added a export with UPNS in it.
Of course its nothing like the format that Facilty needs, so it looks like lots of manual cutting & pasting from pivot tables.
Our LA tell me they can not provide the data in the old format......
So anyone whipped up a quick script to do this?
By stevenwitthers in forum MIS Systems
Last Post: 6th March 2008, 06:15 PM
By daveyboy in forum MIS Systems
Last Post: 9th October 2007, 08:13 PM
By mark80 in forum MIS Systems
Last Post: 24th August 2007, 12:08 PM
By CyberNerd in forum Thin Client and Virtual Machines
Last Post: 19th July 2007, 04:25 PM
By bursar in forum MIS Systems
Last Post: 22nd May 2007, 05:36 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)