+ Post New Thread
Results 1 to 13 of 13
MIS Systems Thread, CMIS/CSV/CTF files in Technical; I have a csv file with data that I need to import into Facility CMIS. I understand that CMIS cannot ...
  1. #1

    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    169
    Thank Post
    54
    Thanked 19 Times in 18 Posts
    Rep Power
    22

    CMIS/CSV/CTF files

    I have a csv file with data that I need to import into Facility CMIS. I understand that CMIS cannot import from a csv file, and needs to be a ctf (common transfer file) file which i think is a xml.

    Does anyone know how to convert a csv file into ctf?

    I found a tool to convert csv into xml, but it isn't the correct format for Facility ctf.

    Hopefully I've made some sense with this and hopefully some can point me in the right direction.

    Cheers all.

  2. #2

    john's Avatar
    Join Date
    Sep 2005
    Location
    London
    Posts
    10,517
    Thank Post
    1,494
    Thanked 1,050 Times in 919 Posts
    Rep Power
    302
    What type of data is it? I'm sure there is a way of bulk entering and dealing with data but you are best talking to Serco Support about it as if you make a mistake you can make a major mess I believe.

  3. Thanks to john from:

    jcs808 (26th February 2010)

  4. #3

    Join Date
    Jun 2007
    Location
    Wakefield, West Yorkshire
    Posts
    621
    Thank Post
    95
    Thanked 129 Times in 100 Posts
    Rep Power
    66
    Hi,

    Just to clear this up, there is an option in the software named 'data transfer'. This will import from csv. It is not an easy process, you have to be skilled and clued up in what you're doing, the data structure CMIS uses and the appropriate destination for the data.
    I would go with John and say give support a ring and explain what you're trying to do. Also maybe search first line for 'data transfer' and see if there's a manual up there.
    The only way i know of writing xml in such a format is from SQL, but you could easily stick your csv into a SQL table (in a database seperate from Facility preferably on a different server altoghther). That's going to take longer than typing them in though unless you're talking about entire years of students and regularly, for example?

    I would also question why they are on CSV. I'm speaking in none-serco terms here and from personal experience - when i used to be a data manager in a school, the primary schools had a legal obligation to pass on the information they had using the 's2s' (schools to schools) site. The only format this accepted information in was ctf. I did have to go to some of our feeder schools in our pyramid and train the staff on how to produce them but the fact i'd taken the time to do that and given them a bit of a life line in terms of support gave them the confidence and patience to do it, and this made my life a whole ot easier for the next couple of years (until i left, and i imagine for my replacement).

    Regards
    Mic
    Tech. Engineer
    Serco Learning

  5. Thanks to michael2k6 from:

    jcs808 (26th February 2010)

  6. #4
    -Link2ICT-'s Avatar
    Join Date
    Jan 2010
    Location
    Birmingham
    Posts
    6
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    0
    Hi,

    If you are a Birmingham school, then give the Link2ICT servicedesk a call and we will be able to offer some advice on the data transfer process

  7. #5

    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    169
    Thank Post
    54
    Thanked 19 Times in 18 Posts
    Rep Power
    22
    Quote Originally Posted by -Link2ICT- View Post
    Hi,

    If you are a Birmingham school, then give the Link2ICT servicedesk a call and we will be able to offer some advice on the data transfer process
    I did and was told it has to be in ctf format, that's why I posted here.

  8. #6

    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    169
    Thank Post
    54
    Thanked 19 Times in 18 Posts
    Rep Power
    22
    Quote Originally Posted by michael2k6 View Post
    Hi,

    I would also question why they are on CSV. I'm speaking in none-serco terms here and from personal experience - when i used to be a data manager in a school, the primary schools had a legal obligation to pass on the information they had using the 's2s' (schools to schools) site. The only format this accepted information in was ctf.
    I'm trying to import Unique Learner Numbers (ULN) for a whole year group.

    It's a csv because that's the format of file you upload to the MIAP website. After a while they return an updated file to you with the ULN included. MIAP tech support don't offer any support beyond this, ie uploading it to your MIS, which is understandable.

    We also don't have direct support from Serco, we have to go to the local authority IT support department, ours is called Link2ICT.

  9. #7
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    929
    Thank Post
    56
    Thanked 162 Times in 114 Posts
    Rep Power
    67
    Quote Originally Posted by jcs808 View Post
    I'm trying to import Unique Learner Numbers (ULN) for a whole year group.

    It's a csv because that's the format of file you upload to the MIAP website. After a while they return an updated file to you with the ULN included. MIAP tech support don't offer any support beyond this, ie uploading it to your MIS, which is understandable.

    We also don't have direct support from Serco, we have to go to the local authority IT support department, ours is called Link2ICT.
    You can get ULN number from the key to success website (same place you can get ks2/3 test results) in CTF format.

    All you need to do is produce a ctf with all your student in, upload it and then your be able to download a ctf with those student plus the ULN.

  10. Thanks to penfold_99 from:

    jcs808 (26th February 2010)

  11. #8
    -Link2ICT-'s Avatar
    Join Date
    Jan 2010
    Location
    Birmingham
    Posts
    6
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    0
    That is correct - The Key to Success website provides the ULN's in CTF format - this is all covered in the Link2ICT guidance notes

    http://services.bgfl.org/myportal/cu...gULN's.pdf

    As Michael rightly says, the data transfer process is fairly complex and requires detailed knowledge of the table structures in Facility - therefore this is a service Link2ICT can provide, I can only apologise if you didnt receive this information when you called.

  12. Thanks to -Link2ICT- from:

    jcs808 (26th February 2010)

  13. #9

    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    169
    Thank Post
    54
    Thanked 19 Times in 18 Posts
    Rep Power
    22
    *-Link2ICT-

    If I call the helpline can someone help me with this, it isn't really my area I'm stuck with this task because our exams sec isn't very good with ICT.

  14. #10
    -Link2ICT-'s Avatar
    Join Date
    Jan 2010
    Location
    Birmingham
    Posts
    6
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    0
    Quote Originally Posted by jcs808 View Post
    *-Link2ICT-

    If I call the helpline can someone help me with this, it isn't really my area I'm stuck with this task because our exams sec isn't very good with ICT.
    Thats what we are here for - please contact the servicedesk and we will see how we can assist

  15. #11

    Join Date
    Jun 2007
    Location
    Wakefield, West Yorkshire
    Posts
    621
    Thank Post
    95
    Thanked 129 Times in 100 Posts
    Rep Power
    66
    Whoever you are @ Link2ICT, thanks for posting :-)
    Nice to see people getting together to sort things out.
    I'm limited in what i can do but if either of you think i can help, let me know.

    Mic@Serco

  16. #12

    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    169
    Thank Post
    54
    Thanked 19 Times in 18 Posts
    Rep Power
    22
    Quote Originally Posted by -Link2ICT- View Post
    That is correct - The Key to Success website provides the ULN's in CTF format - this is all covered in the Link2ICT guidance notes

    http://services.bgfl.org/myportal/cu...gULN's.pdf

    As Michael rightly says, the data transfer process is fairly complex and requires detailed knowledge of the table structures in Facility - therefore this is a service Link2ICT can provide, I can only apologise if you didnt receive this information when you called.

    -Link2ICT- can I ask if you really do work for Link2ICT.

    Just that again I've been told by the helpline that I need to contact the people who provide the ULNs and get them to provide them in ctf format as this is the only way to import student data.

  17. #13
    -Link2ICT-'s Avatar
    Join Date
    Jan 2010
    Location
    Birmingham
    Posts
    6
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    0
    Yes - PM sent...

SHARE:
+ Post New Thread

Similar Threads

  1. CSV to individual text files
    By DanW in forum Scripts
    Replies: 14
    Last Post: 15th September 2009, 11:28 AM
  2. SIMS.net CTF file
    By localzuk in forum MIS Systems
    Replies: 9
    Last Post: 29th June 2009, 10:45 AM
  3. Problem with SIMS CTF Import
    By appleman in forum MIS Systems
    Replies: 6
    Last Post: 20th April 2009, 03:23 PM
  4. Submit CTF to NAA using SIMS
    By penfold_99 in forum MIS Systems
    Replies: 9
    Last Post: 15th July 2008, 06:29 AM
  5. CTF Exports
    By ndavies in forum MIS Systems
    Replies: 2
    Last Post: 26th February 2008, 09:54 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
  •