cinnamonmb

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!)

Thanks Vikpaw! I tried searching on here too and couldn't find anything. Will try this tomorrow when I'm in the office and feedback to you

Hi I realise that when using SIMS profiles you cannot choose to bring the colour formatting that may be contained in the marksheet (for example if a marksheet is formatted to show red, amber or green depending on if a student is on track to meet their target grade or not). In the word template we bring across the description of red, amber or green but we cannot bring the colour across. You can do this in Individual Reports in SIMs but not Profiles. Our SLT want to still ensure that the full profile is visual and that the on track cell is shaded the appropriate colour (Red, Amber or Green) as well as containing the description. I agree that this has impact and gets the message across instantly to students and parents. However, I'm keen to avoid having to manually amend this on over 100 reports for each subject (yuk!). Does anyone have a macro in word that searches through a table in word for and if it finds a certain value to shade the cell a colour based on that value? The macro should then go to the next table in the document and repeat the process. I've spent ages googling this and can't seem to find anything that fits the bill and my VBA skills are basic!! Any help is gratefully received