OpenRoads Multi-User Template Library VBA Macro

Hi all,

Due to the OpenRoads ITL limitations meaning that use of a single network ITL by multiple users was fraught with danger - ie. multiple users opening a single ITL at the same time and last save overwriting others changes, OR not rereading ITL after first open in a session, etc. we have put together this VBA macro that has worked successfully for us in a large multi-user OpenRoads project. I'm not sure if this is an issue in Inroads??

What it does:

  • Opens a new blank ITL, closes it immediately and then opens the current template library ITL to "refresh" the ITL so any interim edits by others are loaded.
  • Backs up ITL on opening to provide a previous version in case required
  • Creates lock file that doesn't allow anyone else to open ITL when in use and notifies others on who is currently editing it.

We have incorporated this into our standard toolbar and use this icon instead of the tasks one. Seeing that ORD doesn't seem to have resolved this issue, I have attached the macro for anyone who may want to use it.

If anyone has any suggestions on some improvements or finds any issues, please let me know.

Refresh_itl.mvba

  • Hi Mark, I've been looking into th MultiUser_ITL.mvba that you have wriiten, which now appears to be included with the ANZ dataset by Bentley.

    Have you got any guides on how it should work?

    Thanks in advance

    Chris

    Regards

    Chris


    AECOM Roads UK&I Digital Engineering, Design & Solutions Lead | Sector Information Management Lead

    Associate Director – Digital

    OpenRoads Designer 10.12 | MicroStation 2023 | ProjectWise CE 10.3.4 | ContextCapture | ProjectWise PowerShell 2023 | ProjectWise WSG API | Generative Components | OpenBridge Designer 10.12

    Civil 3D 2023 | Dynamo | Navisworks Manage

    PowerShell | Visual Studio | Office 365 | Power Platform | Teams | SharePoint | Visio

    Speckle | BIMVision | Revizto | Solibri

  • Hi Chris,

    It's relatively simple. When you open a template library on a network, it creates a .loc file that is essentially a text file that contains your username. When you close the ITL this file is deleted.

    If you attempt to open the Template Library and it finds a loc file with a username other than yourself, it will abort the open process and display a dialog informing the user the ITL is in use and which user is accessing it.

    I have a similar macro that runs a PowerShell script for this on Projectwise but I'm still refining it (although Projectwise Integration issues are causing different issues).

    Hopefully we get a native solution soon enough. This has worked quite well for us on some pretty large projects with large teams sharing an ITL. I'm still not sure why nothing like this has been implemented yet...

    Regards,

    Mark


    OpenRoads Designer 2023  |  Microstation 2023.2  |  ProjectWise 2023

  • Ok, Cool.

    I keep thinking if there is a way to provide users with their own ITL, based on their Username. Maybe appending it to the Master. Then automate the additions and updates back to the master.

    Very Difficult, but could be possible using Migration Tools to convert itl to xml data. But Reconciling the data will be the issue

    Regards

    Chris


    AECOM Roads UK&I Digital Engineering, Design & Solutions Lead | Sector Information Management Lead

    Associate Director – Digital

    OpenRoads Designer 10.12 | MicroStation 2023 | ProjectWise CE 10.3.4 | ContextCapture | ProjectWise PowerShell 2023 | ProjectWise WSG API | Generative Components | OpenBridge Designer 10.12

    Civil 3D 2023 | Dynamo | Navisworks Manage

    PowerShell | Visual Studio | Office 365 | Power Platform | Teams | SharePoint | Visio

    Speckle | BIMVision | Revizto | Solibri

  • I was thinking about this and it would definitely be doable - the only concern is whether the effort would be worth it in the longer term if Bentley rebuild the Template Editor, which is something i've been hearing for a while?

    Regards,

    Mark


    OpenRoads Designer 2023  |  Microstation 2023.2  |  ProjectWise 2023

  • Hello, I understand this post is a couple of years old, but have there been any updates to the Refresh_ITL.mvba since that time?  I downloaded and am having trouble getting it to run.  Thanks!

    Ryan Best

    Bentley CAD Manager