BatchFile

I've got the ReportSender spreadsheet from the SIMS Success Team (here). Run by itself, by double-clicking, it works fine through Outlook, but as a scheduled taks, it doesn't. I'm therefore exploring the SMTP option. The macro code I've got for that bit is as follows: Sub send_mail_SMTP() Dim CDO_Mail As Object Dim CDO_Config As Object Dim SMTP_Config As Variant Set CDO_Mail = CreateObject("CDO.Message") On Error GoTo Error_Handling Set CDO_Config = CreateObject("CDO.Configuration") CDO_Config.Load -1 Set SMTP_Config = CDO_Config.Fields With SMTP_Config .Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 .Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "smtp.office365.com" .Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 587 .Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1 .Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = "[email protected]" .Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "MyP@55w0rd" .Item("http://schemas.microsoft.com/cdo/configuration/smtpencryption") = STARTTLS .Update End With With CDO_Mail Set .Configuration = CDO_Config End With CDO_Mail.Subject = ThisWorkbook.Sheets("Set up").Range("B9") CDO_Mail.From = ThisWorkbook.Sheets("Set up").Range("B6") CDO_Mail.To = ThisWorkbook.Sheets("Set up").Range("B7") CDO_Mail.TextBody = ThisWorkbook.Sheets("Set up").Range("B10") CDO_Mail.CC = "" CDO_Mail.BCC = "" CDO_Mail.AddAttachment thepath + "" + reportname + ".xlsx" CDO_Mail.Send Error_Handling: If Err.Description <> "" Then MsgBox Err.Description End Sub but it's failing with "The Server rejected the sender address. The server response was: 451 5.7.3 STARTTLS is required to send email" Any ideas, anyone?

I can answer this one for myself now I had Capita on Remote as I was having problems applying a patch - and it needed to be applied as SA. They reset the password for me (after an email of authority from SMT), by running a query and we've had no ill effects. So in my case at least, the answer is no, it won't break SIMS, if it's done like that

I'd like to change the SA password on our SIMS server. They guy that set it up has left, without leaving a record of what it was. It looks as if I can do it by going into SQL Management Studio using Windows Authentication - but I'm a bit worried as I'm not sure of the consequences! Is there any reason why I shouldn't do it by expanding Security > Logins, then right clicking on sa, selecting properties and entering a new password? Anything to watch out for? Then I can get on with scripting a DbAttach backup that can run without stopping the server:confused2:

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...?

SIMS Teacher app is down due to an "Azure Service Relay Bus" issue... Methinks there's a connection there and this is two symptoms of the same M$ issue. Perhaps. Which doesn't get us any closer to fixing it :-(

Problems here (Cumbria) - getting a lot of this:

I've got a feeling that the only app currently available is for teachers - If not, please do let me know as we're just rolling out SLG homework here and are encountering "teething issues" with the web part not displaying correctly on a non-English O/S (and we're a boarding school with 40% international pupils!)

+1 for Ruckus - great kit - access points are like cockroaches - you can't kill 'em. One fell off the wall (was 10ft up) - top cover popped off when it hit the concrete floor; clipped it back on and it's fine. Another one, the PSU (external) died, replaced it with a non-oem one and accidentally reversed the polarity:doh: - got smoke out of the AP; disconnected, corrected polarity, plugged back in and that's fine too.

All Harry Potter here. As I'm leaving soon and we're recruiting a replacement for me (see: http://www.edugeek.net/forums/educational-jobs/154007-ict-technician-support-manager-cartmel-cumbria-25440-27123-a.html), I tried and failed to get "in depth knowledge of JK Rowling's novels" included in the person spec... but the Head wouldn't go for it

This is my current position, I've been here almost 15 years (with a 2 and a bit year gap in the middle but that's another story). I'm only leaving as I've got a better position paying more, closer to home; I'm definately not leaving "under a cloud", the management are great as are the staff and pupils. You're left to get on with it most of the time, but the support's always there if you need it. It's a smashing, REALLY varied network manager type position in a small, but secure future-wise, 11-16 secondary school in a beautiful area close to the Lake District. I really want to find the right person as I've got a lot of me invested here; it was my first "proper" job after uni and my Dad came here as a pupil, I've grown the network from 50 computers when I arrived in 2000 to over 300 now. I'd love it to go to someone on here as this is where a large chunk of my knowledge has come from over the years. Please feel free to DM me or reply below with ANY questions about the job or the area - and let me know if you're applying. (I'll edit this in a minute with a link to the website, where you can get the person spec, application form etc. My techie's just putting it up now!) Edit: HERE IT IS: http://www.cartmelpriory.cumbria.sch.uk/page/it_technician_and_support_manager

That's kind of what I thought; the router's taken it and trying to route it, then when it gives up it sends it back as unreachable... which presumably takes longer than my ping timeout interval most of the time. But if that's all it was wouldn't increasing the /w to 2000 or 4000, instead of the default 1000, mean more unreachables and fewer timeouts? I tried it and It didn't make a noticable difference... Unfortunately (!) the connection's fine again today and I don't really want to unplug it to play with it now as that would be unpopular!

Can any of you educated types shed any light on a little (and I mean tiny!) networking anomaly for me? Our internet connection was down yesterday (or "the internet's not working" as our users say - "I think you'll find it is, but our connection to it might not be" is my reply, but I digress), caused by a power cut at the next hop along to us. I set a "ping" going, pinging the LEA filters so I'd immediately see when it came back, which looked like the attached picture: The question is, why do most packets return "request timed out", while one in 10 or so get "reply from 10.105.16.1: destination net unreachable"? 10.105.16.1 is the default gateway and I'm only pinging every second or so - so why are they not all one response or the other? It messes up the statistics as it records the "reply from"s as a recieved packet not a lost one... but that's about as inconvenient as it gets. I've tried messing around with the wait time (/w) but it doesn't seem to make a difference to the ratio of "timed out"s to "reply from"s...

And that's my main gripe with 8.x for workstations - we don't wany big pretty apps on the home page, we want a nice, serene desktop to start work and a sensible start menu to select from, in the school environment. Just like XP. Or 7 if you must.

it maybe is NOW - but in that original version it was missing and I had to google a workaround:rolleyes: (I don't THINK it was a beta...)

Nope, and I hope not to for a while having installed the RTM of 8 early on just to have a look - It was a while ago, but I was astounded by what was missing (like a GUI to change the computer name and join the domain - ended up doing it from a command line IIRC) and the fact that, due to being behind a proxy, nothing on the front page full of apps worked. I dare say these issues have since been fixed, but it was at that time that I decided Linux was the way we would probably be going for curriculum use; I just don't like the way MS are heading anymore. Just my opinion, but these are my experiences summarised: NT4 - solid as a rock but lacking certain features (like USB support) XP - Worked. Easy to deploy and administer. Adequately featured Vista - Cluttered and unstable 7 - Adequate, but bloated and a backward step from XP deployment wise - sysprep a joke 8 - Didn't work. Released before complete. Crazy UI without start button, have to press Win+X to get it to do anything sensible.

So then, the date for adoption of Ubuntu as the OS of choice for student PCs here is set as January 14th, 2020. Reasoning: Windows 8 is such a massive interface and culture change, we may as well go for something that's free and no more of an upheaval and save some cash in the process.

Sorted now just a little reformatting needed and the top couple of rows of text taken out of the table. all we need now is an open source carey-sharey image to go in the (now obvious) image space and we're away!

Edit: RESOLVED just loaded it in Chrome and fount that the CMS is trying to put an image in at the top - HTML is fine. Please could someone who's better at HTML than me (doesn't take much) tell me why there's a big gap above the table on this page on the school website? Online: Cartmel Priory CofE Secondary School - Local Offer Screenshot: It's a custom made CMS, but I'm assuming the problem is in the html for the content of that page as the text "This bit is at the top of the html - why the big gap below?" is at the top of the content entered for the page, and that's in the right place; I just can't see why the table insists on putting several lines of blank at the top. This bit is at the top of the html - why the big gap below? </pre><table border="0" cellspacing="0" cellpadding="0" width="801" style="border-collapse: collapse; table-layout: fixed; width: 602pt"> CARTMEL PRIORY SCHOOL ~ LOCAL OFFER Under the Children and Families Bill which became law in 2014, Local Authorities are required to publish, and keep under review, information about services that they expect to be available for children and young people with disabilities and Special Educational Needs aged 0-25. This is called the Local Offer. The intention of the Local Offer is to improve choice and transparency for families. It will also be an important resource for professionals in understanding the range of services and provision in the local area. Cartmel Priory School is a fully inclusive school that is totally committed to providing the best possible education to all of its children regardless of their gender, ethnicity, social background, religion, sexual identity, physical ability or educational needs. This document is intended to give you information regarding the many ways in which we ensure we support all of our children, including those with SEND. It is important to note that it may not include every skill, resource and technique that we employ as these are continually being developed and modified to meet the changing requirements of individual children. Please click on the links for additional information. SCHOOL NAME: Cartmel Priory School </

Genius... but probably a bit pricy for what we need them for unfortunately. (They could however be in the running when we replace our bookable laptops as they look incredibly cool) I've ordered one of these Linx 8 Windows Tablet 8" IPS Touch Screen Quad Core 1GB 32GB (LINX8) - dabs.com to evaluate and generally kick around and abuse; just the home version, I'm hoping to be able to get at the OS myself and "upgrade" it (wonder if it'll run xp...) at the price, it's worth it even if it ends up just being used as a digital camera, or if I really break it, a chopping board!

Got me thinking now... anyone tried SIMS .Net on one?!

I was looking at those earlier - the home ones are like £60 or something! I didn't know they did an education version - Thanks!

I've got my crystal ball out, planning my major purchases for the next five years. We've currently got 80 netbooks which are 5 years old now, so will need replacing at some point in that period (the Lenovo S9s and S10s are doing well, the Toshiba NB200s are fine too, but the eeePCs are almost ready for the skip!). I don't really want to go down the iPad route, not because I've got anything against them (on the contrary they're great pieces of kit), but because I'd like whatever replaces them to integrate with the (vanilla) domain and behave like a workstation... I'm just wondering if Windows tablets may be the way to go, but I've got no experience of them really. I'm quite prepared to buy one to have a look as it'll come in useful for something no doubt.... These: Asus Vivo Tab Note 8 Intel Atom Z3740 2GB 64GB 8" Windows 8.1 Professional (M80TA-DL010P) - dabs.com cost about the same as an iPad mini and have Win 8.1 professional on them - is that "real" Windows, like I'd install on a netbook? - does that mean I'll be able to do computery things with them like: Boot off a pendrive and image them? Install normal MS Office? Join the domain so that users get their usual network drives? License them on the Microsoft EEA agreement? If anyone has got one / done that / knows the answers, it may prevent me looking like an idiot later!

@localzuk I don't think they'll do it in the UK either from http://www.dhl.co.uk/en/express/shipping/shipping_advice/lithium_batteries.html?utm_source=473347&utm_medium=affiliate&utm_campaign=dhlitnow_campaign_Nov

Yup, that looks good (though we're having to repack them in pairs) http://www.iata.org/whatwedo/cargo/dgr/Documents/Lithium-Battery-Guidance-2013-V1.1.pdf

I think it was Royal Mail - I'm not entirely convinced they declared what was in it...