+ Post New Thread
Results 1 to 8 of 8
MIS Systems Thread, IndRepBaseTemplate.dot Causing Problems in Technical; This is becoming the bane of my life at the moment... I have always had trouble getting my scripts to ...
  1. #1

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,432
    Thank Post
    1,432
    Thanked 1,160 Times in 794 Posts
    Rep Power
    705

    Angry IndRepBaseTemplate.dot Causing Problems

    This is becoming the bane of my life at the moment...

    I have always had trouble getting my scripts to work properly on SIMS generated Word XML files and them throwing an error because the reference to IndRepBaseTemplate.dot has been lost, but it seems things have gotten much worse since the latest update and many of my previous workarounds no longer work.

    Today I've come across the worst yet though: after exporting a batch of reports last night, today I can't open a single one of them. Each time, Word locks up and eventually closes and upon re-opening tells me that IndRepBaseTemplate.dot caused a serious error.

    Any body else had this issue? Better yet, any body found a way to fix it?

    I'm using Word 2010 in Windows XP Pro.

    So far, I have tried (all worked before last SIMS update but no longer help):
    • Putting a copy of IndRepBaseTemplate.dot in the same folder as the exported reports
    • Writing a VBA routine to stop IndRepBaseTemplate being loaded when the document is opened
    • Loading up an Individual Report in SIMS (which in turn puts a fresh copy of IndRepBaseTemplate in my temp folder)



    PS: can anybody from Capita explain why IndRepBaseTemplate is needed in an exported report? I understand that when editing a template it is needed to add the context menus for adding aspects etc., but it does nothing but cause grief in the final document - surely you can find a way of removing the reference upon export? Even opening up a report in Linked Documents it throws an error!
    Last edited by LosOjos; 21st June 2012 at 10:56 AM.

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    No solution sorry, but can't you find another way to dump out the data? How are you exporting it, command reporter? There must be other ways to dump the data that you can parse, or do you want the Word format?

  3. Thanks to vikpaw from:

    LosOjos (25th June 2012)

  4. #3

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,432
    Thank Post
    1,432
    Thanked 1,160 Times in 794 Posts
    Rep Power
    705
    Quote Originally Posted by vikpaw View Post
    No solution sorry, but can't you find another way to dump out the data? How are you exporting it, command reporter? There must be other ways to dump the data that you can parse, or do you want the Word format?
    Hi Vik,

    the Word format is very useful as it gives us so much control over the layout (it's annual reports I'm working on). Of course, all Individual Reports really are are mail merges so I could write my own script to do it. The only problem with doing that is I currently have no way of uploading en masse to student's linked documents (I'm still trying to get that elusive BO documentation! )

    The way it's going though, I'm seriously considering pulling all of our reporting out of SIMS and developing an in-house system. We'll still use Assessment Manager to gather the results from teachers, but I'm getting sick of battling with SIMS to get a format I'm happy with now. May be about time I took it in to my own hands...

  5. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    Sounds like a plan. Did you talk to @David_Grashoff about the BO docs?

    What is your script doing? I remember someone else asking about how to run code at generation time. If you can crack that nut it would be awesome.
    It might be worth talking to the company that has the link to sims from office / printers. It could be in their interest to utilise your tools and make a product out of it. It does single attachment, i can't see why doing them in bulk iterating through a group wouldn't be possible. So long as you used a common unique id like adno or the internal person_id

    EDIT http://www.cohesionsoftware.co.uk/contact.aspx speak to Tim, i'm sure he's on here or one of the company bods is.
    Last edited by vikpaw; 25th June 2012 at 09:39 AM. Reason: add link

  6. Thanks to vikpaw from:

    LosOjos (25th June 2012)

  7. #5

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,432
    Thank Post
    1,432
    Thanked 1,160 Times in 794 Posts
    Rep Power
    705
    Quote Originally Posted by vikpaw View Post
    Sounds like a plan. Did you talk to @David_Grashoff about the BO docs?

    What is your script doing? I remember someone else asking about how to run code at generation time. If you can crack that nut it would be awesome.
    It might be worth talking to the company that has the link to sims from office / printers. It could be in their interest to utilise your tools and make a product out of it. It does single attachment, i can't see why doing them in bulk iterating through a group wouldn't be possible. So long as you used a common unique id like adno or the internal person_id

    EDIT Cohesion - Contact Us speak to Tim, i'm sure he's on here or one of the company bods is.
    Cheers Vik. I had asked @David_Grashoff but the request has to come from our local support. I asked them, they said no problem, 6 months later here I still am... I really ought to chase it up again, it's just finding the time!

    The scripts I use are all very basic things; one script runs to check if students have an estimated grade in a row and deletes that row if not (this is due to the awkward way we deal with targets here which prevents the "delete rows with no results" option from working!). Another (now defunct) script would colour rows based on estimated grade compared to target (SIMS can now do this automatically thankfully). Another populates a cell on each report with an "attendance award" - each student is awarded based on their % attendance.

    They are all things that could be solved by creating and populating new aspects, but I'm trying to automate as much as humanly possible; it's the only way to stay on top of the mass of analysis that is expected top be done!

    The annoying thing is, there were working workarounds for this but since the last SIMS update, none of them work any more, and it's all down to IndRepBaseTemplate - a template that isn't even necessary in the reports once they've been produced!

  8. 2 Thanks to LosOjos:

    David_Grashoff (25th June 2012), vikpaw (25th June 2012)

  9. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    I'd be happy to test something if that helps. Did you just whack macros into the template? I tried messing around with autoexec() or whichever the function was, but never got it to work at run time unless i actually opened the file afterwards. i guess that's okay for viewing, but didn't work for direct printing.

  10. #7

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,432
    Thank Post
    1,432
    Thanked 1,160 Times in 794 Posts
    Rep Power
    705
    Quote Originally Posted by vikpaw View Post
    I'd be happy to test something if that helps. Did you just whack macros into the template? I tried messing around with autoexec() or whichever the function was, but never got it to work at run time unless i actually opened the file afterwards. i guess that's okay for viewing, but didn't work for direct printing.
    If you put your code inside the "Document_Open()" sub routine of the "ThisDocument" module when editing a template, it'll run every time, even when doing a direct print. The problem is, when you take the resulting DOC out of SIMS (either by export or automatic upload to DMS), then VBA will throw an error because the reference to IndRepBaseTemplate is missing (i.e. IndRepBaseTemplate no longer exists). The rror will be something ridiculously irrelevant, like telling you that a module is missing on some core VBA function.

    The best fix I found was to use this code to automatically remove any broken references at run time, it worked great before the update

    Code:
    Dim vbProj As VBProject ' This refers to your VBA project.
    Dim chkRef As Reference ' A reference.
      
       ' Refer to the activedocument's VBA project.
       Set vbProj = ActiveDocument.VBProject
    
       ' Check through the selected references in the References dialog box.
       For Each chkRef In vbProj.References
          ' If the reference is broken remove it
          If chkRef.IsBroken Then vbProj.References.Remove chkRef
       Next

  11. #8

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    I'll give it a whizz tomorrow.

  12. Thanks to vikpaw from:

    LosOjos (25th June 2012)

SHARE:
+ Post New Thread

Similar Threads

  1. Pacemaker causing problems?
    By HaleStorm in forum Hardware
    Replies: 22
    Last Post: 19th June 2012, 01:23 PM
  2. [SIMS] [kind of SOLVED] Macro Errors - IndRepBaseTemplate.dot
    By LosOjos in forum MIS Systems
    Replies: 5
    Last Post: 7th December 2011, 11:21 AM
  3. System Repair causing problems
    By Tricks in forum Windows 7
    Replies: 9
    Last Post: 18th July 2011, 02:48 PM
  4. [CSS] Site causing problems?
    By theeldergeek in forum Web Development
    Replies: 3
    Last Post: 23rd April 2010, 10:46 PM
  5. user6 and right causing problems
    By tea_and_toast in forum EduGeek Joomla 1.0 Package
    Replies: 1
    Last Post: 15th December 2008, 02:41 PM

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

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