+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 25
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 ...
  1. #1
    robk's Avatar
    Join Date
    Nov 2005
    Location
    Ashbourne
    Posts
    537
    Thank Post
    177
    Thanked 130 Times in 109 Posts
    Blog Entries
    1
    Rep Power
    48

    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?

    Help!

    Thanks

    RobK

  2. #2
    monkeyx's Avatar
    Join Date
    Nov 2006
    Posts
    364
    Thank Post
    8
    Thanked 52 Times in 41 Posts
    Rep Power
    25
    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

  3. #3
    robk's Avatar
    Join Date
    Nov 2005
    Location
    Ashbourne
    Posts
    537
    Thank Post
    177
    Thanked 130 Times in 109 Posts
    Blog Entries
    1
    Rep Power
    48
    Quote Originally Posted by monkeyx View Post
    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.

    Robk

  4. #4
    monkeyx's Avatar
    Join Date
    Nov 2006
    Posts
    364
    Thank Post
    8
    Thanked 52 Times in 41 Posts
    Rep Power
    25
    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

  5. #5

    GrumbleDook's Avatar
    Join Date
    Jul 2005
    Location
    Gosport, Hampshire
    Posts
    9,952
    Thank Post
    1,346
    Thanked 1,800 Times in 1,118 Posts
    Blog Entries
    19
    Rep Power
    597
    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!

  6. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,639
    Thank Post
    683
    Thanked 1,400 Times in 1,160 Posts
    Rep Power
    353
    A bit of fuzzy logic for matching name and gender against an export from SIMS containing the UPN?
    Serco ~ SIMS are they the same thing now?!

    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

  7. #7

    Join Date
    Jun 2007
    Location
    Wakefield, West Yorkshire
    Posts
    629
    Thank Post
    96
    Thanked 132 Times in 103 Posts
    Rep Power
    67
    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.

  8. #8

    GrumbleDook's Avatar
    Join Date
    Jul 2005
    Location
    Gosport, Hampshire
    Posts
    9,952
    Thank Post
    1,346
    Thanked 1,800 Times in 1,118 Posts
    Blog Entries
    19
    Rep Power
    597
    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!

  9. #9

    john's Avatar
    Join Date
    Sep 2005
    Location
    London
    Posts
    10,362
    Thank Post
    1,499
    Thanked 1,053 Times in 922 Posts
    Rep Power
    303
    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).

  10. #10

    Join Date
    May 2009
    Location
    Sheffield
    Posts
    255
    Thank Post
    23
    Thanked 38 Times in 29 Posts
    Rep Power
    20
    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!

  11. #11
    robk's Avatar
    Join Date
    Nov 2005
    Location
    Ashbourne
    Posts
    537
    Thank Post
    177
    Thanked 130 Times in 109 Posts
    Blog Entries
    1
    Rep Power
    48
    @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

  12. #12

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,639
    Thank Post
    683
    Thanked 1,400 Times in 1,160 Posts
    Rep Power
    353
    Quote Originally Posted by GrumbleDook View Post
    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
    SIMS MIS it's all the same really!
    What's the plural of an MIS? MISs?

    Quote Originally Posted by MattMitchell View Post
    ... name, sob, gender ...
    you're right Matt, MIS and tears always go together!

  13. #13

    john's Avatar
    Join Date
    Sep 2005
    Location
    London
    Posts
    10,362
    Thank Post
    1,499
    Thanked 1,053 Times in 922 Posts
    Rep Power
    303
    Quote Originally Posted by robk View Post
    @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
    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.

  14. #14

    Join Date
    May 2009
    Location
    Sheffield
    Posts
    255
    Thank Post
    23
    Thanked 38 Times in 29 Posts
    Rep Power
    20
    Quote Originally Posted by vikpaw View Post
    SIMS MIS it's all the same really!
    What's the plural of an MIS? MISs?
    Misses, of course!

    No comment on the SOB bit... ;-)

  15. #15
    robk's Avatar
    Join Date
    Nov 2005
    Location
    Ashbourne
    Posts
    537
    Thank Post
    177
    Thanked 130 Times in 109 Posts
    Blog Entries
    1
    Rep Power
    48
    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

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

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
  •