+ Post New Thread
Results 1 to 9 of 9
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 ...
  1. #1

    Join Date
    Nov 2012
    Location
    Wolverhampton
    Posts
    2
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Unhappy 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?

    Russ

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,494
    Thank Post
    1,452
    Thanked 1,197 Times in 812 Posts
    Rep Power
    711
    Quote Originally Posted by morrigan456 View Post
    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?

    Russ
    Welcome to Edugeek

    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
    Code:
    |^Y7 Target^|^26^|
    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.
    Code:
    Actual tag:
    |^Y7 Target^|^26^|
    
    To find using find and replace, you need to type:
    |^^Y7 Target^^|^^26^^|

  3. Thanks to LosOjos from:

    morrigan456 (16th November 2012)

  4. #3

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,494
    Thank Post
    1,452
    Thanked 1,197 Times in 812 Posts
    Rep Power
    711
    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

  5. #4

    Join Date
    Nov 2012
    Location
    Wolverhampton
    Posts
    2
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Tremendous advice thanks mate, i knew there must be an easier way!! I think its worked!

  6. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353

    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.

  7. #6

    Join Date
    Apr 2013
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    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?

    Many Thanks,
    Michael

  8. #7

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,494
    Thank Post
    1,452
    Thanked 1,197 Times in 812 Posts
    Rep Power
    711
    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.

  9. #8

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353

    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.?

  10. #9

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    LOL! Jinx - you can't speak!

SHARE:
+ Post New Thread

Similar Threads

  1. MS Excel find and replace CR+LF
    By firefighting in forum Office Software
    Replies: 5
    Last Post: 20th November 2013, 08:18 AM
  2. [SIMS] Office 2010 and Individual Reports
    By Jamo in forum MIS Systems
    Replies: 21
    Last Post: 3rd November 2012, 06:16 AM
  3. Script to Find and Replace within an INI file.
    By timethrow in forum Scripts
    Replies: 1
    Last Post: 4th February 2012, 10:17 AM
  4. Individual reports for students in SIMS
    By cjohnsonuk in forum MIS Systems
    Replies: 2
    Last Post: 25th March 2008, 11:27 AM
  5. Mass search and replace
    By Fletcher_Bravo in forum Windows
    Replies: 2
    Last Post: 5th July 2006, 03:44 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •