+ Post New Thread
Results 1 to 13 of 13
MIS Systems Thread, CTF Export for ULN - Problem in Technical; Im having issues creating a ULN for upload to Secure Data Transfer to request ULNs for 1400 or so of ...
  1. #1

    Join Date
    Nov 2010
    Location
    Great Grimsby
    Posts
    72
    Thank Post
    7
    Thanked 2 Times in 2 Posts
    Rep Power
    8

    CTF Export for ULN - Problem

    Im having issues creating a ULN for upload to Secure Data Transfer to request ULNs for 1400 or so of our students.

    Firstly, I tried exporting the simple CTF using the CTF for ULN request function Routines Data Out CTF Export CTF CTF For ULN Request

    This did not contain any address/postcode data and therefore is not accepted by the DFE.

    I then tried to export a partial CTF with the data requested by the DFE helpline, Basic Data and Address Data.

    When try to upload this data the DFE site is giving me the error message below:

    - This file does not appear to be a valid 10.0, 11.0 of 12.0 CTF File - Please contact your school MIS vendor
    - The element 'BS7666Address' in namespace " has incomplete content. List of possible elements expected: 'UniqueStreetReferenceNumber, Locality, Town, AdministrativeArea' in namespace".

    Any ideas how to proceed? I've raised a support call with Capita.

    Obviously, the size of this place, I don't want to have to do this manually...

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,432
    Thank Post
    1,432
    Thanked 1,160 Times in 794 Posts
    Rep Power
    705
    Quote Originally Posted by DeeGee View Post
    Obviously, the size of this place, I don't want to have to do this manually...
    I've not tried this yet since we upgraded our SIMS, but I wonder if it's something to do with the new format of CTF's? I can only ponder...

    What I can say is that doing this manually isn't that bad really, I tend to do it manually as I find it a bit quicker. Just create a report of all your students on roll and drop their UPN number in. Export to Excel, copy and paste the column and you're done! I think there's a limit on 250 students at a time this way, but I still find it quicker than faffing about with CTF's myself.

  3. #3
    GeeHubb's Avatar
    Join Date
    Aug 2010
    Location
    Suffolk
    Posts
    182
    Thank Post
    17
    Thanked 37 Times in 32 Posts
    Rep Power
    56
    I'm sure I saw a News Item on the Supportnet Homepage relating to CTF for ULN export a couple of weeks ago. If you have access to Supportnet, do a search from the Homepage on CTF 12 and it should appear. See if that answers your question.

  4. #4

    Join Date
    Mar 2007
    Location
    Heywood, Lancs
    Posts
    211
    Thank Post
    7
    Thanked 50 Times in 45 Posts
    Rep Power
    27
    Yep, apparently there is a known issue:

    CTF Export: ULN Request/Update (Added 08/01 15:00)
    Please note that the file created for the ULN Request/Update CTF export conforms to the requirement agreed with the DfE. However, we understand that s2s and LRS imports will reject these files as they do not include Post Code. I am meeting with the DfE on Wednesday and I expect a solution to be agreed for implementation ASAP.
    but no updates since. Looks like someone moved the goalposts again.

  5. #5

    Join Date
    Nov 2010
    Location
    Great Grimsby
    Posts
    72
    Thank Post
    7
    Thanked 2 Times in 2 Posts
    Rep Power
    8
    Quote Originally Posted by LosOjos View Post
    I tend to do it manually as I find it a bit quicker. Just create a report of all your students on roll and drop their UPN number in. Export to Excel, copy and paste the column and you're done!
    I have made the report to do this in the past. However, I can't for the life of me remember where I have to paste the UPNs!

  6. #6

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,432
    Thank Post
    1,432
    Thanked 1,160 Times in 794 Posts
    Rep Power
    705
    Quote Originally Posted by DeeGee View Post
    I have made the report to do this in the past. However, I can't for the life of me remember where I have to paste the UPNs!
    I just went to look for you and I can't see it either now, looks like it's CTF or nothing!

  7. #7

    Sylv3r's Avatar
    Join Date
    Jul 2005
    Location
    Co. Durham
    Posts
    3,197
    Thank Post
    370
    Thanked 374 Times in 332 Posts
    Rep Power
    147
    I don't have anything to do with the CENSUS and SIMS, but my data manager had the same error and asked me to install this.

    Learning Records Service - Publications & tutorials - Tools - Validation tool

    She didn't get back to me and the CENSUS has gone so I take it it must have resolved the issue.

  8. #8

    Join Date
    Nov 2006
    Location
    Kendal
    Posts
    1,555
    Thank Post
    111
    Thanked 177 Times in 144 Posts
    Rep Power
    71
    Sorry to raise an old thread. Did anyone get anywhere with this. I am having the same issue an Capita Helpdesk tell me it's because our addresses are not formatted properly e.g. no house number on some addresses. I pointed out this is correct as we are in a rural area so sometimes houses don't have numbers. Told me to raise it with S2S!

  9. #9

    Join Date
    Sep 2012
    Location
    North Yorkshire
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I've submitted our ULN request via the S2S system this afternoon and was originally getting the message this file does not appear to be a valid 10.0, 11.0 of 12.0 CTF File - Please contact your school MIS vendor. This was to do with house names in the house number field. Once we had fixed this I didn't get the CTF error message. We also got to the point whereby some addresses that we had validated in SIMS were not being accepted and/or we were getting error messages saying there is no street name. In the end, we have ended up doing the bulk upload tool via a ctf for the majority of students and then going to the Learning Record Service and searching manually for the few remaining. I know it doesn't solve the issue - but that's the way we got around it. (Thank goodness for that as it took me ages to sort!)

  10. #10
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,022
    Thank Post
    803
    Thanked 346 Times in 270 Posts
    Blog Entries
    60
    Rep Power
    278
    I had this problem, it was related to how house numbers were stored in SIMS. Open the further information link on the error message and see if you have something related to addresses and PAON type in there. The address module is a bit of a mess on pupil details and you have House Name, House Number and Apartment Number. our problems came from kids in apartments where the Apartment Number was put into House Number for example. It's really complicated to explain!

    For example, someone living on Flat 22 Example House on Edu Street should have Flat 22 in Apartment Number, Example House in house Name and Edu Street in Street name with House Number blank. We had Flat 22 in House Number!

  11. #11

    Join Date
    Nov 2013
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    An error with the CTF version can be resolved by opening the CTF file in Notepad on the fourth line down you see the CTF Version (probably 12.0) change this to 10.0 and Save. S2S will then recognise the file and upload it.

  12. #12

    Join Date
    Nov 2006
    Location
    Kendal
    Posts
    1,555
    Thank Post
    111
    Thanked 177 Times in 144 Posts
    Rep Power
    71
    Did anyone have any further advice on this. Here is my error:

    XXXXXX_CTF_ULNLLLL_006.xml - This file does not appear to be a valid 10.0, 11.0, 12.0 CTF File - Please contact your School MIS Vendor LEA element is invalid - The value ULN is invalid according to its datatype "Union" - The value ULN is not valid according to any of the memberTypes of the the union

    No idea how to fix it. Capita blame S2S, S2S blame LRS - I just need my ULNs!

    Fixed it by changing the destination school from the one they mention in their document to our own school!
    Last edited by jcollings; 6th December 2013 at 10:51 AM.

  13. #13

    Join Date
    Nov 2013
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    jcollins, have you opened up the CTF in notepad to find out its version? See example:

    <?xml version="1.0" encoding="utf-8"?>
    <CTfile>
    <Header>
    <DocumentName>Common Transfer File</DocumentName>
    <CTFversion>12.0</CTFversion>

SHARE:
+ Post New Thread

Similar Threads

  1. Missing VGA Drivers for Win7 -problem?
    By adamchapman in forum Windows 7
    Replies: 5
    Last Post: 16th April 2010, 12:01 PM
  2. mail for exchange problem
    By IA76 in forum How do you do....it?
    Replies: 6
    Last Post: 26th May 2009, 10:19 PM
  3. CTF Exports
    By ndavies in forum MIS Systems
    Replies: 2
    Last Post: 26th February 2008, 09:54 PM
  4. WebDAV for staff problem
    By Outpost in forum Wireless Networks
    Replies: 9
    Last Post: 22nd November 2007, 11:33 AM
  5. Exporting emails, having problems.
    By richard in forum Windows
    Replies: 4
    Last Post: 1st December 2006, 05:07 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
  •