This changes all of resutlset X to resultset Y
I find it easiest to clone the template and export the clone and only reimport the template node (not resultset node)
I did post in file sharing on supportnet (619) some excel VBA code that relatively quickly allows you to do many find and replaces on xml template to produce many templates.
i.e. able to create a tempalte template for one subject then use the vba to produce the same template but for many different subjects.
I'm no coder and its pretty simplistic but if is of use to any one please have a look.
Doesn't get round the main issue that creating/editing/maintianing templates (particularly with formulas in) is a slow and tedious process.
just lunching, then i'll test it out on 7.126 and release for beta testing
i'd hardly call sending keyboard commands to the screen sophisticated, however it is once working, quick and painless, and doesn't involve leaving SIMs.
I was right, the move from 7.122 to 7.126 did bring with it some minor changes, which i've accounted for, in fact it has improved the functionality of my script actually, so some beta testers would be welcome. i'm attaching both versions.
it uses vbscript to simulate commands to the SIMS screen, so it's just like you doing it yourself in SIMs just very fast. you may need to place the script on your desktop locally and have admin rights for it to work.
it's best not to have anything else open at the time either else it will take over whatever application has focus.
to prime the system, be logged into SIMS and open the template that needs editing, the cursor will be on the name box and in the column list the bottom row will be slightly coloured, which is how things need to be set up.
then just double click the script and fill in some options, you need to state how many rows from the bottom you want to start altering, how many rows to alter, what displacement for resultset e.g. next one in list, up 2, down 3, entered as just positive or negative integer, and lastly choose whether the block of rows are data or formula.
the big change this time is that both data entry and data review columns can be changed at the same time. or you can alter data entry by formula, but not a combo.
usual caveats apply, make a backup / clone of the marksheet first. this isn't authorised by capita. i am not responsible if it messes up your system and accidentally emails the head to say you skipped out to the pub for lunch during period 5 etc.
please feed back...
EDIT: going out of the office now, so might not catch any replies, but hope all goes well.
EDIT2: This version will only change data review columns or formula columns but will work on 7.126 and 7.128 see later post for fully working 7.128 version.
Last edited by vikpaw; 18th May 2010 at 01:18 PM. Reason: edit
Not working with 7.128 I'm afraid, they must have changed the layout again. Good idea though
did you try both? open up the file and you can modify, it's fairly straightforward to figure out.
otherwise, i've just finished downloading Spring v2 so will stick it on a VM and look
I'm stuggling to open it at the moment, but my machine is misbehaving at the moment - I'll test it today, once I have kicked it back into line
Sorry guys my mistake, the template i was testing on was modified and so i changed the script for no reason. the 7.126 script will work on 7.128 but will only change data review columns or formula columns.
i am just testing a new 7.128 with 3 variants on it, which will have the option to enter blank or 0 for Data Entry, 1 for Data Review and 2 or higher will alter Data Entry by Formula.
will post up shortly, sorry again.
Here it is, please see previous post for conditions of use / caveats etc.
I really hope it works for you now.
There are a few things that need tweaking but i just want to make sure it works ok. During testing i found it's quite easy to use working down the list in small numbers doing little batches of different types of column without starting on the bottom row each time.
To do this, once the script has run, click the link for 1.Basic and it resets the page back to how the script likes it, but with the start point being just after the last change, so you can start with 255 rows up, or whatever the total number of rows is, and then say change 10, let it move down, then do the next 10. Probably completely useless in practise, but it worked for me during testing, as i knew exactly how many columns and of which type were in my template.
EDIT Usual caveats apply, make a backup / clone of the marksheet first. this isn't authorised by capita. i am not responsible if it messes up your system and accidentally emails the head to say you skipped out to the pub for lunch during period 5 etc.
This version does not work for SLG enabled schools and a minor edit to the script is needed.
Last edited by vikpaw; 18th May 2010 at 01:20 PM. Reason: add caveats
LosOjos (5th May 2010)
I'm trying to use it but I'm getting quite confused.
I have a template as such:
So I click on the name of the last aspect, then I run the script with the options:Code:Target - Result 1 Estimate - Result 2 Estimate - Result 3 Data Entry - Result 4 --- Data Entry - Result 4 | Data Entry - Result 4 | Data Entry - Result 4 |--- I want to change this range to (for example) 'Result 5' Data Entry - Result 4 | Data Entry - Result 4 | Data Entry - Result 4 | Data Entry - Result 4 ---
Rows to move up = 7
Columns to change = 8
Displacement = 1
Data type = 0
What happens is that I see SIMS briefly open the group selector, then it opens up a marksheet in the template and changes the date: I must be doing something wrong!
Also, the 'Cancel' button doesn't work, the script just continues the same as if you press the 'OK' button
Seems okay, but make sure after clicking name of aspect i.e. clicking on the row in the list you then click on the link for 1.Basic, to make sure your cursor is in the first most entry box.
The displacement, will move 1 up the list so if you created your resultsets methodically, the example would change it to Result 3.
Hope that helps.
the cancel button, is just there because i'm using the prompt, i'll have to have a look if i can set it to not appear, or better still actually "break" the script.
it's very rough and ready for my use, i only recently started putting in the loops and prompts otherwise i just edit the script each time i need it.
There are currently 1 users browsing this thread. (0 members and 1 guests)