MIS Systems Thread, Individual Reports - Find and Replace in Technical; WOW! I didnt even know this place existed! Im so pleased to have found it!
I wonder if someone could ...
16th November 2012, 11:30 AM #1
- Rep Power
Individual Reports - Find and Replace
WOW! I didnt even know this place existed! Im so pleased to have found it!
I wonder if someone could assist me? Im new to SIMS but am a software developer by trade (C# .NET).
I have been given individual reports to do for students. They have many many aspects on and are all linked to record sets. In brief what I want to do is a search and replace in word to change the record set but if i do that then the bookmarks no longer work. Anyone ever come across this?
16th November 2012, 12:04 PM #2
Welcome to Edugeek
Originally Posted by morrigan456
What do you mean by "bookmarks"?
To find and replace resultsets, make sure you are in "design mode" (on the developer tab). You'll see that all the XML tags expand, and inside those you will see something along the lines of
The first part of that is the name of the resultset, the second part is it's external ID. You can find the ID by opening up the resultset in SIMS (Focus > Assessment > Result Sets) and scrolling to the bottom pane, properties.
You need to do a find and replace on both parts for it to work properly.
TIP: Double up on the ^ symbol when you do find and replace, it's a special character in word but doubling it acts as an escape, i.e.
To find using find and replace, you need to type:
Thanks to LosOjos from:
morrigan456 (16th November 2012)
16th November 2012, 12:22 PM #3
While I'm at it, a couple more tips:
- Compress all images in your templates; SIMS is very inefficient when generating reports and will retain all of them in memory before printing, so you want to keep file sizes as small as possible (I've pointed out that they'd be better off generating one, printing one, freeing memory rinse & repeat but to no avail)
- Don't put tags in the header/footer; for some reason, this regularly causes reports to crash or simply not pull out the data, printing the actual tag instead. Talking of which...
- Avoid headers/footers all together if you can; they greatly increase the time it takes to generate reports. If you must use headers or footers, try to get creative with table formatting first, they generate much quicker and you can quite often achieve the same results as a header/footer
16th November 2012, 12:32 PM #4
- Rep Power
Tremendous advice thanks mate, i knew there must be an easier way!! I think its worked!
17th November 2012, 07:27 AM #5
The only thing i would add is that also do a find and replace on just the resultset name as a second pass. This is because it appears twice in the tag, once for display in non-developer view and once as part of the reference. If you just change the reference, it will still show visibly as the old resultset in the template, which could be confusing for you or future editors.
What i normally do is replace a single tag, manually, and this brings through the resultset ID you want. Then do two passes, once on the ^##^ and again on the resultset name. You should get double the number all going well. I usually take this as a sign that it's worked ok.
18th April 2013, 10:54 AM #6
- Rep Power
Hi all - forgive me for going off on a tangent from the original thrust of the thread - first post and all. I wish to be able to modify some of the text or formatting as it is being generated - i.e. if a class name field is being filled in with 'R1' I want something that will automatically update to 'Reception 1' when the report prints. Possibly more important and something that I don't know a workaround for - is there a way to change formatting based upon the text that fills a field. If I have a text box and text that is too long for it reports come out truncated whereas I want the box to become larger. Is that part of the property of the text box. Can the first part be done by embedding a macro in the report that runs when it is sent to the printer or saved upon export?
18th April 2013, 11:16 AM #7
Hi @Michael_ and
This can be done with macros, you need to create a Sub Routine called Document_Open in the ThisDocument module of IndRepStudentTemplate when editing an individual report's template. Any code in that routine will be run upon the document opening.
A word of warning though - myself and @vikpaw have come across a range of problems when doing this. I quite often have a VBA error on a core function which is actually caused by a missing reference to the SIMS VBA plugin that handles individual reports, IndRepBaseTemplate.dot. We've not found a sure fire way of solving these errors yet. Having said that, I still use them extensively as the errors only seem to happen when trying to open a saved document, not when printing from SIMS.
18th April 2013, 11:17 AM #8
The text overfill is the textbox property, presumably the row in teh table has a fixed size.
Changing text would be a macro - @LosOjos is the most experienced in that arena, it is possible, but recently we've both had trouble getting them to work. It's hit and miss with quite unpredictable behaviour - i was looking at replacing @ with A*, and it goes funny.
It works as long as you manually open each document, but automating and getting it to work in bulk is tricky.
Another alternative approach might be to put some kind of conditional field in, and hide the cell that shows R1, make it small or colour it white, and then put the text you want in another cell. I'm not sure if this works at runtime or if you'd need to open it to trigger the action. It's bulk printing that would fail to work.
Is there another way for you to get the info out, perhaps use an aspect to show that info.?
18th April 2013, 11:18 AM #9
LOL! Jinx - you can't speak!
By firefighting in forum Office Software
Last Post: 20th November 2013, 09:18 AM
By Jamo in forum MIS Systems
Last Post: 3rd November 2012, 07:16 AM
By timethrow in forum Scripts
Last Post: 4th February 2012, 11:17 AM
By cjohnsonuk in forum MIS Systems
Last Post: 25th March 2008, 12:27 PM
By Fletcher_Bravo in forum Windows
Last Post: 5th July 2006, 04:44 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)