CAM Posted October 16, 2017 Posted October 16, 2017 I submitted my ULN CTF on Friday via S2S when it came back up and it was uploaded without any error messages. When I go to download it it says the status is WSRC0007 Application Error and no downloads available. I'm already snowed under and struggling with the census. I don't need this!!! Any ideas what to do? I cannot submit until I have ULNs and the LA was asking for the census on Thursday.
Banjo Posted October 16, 2017 Posted October 16, 2017 I know there have been problems with S2S (Access Denied - last week). This may be a hangover from that. I'd try again with the CTF.
CAM Posted October 16, 2017 Author Posted October 16, 2017 I tried uploading again this morning and it said the same thing. As it stands I can't complete the census. :/
TLARWise Posted October 16, 2017 Posted October 16, 2017 The ULN service on S2S has been down for over a week now. Do you have a login to the LRS service (https://idp.lrs.imservices.org.uk), they have a batch upload option although it is very fiddly and you don't get the result file back in ctf format.
CAM Posted October 16, 2017 Author Posted October 16, 2017 I have an account but no batch upload option.
TLARWise Posted October 16, 2017 Posted October 16, 2017 When you logon click on Learner Management and you should see an option called Submit Batch Registration appear underneath. Instructions for use can be found at https://www.gov.uk/government/collections/lrs-batch-toolkit-for-aos-and-lrbs 1
CAM Posted October 16, 2017 Author Posted October 16, 2017 When you logon click on Learner Management and you should see an option called Submit Batch Registration appear underneath. Instructions for use can be found at https://www.gov.uk/government/collections/lrs-batch-toolkit-for-aos-and-lrbs Thanks, I have access to this but it doesn't look like an exceptionally friendly process. :/ How do I import the data into SIMS or is it a case of type 250+ ULN numbers in one by one?
TLARWise Posted October 16, 2017 Posted October 16, 2017 Copy/Paste and repeat then go home with RSI I am afraid.
CAM Posted October 16, 2017 Author Posted October 16, 2017 Deleted that post. Not aimed at you, at the DfE. Sorry. I don't know what to do now then. My deadline is tomorrow and I've been pulling tons of extra unpaid time to try pull it off. I've just finally broken. My foot hurts...
Ditto Posted October 20, 2017 Posted October 20, 2017 I'm getting the WSRC0007 too. I've logged support calls but nothing yet. My LRS account was locked as I had not used it since March - I had no need. They could not reset until I submitted a Super User form change. LRS turned it around quickly but I now have a different username. I'm wondering if that's related to the issue? In LRS I can get an XML file but it's not in CTF format. It has the ULNs I'm after. You can load the XML in Excel and then export a simplified data file with UPN, ULN and surname, forename etc. With SIMS, if there is an import that might be an option. I'm on progresso and it needs the CTF file format that should come out of the ULN service in S2S. Unfortunately a simple CSV import from the other file is not an option in progresso.
CAM Posted October 24, 2017 Author Posted October 24, 2017 (edited) It's "resolved" after LRS contacted me. When you log in with a user with LRS Batch user access, there is an option under Learner Management called View Exceptions. This is where the errors from S2S get dumped for you to deal with. You need the provider for your LRS account to add that in. There is NOTHING on S2S to indicate what the error means, what you need to do or that you need to go to a COMPLETELY DIFFERENT WEBSITE to deal with this. Rubbish design! Also I accidentally registered a learner with their names reversed when getting ULNs manually, so I flagged my mistake and told them to delete the fake record. They came back to me going on about merging data and that the challenge isn't accepted as only one ULN was supplied.....no just delete the incorrectly added record. Not my problem to deal with. What is with these idiots at LRS? Edited October 24, 2017 by CAM
Ditto Posted October 24, 2017 Posted October 24, 2017 I managed to get the LRS records along with the ULN. S2S have told me the solution is to cut and paste the numbers from there. Unfortunately for me, I need a CTF file format to import (we use progresso) the ULNs and this is clearly the part of the ULN service(?!) that is not working, converting there XML file to a CTF format. Normally, I could bulk import with progresso, but they forgot to support simple ULN import. Apparently it's possible to load to exam candidate details and reverse populate ULN, but I'm told you need to populate other fields too. As we are a new school without any pupils sitting exams and don't yet have a centre number, I'm not even going to go down that dead-end route! I've managed with a bit of cut and paste to create a CTF file with the ULNs, but it's not updating the ULN field in progresso - could be a format error on my part so still investigating. It looks like I'll refer this back to progresso support ultimately. Last resort is to cut and paste in to the front end. Fortunately it's just 74 records but we are small school - that's a nightmare and error prone for a large school. Hopefully SIMS offer a means to bulk import from the LRS records or a reduced column spreadsheet based on that sheet.
Ditto Posted October 24, 2017 Posted October 24, 2017 Cracked it! I had used the tag in the CTF. Progresso did not complain about it. On checking, it needs to be . Just a global Find&Replace in the CTF and job done. No more ULN service/LRS hopefully for quite some time.
djrscally Posted October 24, 2017 Posted October 24, 2017 Cracked it! I had used the tag in the CTF. Progresso did not complain about it. On checking, it needs to be . Just a global Find&Replace in the CTF and job done. No more ULN service/LRS hopefully for quite some time. Till January census, basically
GeneralDreedle Posted October 24, 2017 Posted October 24, 2017 I have low expectations of government websites but this sorry mess is the worst I can ever remember. Websites that fail with no error message, logins that only work when you reload the page, All files failing with LRS error codes that no one will provide documentation for, And a shocking runaround from the support providers. The LRS now smugly saying everything there is fine, its just S2S that's a basket case. After multiple support requests, phonecalls (especially like the LRS helpline where a bloke was reading out a 50 character url and telling you to bog off there), frantic repetition of effort, I have now found these XML output files which get dumped in the LRS site. But there is no way to input these. The XML is not even close to CTF format. I can manipulate it in Excel to create columns with Surname, UPN and ULN, but I don't know of any way to bulk import ULN like this (anyone?). So the two options are manually paste ULNs from this file or wait and hope that the S2S service gets fixed. But the deadline is a few days away now. Anyone have any other ideas?
Ditto Posted October 24, 2017 Posted October 24, 2017 Till January census, basically I will use LRS manually if we get any incoming students for that one. Perhaps overly optimistic, but perhaps S2S ULN service will be fixed by then!
Ditto Posted October 24, 2017 Posted October 24, 2017 What MIS are you using? Progresso for me. What I found was loading the LRS xml file in to Excel worked fine but it was unable to re-export it. In the end, I took the original CTF that was uploaded to ULN service and manually added the element "nnnnnnnnnn" from the LRB file. You have to do this for each pupil. I put it after the UPN element. I then did a global find/replace of "ULN>" to "UniqueLearnerNumber>". Hey presto - I have a CTF that will load and update the ULN in my MIS. It's a shame Excel was not more capable by allowing the "<UniqueLearnerNumber> to be added to the CTF schema and updated with the LRB column of numbers. That'll make it one cut and past rather than one per pupil. There may well be an XML tool to do that, but not one I know of. Fellow Edugeekers - any suggestions on this one? 1
CAM Posted October 24, 2017 Author Posted October 24, 2017 I know you can do operations on CSV and XML files in Powershell so that might be worth a read. Although it was recently blocked at work as a restricted application.
djrscally Posted October 25, 2017 Posted October 25, 2017 What MIS are you using? Progresso for me. What I found was loading the LRS xml file in to Excel worked fine but it was unable to re-export it. In the end, I took the original CTF that was uploaded to ULN service and manually added the element "nnnnnnnnnn" from the LRB file. You have to do this for each pupil. I put it after the UPN element. I then did a global find/replace of "ULN>" to "UniqueLearnerNumber>". Hey presto - I have a CTF that will load and update the ULN in my MIS. It's a shame Excel was not more capable by allowing the "<UniqueLearnerNumber> to be added to the CTF schema and updated with the LRB column of numbers. That'll make it one cut and past rather than one per pupil. There may well be an XML tool to do that, but not one I know of. Fellow Edugeekers - any suggestions on this one? Sort of doubt it; you can manually edit schema for XML files you've imported to Excel by changing the file extension of a .xlsx to .zip and editing the right file in the archive, but I've never gotten it to work for a CTF or Census file - apparently it only works for really simple XML.
GeneralDreedle Posted October 26, 2017 Posted October 26, 2017 What Graham said will work but it's over the line of cost/benefit, even for the 300+ we need. So dragged the xml from LRS into excel which nicely translates the xml tags into columns, pruned the garbage out, and got admin to cut and paste ULNs into SIMS for me. 1
BatchFile Posted October 30, 2017 Posted October 30, 2017 I've just logged a change request for SIMS to import the batch XML files produced by the LRB. I've more confidence in that working than S2S being fixed 1710-3701211 if you'd like to vote on it Maybe @PhilNeal could give it a nudge for us...?
PhilNeal Posted October 30, 2017 Posted October 30, 2017 @BatchFile - sorry I'm now a non-exec & somewhat removed from day to day operations 1
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now