LosOjos

To be fair, it's fairly simple in Access. In 2007 onwards, there's an "Export to Access" option which will let you spit the tables out to a new Access file. You put that on a share, then with your front end (all your forms for data entry and any reports you want to run on it) you create a linked table simply by doing an "Import from Access" and choosing the "linked table" option (this is from memory, the wording may be slightly different but the concept's the same). Then copy the front end Access file to whichever machine you want. It's not hugely scalable but if it's just for a small team of techies to keep track of things, it can be easier and quicker to get going than installing an SQL instance.

OK, well I personally can't see the benefit of an EXE over a website but rather than get in to that... How about Access? Split the front end and back end, put the back end on a shared drive, copy the front end to whichever machine needs to run it. You'll have to design it yourself, and if you want to change anything you'll have to remember to update all the machines (a downfall to a program rather than web, but not getting in to that ) but at least it gives you total control

Why are you particularly opposed to web based? In order to have the software open on multiple machines, writing back to the same file/DB, you'll need that file/DB to be on a server so most solutions you'll find will have a web front end I'd imagine... Personally I use Liberum, but that's web based.

Hi all, seems there are still some issues with this, but with a bit of tweaking you can get the import to work. I wrote a guide here if anyone is stuck: Importing Pupil Premium Data in to SIMS.net - Geek Josh

Yeah you would have to if you're doing it GCSE only (that's what ALPS does), I do that anyway as part of my analysis so it's quicker that way for me. You could run a 'Full' PI report, filter and delete all non-GCSE's then do a Pivot on the remaining to get your GCSE APS per student quickly though.

Just done this myself, don't know if it was a hiccup in our system but I found that initially, hardly any of the students in my new upload were automatically matched. As it was late Friday afternoon, I left all the students in the 'Intake' stage and went home. Logged back in to have another crack this morning and the vast majority of students had been matched and updated, just a handful needed matching manually and all the new Y7s were sat waiting to be transferred. TL;DR - if they don't match straight away, leave it over night.

If you're just using it for target setting, save yourself the hassle and calculate the targets yourself using ALPS' measures (there are XML files in the program folder showing the mapping of KS4 APS to ALPS grade). That's what I've ended up doing in the past, enabled me to export a marksheet, drop in the IF statement to do the conversion and upload straight back in to SIMS.

Backup your DB before continuing! Login to your Wordpress DB, then run the following SQL query (all posts and pages are stored in the wp_posts table on a standard WP installation): UPDATE wp_posts SET post_content = REPLACE(post_content, 'Ysgol Gyfun Gwyr', 'Ysgol Gyfun Gŵyr'); Funnily enough I had to do this myself over the weekend to update my own WP site!

Awww, shucks. Just call them first and explain, I don't want to be responsible for the resulting massacre if you drive out there only to find they won't even look at it.

Reading between the lines, it sounds as though you're worried the customer will simply make clones of some setup you have installed rather than paying for additional machines, am I right? If so, I think licensing is the way to go. Far too much time is spent on "DRM" (which it sounds like this is in the realms of), which is never perfect. Draw up a license and if you find they break the terms of that license, then you have legal grounds to take it further. By the same token, if what you have done involves nothing but a setting up FOSS, I'm not sure there's anything you could do if the customer works out how to backwards manufacture that setup, as you don't own any of the software involved. Focus on providing great service rather than crippling DRM and they're more likely to return as customers IMO. PS: I'm not in any way legally trained, this is pure speculation.

There's a great place in Bloxwich who can cut custom sized plexiglass, I reckon if you took the side panel down there with you they'd sort you out: The Plastic Man Ecommerce Store - The Plastic Man Ecommerce Store

@sted has the right answer. Don't forget to check for duplicates afterwards, easiest way I find is a pivot table, username as the row and also as the data (count), will highlight anyone who you need to tweak slightly

Have you calculated your PI data? Go to "Tools > Examinations > Edit PI Data", then click the "CKD" button top right. Also, make sure your qualification data and performance measures are all up to date, and that you have applied patch 19806 (you probably already will have done if you have a sixth form)

[Cross posted from Data Manager's group] In terms of getting your PI data to include the results, you only need to enter the final result. However, you do need the correct QAN, otherwise your Autumn census is going to give somebody a serious headache you'll also need to know how many L3 entries it's equivalent to, how many A-E and the point score, all of which will be under "Performance Measures" on the Ofqual Register site once you find the correct qualification. To add external results, go in to (in SIMS.net) Tools > Examinations > Edit PI Data", then find the student in the list and you'll see all of their results along the bottom half of the screen, as well as an "+ Add Result" button which will allow you to add the extra results (one by one unfortunately!)

In terms of getting your PI data to include the results, you only need to enter the final result. However, you do need the correct QAN, otherwise your Autumn census is going to give somebody a serious headache you'll also need to know how many L3 entries it's equivalent to, how many A-E and the point score, all of which will be under "Performance Measures" on the Ofqual Register site once you find the correct qualification. To add external results, go in to (in SIMS.net) Tools > Examinations > Edit PI Data", then find the student in the list and you'll see all of their results along the bottom half of the screen, as well as an "+ Add Result" button which will allow you to add the extra results (one by one unfortunately!)

There are 10 types of people in the world. Those who understand ternary, those who don't and those who mistake it for binary.

annual On the off chance some new eyes are checking this out since last year, please do look in to it! Just finished for another year, we managed to get one of our teams in the finals for Best in Show Sadly they didn't win, but we're still incredibly proud of them to have placed top 3 overall in a nationwide competition with hundreds of participants, and they were all given a limited edition blue Raspberry Pi for their efforts

Fair warning: I totally skipped the other posts in this thread (sorry!) However, you may find this list of sites useful: Festival of Code 2014 There's a bit of everything there to get you started with whatever you like, plus a load of links to open data sets to perhaps inspire you to write something useful! (I find I learn a lot more when I have an aim in mind, the problem with many tutorials is it can be difficult to see the real world application)

I'm sorry Phil, but that's a poor excuse. There are many more reasons than printing that we export marksheets. It's a feature that SIMS provides and we make use of, and this missing field is clearly just an oversight.

Just upgraded to 7.159 - still not fixed. Come one, this has to be an easy one, right?!

Just as an alternative to CONCATENATE, you can use ampersand to join text too e.g. =A1&"."&A2&"@school.sch.uk"

Hmm in that case it seems likely that either SIMS or .NET framework has become corrupted, I'd try reinstalling both on that machine

@Mirmo - thanks very much! I wish they'd make up their minds as to where these things will be available; what happened to the central system they promised? Months of development, millions of pounds* and we end up with what amounts to 3 links to the original websites that are still as fragmented as ever! * may or may not be an exaggeration!

I've had this issue in the past, usually for a user who is in a custom SIMS permissions group following an upgrade. To fix it, I remove the user from all permissions groups, reset their password then login as them. SIMS should load, but they'll have no access. Log back in as yourself and re-add their permissions groups, then try logging in again. If the issue persists, you'll have to try re-adding their permission groups one by one until you find which is causing the problem, then possibly recreate that group (if it's a custom group that is).

@johnat1121 - how did you get around that restriction?