-
Posts
6,910 -
Joined
Content Type
Forums
News
20th
EduGeek EDIT Conference
Blogs
Everything posted by LosOjos
-
[SIMS] Best way to print individual reports???
LosOjos replied to ilsley_SIMS's topic in MIS Systems
I've not been upgraded to 2013 yet, but a quick Google suggests the issue is with Reading View. Two options; open Word, go in to Options and look for a checkbox labelled "Open e-mail attachments and other uneditable files in reading view" - uncheck it. Of, try this (untested) version of the script: Option Explicit Dim Arg 'Script argument Dim FSO 'File System Object Dim oFol 'Folder object Dim oFil 'File object Dim oFils 'Files Dim myWord 'Word object Dim filePath 'Path to file (need for Word to open the file) 'Check arguments If WScript.Arguments.Length < 1 Then MsgBox "Drag a folder containing Word XML files onto this script", vbOKOnly, "Error!" WScript.Quit End If Set FSO = CreateObject("Scripting.FileSystemObject") Arg = WScript.Arguments(0) If FSO.FolderExists(Arg) = False Then MsgBox "Drag and drop a folder onto this script to print the contents." Set FSO = Nothing WScript.Quit End If Set myWord = CreateObject("Word.Application") myWord.Visible = True 'Get folder informaton Set oFol = FSO.GetFolder(Arg) Set oFils = oFol.Files For Each oFil in oFils '-- enumerate files in the folder using For/Each. Each oFil is a File object. If FSO.GetFileName(oFil) <> "IndRepBaseTemplate.dot" Then filePath = oFil myWord.Documents.Open filePath, False, True, False, , , False, , , 8, , True myWord.ActiveWindow.View.ReadingLayout = False myWord.PrintOut False myWord.Documents.Close False End If Next myWord.Application.Quit False Set myWord = Nothing Set oFils = Nothing Set oFol = Nothing MsgBox "Complete!", vbOKOnly, "Printing done" -
I'd avoid putting Windows on them - I have one myself and it was so slow with Windows it was painful. Maybe ChromeOS? Very lightweight, Internet only, all via "the cloud" - not sure about safeguarding though, might need to research that a bit first
-
It's because I'm using an adblocker, one of the scripts being used is from a tracking site (newrelic.com) so it's blocked
-
I got the same as @abillybob - Chrome problem maybe?
-
Is the "Verbal Memory" test supposed to show you a series of HTML tags? Some of them were too long to read and obscured the buttons so you can't click them...
-
[sims] SIMS Custom Report - All singleton students and youngest of siblings..
LosOjos replied to remoore's topic in MIS Systems
SIMS already has functionality to deal with this First thing to do is go in to "Tools > Housekeeping > General" and run the "Update Mailing Point" routine (change "Mailing Point" to "Youngest Child" if that's how you want to do it). This sets a flag on each student. Then, when you create a report (via "Reports > Design Report", you just add a filter on "Mailing Point". Add the details you need, set the output to Excel and you're ready to create your Maile Merge You can do Mail Merge straight from SIMS, but personally I find doing it the usual way via Word/Excel easier to manage - depending on the IT skills of the school's office staff though, you might want to set up a SIMS mail merge for them so they can just run the report whenever it's needed. -
What is it you're trying to extract? It can be quite limiting in terms of what you can produce straight from SIMS, won't argue with that, but I'm yet to find anything I can't extract one way or another... (without SQL)
-
Given Sky's big announcement today, they're really not making themselves look like a great option at the moment... I've been chomping at the bit to get Virgin in my area, but with rising prices and no sign of new content, I'll probably stick with Sky when my contract's up for renewal early next year (unless the Sky Q box and/or 4K content costs a fortune, then I'll jump ship!)
-
That's what I'm doing at the moment, I was just looking for a way to 'catch all' in one VirtualHost block and then only apply SSL config if the client had come in on 443... It seems it should be possible in Apache 2.3 with , but I'm on 2.2 at the moment and want to set aside a few hours for the upgrade, just in case it all breaks! Like I said, it's working fine as it is, I was just looking for any ways to trim down the repetition further.
-
Thanks @Geoff, however I'm not sure the IfModule directive works for this, it seems to always trigger if mod_ssl is enabled, not necessarily when the site has been accessed via HTTPS, causing client errors when trying to access the site via HTTP (complaint about trying to access an HTTPS site over an insecure port (80)) Will certainly make use of the IncludeOptional though, will help clean things up.
-
Wondering if anyone has any thoughts on this. I've been setting up my website and subdomains to make use of my Let's Encrypt certificate - all working fine, no problems there (and I'm keeping standard HTTP alive while LE is in beta) One thing that's bugging me though is I fell the Apache config to do this is overly complicated. The vast majority of the config for my sites is identical, regardless of whether the client came in on 80 or 443, so I feel there ought to be a simpler way of representing this in Apache. I've simplified it massively by using 'Include' so that now I have something like this: ServerName example.com Include /var/www/example.com.conf ServerName example.com Include /var/www/example.conf Include /var/www/ssl.conf ServerName test.com Include /var/www/test.com.conf ServerName test.com Include /var/www/test.com.conf Include /var/www/ssl.conf However, the coder in me feels like there must be some 'If' statement I'm missing that would make this even simpler. I'm think something along the lines of: ServerName example.com Include /var/www/example.com.conf Include /var/www/ssl.conf ServerName test.com Include /var/www/test.com.conf Include /var/www/ssl.conf Is something along those lines possible, or have I already simplified things as much as I'm going to?
-
[sims] Vote for a reporting CR? Relative (last week/month/term) dates in reports
LosOjos replied to pete's topic in MIS Systems
Nope, nout Just to be sure, we are all using the new Capita MyAccount site? there's not another new site I haven't spotted? -
[news] Anonymous declares "War" on ISIS
LosOjos replied to abillybob's topic in Jokes/Interweb Things
They also declared war on ISIS after Charlie Hebdo - any evidence of their impact since then? -
[sims] Vote for a reporting CR? Relative (last week/month/term) dates in reports
LosOjos replied to pete's topic in MIS Systems
There is a workaround involving CommandReporter, a bit of scripting and Windows Scheduled Tasks, but I totally agree this would be a great feature to have. Voted. EDIT: how on earth do you find a CR by number on the new site? -
There's not really a single GPU setup that can handle 4K gaming at the moment, and I wouldn't really advise your use case as being worth shelling out for. Websites aren't going to look any better in 4K, in fact they'll likely look worse as they'll either be cramped up one edge, full of white space or have text so tiny you can't read it and end up zooming in to a point it's somewhat comparable to 1080 (or lower, depending how far you sit from your screen - I have my HTPC set up to zoom pages to about 150% on resolution 1080 so I can read them from the couch!) Viewing photos in 4K might be nice if you've got a good camera, editing won't make a fat lot of difference though (apart from the UI probably being too small to use easily) What I'm saying is, don't use 4K for the sake of using 4K. It's awesome if you get a set up capable of true 4K gaming (which you currently can't on a £300 budget) or for viewing 4K movies (which there's a serious lack of), but it's awful for general computer use.* IMO, you'd be best waiting for another generation when 4K gaming at decent quality on a single, sub £300 GPU might be a reality. * unless we're talking a monitor sat a few inches from you on a desk, then depending on your eyesight you might prefer it - I don't!
-
For this reason, and potential DPA pitfalls, I've always maintained that I will not share student data until that student is confirmed as attending the new school. I'm a Data Manager, so don't have a lot to do with the admissions process, but when I have been asked for data I've always maintained this stance.
-
Conditional formatting (colours) in Assessment manager columns
LosOjos replied to niqbal's topic in MIS Systems
+1 - also, you can use a "Column for Data Review using formula" to avoid the need for another aspect; it's value won't be stored. Just think of it as a "utility" column, I do this a lot for multi stage calculations where I only need the end result storing.- 2 replies
-
- assessment manager
- formula
-
(and 2 more)
Tagged with:
-
CommandReporter - How to specify the output format of reports
LosOjos replied to iceman's topic in MIS Systems
Glad you've found a way that works for you Just want to clarify this point: XSLT isn't just an XML to CSV converter, it's a quick way of parsing XML to create any output. The example I posted above for instance takes CR's version of the XML and converts it in to the "manual run" version you posted above. I mentioned CSV because in SQL Server for instance, CSV imports are extremely quick. I reduced the update time of one of my systems drastically (we're talking from a couple of hours to a couple of minutes) when I discovered XSLT, as it meant rather than writing a horrible SQL XML parser (very slow!), I could use XSLT to convert the XML to CSV first, then let SQL import the CSV (very fast!). It was something of a fringe case though - I was dealing with SIMS photos, which SIMS won't export in anything but XML format TL;DR - if you do a lot of XML manipulation, you'd be well served to learn XSL[T] -
CommandReporter - How to specify the output format of reports
LosOjos replied to iceman's topic in MIS Systems
XSL is a scripting/templating language with the specific purpose of processing XML documents i.e. taking XML as input and producing output in another format. This is useful to you as you can take CR input and output XML formatted how you'd expect it. NOTE: if your Delphi is just parsing XML to produce a SQL query, it'll likely be much quicker to bypass that step and instead write an XSLT to convert your XML to CSV and let SQL import the CSV Looking at your snippets above, you could use XSL like this to ensure you always get the desired format: You'll want to 'fortify' that XSL a bit to check nodes exist (SIMS doesn't include nodes with no data in its output) but that should give you the idea. Depending on your OS, you'll want a way of "applying" that transform. As you'll be using Windows on your CR machine, you could use MS's mssxl tool: https://www.microsoft.com/en-gb/download/details.aspx?id=21714 -
CommandReporter - How to specify the output format of reports
LosOjos replied to iceman's topic in MIS Systems
I'm afraid the only workaround for this I found was to produce the report both ways myself and account for that in code, i.e. match either element name as produced manually or by CommandReporter. As for the schema, that really shouldn't be a problem - just ignore it if you don't need it. I don't know how you're parsing your XML, but any decent parser will separate schema from data. If you absolutely must have an identical, schema-less format every time, perform an XSL transform on CommandReporter's output to ensure you get the expected format before it's passed to your program. -
Cool I've got to say, I'm getting more and more tempted by the XB1, especially if it'll (eventually) be able to play most of the little ones 360 games
-
When they say "backwards compatible", are we talking put the disc in the drive and play it or purchase a digital version to play?
-
Decimals work fine in gradesets...
-
The photographers should never have had access to UPNs... If however you do find yourself with a load of files with UPNs rather than admission numbers, you can use something like IrfanView to rename them all from a CSV (which SIMS can produce) so that you can still do the import.
