[SIMS] CTF Export for ULN - Problem

[DeeGee]

I’m 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...

[LosOjos]

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.

[GeeHubb]

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.

[Linfit]

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.

[DeeGee]

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!

[LosOjos]

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!

[Sylv3r]

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.