LosOjos

Depending on what it is you're trying to do, you may find that CommandReporter is enough. It's not live data I know, but it is at least a Capita approved extraction method that won't land your school a huge consultancy bill should things go wrong. I have seen you're already usin g it, but maybe some of these threads will help you get what you want from it: http://www.edugeek.net/forums/mis-systems/66215-sims-net-reporting.html http://www.edugeek.net/forums/mis-systems/83623-executing-commandreporter-scripts.html http://www.edugeek.net/forums/mis-systems/119999-command-reporter-filtering-reports.html http://www.edugeek.net/forums/mis-systems/86701-clr-params-string.html (I really need to start keeping an index of the best CLR threads!)

That's a new one to me! Gonna try this on my own DB and see if I can replicate it, then get thinking of a solution...

Haha, genuinely cracked up when you first hear "choo choo"

I'm not a Millgate customer (I'm a Data Manager so don't get to choose our suppliers) but I'm sure you're all wonderful, handsome people, can I be entered for a chocolate pizza if I stop brown-nosing?

Because he'd also have been 15 at the time and that's not illegal in this country, just stupid!

I wanted to like ME because it was the first OS I ever installed on a new machine. It's constant BSODs and conflict errors very nearly made me give up on IT! Was so relieved when I found out I wasn't the only one who was having so many problems with it (this period just about pre-dated me having Internet access - EduGeek would have been a life saver back then!)

I'll bite - elaborate?

Fixed that for you:

All those OS's in the graphic were MS flagship OS at time of release, not including server or workstation versions

Have you tried it in Chrome/Firefox?

Be careful what you're buying - Powerline and Homeplug are not the same, all the devices you want to connect need to be using the same standard

I rarely buy brand new games, tend to wait until they drop below £10, so most of them I've been playing won't qualify! In fact, thinking about it, I think there's only Tomb Raider and GTA5 - both excellent but I don't feel qualified to vote!

How did you get on with this?

You need to go to "Tools > Lookups > Maintain" and search for "Behaviour - Action Taken" Oh and you'll need to be in one of the following permission groups: Partnership Server Manager School Administrator System Manager Personnel Officer Personnel Assistant

I'd tweak that slightly - definitely patch it as a security flaw but I wouldn't go so far as to void warranties, at least not until measures have been put in place to stop you accessing it. It does seem to be an oversight on MS' part to leave such a dangerous (in the wrong hands) tool open for all to [ab]use

How could he value them without knowing what they were?

Express will install fine on 2012r2, although you might want to consider whether you can work within it's limitations. Full OS support list: Hardware and Software Requirements for Installing SQL Server 2012 Comparison of SQL version features: Features Supported by the Editions of SQL Server 2012

I'm afraid you're stuck with it! What I have done in the past is write a small script to open the resulting CSV in Excel and save it as whatever format I need - also helps whereby SIMS is inconsistent on whether or not it encloses strings in quotes, which causes SQL havoc: 'Check arguments If WScript.Arguments.Length <> 1 Then WScript.Echo "Usage: CScript CleanCSV Path/To/CSV" WScript.Quit End If Set myExcel = CreateObject("Excel.Application") myExcel.Visible = False myExcel.Application.DisplayAlerts = False Set myWorkbook = myExcel.Workbooks.Add() Set mySheet = myWorkbook.Sheets.Add() Dim arr(99) For x = 0 to 99 arr(x) = 2 Next Set QT = mySheet.QueryTables.Add("TEXT;" + WSCript.Arguments(0), mySheet.Range("$A$1")) With QT .TextFileCommaDelimiter = True .TextFileColumnDataTypes = arr .Refresh End With myWorkbook.SaveAs WScript.Arguments(0), 6 myWorkbook.Close myExcel.Application.Quit The arr() part is a bit of a hack to make sure Excel doesn't reformat any dates etc. (some of our reg groups are a number followed by 'E' followed by another number which Excel interprets as scientific notation!)

This does it but obviously you'll need to alter it to do what you need: import re with open('C:\example.txt', 'r') as f: original = f.read() x = 0 prevEnd=0 output="" for m in re.finditer(r"({VAR)([0-9]+?)(})", original): x += 1 VarID = m.group(2) # the number following VAR print VarID output += original[prevEnd:m.start()] + r'cid:image' + str(x) + r'' prevEnd = m.end() output += original[prevEnd:] print output EDIT: just noticed you had already virtually got there by yourself only real difference in my version is the grouping of parts of the match with brackets which means you can then pull them out easily while you iterate the matches EDIT2: realised that it stops at the last match, so just added a bit to concatenate the remainder of the file, and I tidied up the regex a bit to make it more accurate (only matches if it finds '{VAR' followed by at least one number followed by '}')

So in the text, you are wanting to find and replace any string in the format {VAR###} - is it always curly braces? Is the text variable or always VAR? You say you don't know what number the VAR instances start at - does that matter? I mean do you need your "image#" to start at the same number or anything? EDIT: just seen your last post - so the numerical element could be any length, but will be immediately followed by a closing curly brace?

Is direct connection via a cable or wireless?

My mom has just got a Kindle Fire and personally, I'd avoid them (only the tablets though, love "classic" Kindles). Simple reason being that Google Play Store isn't on them, so you're stuck using Amazon's own app store which apart from lacking a load of useful apps (Google Drive being one for starters!) is full of paid for apps that are free on the Play Store (not the exact apps but the only equivalent you can get). You can sideload apps on of course, but I'm guessing your mom isn't technically minded enough to do that (please excuse me if I assume wrong!), plus it voids your warranty. Oh, and there are adverts on the lock screen. Ads on a device I paid good money for? Not for me, thanks. Add to that the fact the only thing Kindle about it is the Kindle app, which is available for free on any Android tablet with access to the Play Store, and I think they're pretty much the worst of all worlds.

I calculate our best 8 a little differently. For each grade column, I create another column for the points. I then have two tables, one for GCSE and one for BTEC, with the grades listed left and points to the right. I then do a lookup on the relevant table to find the equivalent points for each subject. I then use Excel's LARGE function to get my best 8 (best 6-8 GCSE + best two BTEC if they have them). The reason I do it that way rather than with macros is simply because I'm not the only person who has to maintain it and my counterpart isn't too hot on VBA. Also means we can easily add in new point score tables for odd subjects (like CACHE or OCR) that use different point scores.

Yeah the spam is getting worse it seems. Maybe just having to have a mod approve the first thread started by a new user?

I think it's a great idea - suppliers could put a Which style award badge on their websites; assures any geek worth their salt, raises the standing of the community and helps suppliers convince new customers of their reputation. I can't see a downside!