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?
Help!
Thanks
RobK
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.
Tim
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
Robk
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.
Tim
A bit of fuzzy logic for matching name and gender against an export from [edit]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 08:10 PM. Reason: Edited to put in the correct MIS!
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
Hi,
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.
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!
Was going to say Tony, take the Sims and Serco being the same backI 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).
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!
@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.
Robk
SIMS MIS it's all the same really!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!
__________________
Tony
--
Dyslexia, not a condition but a way of loaf!
My views, not my employer or any other group / project / agency I work with ... but feel free to thank me for them anyway
What's the plural of an MIS? MISs?
you're right Matt, MIS and tears always go together!
Hope so, time to badger them I'd say thenI know its defo an access database we get from the LEA but as I didn't do anything with it I avoided that bit.
Misses, of course!SIMS MIS it's all the same really!
What's the plural of an MIS? MISs?
No comment on the SOB bit... ;-)
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?
RobK
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Reply With Quote
