About

JTB FlexReport is a report tool for applications using network license systems like FlexNet / FLEXlm (flexlm license manager), IBM LUM (IBM License Use Management), DSLS (Dassault Systèmes License Server), SPLM (Intergraph SmartPlant License Manager), SLM/Sentinel LM/Sentinel RMS/Sentinel Protection Server/SafeNet Sentinel (SafeNet / Gemalto / Thales), LM-X, Solidworks SNL License Manager, T-Systems license manager product LICMAN, Vertex Systems, MathLM (Wolfram Mathematica license manager), RLM (Reprise License Manager) and RLMCloud, Ranorex, Venturis (TRICAD), Altium, Primavera from Oracle, GHSlm (Green Hills Software License Manager), LSTC-Dyna (LS-DYNA / Ansa / mETA / Livermore Software Technology Corporation), BETA LM (BETA CAE Systems), PKit license manager (PersonalQM / Method Park / Stages), ELM (EPLAN License Manager), Sentinel HASP (aka Aladdin HASP SRM) by SafeNet, DP Technology (DPT/ESPRIT), Tebis, CodeMeter (Wibu-System), DS-2 (PLM of Zuken PCB Design), TLM (TASKING License Management by Altium), or 12D software licensing. With JTB Process Monitor any Windows application like Acrobat, Visio, Bentley MicroStation, single licensed AutoCAD or AutoCAD LT can be reported usage of. 

Do you want to optimize your software purchases tomorrow? By the license tracking JTB FlexReport does and the graphic reports that can be produced JTB FlexReport will help you to manage and forecast future license usage and license usage trends at your company.

Is SAMsuite, SAMreport or FlexNet Manager/FlexNet Manager for Engineering Applications a too expensive product or SAMreport-Lite not enough? Do you want better license statistics or searching for an alternative to FlexNet Manager for your floating licenses (concurrent licenses)? Need help with your software asset management? Then take a good look at JTB FlexReport that is an inexpensive solution.

Email or Contact us to get a time limited trial for free. You can try it in your environment with your real data for a few weeks with full functionality.
Full support is provided during trial period. Right after installing it for the first time it works in trial mode for 7 days. Email us the computer number as reported in JTB FlexReport Config>License Activation (install JTB FlexReport Core first).

We offer Proof of Value (POV) of JTB FlexReport, by the ability to testing its capabilities within your environment, so that you can build a business case for the software based on your own real data.

JTB FlexReport will help you to see the license usage over time and help to justify new purchases. This will help you to decide when and how many licenses you will need to purchase next time. Instead of guessing and purchasing more licenses than you really need you can save your money using JTB FlexReport. JTB FlexReport will help to implement Software Asset Management (SAM) procedures in your organization, optimize existing investments, be better prepared for Vendor Audits, reduce risks like unexpected software costs, maintain compliance, control costs and reduce costs.

Look at an introduction on YouTube, in Flash format or in PowerPoint format.
For PowerPoint version make sure you view the PowerPoint show as it's animated. Press F5 in PowerPoint.
(Download Microsoft PowerPoint 2010 Viewer or newer if you don't have PowerPoint or the PowerPoint viewer)
Alternative online presentation format of the PowerPoint presentation.

JTB FlexReport web report

if you want to host a web based version of JTB FlexReport we have it. See this blog post for an example of usage.

More functionality

JTB FlexReport can produce HTML reports showing who uses the licenses right now. Basic report Sample 1. Advanced report Sample 2 or a dark version. These can be created manually or automatically and for example be put on SharePoint. See also the freeware JTB FlexReport LT.

Histogram Chart that can help to determine if you need more or less licenses. Notice how there are 25 licenses but probably it could be enough with 20 or even 15 licenses because there is very small percentage when there are more than 15 licenses used concurrently.

Data is also logged to a database so you can track the usage per user or host (computer) as well as work with groups of users or hosts. Great if you need help to split license costs. Groups of features or servers can also be created and be used for reporting upon.

Email notifications (alerts/reminders) when usage is exceeding a specified level.

Let's say you have 10 licenses of your software that costs $3,000 each. Now you have 20 users that shares these licenses. Do you know if you really need these 10 licenses or if you need more now when 2 more users are coming in? If you have JTB FlexReport it will be easier to make a correct decision. If you just need to purchase 1 less license imagine your ROI (Return Of Investment) and benefit of using JTB FlexReport.

With the help of JTB FlexReport you can minimize software and maintenance/subscription/renting spendings.

JTB FlexReport supports reporting on usage of applications and companies that uses FlexNet / FLEXlm from Flexera (formerly Globetrotter Software, Macrovision and Acresso), IBM LUM and applications like 12d Model from 12D Solutions, RISA-3D (SLM based) and many more. Several thousands of independent software vendors have used the FlexNet / FLEXlm family of products. Among them are companies and/or applications from ANSYS (ANSYS License Manager), Abaqus, Autodesk, AVEVA (PDMS), Borland, Cadence, CADopia (IntelliCAD), Citrix (Citrix MetaFrame, Citrix XenApp), Cognos, EDS, Esri (ArcGIS), I-Deas, Macromedia, Mathsoft (MathCAD), Mathworks (Matlab), Mentor, Pixar, Platform, Progman/Cadcom, PTC (Pro-Engineer), Rasterx (RxView), Rational, Siemens PLM Licensing, Softimage, Solidworks, Sybase, Synopsys, Unigraphics, WindRiver, ZWSOFT (ZWCAD, ZW3D), etc. IBM LUM is used by Dassault Systemes with applications like Catia and Enovia. LM-X is for example used by Solibri products. MathLM (Mathematica), Vertex Systems (Vertex BD - BIM Software for Steel and Wood Framing Construction, Vertex G4 - 3D Mechanical Engineering Software for Machinery Industries, Vertex Flow PDM / PLM Software).

RLM (Reprise License Manager) is for example used by Ansys/EvenAG, Bitplane, CadWorks, CMG (CMGL), Bricsys/BricsCAD, DesignBuilder, Elemental Tech, FEMTools/DDS, FINCAD, Genarts, GibbsCAM, Graebert (ARES), HumanSolutions, Lanner, LLamasoft, MAPublisher, Minesight, Oasys Design Systems, Programming Research, Runge, Siemens/KineoCam, Siemens/LMS (LMS International), Simerics, SolidAngle, Solver, StreamSim, TecPlot, Trace32 (Lauterbach), WesternGeco (Gedco). Import of RLM license server report log is available as well as snapshots taken with the rlmutil.exe utility.

This is an example of a detailed report created with JTB FlexReport. Every user is mapped to a group. The group can be a location, division, cost center, it's up to you. You can also see what users that are not within a group.

Report app that makes it easy to create different type of charts and reports of the license usage and historical usage. Create the reports manually or automatically on schedule to be published on a server as PNG files or emailed.

This report is showing how many hours each user has used applications each month sorted with the highest usage first.

If you have cascading licenses or multiple versions of the same application, you can combine the various separate reports to get a total usage. This way it can help you to comply with that your company are not using more licenses than allowed as can be the case if you for example have AutoCAD 2018, AutoCAD 2017, etc. on subscription from Autodesk.

Look at historical data of for example of 20 months where max usage per day is showed. Notice that the available number of licenses has been adjusted up and down. In this case the licenses are rented on a monthly basis.

Or 10 months.

Or just 5 days.

Any of the chart and list reports can be created automatically on a regular interval as PNG images and if a fixed name is used for them they can be put on a simple HTML page that users can access or for example SharePoint.

Drilldown to find who might have used licenses at a specific point in time.

Usage per Feature per Day.

Denied per Month. Notice in column LicenseFound how some users did not find a license within a reasonable time as well as how many times they were denied.

Concurrent Usage Per Month report showing max, min and average usage as well as standard deviation.

Find out what users have borrowed licenses but still are online and connected to the network and if needed contact them to return the license earlier. Use the Pinged Host Report. 

Chart report on how many hours users have been using a feature.

For Autodesk customers who own a subscription with multi-user access or network maintenance or Design & Creation Suites, JTB FlexReport can help you transition to a plan for named users.

IBM LUM idle time reporting is available where the the percentage idle time per Workbench, user and host is reported on per day, week or month. Contact us for details.

German privacy law, the EU General Data Protection Regulation (GDPR) compliance or similar can be met by not recording any details about the users and hosts.

Multiple license servers in a LNA/WAN can be monitored from one location even across multiple time zones or countries. No limitation in number of servers, features, users or hosts that can be monitored.

FlexNet/FLEXlm support includes Floating (Concurrent) Licenses (also referred to as concurrent usage or network licensing), Redundancy via License-File List (distributed license servers), Redundant License Server Systems (triads or three-server redundancy) and node-locked licenses (Counted Licenses and Uncounted Licenses).

This is a list of systems that are not directly supported but JTB Process Monitor can report on the application usage of many of the applications using these license systems. Archicad wibu, Felics, Bentley licensing and SELECTserver, RSoft, GNS License Manager, Orcaflex, Transoft, Sparx, Bitlock, Elprocad, Rhino3d zoo, IBM Rational ClearCase Atria.
Contact us if you have a need for full support of any of them or any that is not listed here.

Get ready to optimize network license and most any other software's usage as well as your software assets.

Network license assessment can be made easier with JTB World's license reporting for FlexNet and many other license systems.

Are you a PowerBI user? if so connect to the database and create your own reports. 

Typical users of JTB FlexReport are: IT managers, Director of Information Technology, CAD managers, IT staff, IT technicians, IT Asset Management staff (ITAM), License Administrators, Software Compliance Specialists, Software and Sys Admins, Application Administrators, BIM/CAD Systems Managers, Asset Co-ordinators, Network Sys. Admin., Systems Administrators, Design Technologies Administrator, Technology Manager any many more.

JTB Process Monitor

This is a separately purchased module that expands the functionality of JTB FlexReport to be able to record and monitor usage of processes or applications.

This opens the door to monitor usage of standalone applications like Word, Excel, Outlook, Adobe creative cloud for teams, Autodesk Named User licenses, AutoCAD LT or applications with network licenses that otherwise are not supported by JTB FlexReport. And with that you can reduce cost and optimize licensing for many more products.

There is a service part and a client part of the application and two separate installers. The data is saved into the main JTB FlexReport database and reports on the usage can be done in the normal way. This means that JTB FlexReport also needs to be installed. The client computer does not need to be connected to the network all the time, making it useful even when users are working off-line like from their home or on travel. It still can monitor the usage and when connected again it will send back the data to the server.

Another usage scenario is to identify users that might not need a full license.

There are also applications that even though they use FlexNet or LUM they are used only a few seconds or minutes and their usage recorded with JTB FlexReport is limited because of the snapshot intervals. With JTB Process Monitor also these applications can be more correctly monitored.

Optionally allow the user to select a project to associate with the session when an application is started. This way you can report on hours used per project.

If you have a need to split costs of software based on usage JTB Process Monitor will be a big help.

JTB Process Monitor can be set to report on actual usage of a software by monitoring mouse and keyboard usage within the software. So if the software is not being used for a certain time this will be detected.

Do you have a lot of users borrowing network licenses and don't want to see 24 hours usage per day on the reports? Add JTB Process Monitor and either get the time the monitored app is run or actively used. 

JTB Process Monitor is useful while preparing to convert standalone licenses to network licenses as it will help to know how much the applications are used and by what users.

JTB Process Monitor can be used to report on what actual product is run on the client when using an Autodesk suite or collection license or named user licenses.

For Autodesk customers who own a subscription with Standalone Maintenance or Design & Creation Suites, JTB Process Monitor can help you transition to a plan for named users.

JTB Process Monitor can report usage of products on Autodesk's named users plans. You get much more functionality and report from JTB FlexReport and JTB Process Monitor that the limited reporting Autodesk provides. Report on how much the applications are actually used by your users. Do you really need a license for a user only using the application 4 times per week a total of 2 hours? Or are there better options? With JTB Process Monitor you can better take these decisions. 

See more in the JTB Process Monitor Documentation.

For a trial of JTB Process Monitor you need these 5 installers: JTB FlexReport Core, JTB FlexReport Service, JTB FlexReport Client, JTB Process Monitor Service and JTB Process Monitor Client. 

Download

Downloads for the latest version 2021.1.1 See also the Documentation and upgrade tips.

Note that version sometimes can be lower for individual installers and files.
See Revision History for details.

Email or Contact us to get a time limited trial for free. You can try it in your environment with your real data for a few weeks with full functionality.
Full support is provided during trial period. Right after installing it for the first time it works in trial mode for 7 days. Email us the computer number as reported in JTB FlexReport Config>License Activation (install JTB FlexReport Core first).

We offer Proof of Value (POV) of JTB FlexReport, by the ability to testing its capabilities within your environment, so that you can build a business case for the software based on your own real data.

Main download

JTB FlexReport Core
JTB FlexReport Core 2021.1.1 Setup.zip 
Mandatory installer. This is the main or core service needed to retrieve usage and save to the database. .NET Framework 4.6 or newer required.

Reports service and client

JTB FlexReport Service
JTB FlexReport Service 2021.1.0 Setup.zip 
Optional but recommended installer. This is the report service that is needed for the creation of reports. .NET Framework 4.6 or newer required.

JTB FlexReport Client
JTB FlexReport Client 2021.1.0 Setup.zip 
Optional but recommended installer. This is the client for the report creation. .NET Framework 4.6 or newer required.

JTB Process Monitor service and client

JTB Process Monitor is priced separately and is not included with the purchase of JTB FlexReport. Let us know approximately how many computers it should monitor and contact us for a quote.

JTB Process Monitor Service
JTB Process Monitor Service 2021.1.0 Setup.zip 
Optional installer. This is the service that is needed together with the JTB Process Service. .NET Framework 4.0 or newer required.

JTB Process Monitor Client
JTB Process Monitor Client 2021.1.0 Setup.zip
Optional installer. This is the client for the JTB Process Client. .NET Framework 4.0 or newer required.

SPLM (SmartPlant License Manager) service and client

JTB FlexReport SPLM Service
JTB FlexReport SPLM Service 11.1.0.zip
Optional installer for monitoring of SPLM usage. This is the service that is needed together with the SPLM Client. .NET Framework 4.0 required or newer. Install on same machine as where core JTB FlexReport is running.

JTB FlexReport SPLM Client
JTB FlexReport SPLM Client 11.1.0.zip
Optional installer for monitoring of SPLM usage. This is the client for the SPLM Service. .NET Framework 4.0 required or newer. Install on the SPLM license server.

Other downloads

Sample database for MS Access
Sample database for MS SQL Server - useful for evaluation and demo of the report and chart features.

Download of FlexNetFeatures.xml. Useful if there is no internet connection or access to the file is blocked where JTB FlexReport is installed. If you want to get descriptions for features in JTB FlexReport Config>Features then download this xml file to your desktop and save it into the JTB FlexReport folder and then click on JTB FlexReport Config>Features>Get Feature Descriptions.

Tracking of Primavera usage is available upon request.

These are two MS Access based tools to help merging multiple MDB databases into one or update an old one if there are database definition problems like indexes missing resulting in duplicate rows and other potential issues.
JTB FlexReport Merge DBs 11.0.0.zip

JTBFlexReport.NET.mdb 2020.11.0.zip is an empty database if there is a need to start from scratch and you don't have the empty copy in the installation folder.

SQL Server scripts:

Update DB: JTB FlexReport SQL update version 2020.11.0.txt This will add needed temporary tables when Update DB fail and the Client shows the error that Temporary tables are not created. 

Backup old data: JTB FlexReport SQL backup old data 11.TXT

Delete old data: JTB FlexReport SQL delete old data 11.TXT

Create a copy of the database and upgrade the copy at the same time:
JTB FlexReport SQL create and copy db version 2020.11.0.txt
This can be useful if JTB FlexReport is not able to automatically add new tables, new indexes or new columns.

Upgrade Tips

When upgrading JTB FlexReport Core, Service or Client from 12.0.0 or JTB Process Monitor from 12.1.0 or newer, just run the setup.

When upgrading from 2020.10.0 or older, the database needs to be updated. After installing run Update DB in JTB FlexReport Config or for SQL Server the Update DB script above can be used. 

To upgrade from older versions than above, uninstall previous JTB installations and install the new ones. Before uninstalling it is good practice to first stop the JTB services. The Core, Service and Client installations can be installed without uninstalling previous version.

If you want to be on the safe side make a backup of the database or the setup folder but that is normally not needed.

Some settings are saved in the registry and normally are upgraded correctly. But to be on the safe side backup of these keys can be done (one or both may exist):
HKEY_LOCAL_MACHINE\SOFTWARE\JTB World
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\JTB World

If you want to start with a new database from scratch, backup, delete or rename the old database before installing the new version of JTB FlexReport Core. JTBFlexReport.NET.mdb is the MS Access database to use. For SQL Server see Core documentation how to create a new database.

If using MS Access database now it's time to remember to compact the JTBFlexReport.NET.mdb database using the Database Administration tool or MS Access. Never let it grow close to 2Gb.

JTB FlexReport Config > Update DB can be used to update the database definition (if upgrading from a version older than 12.0 to 12.0 or newer) to the latest if you plan to keep using an old database. Sometimes this update is not able to solve all problems. A more thorough method for MS Access databases is using JTB FlexReport Merge DBs <version>.zip, extract JTBFlexReportMergeDBs - manual start.mdb and follow the instructions in the .txt file. This can solve bloating databases due to missing or incorrect indexes. If using SQL Server database there are scripts that can help to update the database definition.

Run JTB FlexReport Config>Launch Service Configurator and make sure the settings are correct and press ok. Then check all other properties like license servers to monitor. Start service.

A good practice is to after a while make sure everything works after the upgrade. Start to check that JTBFlexReport2.htm found in JTB FlexReport folder looks ok.
Look for the JTBFlexReport.log file in the temporary folder (the folder can be set in JTB FlexReport Config and is as default %ALLUSERSPROFILE%\JTB World\JTB FlexReport). If there are errors in that file that you don't understand please zip and email it to us for further investigations.

Run JTB FlexReport Service Configurator and make sure the settings are correct. Press Configure and start services and use the two test buttons. Run the Report Client and verify that the reports are working.

Sometimes the following can be needed: Run JTB FlexReport Service Configurator, make sure JTB FlexReport Sampling Service is checked, press Configure and Start Services, then press Clear followed by Sampling All Records.

The following is not needed for version 12.0 or newer. If "Log On As" has been manually modified (when UNC paths are used) for the Windows services of JTB FlexReport you need to modify this again after installing. Typical indicator can be that denials are no longer recorded or reported on even though the debug log paths are still available on the FlexNet tab.

If the configurator for the report service or client crashes or other strange errors happens it might help to uninstall, empty the installation folder(s) and reinstall. Make also sure the .NET Framework is matching the requirement for the installer.

On some systems when running the installer nothing happens. This can be because the settings on the server does not allow running files downloaded from the internet. To solve this right click on the exe and msi files one at a time, select properties and click on unblock.

Newsletter

Subscribe to our JTB FlexReport newsletter or any of our other Newsletters.

System requirements

Microsoft .NET Framework 4.6 or/and later is needed. 

Operating system - Windows 10, Windows Server 2019, Windows Server 2016, Windows Server 2012 R2, Windows Server 2012. 32-bit and 64-bit operating systems are supported. Windows 2003 Server, Windows XP, Windows 2000 (SP2), Windows Server 2008 R2, Windows 2008 Server, Windows 8.1, Windows 8, Windows 7, Windows Vista might work but are not supported. FLEXlm or FlexNet can be installed and run on other operating systems like Mac OS X, UNIX or Linux and is possible to report usage from but JTB FlexReport must run on a Windows OS.

Microsoft Access is not needed to have installed even if MS Access is selected to be used as database.

If MS SQL Server is used to host the database the following are supported: MS SQL Server 2008 R2, MS SQL Server 2012, MS SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019, MS SQL Server Express 2008 R2, MS SQL Server Express 2012, MS SQL Server Express 2014, MS SQL Server Express 2016, MS SQL Server Express 2017, MS SQL Server Express 2019.

2 GB is the limit for MDB files if MS Access is used.
10 GB is the limit if MS SQL Server Express 2008 R2 or newer is used.
No limit if MS SQL Server is used.

JTB World is an Autodesk Authorised Developer

Purchase

You can always try the product first to make sure it fills your needs. Full support is provided during the trial period.

Contact us for a price quote by sending an email to info@jtbworld.com. Include what applications you have and the number of licenses each or at least the total number of licenses / modules / features / components / bundles / packages you want to report on. No need to include free licenses.

The price is ranging from a few hundred USD and up depending on the amount of network licenses it should handle (for example $3891 USD for 451-500 network licenses to monitor) and depending how much customization that needs to be done, if any. Enterprise license is $7626 USD.

The price is normally not based on number of license servers, services or number of applications or features.

JTB Process Monitor is priced in relation to an estimation of number of clients. The price per license is approximately 1/4 of the price for the main core JTB FlexReport application plus a base cost of $489 USD. Let us know approximately how many computers it should monitor and contact us for a quote.

Price is also geography-based to make the price attractive and reasonable in some countries that typically have lower priced software. Token based licenses are priced in relation to the number of tokens and how much they are worth. Node-locked licenses can also be valued lower than floating licenses. Autodesk subscription customers only pay for the license count they have on subscription even if they have multiple versions. Example: Count the base product/package AutoCAD but not the sum of AutoCAD 2021, 2020 and 2019. And for bundles only count the bundle/suite/collection and not the products that are part of the bundle. If you have a situation that you have much more network licenses than you make use of let us know as we can take that into account and lower the price.

If you're interested in renting the software contact us for details.

Educational institutions like schools, high schools and universities with free or educational licenses like Autodesk Campus licenses are offered substantial discount.

The price includes installation support, support, most upgrades, bug fixes, minor customizations during the first year. The price also includes that you can increase the number of licenses to report on with around 10-20%.

Maintenance (15% of the purchase price) including upgrades and support is available on a yearly basis after the first year. Maintenance is entirely optional. Increases of the number of licenses or products can be adjusted at the time of the change if there is a big increase or when the maintenance is to be paid. The maintenance can be lowered if the number of licenses goes down. The maintenance price can change from year to year as the money value is changing and due to currency exchange factors.

Payment methods

If you decide to purchase we will send you details so you can make a bank wire transfer or we will send you a hyperlink to a secure e-commerce web site that will handle the purchasing.

Email the computer number as reported in License Activation and you will receive a license key to unlock and register JTB FlexReport after the purchase is done. The license is perpetual even if you don't need or want to pay maintenance you can still use JTB FlexReport for the version you last paid for and for up to the amount of licenses to monitor you purchased for. If upgrade or support or increase of licenses to monitor is needed maintenance needs to be renewed.

If you need to purchase through a reseller see this link.

Documentation

Read the documentation first for instructions on how to install, configure and run JTB FlexReport. For a presentation see this video on YouTube.

Main installers to download for most are “JTB FlexReport Core Setup <version>.exe”, “JTB FlexReport Report Service <version>.exe” and “JTB FlexReport Report Client <version>.exe”.

To get started using JTB FlexReport read the JTB FlexReport Core application documentation PDF, specifically start with the subjects General information, Installation and Getting started. JTB FlexReport Report Service and Report Documentation PDF will be useful to understand how the report creation works.

After installing click on License Activation button in JTB FlexReport Config and send us the computer number so we can send back a license key that you then can enter to activate the license. The installation works without activation for 7 days.

See activation instructions here: JTB World Apps Licensing. 

Download the JTB FlexReport Core application documentation PDF.

View JTB FlexReport Core Installation YouTube video or download it. (the video is quite old and not up-to-date)

View JTB FlexReport Detailed Reports usage YouTube video or download it. (the video is quite old and not up-to-date)

Download the JTB FlexReport Report Service and Client Documentation PDF. At the end of the document there are several sample reports showing what the report app can achieve.

View JTB FlexReport Chart Report Installation YouTube video or download it. (the video is quite old and not up-to-date)

View JTB FlexReport Chart Client usage YouTube video or download it. (the video is quite old and not up-to-date)

Download the JTB Process Monitor Documentation PDF.

SPLM (SmartPlant License Manager) documentation as below:

License file should be placed in the folder where the JTB FlexReport SPLM Service is installed.
This is the same license file as you have for JTB FlexReport core.

You need to run the setup.exe from JTBFlexReportSPLMService_(version no here).zip on the computer where you now have JTB FlexReport installed and running. You will get a configurator showing where you specify the path to JTBFlexReport.NET.mdb or whatever database you selected. Click on Configure and on Start Service. Take note of the port number and the server machine name as this is needed to configure the SPLM client.

JTBFlexReportSPLMClient_(version no here).zip needs to be copied to the SPLM server or servers and run setup.exe. In the configurator specify the path to pdlice.exe (local path required, example C:\path\pdlice.exe). The Product Usage Log Location is used to get denials only from an existing SPLM log. Select Log Product Usage on the SmartPlant License Manager main window and click Select and in the dialog box start logging after specifying log location. Use the same port and name as in the service configurator. Click on Configure and click on Start. Then click on Exit.
Now if everything goes well you should eventually get SPLM usage added to JTBFlexReport.NET.mdb or whatever database you selected.

JTB FlexReport FAQ

Autodesk Network License Manager and Autodesk GNUL licenses are supported.

See also the FlexNet Feature Codes page with most Autodesk feature codes ad their descriptions.

Support

JTB World regards customer support high and if you consider purchasing our software we will support and guide you for free to be able to run and try it fully.

For any support questions, feature request or feedback feel free to contact us.

Support is most often provided via email. Skype, phone, web-meeting are also available if needed.

Support is included with the purchase during the first year. After that support is provided if you have a maintenance agreement with us.

The support of JTB FlexReport is included in the price during the first year.

Maintenance including upgrades and support is available on a yearly basis after the first year. Maintenance is optional unless there is an increase of licenses to monitor or there is a need for support or upgrades.

Most often support is given within 24 hours even though we cannot guarantee it.

Version History

• 2021-01-19 - JTB FlexReport 2021.1.1
  • JTB FlexReport Core
    • Fixed problem that could cause the JTB FlexReport folder to be filled with temp*.tmp files. 
• 2021-01-18 - JTB FlexReport 2021.1.0
  • JTB FlexReport Core
    • Fixed problem that could cause logging to stop if the c:\Windows\Temp folder was filled with tmp files.
    • Fixed another problem where the FlexNet debug log import could fail to work.
    • Removed saving current usage from FlexNet debug log because it can be incorrect if the imported log is older than a few hours. And if weeks or months old log it can result in very long incorrect usage.
    • Various minor fixes.
  • JTB FlexReport Service/Client
    • Fixed problems when multiple servers or features could not be selected and reported on.
    • Fixed another bug caused by ' character in user and host names.
    • Fixed a problem where dates in exported Excel files could fail to be correct in some countries date formats.
    • Various minor fixes.
  • JTB Process Monitor Service/Client
    • Performance improvements for the Client causing less CPU strain.
    • Various minor fixes.
• 2020-12-07 - JTB FlexReport 2020.12.0
  • JTB FlexReport Core
    • Fixed a problem where the FlexNet debug log import could fail to work. 
  • JTB FlexReport Service/Client
    • Fixed another bug caused by ' character in user and host names.
• 2020-11-23 - JTB FlexReport 2020.11.1
  • JTB FlexReport Core
    • Fixed a problem that logging stopped or failed in some situations.
    • Fixed missing scrollbar in Features dialog box in JTB FlexReport Config.
  • JTB FlexReport Service/Client
    • Fixed a bug caused by ' character in user and host names.
    • Fixed a bug where Feature Groups could not be reported on.
• 2020-11-09 - JTB FlexReport 2020.11.0
  
  • JTB FlexReport Core

    • Fixed problem with usage of "Do not log detailed usage" checkbox checked.

    • CodeMeter log reading bug fixes and performance improvements.

    • Performance improved in various areas.

    • Added email notifications for some FlexNet connection errors.

    • Exclude soft denials from being notified by email.

    • Various minor fixes.

  • JTB FlexReport Service/Client
    • Startup time of the Client improved. Requires update of the database using JTB FlexReport Config > Update DB. 10 tables prefixed tblTemp will be added. They are updated every 10th sampling interval (Precision Value).
    • Fixed a regression bug that existed in several list reports since their introduction in the Client causing sometimes more hours to show than it should.
    • Various minor fixes.
  • JTB Process Monitor Service/Client
    • Processing of older local usage data after upgrading to 2020.8.0 or newer.
    • Various minor fixes.
• 2020-10-02 - JTB FlexReport 2020.10.0
  
  • JTB FlexReport Service/Client

    • Fixed a regression bug that existed in the hours chart report since version 12.1.1 causing sometimes more hours to show than it should.

    • Fixed a UI glitch in the Office 2007 style.

    • Known issue with the list reports causing sometimes more hours to show than it should. This issue has existed since the list reports were introduced and will be fixed very soon.

• 2020-09-29 - JTB FlexReport 2020.9.4
  
  • JTB FlexReport Core

    • Fixed problem that logging sometimes stopped at midnight or random occasions.

    • Fixed a Sentinel log parsing bug.

  • JTB FlexReport Client
    • Fixed a problem introduced in 2020.9.3 causing sampling service error.
• 2020-09-26 - JTB FlexReport 2020.9.3
  
  • JTB FlexReport Core

    • Added support to import FlexNet debug log usage and denials.
      GHSlm improved to handling large logs without interrupting other monitored license systems.

    • DS-2 bug fixed to use correct server name.

    • Fixed a bug where logging could stop in some cases.

    • Fixed bug that could result in an empty HTML report.

  • JTB FlexReport Service/Client

    • Raw data list and pinged hosts reports use date filters.

    • Gridline settings saved and used as expected in future reports, auto reports and favorites.

• 2020-09-03 - JTB FlexReport 2020.9.2
  
  • JTB FlexReport Core

    • Fixed a problem to parse multiple CodeMeter logs in some cases.

    • GHSlm bug in JTB FlexReport Config causing the settings not to show up in the grid.

  • JTB FlexReport Client
    • Fix error on startup and during usage. To fix, uninstall the Client and use the last checkbox "Delete Configurator settings in the folders (not recommended if you will install again)". Then install the new version. Error that is seen contain this text: "The maximum message size quota for incoming messages (65536) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element."
• 2020-09-01 - JTB FlexReport 2020.9.1
  
  • JTB FlexReport Core

    • Fixed a problem where issued licenses for FlexNet could show as 0.

    • Fixed a problem where multiple sub processes of JJTB FlexReport incorrectly run at the same time.

• 2020-09-01 - JTB FlexReport 2020.9.0
  
  • JTB FlexReport Core

    • Added email notifications when problem to initially access and open the database.

    • Fixed a problem to parse some CodeMeter logs.

• 2020-08-31 - JTB FlexReport 2020.8.1
  
  • JTB FlexReport Core

    • Fixed installer to kill the JTB_DS2.exe process if is running when  installing. 

• 2020-08-30 - JTB FlexReport 2020.8.0
  
  • JTB FlexReport Core

    • TLM usage monitoring supported. TASKING License Management by Altium.

    • FlexNet licenses with a mix of permanent and temporary (leased) licenses can now be separated. "Feature Expiry" is a new column on the FlexNet tab grid in JTB FlexReport Config to enable this together with specifying the license file to get the number of issued licenses for each.

    • RLM can now be monitored by snapshots as an alternative to the reporlog.

    • Some older versions of Sentinel is added support for. Like SentinelLM 7.0.0 Application Monitor by Rainbow Technologies, Inc.

    • Fixed the time for CodeMeter to be saved as the local time zone.

    • DS-2 tab is remembering hidden state.

    • Fixed an error where RLM monitoring could fail.

    • Fixed an error with the test button on the DSLS and RLM tabs.

    • Fixed an error related to the lsmon override functionality for Sentinel monitoring.

  • JTB FlexReport Service/Client

    • List Report Type "Host Groups" has added "Min Max Avg" as new report option.

    • About dialog box improved to show database size.

  • JTB Process Monitor

    • Option to log Total usage, Active usage or both.

    • Several bug fixes.

• 2020-08-10 - JTB FlexReport 12.3.0
  
  • JTB FlexReport Core
    • DS-2 License Manager usage logs supported. DS-2 is a PLM of Zuken PCB Design.
    • Fixed a bug related to some license systems that could cause data to not be logged as expected.
  • JTB FlexReport Service/Client
    • Auto Reports can now be scheduled within the interval of 1 and 24 hours. Before it was 1 to 60 minutes only.
    • Adjusting placement of date stamp on charts.
    • Export to Excel/image issue fixed.
    • Denial issue fixed where denials happening at pm where showing as am on Denied Requests list report using All interval. That is between 12:00 and 24:00.
    • Sampling of data improved with better rounding.
• 2020-07-06 - JTB FlexReport 12.2.1
  
  • JTB FlexReport Core
    • CodeMeter logging improved and bug fixed.
    • Option added to not force close JTB FlexReport Core Service at mid night as it can cause a SQL Server lock. Merging of reg file found in installer folder is needed. 
    • Fixed issue in JTB FlexReport Config. 
• 2020-07-06 - JTB FlexReport 12.2.0
  
  • Upgraded to JTB License 4.3.0.1.
  • Licensing update with encryption compliant with Federal Information Processing Standards(FIPS).
  • JTB FlexReport Core
    • Different versions of lsmon.exe can now be used for different servers. This to solve a problem where lsmon.exe used by JTB FlexReport in some cases needs to match the version on the license server.
  • JTB FlexReport Service/Client
    • Fixed a bug with the List report User Groups Min Max Avg where the user group column was missing.
  • JTB Process Monitor
    • Only one instance of the JTB Process Monitor programs can run at the same time.
    • Installer improvements to kill running processes like the Configurators or Client.
    • Command line installer more has the option to not show the Client on Windows Start menu using /nostartmenu=true.
• 2020-06-20 - JTB FlexReport 12.1.1
  • JTB FlexReport Core
    • Added support for CodeMeter log usage monitoring.
    • Fixed duplicate logging of HASP and DPT usage that under certain situations could happen. Old data needs to be manually cleaned up or start with a new database.
    • Big improvements of the time it takes to take a snapshot of usage and save to the database when there are a lot of features/users/hosts.
    • Fixed a bug related to DSLS that could result in no data logged until the next day.
  • JTB FlexReport Report Service/Client
    • Export All Tabs or Current Tab to Excel or Images.
    • More list report options to create Min/Max/Avg usage list reports.
    • User only list report is a new report type. It aggregate the effective time the user used any feature to give a total time for that user no matter what server/feature used.
    • Fixed a problem with PerDay drill down and tooltip (list shows different date in usage)
    • Fixed a problem with stacked line chart not being stacked.
    • Fixed problem with selection and filtering if features, servers and other list boxes in the Client UI.
    • Fixed issues with using the checkboxes for the services in some cases in the Service Configurator.
    • Fixed issue with Sampling All Records that could fail if not enough SQL Server user rights existed.
    • Fixed incorrect naming of exported images that sometimes could happen. Names could start with tabStrip.
    • MinMaxAvg list report now correctly aggregate usage even when a feature is on multiple servers.
    • Unique users drill down discrepancy fixed.
    • Fixed a bug with the discrepancy report failing in some cases.
    • Fixed an issue with This Week and Previous Week selections including extra days.
    • Fixed List Reports not grouped as expected.
    • Minor hours chart vs. list report discrepancy fixed.
    • Several other minor fixes and improvements.
• 2020-06-14 - JTB FlexReport 12.1.0
  • JTB FlexReport Core, Service and Client only released to some customers.
  • JTB Process Monitor
    • New and better install and uninstall functionality. No need to uninstall before installing a newer version. Better silent command line install of the Client to install and configure for many machines. 
• 2020-03-31 - JTB FlexReport 12.0.5
  • JTB FlexReport Core
    • Fixed a problem with Feature Version checkbox usage on the FlexNet tab in Config could cause the feature not working and making the test button not working as expected and in some cases no logging of usage to happen.
• 2020-03-23 - JTB FlexReport 12.0.4
  • JTB FlexReport Core
    • Fixed problem that the HASP logging executable did not close as expected.
      Fixed a problem that during trial some data was not logged to the database.
• 2020-03-09 - JTB FlexReport 12.0.2
  • JTB FlexReport Core
    • Fixed problem to create -temp mdb if it is missing.
    • Fixed a FlexNet related bug that could cause some data not be saved to the database.
    • Fixed a FlexNet related bug that might cause some problem with duplicate logging of usage.
• 2020-02-25 - JTB FlexReport 12.0.1
  • JTB FlexReport Core
    • Fixed error when using Test button and one or more rows are disabled.
      Some UI fixes.
• 2020-02-24 - JTB FlexReport 12.0.0
  • JTB FlexReport Core
    • Added support for HASP log usage monitoring. Sentinel HASP (aka Aladdin HASP SRM) by SafeNet.
    • Added support for DP Technology (DPT) log usage monitoring. ESPRIT is using this system.
    • Added support for Tebis license manager. 
    • HTML reports of current FlexNet usage now have an option to show feature version for each user. Commonly used by Matlab. New column "Feature Version" in JTB FlexReport Config on the FlexNet tab.
    • DSLS logging and reporting improved, for NamedUser usage and German and French languages.
    • Update DB can fix a couple of problems with certain older databases and warning about duplicated data in some tables.
    • Allows ' in SQL Server passwords.
    • Support to handle multiple EPLAN servers.
    • Fixed log reading errors related to EPLAN.
    • New and better install and uninstall functionality. No need to uninstall before installing a newer version.
  • JTB FlexReport Report Service/Client
    • Fixed a problem with the histogram report using the summation for one or multiple features.
    • Fixed problem related to SQL Server configured with some date formats that could cause reports to use wrong dates or not working at all.
    • Fixed a problem where the issued license line on charts created using the Detailed tab could be wrong.
    • Added option to see borrowed lines on charts with multiple features in one.
    • Fixed auto reports missing borrowed line in some cases.
    • Update DB can fix a couple of problems with certain older databases and warning about duplicated data in some tables.
    • Allows ' in SQL Server passwords.
    • Fixed problems with Favorite and Auto Reports related to multiple selections of features, servers, etc. not working.
    • Fixed MinMaxAvg chart issue when selecting multiple features.
    • New and better install and uninstall functionality. No need to uninstall before installing a newer version.
    • Fixed a minor glitch in the Service Configurator when doing a first clean install.
    • Fixed a problem where the stacked PerDay report was not stacked.
  • JTB Process Monitor Service
    • Allows ' in SQL Server passwords.
  • JTB Process Monitor Client
    • Fixed a problem related to date format differences that could cause usage not being sent to the service.
    • Fixed problems to send usage data to the service.
    • Fixed problems to gather data as expected especially when using Idle Time Timeout.
• 2019-11-18 - JTB FlexReport 11.7.0
  • JTB FlexReport Core
    • The HTML reports can now make use of CSS so changes to color and fonts can be done by the end user to .css with the same name as the htm report. Dark theme CSS included.
    • Fixed a problem with logging of DSLS usage due to change in the output from dslicsrv.exe.
    • Database Configurator widow can be resized correctly.
    • RLM server override used in HTML reports.
    • Added checking for newer version of JTB FlexReport Core at start of JTB FlexReport Config or by using the "i" icon.
  • JTB FlexReport Report Service/Client
    • Fixed a chart problem when 1 month was used as interval.
    • Fixed problem with some reports causing the error "No data available based on these Search filter".
    • .NET Framework 4.6 or newer required for the Report Client.
    • Added checking for newer version of JTB FlexReport Client and Service at start of JTB FlexReport Client.
• 2019-11-14 - JTB FlexReport 11.6.1
  • JTB FlexReport Report Client
    • Export to Excel bugs fixed.
    • Interval selection hidden when it is not being used.
• 2019-11-08 - JTB FlexReport 11.6.0
  • JTB FlexReport Core
    • Added support for monitoring ELM (EPLAN License Manager) usage.
    • Added support for RLM passwords.
    • Removed an error message in the HTML Creator that not was an error.
    • Fixed a bug since v11. 5 for: RLM it is now working to have a mix of servers to have port@server or not.
    • Now can handle extra spaces when multiple email recipients are specified for notifications.
  • JTB FlexReport Report Service/Client
    • Added ability for auto reports of Hours Charts to use Hours settings.
    • Fixed a problem related to auto reports sent to multiple recipients.
    • Fixed a formatting problem of hours column in some exports to Excel that could happen depending on country/language/decimal settings in Windows.
    • Fixed a problem with usage of "Multiple Report" checkbox that could cause no report being created.
    • Fixed a problem with usage of "Multiple in one" usage that could cause no report being created.
    • Fixed a problem with usage of "Fill effect" checkbox causing unexpected behavior.
    • Fixed a problem in denial report where License Found did not show Yes when it should.
    • Now can handle extra spaces when multiple email recipients are specified.
    • Other minor fixes.
• 2019-09-13 - JTB FlexReport 11.5.1
  • JTB FlexReport Core
    • Fixed a problem with activating the license.
  • JTB FlexReport Report Service/Client
    • Fixed a problem with activating the license.
    • Fixed a problem Client>Tool>s>Color>Line management to manually change color and other properties of chart lines.
    • Fixed a problem where saved auto reports in some cases were deleted automatically.
  • JTB Process Monitor Service
    • Fixed a problem with activating the license.
• 2019-09-02 - JTB FlexReport 11.5.0
  • JTB FlexReport Core
    • For RLM it is now working to have a mix of servers to have port@server or not. This can be useful if there are 2 or more vendors on the same server. Each vendor have their own report log but the port is common for all so only want to specify port@server for one of the rows.
    • The HTML Creator tool can now make use of CSS so changes can be done by the end user to StyleSheet.css is in the JTB FlexReport folder. The images are scaled to 95% of the browser width by default.
    • Disabled servers are excluded while testing on FlexNet tab with test button.
  • JTB FlexReport Report Service/Client
    • Office 2016 them added for the Client.
    • Auto Reports can be saved to a UNC path location.
    • Resizing of columns in List Reports is retained between reports and sessions.
    • Fixed problem when <All> is used in auto reports and favorites and new users or hosts are added after the report was configured.
    • Fixed: Stacked percentage report gives an overflow error.
    • User Groups and Min Max Avg List Report problem fixed.
    • DPI scaling issue in Client fixed.
    • Fixed problem where issued and borrowed license lines were missing when interval was low and time frame large.
    • Fixed bug when only selecting <Unassigned> all other assigned are showing.
    • Pinged host report bug fixes and improvements.
    • Fixed problems with formatting of numbers as text in some exported Excel reports.
    • Improved usage flow in the Service Configurator
    • Current locally used date format is used in more places
    • Clarified wording in some error messages.
    • Certain error log files that were not deleted are now automatically deleted as they could fill up a hard drive eventually.
    • Various other bug fixes.
  • JTB Process Monitor Service/Client
    • Bug fixes solving problems to record usage correctly.
    • Bug fixes related to various date formats.
• 2019-04-16 - JTB FlexReport 11.4.1
  • JTB FlexReport Core
    • Fixed a problem in the Create SQL DB functionality making it fail to work.
  • JTB FlexReport Report Service
    • Disabled creation of the ToolErrorLog files in C:\ProgramData\JTB World\JTB FlexReport Service\Logs and that could quickly grow large in file sizes. These should only be enabled during special code investigations. 
• 2019-04-08 - JTB FlexReport 11.4.0
  • JTB FlexReport Core
    • RLM denials supported
    • Fixed a problem with FlexNet monitoring on 32-bit Windows
    • Fixed a problem to import RLM logs containing a new time format
    • Fixed a problem where the UserDetailedLogTemp table could be created incorrectly causing problems run the Report Client.
  • JTB FlexReport Report Service/Client
    • Fixed problem with some denial reports failing to create and/or grouping data as expected
    • Fixed problem where date range not being used for denial list reports
    • Fixed problem where auto report stopped after trying to create report with no data in it
    • Fixed Unique user chart and other list report problems.
    • Fixed Auto Filter bug
    • Fixed problem that the feature and/or server did not show in some list reports
    • Fixed various other bugs
  • JTB Process Monitor Service/Client
    • Fixed some problems that could cause logging to not work
• 2019-02-04 - JTB FlexReport 11.3.0
  • JTB FlexReport Report Service and Client
    • Fixed date problem in Raw data list report where the month actually showed the minutes.
    • Fixed a problem with several list reports showing 0 hours usage when SQL Server was used. 
• 2018-12-27 - JTB FlexReport 11.2.1
  • JTB FlexReport Core
    • Fixed problem with Get Feature Description in Config not working.
    • Microsoft .NET Framework 4.6 is now minimum version supported.
• 2018-12-12 - JTB FlexReport 11.2.0
  • JTB FlexReport Core
    • Added support for change in LM-X version 5.
    • When lsmon is used to get SLM/RMS usage the feature now also includes the version
    • Added showing available licenses for LSTC showing on HTM reports and for saving to log table
    • Fixed issue with missing different serial number for nodelocked licenses with unique IDs. Example "MATLAB @ ID=38144". This happened due to now formatting of the lmutil output.
    • Fixed issue where MinMaxAvg report did not work in some date ranges
    • A problem with List reports Export to Excel fixed
    • Fix problem with the Database Administrator that could cause data loss in table tblUserDetailedLog
    • Fixed problem to validate some paths in Core Configurator
    • Fixed problem with date formatting for certain date settings for BETA LM resulting in HTML report not showing the usage and no data saved to database
    • Fixed problem in Group Administrator related to host groups based on IP
    • Fixed certain date formatting issues that could cause usage to not be saved to the database
    • Fixed problem where list reports could show the minutes wrong when converting between decimal and HH:MM format.
    • Fixed a problem that could cause RLM RL files not to be imported.
    • Performance improvements for the Core service.
    • LSTC license usage supported to show on the HTML reports and fixed some cases when not saving to database
    • Fixed a Sentinel parsing issue that caused some usage to not have any end time
    • Server description used if available to be saved in database now for DSLS and LSTC
    • Various minor fixes
  • JTB FlexReport Report Service and Client
    • Big overhaul of the Auto Report with bug fixes and performance improvements
    • Various reports that failed with errors are now working as expected
    • Report Service Configurator email settings will be retained in the future
    • Time Frame bug fixed for Continuous Line chart that could happen if aa PerDay report was created just before
    • Fixed UI glitch in the Service Configurator
    • Raw Data List Report is showing hours and minutes for the Start, End and BorrowEnd columns
    • Raw Data List Report is showing BorrowEnd column rows empty when no borrowing has taken place
    • Exported reports to Excel now handle various date and time formats better
    • List Reports have been fixed to handle various date and time formats better
    • List Reports have been fixed to include the Feature even if the Feature Description is empty
    • Fixed various reports failing for data coming from JTB Process Monitor
    • Various minor fixes
• 2018-04-30 - JTB FlexReport 11.1.0
  • JTB FlexReport Core
    • Added support for new DSLS log format
    • In HTML report for DSLS number of reserved licenses are showing
    • Fixed a problem where Sentinel usage did not show up in HTML reports or being logged
    • Fixed DSLS date parsing bug related to Korean date format
    • Various bugs fixed in Group Administrator
    • Database Administration bugs fixed where moving data did not always work
    • Fixed a bug in JTB FlexReport Config>Features dialog box that made the first imported description to not be saved
    • Changed column name in JTB FlexReport Config>Features dialog box from AppName to Feature
    • Fixed a problem with HTML reports where not all servers were showing up
  • JTB FlexReport Report Service and Client
    • New feature for Histogram reports added. New summation checkbox. When Summation is checked and multiple features and/or servers are selected the result will be summed.
    • Fixed problem when multiple features or servers are selected and in some cases only one of them are showing in the chart report
    • Fixed problem to show the issued licenses line as expected in some chart reports, it could sometimes show only as a fixed horizontal line even if the issued licenses was going up or down
    • Fixed problem with highlight today checkbox not working as expected
    • Date format fixed in exported files to Excel for some reports
    • Some export to Excel bugs fixed
    • MinMaxAvg Concurrent Usage when aggregated on server now shows the column for the server in the report
    • Histogram report bugs fixed
    • Fixed a problem where feature was empty on some list reports
  • JTB Process Monitor
    • Various JTB Process Monitor bugs fixed
  • JTB FlexReport SPLM
    • Bug fixes where dates were not saved correctly when certain date formats were used
• 2018-01-05 - JTB FlexReport 11.0.4
  • JTB FlexReport Core Setup updated to solve a problem where logging in some cases is not working for SQL Server
  • Database script under download section updated: JTB FlexReport SQL create and copy db version 11.0.4.txt
• 2017-12-21 - JTB FlexReport 11.0.3
  • JTB FlexReport Report Service and JTB FlexReport Report Client updated
    • Fixed problem with Auto Reports existing in version 11.0.0 to 11.0.2
  • JTB Process Monitor Service updated
    • Fixed problem with error "Object reference not set to an instance of an object" in 11.0.0 and 11.0.1
  • Known issue in JTB FlexReport Core 11.0 to 11.0.2 where logging in some cases is not working for SQL Server. (solved in 11.0.4)
• 2017-12-20 - JTB FlexReport 11.0.2
  • Fixed various errors in version 11.0.0 and 11.0.1
  • Fixed problem to update database from old format in certain cases
  • JTB FlexReport Core, JTB FlexReport Report Service and JTB FlexReport Report Client updated
  • Known issue with Auto Reports
  • Known issue with error on some reports with specific combination of settings, if running into any errors please report to us
  • Known issue with Histogram reports created from the Feature Server tab, use the Detailed tab in the meantime
• 2017-12-19 - JTB FlexReport 11.0.1
  • Fixed error "Object reference not set to an instance of an object"
• 2017-12-18 - JTB FlexReport 11.0.0
  • Added support for GHSlm (Green Hills Software License Manager)
  • Added support for LSTC-Dyna (LS-DYNA / Ansa / mETA / Livermore Software Technology Corporation)
  • Added support for BETA LM (BETA CAE Systems)
  • Added support for PKit license manager (PersonalQM / Method Park / Stages)
  • Chart Client renamed to Report Client as it includes all list reports too
  • No need for MS Access to create detailed list reports as these have been added to the Report Client
  • The database has been size and speed optimized. The database structure is automatically updated
  • RLM monitoring now has the option to include the feature version or not in the feature name
  • Removed bug that could result in duplicate rows in the HTML report when DSLS is reported on
  • Fixed a RLM parsing bug that could stop the parsing
  • Automatically remove most empty rows in the grids in JTB FlexReport Config when it is opened
  • JTB FlexReport Database Administration bugs fixed
  • Fixed a problem where the HTML report could not be created when in some cases where features have very high number of issued licenses like 2147483647
  • Fixed an error that could cause LM-X logging to fail
  • Added support for RLM version 11.3 or newer with denials in the log file that resulted in not logging any data in previous versions of JTB FlexReport
  • Removal of read-only attribute of copied log files to solve error
  • Fixed issue with HTML reports that accidentally removed part of port@server text in some cases
  • JTB Process Monitor - Solved a problem to map processes with a full path to the correct feature name
  • JTB Process Monitor - Improved performance when "Idle Time" is being used
  • New licensing of JTB FlexReport
  • Other minor bug fixes
• 2016-12-15 - JTB FlexReport 10.3.0
  • For FlexNet "ACTIVATED LICENSE(S)" the date and time for when the license is borrowed until is set to the current time as no other time is available to use.
  • Fixed an issue caused by a new version (11.13.1.2) of lmutil.exe that could cause problems to report correctly if lingered or borrowed licenses were in use.
  • Removes extra white space before user names for DSLS usage that in some cases can happen and cause duplicated usage.
  • Removes 0@ from showing in HTML-reports. Specifically for SLM/RMS usage.
  • JTB Process Monitor fixes issues with wrong start usage date being saved to the database.
  • JTB Process Monitor Client uses much less CPU.
  • Other minor bug fixes.
• 2016-09-12 - JTB FlexReport 10.2.0
  • The Database Administrator now supports SQL Server
  • Improved parsing of FlexNet debug logs
  • Bug with test button for SLM/RMS tab fixed
  • Issue with DSLS logging fixed
  • Improved parsing of RLM report logs
  • Fixed DSLS logging caused by new format used by DSLicSrv.exe
  • Sentinel lsmon.exe bug solved where nothing was reported by lsmon.exe
  • Sentinel feature names now include the version
  • Sentinel usage support MaxLic setting in JTB FlexReport Config>Features so that your number of licenses can be used as this information is not available in the Sentinel logs
  • Fixed an issue with import of Ranorex usage log
  • Improved performance of denial logging to the database
  • Fixed a problem in JTB FlexReport Config>Features causing the default of checkboxes to not work as expected when database is SQL Server. Manual fix of existing database can be needed
  • Fixed a problem with the HTML report grouped on features that caused click to expand functionality not work as expected
  • Fixed a problem parsing LM-X xml files
  • Fixed a problem with user groups in the HTML report
• 2016-06-25 - JTB FlexReport 10.1.0 (update)
  • JTB FlexReport Core was updated with a minor fix that caused errors when starting JTB FlexReport Config the first time.
• 2016-03-10 - JTB FlexReport 10.1.0
  • Chart Service and Client only are updated.
  • Fixed issue where Auto Reports in some cases (depending on date format) could fail.
  • Fixed issue that could cause the Chart Client to fail when upgrading to version 10.0.
  • Improved startup time of Chart Client.
• 2016-02-10 - JTB FlexReport 10.0.0
  • Chart Client defaults to a Wizard mode that hides options depending on what report type is selected.
  • Added Favorites functionality in Chart Client making it easier to access and create different reports.
  • Improved performance and minimized CPU usage for the Chart Client and Service.
  • Added issued license line to some charts that were missing it.
  • Fixed a problem when interval is 1 week in Chart Client.
  • Fixed Unique Chart not dropped to Zero issue.
  • Fixed some date format issues in Chart Client.
  • Fixed issues with the Auto Reports functionality.
  • Fixed issues with Auto Filters in Chart Client.
  • JTB FlexReport HTML Creator is a new tool to help create dynamic HTML pages based on automatically created charts.
  • Fixed a parsing issue for Sentinel RMS License Manager logs
  • Issue with 90 day reports in Detailed Reports fixed. The report did not work for certain date formats in some countries.
  • If issued license count is 2,147,483,647 like for some Altair features it’s in reality not that so if the issued license count is more than 100,000,000 it will be forced to 100,000,000.
  • DSLS Named Users now get the start time from “last used at” instead of “granted since”.
  • DSLS user names with spaces supported
  • Fix some issues with the importing using “Import of DSLS usage log” button in JTB FlexReport Config
  • Fixed a parsing issue related to Sentinel’s lsmon.exe output when “License start date” is “No License start date!” causing an error to get usage.
  • Added context menu in grids to delete current row in JTB FlexReport Config.
  • Fixed a problem reading FlexNet denials from certain vendors like Nemetschek SCIA Engineer.
  • Fixed an issue where SPLM logging did not respect the NoLog setting in JTB FlexReport Config>Features.
  • Fixed several RLM parsing issues.
  • Added option to include dongle with server name for 12D reports.
  • Fixed AVEVA Sentinel issue causing duplicate usage being logged.
  • Fixed DSLS issues that could cause wrong counts in reports.
  • Detailed Reports based on 90 days did not work in some countries bug fixed.
  • Other bugs and changes have also been done.
• 2015-04-12 - JTB FlexReport 9.2.0
  • Chart Service and Client updated only.
  • Changed to smaller width of current day lines.
  • Preset values reverted to 6 months bug fixed.
  • Fixed a regression problem where the current day did not show in some charts.
  • Fixed some regression problems with charts not being created.
  • Fixed a regression problem where some automatic reports did not work.
  • Fixed a regression problem where denials did not show up in charts.
  • Some other minor bugs fixed.
• 2015-04-05 - JTB FlexReport 9.1.1
  • Problem to install on Windows Server 2003 solved.
  • A problem with auto reports solved.
  • A problem with logging of SPLM usage solved.
• 2015-04-01 - JTB FlexReport 9.1
  • JTB FlexReport Chart Service and Client updated.
  • Auto filtering is now possible when selecting for example features, servers, users and hosts (including their groups). If showing the features and servers and selecting one server the features list will be automatically filtered to show only the features available on that server. This can be activated/deactivated on the application menu at the top left.
  • Drill down on denials added.
  • Start up time of the client has been improved.
  • Improved performance when using large databases. If you use SQL Server and you still don't see improvements you might need to manually add the new indexes. On the Download section at the bottom there are some scripts that can be used. Specifically "JTB FlexReport SQL create and copy db version 6.txt".
  • Fixed some memory leaks causing RAM usage to increase.
  • Improved sampling service performance.
  • A lot of bug fixes has been made and upgrade is strongly recommended as some reports in earlier versions might show incorrect results.
  • Auto reports might need to be set up again after this upgrade as a lot of improvements related to performance and reliability has been done. Normally it should work to select each report and press validate path and then save.
  • Fixed a bug causing crash when showing certain charts in 3D.
  • Cleared the 'No protocol binding matched the address' error on FlexReport Servie.
  • Highlight today disabled in continuous chart.
  • Allowed multiple email addresses with semicolon.
  • Allow email servers with no password credentials.
  • Issue with service and client on different domains fixed.
  • One Export to Excel problem fixed.
  • Fixed an issue when the features and servers lists did not populate.
  • And several more issues being fixed.
• 2015-03-24 - JTB FlexReport 9.0
  • JTB FlexReport Core and JTB Process Monitor are updated. JTB FlexReport Chart Service and Client will be updated soon.
  • DSLS support added including import of historic logs and denials.
  • The SLM tab is renamed to SLM/RMS and adds improved functionality for Sentinel RMS. AVEVA Licensing System fully supported.
  • SPLM 2012 support added.
  • Altium license monitoring support added.
  • JTB Process Monitor updated to handle idling of processes with detection of usage of an application if mouse movement or keyboard usage is detected for the application or if the CPU usage for the application exceeds a specified level.
    This way you will get a better picture of how much the applications really are being used as sometimes an application can be running the whole day but only being used an hour or so. If monitoring network licenses both with JTB FlexReport Core and JTB Process Monitor you will now see that they match better, especially if you’re making use of TIMEOUTALL or TIMEOUT on the FlexNet license server.
  • JTB Process Monitor can now detect if different AutoCAD verticals are running even though they use the same acad.exe by the added title filter. Thus you get a report on AutoCAD 2016 as well as AutoCAD Architecture 2016 separately.
  • Added automatic reading of user and host names from AVEVA’s ALS XML.
  • Several improvements and bug fixes related to 12D usage monitoring.
  • Added support for showing user group information on the HTML report grouped on servers. User groups are first taken from the FlexNet options file if it’s been specified on the FlexNet tab, otherwise from user groups defined in the Group Administrator.
  • Improvements in parsing lmstat result to get correct User and Host for FlexNet based licenses.
  • Added support for SLM based licenses to show up in the HTML reports and also log feature usage to the ‘log’ table.
  • Added support in HTML reports to use the override of available licenses (that is set in JTB FlexReport Config>Features>MaxLic). Useful for example for SLM based licenses that does not automatically get the number of available licenses per feature.
  • Simplified log browsing in JTB FlexReport Config.
  • Added index IX_UserDetailedLogTemp on table UserDetailedLogTemp to improve performance while reporting.
  • Fixed an issue where multiple reserved groups does not show up in HTML reports.
  • Fixed issue with LUM usage not showing in some HTML reports.
  • Fixed an issue when logging multiple RLM servers.
  • Fixed a problem with RLM parsing of the reportlog where the port number before in some cases where added before the server name when saved to the database.
  • Fixes to RLM logging to use override server when needed.
  • Compacting of –temp database in the database admin tool, and one try of compacting is also now done before fixing any indexes or other table issues.
  • Fixed an issue in the Excel based report that caused the populating of features to not work.
  • Fixed issues in the Detailed Report that made them fail to run with large SQL server databases due to timeouts.
  • Fixed an issue creating HTML reports using the VBS and INI files.
  • lmutil.exe 11.12.1.4 included
  • Several other minor bug fixes and improvements have also been done.
• 2014-05-16 - JTB FlexReport 8.0.1
  • Fixed some RLM logging issues causing RLM usage to not work.
  • Added SQL Server scripts to backup, delete old data and fix database available under the download section above.
  • Fixed a problem with settings in JTB FlexReportConfig>Notifications.
  • Fixed problem with test buttons in Config that in some cases showed an unexpected error.
  • Fixed some issues introduced in 8.0 in the Access frontend Detailed Reports.
  • To improve performance of Access frontend Detailed Reports the following index can be created in SQL Server.
    CREATE NONCLUSTERED INDEX [groupindex]
    ON [dbo].[UserDetailedLogTemp] ([DateField])
    INCLUDE ([ServerName],[UserName],[UserHost],[AppName],[LingerValue],[Licenses],[ProjectID])
  • Fixed issues in SPLM Service that in some cases stopped logging of data.
  • Fixed issue with Ok button in Features and Servers forms. If no change was made the Ok button did nothing, now it closes the form.
  • Fixed an issue with tmp files not being deleted when monitoring LUM licenses.
  • Fixed an issue when Chart Client Configurator was started from JTB FlexReport Config.
  • Fixed issue in Chart client when changing the width of the list boxes.
  • Fixed issue in Chart client reports that did not include <Unassigned> when needed.
  • Fixed performance issue when changing tabs in Chart client Ribbon.
  • Invalid column name issue fixed in Chart client.
  • Count issue fixed in Chart client list report.
  • Plus some other minor fixes.
• 2014-04-07 - JTB FlexReport 8.0.0
  • Added support for monitoring of Reprise License Manager (RLM).
  • Added support for monitoring of Venturis.
  • Added support for monitoring of Ranorex.
  • JTB FlexReport Config has got a large UI update.
  • Email PNG reports automatically added to chart client.
  • More settings available before a report is created on the Report Settings tab in the chart client. These are also use by the auto report functionality.
  • More preset values for date ranges added in the chart client.
  • Time frame is being used for Histogram charts now.
  • <All> and <Unassigned> added to all list boxes in chart client where applicable to make it easier to make selections.
  • Improvements and bug fixes for the auto report functions.
  • Filtering added for lists in the chart client. Example: filter all features containing the text Auto.
  • It is possible to within the list boxes type on the keyboard to locate a specific item.
  • Fixed random error when reading OPT files in the Group Administrator.
  • It is recommended to add this index if SQL Server is used:
    CREATE NONCLUSTERED INDEX [IDIndex] ON [dbo].[UserDetailedLogTemp] ([ID])
  • Added support for email setting SSL in JTB FlexReport Core making it possible to for example use gmail’s SMPT server.
  • Process Monitor Client optionally disable popup balloon or possibly show it less often and only when needed. Available in the client configurator.
  • Fixed bug with 3D charts on 64-bit systems.
  • Added support for changes in LM-X XML output files.
  • Bug fix to solve used license count when there is a mix of nodelocked licenses and floating licenses.
  • Shortened time it takes for doing snapshots in JTB FlexReport Core by moving HTML reports, ping of hosts, update of IP and finding denials in FlexNet debug logs to separate threads.
  • Include duplicate usage checkbox added to Detailed Reports.
  • Fixed a problem with SPLM logging that existed in JTB FlexReport Core.
  • Fixed a problem when in some cases denials are not recorded when there are multiple FlexNet debug logs specified.
  • Fixed a rare problem to get user and host names correctly when querying a FlexNet license server.
  • Updated JTB FlexReport Graphic Reports.xls with fix so it works with Excel 2003.
  • Add these indexes to the database to improve startup time for the chart client when SQL Server is used:
    These might be needed to be added manually depending on SQL Server access rights.
    CREATE INDEX dt ON dbo.log(DateTime)
    CREATE INDEX dt ON dbo.tblUserDetailedLog(CheckedOutDate)
    CREATE INDEX dt ON dbo.tblUserDetailedLogPrev(CheckedOutDate)
  • Added column ProjectID to temp database table UserDetailedLogTemp. Added table SamplingInterval to temp database.
  • Other minor bug fixes and improvements.
• 2013-08-20 - JTB FlexReport 7.4.3
  • Added support for Sentinel Protection Server logs. Available on the SLM tab in JTB FlexReport Config>Properties.
  • Issues with the reports using these combinations are fixed: Feature Group-Server–Host Group and Features-Server Group-Host Group.
  • Discrepancy report bug fixed where some of the data ended up in wrong column.
  • JTB FlexReport Detailed Reports added option to include or not include duplicates (for example with Process Monitor data when a user runs two or more sessions of a program at the same time you might want to not included duplicates). Also available as separate download.
  • Added a workaround for a rare bug in lmutil.exe that could cause incorrect usage. This is used when taking FlexNet usage snapshots.
  • Fixed a problem with Wildcard processing.
  • Fixed an error with SLM parsing: "Error in ProcessSentinel inner".
  • Fixed SLM parser to handle logs where the first rows in the log include LM_SERVER as user name, something that can happen if the log is started while there are users having licenses checked out. This could result in reports showing too much usage. If you have this problem you either need to filter out the SLM features in the tables tblUserDetailedLog and tblUserDetailedLogPrev and delete them or if you have MS Access as database, JTB FlexReport Database Administration.exe can be used, select the SLM features, specify a date range that is a bit larger than the existing data and then delete them. Alternatively start with a new database.
• 2013-06-26 - JTB FlexReport 7.4.2
  • Fixed an issue with the Get Feature Descriptions in JTB FlexReport Config where it just did not work to get the descriptions. The issue only happened if MS Access database was used.
  • Fixed a bug in the Access database table tblAppName that causes feature and description to be padded with up to 255 spaces causing among other things issues with some of the reports. Running JTB FlexReport as normal after upgrading to 7.4.2 on a problematic database will automatically fix the issue.
• 2013-06-10 - JTB FlexReport 7.4.1
  • Fixed a parsing bug in JTB FlexReport core that was very rare (when token based features are used and certain other factors existing) and resulting in no saved data in the "log" table.
  • Removed the need to also have .NET Framework 3.5 for JTB FlexReport core.
  • Fixed a bug where issued line did not show up in some charts.
  • Fixed a minor issue in Chart client when Windows text scaling is other than 100%.
  • Fixed a problem when editing auto reports in chart client when feature groups are being used.
• 2013-05-12 - JTB FlexReport 7.4
  • Added feature description download button to JTB FlexReport Config>Features. Descriptions are taken from this FlexNet features code page.
  • Edit functionality for auto report settings.
  • Add these combinations to detailed tab in Chart client for continuous report type:
    Feature Group - Server - Host Groups
    Feature - Server Groups - Host Groups
  • Add selection of weekdays to the title of the charts where you can select weekdays.
  • Update for all host IPs can now be done multiple times per day.
  • New option in SPLM client configurator to determine what user and host data to use.
  • In auto report if a chart has no data an image will not be created. But the problem is logged in an error log.
  • Added server to LUM license expiry report.
  • Improved the look of the legend on the histogram report when there are many licenses.
  • Fixed some potential duplicates in denial email notifications.
  • Fix so that database is created with case insensitivity.
  • Fixed problem with filtering of FlexNet features for HTML reports created using INI files.
  • Fixed LM-X test button bug.
  • Minor SPLM reader fixes.
  • Other minor bug fixes here and there.
• 2012-10-26 - JTB FlexReport 7.3
  • Wildcard processing is done in a separate process so it does not interrupt the regular snapshots. It is also only run every 5:th snapshot. After an upgrade installation make sure to configure once using JTB FlexReport Config>Properties>General>Launch Service Configurator.
  • When the JTB FlexReport Core service is started the snapshot is taken directly instead of waiting so that the HTML reports can be used to quickly confirm that things are working and so the features and servers are populated as soon as possible.
  • Fixed a bug in chart client when using feature groups as well as a bug with the hours charts.
• 2012-10-04 - JTB FlexReport 7.2
  • Solved problems with auto reports that did not work with some language settings.
  • Solved several bugs in the chart client. For example: Line outside chart when using week interval. Fixed a problem when switching tabs between for example continuous chart and to hours chart the borrowed usage disappears from the hours chart. Fixed some problems when the database is SQL Server in combination with certain report settings.
  • Solved a problem with MathLM parsing.
  • Added to JTB FlexReport Config>Features: Check All in Current Column and Uncheck All in Current Column to quickly check or uncheck all checkboxes in the current column.
  • Added a test button so FlexNet, LM-X, MathLM settings easily can be verified.
  • Added filtering using the ini files to create HTML reports on the fly (using VBS or BAT) with only selected features. FlexNet and LUM supported.
  • Added support to create HTML reports on the fly using vbs/ini files for LUM license usage.
• 2012-08-27 - JTB FlexReport 7.1
  • JTB FlexReport Core, JTB FlexReport Service and Client updated.
  • Support for MathLM licensing added.
  • Hour Chart report type now supports filtering on weekdays.
  • Improved startup time for the Chart Client.
  • UI updates in JTB FlexReport Config>Properties.
  • Optionally include reserved info in HTML reports. FlexNet only.
  • Fixed issues reading Licman and FlexNet debug logs.
  • Fixed performance issues in different areas.
  • Fixed a lot of bugs and glitches in different areas.
• 2012-04-16 - JTB FlexReport 7.0
  • Automatic reports added to chart client making it possible to create PNG charts on schedule.
  • Support for Vertex Systems licensing added.
  • Improved functionality and performance for Group Administrator.
  • Added resize splitter for the Ribbon to make it possible to view more items in the lists in Chart Client and Group Administrator.
  • Added support for T-Systems license manager product LICMAN 2.0.
  • Fixes several issues in the chart client.
  • MS Access table definition for tblDeniedUserLog updated to only allow unique rows.
  • ConvertAccessToSql.exe supporting the Microsoft.ACE.OLEDB.12.0 provider so it can work on 64-bit systems.
  • Fixed Detailed Report bugs.
  • Fixes issues with SPLM service and client.
  • Fixed Group Administrator issues.
  • Fix for LUM solving duplicate usage for users using different versions of one product at the same time as well as multiple users using multiple sessions with different start times of the same product and version.
  • Improved parsing of LUM I4LS.INI files that has errors in them.
  • Solved problem with denial notifications.
  • Fixed 12D issue with orphaned log files.
  • Fixed rare issue reading FlexNet debug logs.
  • Fixed a problem reading Sentinel log files.
  • Fixed issues with Licman new format.
  • Fixed occasional deletion of Licman log file.
  • Fixed HTML4-report problem to show correct name on multiple different servers per feature on a user row.
• 2011-10-03 - JTB FlexReport 6.3.2
  • Fixed some problems to create chart reports on the Detailed tab.
  • Fixed some issues introduced in 6.3 for the HTML reports happening in some situations resulting in duplicate servers showing.
  • Fixed issue with reading certain OPT files in Group Administrator.
  • Improved silent installation procedure for Process Monitor Client using jtbprocessmonitorClientConfigured.reg.
  • Fixed problem with ' character in project names in Process Monitor Service.
  • Improved reliability in timing of showing the Project selection dialog box for Process Monitor Client.
  • Fixed Excel chart report to retain custom paths to the database.
• 2011-08-22 - JTB FlexReport 6.3.1
  • Chart Service and Client updated. Fixed a problem with chart drilldown when using SQL Server database.
  • Fixed several issues with client chart reports created using the Detailed or Hour tab.
  • Fixed a crash in Detailed Report that can happen on 32bit systems.
  • For users with JTB FlexReport Core 6.3 installed JTB FlexReport Detailed Reports 6_3_1.zip can be downloaded separately.
• 2011-08-08 - JTB FlexReport 6.3
  • Support for Licman licensing system.
  • Server description used in HTML report. Actual server name as tooltip.
  • Feature code in HTML report seen as tooltip if description is used.
  • JTB FlexReport Graphic Reports.xls updated to support Microsoft Access Database Engine 2010 (64-bit).
  • Updated detailed reports with some project reports for Process Monitor usage.
  • Notification supported for LM-X.
  • Fixed a problem to log IP to SQL Server.
  • Fixed a bug with logging of Sentinel data.
  • Fixed some parsing issues where lmstat contain nodelocked license, locked to ethernet address.
  • Several bug fixes across all programs.
• 2011-06-12 - JTB FlexReport 6.2.2
  • Database configurations are persisted when reinstalling this version or upgrading to future versions from now and on.
  • Solved a problem where JTB FlexReport Config could hang indefinitely.
  • Solved a problem with JTB FlexReport Core on Windows Server 2003 where the wildcard functionality to create groups does not work.
  • Solved some problem connecting and saving data to SQL Server.
  • Fixed port finding in client configurator when chart client and service is on same machine.
  • JTBFlexReportAdvancedSettings_6_2_2_hotfix.zip includes updated .reg files. Only needed if you manually use the .reg files in the Advanced settings subfolder.
• 2011-06-07 - JTB FlexReport 6.2.1
  • JTB FlexReport Core has a problem in 6.2 with .NET Framework 4.0 required. Changed to 3.5 instead.
  • Chart client updated to fix date format on x axis for continuous charts with 1 or 2 days of data.
  • Option to migrate registry settings for JTB FlexReport Config>Properties when upgrading from versions earlier than 6.2.
  • JTBFlexReportMergeDBs.zip updated to handle table tblProjects.
  • JTBFlexReport.log and JTBFlexReportDebug.log are deleted when larger than 100MB.
• 2011-05-16 - JTB FlexReport 6.2
  • SLM/Sentinel and LM-X (from X-Formation) support added.
  • Process Monitor support of projects. Adds the new table tblProjects.
  • Sampling service checks the size of the temp MDB database.
  • Made the denied users and denied points different to make it easier to see when they have the same value.
  • Drilldown of denials added.
  • Added support for finding IPv4 and IPv6 for hosts making it possible to create group based on IP patterns.
  • Group administrator improved with wildcards support and IP support.
  • Made it possible to export from a histogram chart.
  • To migrate settings in JTB FlexReport Config>Properties from an earlier version the following registry key can be renamed from:
    HKEY_LOCAL_MACHINE\SOFTWARE \JTB World\JTB FlexReport
    to
    HKEY_LOCAL_MACHINE\SOFTWARE \JTB World\JTB FlexReport Core
    alternatively from
    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\JTB World\JTB FlexReport
    to
    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\JTB World\JTB FlexReport Core
  • SQL Server DB changes: Added MaxLic to tblHostGroups. Added IDENTITY(1,1) to HostGroupId in tblHostGroups. Added IDENTITY(1,1) to GroupId in tblGroups.
  • MS Access and SQL Server DB change: Added DisplayAsUser to tblAppName. Added ProjectID to tblUserDetailedLogPrev and tblUserDetailedLog.
  • MS Access and SQL Server DB change: added HostIPv4 and HostIPv6 to table tblHostDetails.
  • Core JTB FlexReport has now full functionality even with .Net Framework 2.0.
  • Users and hosts are added automatically to respective table.
  • SPLM client and service bugs fixed.
  • Unique users chart issue fixed.
  • Chart client Index out of range bug fixed.
  • Bug fixed where in some circumstances not all servers show up on HTML reports.
  • Access based Detailed report issues fixed.
  • Issues license line in some charts did not show correctly and is now fixed.
  • Bug fixes when SQL Server is set up to use any non-English date format.
  • Histogram chart issues fixed.
  • Borrowed usage not showing in continuous charts fixed.
  • Denials not showing in some cases fixed.
  • Duplicate of denials bug fixed.
  • Fixed a crash that would occur when printing the chart through PDFCreator or other virtual printers. Requires the chart version for .NET Framework 4.0.
  • Stacked line chart problem with multiple features fixed.
  • Last 7 days report having memory issues fixed.
  • Group administrator bugs fixed.
  • Chart Axis control UI problem fixed.
  • Removed scrolling of the Ribbon in Chart client to avoid problem with other controls.
  • Several other minor bug fixes and changes.
  • Many different bug fixes making this a recommended update.
• 2010-10-03 - JTB FlexReport 6.1.2
  • Bug fixes to solve problems with the Chart Client/Service connection.
  • Bug fixes to open JTB FlexReport Config>Features/Servers.
  • Chart Service is now needed for the Detailed Reports.
  • Updated installers are:
    JTBFlexReportSetup_6_1_2.zip, JTBFlexReportChartClient_6_1_1.zip, JTBFlexReportChartService_6_1_1.zip
• 2010-09-27 - JTB FlexReport 6.1.1
  • Core JTB FlexReport (JTBFlexReportSetup.zip) needs to be updated if 6.1 was installed as it fixes a problem that made main functionality not working.
• 2010-09-24 - JTB FlexReport 6.1
  • Group Administrator.exe is a new application included to administrate groups for features, servers, users and hosts.
  • Groups can support wildcards to determine for example what users to include in a specific group. Database structure additions.
  • Detailed Reports have improved performance up to 6 time quicker to load and process data.
  • HTML4 that is grouped on feature instead of server. Use reg file to activate it.
  • Added usage of HTMLSimple Activate 32-bit.reg based on a wish for a report with less details for the users.
  • Fixed problems with HTML sorting.
  • Allow descriptions with more than 28 characters in JTB FlexReport Config>Features.
  • Updated Database Service Configurator so it shows correct SQL Server settings after reopening.
  • Database administrator remember database location.
  • Removed the need to use BAT or CMD registry hacks.
  • A lot of bug fixes and minor improvements.
  • Strongly recommended upgrade if you have 6.0 due to bugs fixed.
• 2010-05-31 - JTB FlexReport 6.0
  • SQL Server/SQL Server Express support.
  • Better performance for chart reports.
  • New chart reports and other changes to the chart client.
  • Drilldown on chart reports.
  • Copy chart to clipboard.
  • Hour chart improvements and hour filters.
  • Process Monitor improvements.
  • Database structure changes.
  • Bug fixes
• 2009-10-05 - JTB FlexReport 5.1.2
  • SPLM (SmartPlant License Manager) support added. Installers available upon request. Individual version for SPLM is 1.0.1.
• 2009-10-01 - JTB FlexReport 5.1.1
  • JTBProcessServiceSetup.zip is updated to version 1.0.2 to fix some issues that made reports failing as well as a problem on 64-bit systems. Only this installer is updated. Uninstall previous version first.
• 2009-09-10 - JTB FlexReport 5.1.0
  • This adds only the 1.0 version of the new feature JTB Process Monitor making usage reports on most any application possible. Existing customers that wants this feature can request a quote for the upgrade.
  • Upgrade from 5.0 to 5.1 is only needed if you want the new functionality.
  • There is a HTML report for LUM license expiry that can be activated. Contact us for details. LUMExpiryHTML Activate 32-bit.reg or LUMExpiryHTML Activate 64-bit.reg is needed.
• 2009-06-01 - JTB FlexReport 5.0.0
  • New client/service solution for chart generation that will phase out Excel as tool for generating charts.
  • HTML reports have been improved on and the aggregated usage now shows utilization as well.
  • Added fixed number of decimals to most detailed reports where needed and right justified some columns.
  • The from and to date filters are taken into account for the denial reports.
  • User, Host and server reports for borrowed licenses added.
  • "HTMLBW Activate.reg" can be used to make the HTML2 report in black and white and "HTMLBW Deactivate.reg" can be used to restore to the default colors being used.
  • "HTMLAggregateAtTop Activate.reg" can be used to put the aggregated usage of the features at the top and "HTMLAggregateAtTop Deactivate.reg" can be used to put it back at the bottom as it is by default.
  • Tools to merge databases are included.
  • "BATusage Activate.reg" can be used if for some reason CMD files are not allowed to be executed. "BATusage Deactivate.reg" restores to default setting using CMD files.
  • Fixed a problem that can arise when reading the FlexNet debug log to record denials.
  • Updated demoHTML to fix issues with creation of HTML files via VBScript.
  • Updated JTB FlexReport Detailed Reports to solve some problems when importing groups from OPT files. Now users and hosts enclosed within quotes are supported.
• 2009-01-29 - JTB FlexReport 4.4.0
  • Added sort after Feature or Feature Description if available in the HTML2 aggregated usage report.
  • Workaround added to solve problem with duplicates of licenses in the reports due to multiple vendor daemons sharing the same port.
  • JTB FlexReport Detailed Reports.mdb updated to include a text label showing when the last reload of data was.
  • Minor database addition to tblUserDetailedLogPrev that has a new field named LicenseSystem that can be FlexNet, LUM or something else. This is for internal purpose mainly.
  • Fixed some IBM LUM cluster related bugs.
  • Added support for a very detailed log table “tblUserCompleteDetailedLog” that of course also makes the database grow quickly the more users you have using features. For each snapshot all detailed user information is saved.
    A registry file is needed to activate this feature and is available upon request.
  • Other minor bug fixes.
• 2008-11-02 - JTB FlexReport 4.3.3
  • If you have installed 4.3.* you should install this version because of bug fixes it includes.
  • Corrects problem with borrowed licenses not always being saved to the databases as being borrowed.
  • JTB FlexReport Detailed Reports version is 3.6.1 and corrects a minor issue with user and host groups not showing all users in "Users not in User and Groups table" and not all hosts in "Hosts not in Host and Host Groups table".
• 2008-10-25 - JTB FlexReport 4.3.2
  • Fixed some bugs that some users found in previous 4.3.* versions where the detailed data was not completely saved to the database in some cases.
  • A limited version that still works on .NET Framework 2.0 is available.
  • Improved the detailed reports "Groups>Min Max Avg per day" and "Groups>Min Max Avg per Interval" report with an option to remove doubles. If you know that you have features that can be checked out multiple times concurrently you should select No. Otherwise Yes will give the best result.
  • Added support for LUM Clusters.
  • Added support to select if LUM features should include the version or not.
  • JTB FlexReport Detailed Reports version is 3.6.0.
  • tblUserDetailedLogPrev is a new table in JTBFlexReport.NET.mdb that acts like a cache to speed up the performance to save to the database and keep it from bloating in size. The table is automatically added to any existing database as soon as JTB FlexReport Config.exe is run or the service is started. tblUserDetailedLogPrev needs to be unioned with tblUserDetailedLog for customers that have made their own custom reports. For an example UnionUserDetailedLog is doing this in JTB FlexReport Detailed Reports 3.6.0.mdb
• 2008-10-07 - JTB FlexReport 4.3.1
  • .NET Framework 3.5 or later required.
  • Fixed some minor problems with 4.3.0.
  • Just starting JTB FlexReport Config now upgrades your existing database correctly by adding the required fields.
• 2008-10-06 - JTB FlexReport 4.3.0
  • .NET Framework 3.5 or later required.
  • Optional notification if database grows above specified size.
  • New optimization is done in how to save data to the database making each snapshot goes much quicker than before and not be affected if the database is large. This should make the NoTest setting superfluous.
  • Optional email notifications for denials or if a specified number of licenses is exceeded.
  • Optional email notifications if specified server(s) can be pinged.
  • Pinged host reports - This report is useful to find out if users that have borrowed licenses still are online in the network. They can then if there is lack of licenses available be asked to return their borrowed license earlier.
  • Run the service application with low priority as option
  • Some database additions. The database is automatically updated.
  • Correct redundant server name bug.
  • Minor fix to the HTML report to avoid script warning in Internet Explorer when running locally.
  • A special fix on customer request to solve a problem with rational and ibmratl vendor daemons. This is an unusual case and is activated by a registry key change upon request if you find the reports showing usage that is twice as high as it should be or users listed two times in the HTML reports.
  • Some other minor bug fixes.
  • JTB FlexReport Detailed Reports.mdb version is 3.5.0
• 2008-08-27 - JTB FlexReport Detailed Reports.mdb version is 3.4.16
  • Fixes date sort problems.
• 2008-06-25 - JTB FlexReport 4.2.0
  • Support for IBM LUM license usage reporting.
  • Fixes date problems with some locale formats that have the month and day on different locations. Like 23/5/2008 and 5/23/2008.
  • The HTML2 report uses cookies to remember the states of show/hide as well as show available number of licenses in the summary.
  • Update to improve reporting on Matlab license usage.
  • Updates to the graphic reports so they work better with Excel 2007.
  • Some other miscellaneous updates and bug fixes.
• 2008-04-27 - JTB FlexReport 4.1.2
  • If you have a 4.1.* version installed you should upgrade as soon as possible as there are several regression problems fixed.
  • Some usage in some cases in previous 4.1.* versions were not logged and is now fixed.
  • If a snapshot takes longer time than the specified interval you will be notified by email if you have set up the notification settings.
  • The debug and error log can be saved to a custom folder.
  • User and Computer groups functionality was broken in previous version and is fixed.
  • The installation add file versions to the name of JTB FlexReport Detailed Reports.mdb and JTB FlexReport Graphic Reports.xls so you can be sure to get the new version.
  • There are three reports for denied usage added to JTB FlexReport Detailed Reports.mdb.
  • JTB FlexReport Config>Properties>Advanced has a new setting: NoTest that can affect performance and database size.
  • Denied notifications works better.
  • JTB FlexReport Graphic Reports.xls now works with Excel 2000 again.
• 2008-03-19 - JTB FlexReport 4.1.1
  • A fix of a problem with reading the license file. If you have this problem in a previous version you will not be able to use the program so you know if you are affected.
  • JTB FlexReport Detailed Reports.mdb version is 3.4.14 fixes an issue with users having names including the quote ' character. Users with this problem with this problem will have most reports not working at all.
    Make sure to rename or delete JTB FlexReport Detailed Reports.mdb before installing or download it separately.
  • If you have 4.1 and don't see the above issues there is no need to upgrade.
• 2008-03-09 - JTB FlexReport 4.1.0
  • Performance improvements with up to 3 times less strain on the server and each snapshot is quicker than before.
  • Uncounted, node-locked license usage is saved to the log table so graphs can be generated on them.
  • Nodelocked licenses locked to different IDs or increment lines can now be reported separately. Matlab has this for example.
  • Windows Server 2003 R2 Enterprise x64 Edition and Windows Server 2008 are supported.
  • Developed with Visual Studio 2008.
  • JTB FlexReport Detailed Reports.mdb version is 3.4.13 now includes Concurrent usage reports with user name groups Max Min Avg per day or per specified interval between 1 minute and 60 minutes.
  • JTB FlexReport Graphic Reports.xls version is 2.6.1 and works better with Excel 2007.
  • Some bug fixes like groups in the Access report were still for some not saved correctly between sessions.
  • It probably is needed to uninstall the old version before installing this one. To be sure the latest version of the reports are installed rename or delete JTB FlexReport Detailed Reports.mdb and JTB FlexReport Graphic Reports.xls.
• 2007-11-26 - JTB FlexReport 4.0.0
  • Support for applications like 12d Model from 12D Solutions from Australia.
  • FlexNet license denial notifications. See the tab FlexNet debug log in JTB FlexReport Config>Properties.
  • User names with the ' character are now supported.
  • Existing customers needs a new license file. The license file should be located in the installation folder.
  • Groups defined in the detailed report are now correctly saved to the JTBFlexReport.NET.mdb again. For help to migrate the groups contact us.
  • JTB FlexReport Detailed Reports.mdb version is 3.4.10. Download here if you are upgrading your installation or you can rename JTB FlexReport Detailed Reports.mdb before installing.
  • JTB FlexReport Graphic Reports.xls version is 2.6.0
  • Automatic finding of FlexNet license servers with the Find button on the FlexNet tab in JTB FlexReport Config>Properties.
  • Several other bug fixes.
• 2007-10-11 - JTB FlexReport 3.4.3
  • The installation package is not updated.
  • JTB FlexReport Detailed Reports.mdb (file ver. 3.4.9) updated with reports that includes User, Host and Server. Host Group Report per year added. Max Min Avg Concurrent Usage reports should work in older versions of Access now.
  • Version that does not require Access is available. It uses Access Runtime 2007.
• 2007-07-18 - JTB FlexReport 3.4.2
  • JTB FlexReport Config.exe updated to support other ways to configure SMTP.
  • JTBFlexReport.exe updated to solve a bug that was introduced in 3.4.0 that can make borrowed licenses not to be logged for the detailed reports.
  • Spaces in display names are better handled in some specific cases.
    A less normal display name could look like this: Z>IIZ]G k0,p-s
• 2007-07-07 - JTB FlexReport 3.4.1
  • JTB FlexReport Config.exe updated to solve a regression problem when run on Windows Server 2003 as well as a minor bug if you change the database and then try to edit the application list without closing the program in between.
• 2007-07-03 - JTB FlexReport 3.4.0
  • Logging to tblUserDetailedLog is now optimized further so the size increase of the database is minimized.
  • A new column is added to tblUserDetailedLog to take into account for multiple license checkouts that are common for features that are using tokens.
  • JTB FlexReport Config>Properties>Notifications. Select an minimum interval how often you will be notified per email. If the server is not reachable using PING an urgent email can also be sent with a separate interval.
  • JTB FlexReport Config>Applications is used to set the thresholds for email notifications.
  • Two new columns in tblAppName. EmailNotificationPercentageLevel. Use this column to set a threshold in percentage. For example if you want to be notified when more than 90% of the licenses are used. EmailNotificationLicensesLeft. Use this column to set a threshold in licenses left available. For example if you want to be notified when 2 or less licenses are available.
  • JTB FlexReport Detailed Reports.mdb updated to work with token based licenses as well as some new reports.
  • Report for Concurrent Usage Per Day or Month with Max usage, Min usage, Avg usage and Standard deviation.
    
• 2007-06-08 - JTB FlexReport 3.3.3
  • Fixed some small regression bugs in 3.3.0 and 3.3.1.
• 2007-06-07 - JTB FlexReport 3.3.1
  • JTB FlexReport Database Administration updated to solve a bug.
• 2007-06-07 - JTB FlexReport 3.3.0
  • JTB FlexReport Detailed Reports.mdb updated. Some bugs fixed. Settings, filters are retained between sessions as well as after future upgrades. Performance increase. Time is showed as both decimal as well as hours and minutes. Compare 5.50 with 5:30 for example. You can see between what dates you have data available. Crashes in some cases in older versions of Access have been fixed.
  • JTB FlexReport Graphic Reports.xls updated. A fuzz factor is added to not show gaps if there are temporary dips in the line for the number of licenses. You can see between what dates you have data available.
    
  • JTB FlexReport Database Administration is a new application that let you compact, move and delete data from the main database.
  • If you have created your own reports based on the tables Log or tblUserDetailedLog in JTBFlexReport.NET.mdb notice that the Compact in JTB FlexReport Database Administration will delete the obsolete table tblUserLog.
  • A bug is fixed that in some rare cases made the logging of detailed data to stop working.
• 2007-05-16 - JTB FlexReport 3.2.10
  • JTB FlexReport Detailed Reports.mdb includes a new report for Max Min Avg Concurrent Usage Per Day. It even respects the filters a "second time". That means when you reload the data the filters are used and if you then want to filter further on that data you can do so (only showing less information though), just reopen the report or press Shift+F9.
• 2007-05-11 - JTB FlexReport 3.2.9
  • Some minor documentation updates.
  • JTB FlexReport Detailed Reports.mdb is updated so that the information for the groups and host groups are saved in JTBFlexReport.NET.mdb. This way there is no need to transfer that data when JTB FlexReport Detailed Reports.mdb is updated.
• 2007-05-09 - JTB FlexReport 3.2.8
  • JTB FlexReport Graphic Reports.xls can automatically have the data refreshed when opened using the Auto refresh option set to -1.
  • JTB FlexReport Detailed Reports.mdb has fixed an issue with the end date not being included on the reports.
  • JTB FlexReport Detailed Reports.mdb reports includes a column for user and host groups.
• 2007-04-26 - JTB FlexReport 3.2.7
  • Some minor bug fixes for problems that some customers found in 3.2.6.
• 2007-04-22 - JTB FlexReport 3.2.6
  • JTB FlexReport Detailed Reports.mdb updated to support international date formats.
  • JTB FlexReport Detailed Reports.mdb includes reports per server for borrowed licenses.
  • A new type of HTML report is available. See Sample 2.
  • More and better support for Windows Vista and the UAC.
• 2007-02-06 - JTB FlexReport 3.2.5
  • OPT files import is supporting extended rows as well as both GROUPS and HOST_GROUPS.
  • JTB FlexReport Detailed Reports.mdb with reports for usage grouped on Host Groups.
• 2007-01-18 - JTB FlexReport 3.2.4
  • Minor bug fixed that can affect some customers due to the syntax of the lmutil status file.
• 2006-12-24 - JTB FlexReport 3.2.3
  • JTBFlexReportDetailed3.mdb renamed to JTB FlexReport Detailed Reports.mdb and updated with some new reports as well as easy access to compact the main database.
  • support for timeout and retry of snapshots to solve if the license server temporary cannot be reached
  • JTB FlexReport Config>Properties updated
  • JTBFlexReport.NET.xls renamed to JTB FlexReport Graphic Reports.xls
• 2006-12-20 - JTB FlexReport 3.2.0
  • JTBFlexReportDetailed3.mdb updated. Filter on weekday, time and date interval added.
  • JTBFlexReport.NET.xls updated to handle other intervals than 10 minutes. This must match the settings in JTB FlexReport Config.
• 2006-10-12 - JTB FlexReport 3.1.8
  • Minor fix
• 2006-10-01 - JTB FlexReport 3.1.5
  • There is not a 64 bit version of 'Microsoft.Jet.OLEDB.4.0'. Forced the application to use 32 bit and target cpu to x86. Fixes the error message: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
• 2006-09-30 - JTB FlexReport 3.1.4
  • Support for more types of FLEXlm/FlexNet type of status logs.
  • Bug fixes.
  • Recommended upgrade for all users.
• 2006-08-17 - JTB FlexReport 3.0.5
  • Stabilized some processes that in rare cases could halt the program if the debug log is activated.
  • Added 90-days detailed reports.
  • JTBFlexReportDetailed3.mdb updated.
• 2006-08-08 - JTB FlexReport 3.0
  • Now based on .Net Framework 2.0.
  • Minor additions and updates.
• 2006-05-25 - JTB FlexReport 2.3
  • Support for groups defined in the FlexNet/FLEXlm options files (OPT).
  • JTBFlexReportDetailed3.mdb has several detailed reports.
  • Reserved license groups or hosts are reported correctly. Users using reservations should upgrade.
• 2006-03-27 - JTB FlexReport 2.2
  • More granular and better detailed reports
• 2005-05-14 - JTB FlexReport 2.1
  • The time on the file name on the HTML backup files is more correct now. It was off 10 minutes before.
  • Some special cases of the FlexNet/FLEXlm status file syntax that generated an error are fixed upon users notification.
  • Spaces in the user name are now handled correctly.
  • There is a undocumented registry fix so the temporary files can be saved in another folder than %temp%. Contact us if needed.
  • There is a separate Access database (JTBFlexReportDetailed.NET.mdb) that helps you with detailed reports on user usage.
  • Some issues with grouping of users in the graphic report have been addressed.
• 2005-04-11 - JTB FlexReport 2.0
  • Built using .Net Framework 1.1.
  • Advanced grouping of features, users or servers.
  • Separate usage per server.
  • Detailed user usage logging.
  • Borrow usage is logged.
  • Ability to run as a service.
• 2004-08-01 - JTB FlexReport 1.4
  • Minor improvements and bugfixes related to different date formats.
  • Some improvements on the Excel reports to make it easier to navigate between the sheets.
• 2004-07-17 - JTB FlexReport 1.3
  • The logs are saved in an Access Database instead of CSV to improve the reporting functionality.
  • Improved reports with better flexibility.
• 2003-12-28 - JTB FlexReport 1.2
  • Launched at the internet.
• 2003-11-10 - JTB FlexReport 1.1
  • Report tool added
• 2003-08-20 - JTB FlexReport 1
  • CSV reporting added
• 2002-03-10 - JTB FlexReport Beta
  • HTML reporting

License agreement

The license agreement is found here.

Customers

“With JTB monitoring and distributed licensing, we were actually able to cut 80 licenses off subscription on our last Autodesk renewal. It’s been a great success for us – thank you!” - Dan Glassman, AEI | AFFILIATED ENGINEERS, INC.

"I am very happy with LUM support. It is very good tool. I would recommend to anyone to use this tool." - Jorma at Metso

“JTB FlexReport is dynamite. Expect tech support very quickly. Fantastic graphing and reporting tool for license usage. I liked it so much I personally paid the annual fee so I can keep using it here. And no, I am not a paid spokesman, it’s just that good……….” – Phil Endrizzi, CADD Coordinator

"JTB FlexReport is a must have utility for anyone with more than a handful of licenses if they truly want to understand where they stand with their software license inventory and usage. In addition to license inventory and usage, JTB Flex Report allows us to troubleshoot issues with our license server that would otherwise have likely went unnoticed."

"Your product has been invaluable to me and to the business."

"Since I have been using your JTB FlexReport software it has made my job easier for report generation of license utilization for our various applications. All in all it is a fantastic software product and it is reasonable priced." - David J. Maslowski, Hach

Some JTB FlexReport customers:

Several hundreds more customers are found here.

Tags: network license usage tracking, usage tracker, license tracker, license tracking, Software License Optimization, AutoCAD network license usage, AutoCAD license usage report, Managing Autodesk network licenses, network license-usage report for Autodesk software that uses FLEXlm licensing technology, Autodesk audit, License Compliance, how to ensure future compliance, The Business Software Alliance (the BSA). AdLM monitoring. AdLM or NLM is often used as short for Autodesk Network License Manager.

Autodesk License Types: Named user, Stand-alone, multi-seat version, Network. License Behaviors: Perpetual (non-time-limited), Term Extendable (limited time) and Term Non-Extendable. Autodesk Subscription.

About

JTB SmartBatch (aka SmartPurger) is a batch and script utility for processing multiple DWG drawings with full control with AutoCAD, BricsCAD, ZWCAD or GstarCAD.

JTB SmartBatch closes dialog boxes that might otherwise stop batch processing like for example dialog box showing missing fonts. Execute LSP or SCR files on multiple drawings. JTB SmartBatch handles crashes so the AutoCAD batch processing continues to the end and leaves bad drawings to be corrected manually. Many purge and cleanup settings available. Useful before backups and distribution of drawings. The file's modified time stamp can be restored.

The free trial without license file is fully functional except that you can only batch process 10 drawings per session to give you the chance to confirm that the program works as expected. When you purchase you can use JTB SmartBatch with no limitations.

Batch process drawing files with JTB SmartBatch to avoid bloating or corrupt files by running AUDIT and PURGE on them or any other custom command you want.

JTB SmartBatch batch processing for AutoCAD is useful if you want to minimize the size of files before a backup or before sending drawings by e-mail, burning to CD or just to use as a quick viewer of drawings. You have options to save the files to a separate folder or to a different drawing version.

JTB SmartBatch can execute custom script files (.SCR) or AutoLISP files (.LSP, .FAS or .VLX). We can help you create them based on your special needs.

JTB SmartBatch can make use of AutoCAD Core Console that was introduced in AutoCAD 2013 making the scripting process faster then ever as the Core Console takes less than a second to open per drawing. In a test using the Core Console took 11 minutes compared to normal AutoCAD 2013 that took 58 minutes to process 145 drawings.

You can set up JTB SmartBatch to run different AutoCAD applications for different drawing file versions. Optionally specify the profile to be used when starting AutoCAD.

From a real project: 1773 drawings and a total size of 526MB in 2000 DWG format become 218MB in 2004 DWG format. Conversion and purging was made totally unattended. JTB SmartBatch can without problem process 10,000 drawings and more.

You can run audit, zoom extents, create preview icons. Convert between versions. Purge Blocks, Detail view styles, Dimension styles, Layers, Linetypes, Materials, Mline styles, Multileader styles, Plot styles, Regapps, Section view styles, Shapes, Text styles, Table styles, Visual styles, Page Setups, Filter states, Layer states, Layer manager states (Express Tools), Line objects without length, Text objects without text, embedded VBA code, registered applications collections, Anonymous Groups, Groups, Orphaned Data. It's possible to restore the date and time of the file to what it was before the scripting. Delete .BAK and other temporary or garbage files. And much more.

ZWCAD usage.

Remember that this is a very powerful tool and make sure you understand and know what you do when you use it. Read the documentation before you run it. Try on some test files/folders as a start. To be on the safe side make sure you have backups before you run.

Do you have a large list of text strings that you need to find and replace on many drawings? Contact us for a special command that can be used with JTB SmartBatch. 

If AutoCAD's -PURGE command crashes AutoCAD because it runs out of memory (FATAL ERROR: Out of memory - shutting down) when purging Regapps make sure to use the purge option "Purge all registered applications collection" instead. It can take really long time (from some minutes to some hours) so set the timeout to max value (100000) and leave it running during the night. Sometimes it can help to unload the xrefs on all drawings you want to purge from Regapps otherwise they just keeps coming back (this is not needed when using accoreconsole.exe or for AutoCAD 2018 and newer if XREFREGAPPCTL is set to 0, run on both host and xrefs). Create a small lsp file with this code and run it first on all drawings.

(command "._-xref" "_u" "*")
After that you can run the files, purging the Regapps. Remember that all nested xrefs has to be run.

Then run a lsp file that loads the xrefs again using code like this:
(command "._-xref" "_r" "*")

Since release 2.6 you can use the option "Purge Regapps using ASDKCleanRegAppARX.arx (2004-2008)". Thanks to James Maeding that provided it and the ADN team that created it. This is much better than the other options "Purge all Regapps" and "Purge all registered applications collection". Layer filters too are purged with this option.

Download

Latest release is version 5.2.4. Installer for both AutoCAD and BricsCAD. 

• Download JTB SmartBatch installer

Limitation in trial mode is that only 10 drawings can be processed per JTB SmartBatch session.

JTB SmartBatch trial can also be downloaded and installed as an app from the Autodesk App Store site. Purchase is also available through this site.

If purchase has been done via Autodesk App Store the download is available on the My Downloads page. Sign in with the same account used when purchasing.

Newsletter

Subscribe to our JTB SmartBatch newsletter or any of our other Newsletters.

System requirements

Example of products that JTB SmartBatch can run on: AutoCAD 97 LT and newer (LT only supports a limited number of functions), AutoCAD r14 up to AutoCAD 2008, AutoCAD 2009, AutoCAD 2010, AutoCAD 2011, AutoCAD 2012, AutoCAD 2013, AutoCAD 2014, AutoCAD 2015, AutoCAD 2016, AutoCAD 2017, AutoCAD 2018, AutoCAD 2019, AutoCAD 2020, AutoCAD 2021. All flavors or toolsets should be working like AutoCAD Architecture, Autodesk Advance Steel, Autodesk AutoCAD Civil 3D, Autodesk AutoCAD Electrical, Autodesk AutoCAD Mechanical, Autodesk AutoCAD MEP, Autodesk AutoCAD P&ID, Autodesk AutoCAD Plant 3D, ACA, ADT, ABE, ABM, ABS, AMEP, LDD and MDT. 32-bit and 64-bit supported.

An AutoCAD based application is required to run JTB SmartBatch, but other DWG compatible applications like BricsCAD, GstarCAD, ZWCAD and AutoCAD OEM also work.

Windows 10 have been tested and are supported. 32-bit and 64-bit supported. Windows Vista, Windows 7, Windows 8, Windows 8.1 are not supported but should work.

Purchase

Join many other satisfied customers around the world since its first release in 2001. JTB SmartBatch has been sold to customers from Alaska USA to New York USA, to Brazil in South America, to Netherlands in Europe, and all the way down to Australia and many other places. Customers ranges from individuals to very large companies.

New license: 95 USD for one license of JTB SmartBatch or less depending on the quantity of licenses.

Upgrade license: 45 USD for one license of JTB SmartBatch or less depending on the quantity of licenses. If you purchased on or after January 1, 2018 the upgrade is free of charge.

If you have really many users that you want to give access to this software we can discuss a discounted price based on your particular situation. Educational discounts available.

The license is perpetual. Support and upgrades is included for a minimum of 2 years after purchase. If you have more than one computer and you are the only user of the application one license is enough.

See activation instructions here: JTB World Apps Licensing. 

JTB SmartBatch can also be downloaded, installed and purchased as an app from the Autodesk App Store site. Use this link to purchase.

Documentation

FILEDIA
0
_SAVEAS
DXF
_V
2013


FILEDIA
1
QUIT
;

Version History

2020-11-22 - SmartPurger 5.2.4
-Minor adjustments. 

2020-10-05 - SmartPurger 5.2.3
-Unified installer to install also as AutoCAD app if AutoCAD is installed.

2020-05-29 - SmartPurger 5.2.2
-Upgraded to JTB License 4.3.0.1.

2020-05-29 - SmartPurger 5.2.1
-Fixed shortcut to JTB World Apps. 

2020-05-23 - SmartPurger 5.2
-Added AutoCAD 2021 support. 

2019-03-28 - SmartPurger 5.1
-Added AutoCAD 2020 support. 

2019-02-04 - JTB SmartBatch 5.0

• New licensing system with support for network licenses
• Refreshed UI
• Fixed problem to browse for folder on Settings>SaveAs
• Fixed problem to Check for Update
• Improved functionality to close dialog boxes
• .NET Framework 4.6.1 or later needed
• SmartPurger renamed to JTB SmartBatch to better reflect that it is more of a Batch app than a Purge app

2018-03-22 - SmartPurger 4.0 (update)
-Added AutoCAD 2019 support. No change in version number.

2017-03-22 - SmartPurger 4.0
-Added support for AutoCAD® 2018
-Fixed error that caused SmartPurger to not complete deletion of files in certain cases
-"Delete only files older than specified number days" setting did before not delete files as expected. This is not fixed.
-Fixed error that caused SmartPurger to stop when path or files names were very long.
-Fixed error that caused SmartPurger to stop when it reached certain folders that could not be accessed by the current user.
-Fixed a problem related to deletion of files as specified on the Settings>Delete tab where the deletion did not complete search of all folders.

2016-08-29 - SmartPurger 3.8
-With this version it’s possible to only delete certain “garbage” files without having to also run AutoCAD to purge and process custom scripts. See “Only delete files, don’t process any DWG files” checkbox on Delete tab in Settings.
-Quick access to deleted files log file through new button on Delete tab.
-Minor bug fixes related to usage with AutoCAD 2017

2016-05-25 - SmartPurger 3.7
-Support for Autodesk AutoCAD 2017 added
-If SmartPurger runs in the background it does not take unnecessary focus from whatever other app you're working with.

2015-04-13 - SmartPurger 3.6 update
-Support for Autodesk AutoCAD 2016 added

2014-06-20 - SmartPurger 3.6
-Support for Autodesk AutoCAD 2015 and the new Orphaned Data purge
-Support for sharepoint folder locations

2014-01-08 - SmartPurger 3.5
-Fixed a bug where accoreconsole did not save to specified DWG version
-Purge multileader styles bug fixed where it did not always purge these styles.
-Handle dialog box about VBA not installed
-Fixed bug where Educational Version - Terminated sometimes show up in status column even though the drawing is not educational

2012-04-30 - SmartPurger 3.4
-Added support for AutoCAD console mode.
-Support for AutoCAD 2013 and the 2013 DWG file format.
-Thumbnail color can be changed.
-Support for purging of Detail view styles and Section view styles.
-Support for custom Windows DPI settings.
-Free trial allow to script up to 10 drawings.
-AutoCAD apps support.
-And some other minor bug fixes.

2011-08-23 - SmartPurger 3.3
-Support for other applications like Bricscad or AutoCAD OEM
-Version check added to see if a newer version of SmartPurger is available.
-Support for dialog box to be closed: Open - Foreign DWG File
-Support for dialog box to be closed: Annotation Scale - Large Number of Scales
-xstrcase usage within SmartPurger to handle usage of diacritics and accentuated characters in filenames
-Profile list is not always working
-OCX registration problem fixed
-Correctly showing the total time when it is more than 24 hours

2011-06-12 - SmartPurger 3.2.2
- Fixed timer issue when selecting folders only.
- Fixed a problem that the lisp file selected to be run was not run.
- Can close password dialog box.
- Other minor fixes.

2011-05-01 - SmartPurger 3.2.1
- Fixed a problem showing file properties on 64-bit systems.
- Added portable download making it possible to run without installing.

2010-08-06 - SmartPurger 3.2
- Bug fixes related to timer and adding folders as well as some minor bugs.

2009-12-07 - SmartPurger 3.0.4
- Bug fixes for adding files.
- Bug fixes to enable saving to DWG 2004 format.

2009-11-16 - SmartPurger 3.0
- New UI and full 64-bit support.
- Current customers need to contact us for an updated license file.

2009-02-02 - SmartPurger 2.8.0 Support for AutoCAD 2010 and Windows 7 as well as better support for Windows Vista

2007-09-17 - SmartPurger 2.7.0 Added support to close more popups.

2007-07-29 - SmartPurger 2.6.0 Thanks to James Maeding for ASDKCleanRegAppARX.arx can be used to more effectively purge registered applications.

2007-06-19 - SmartPurger 2.5.0 Fixed some problems that made SmartPurger not work for AutoCAD LT 2007 and AutoCAD LT 2008.

2007-04-09 - SmartPurger 2.4.1 Support for plotting even with popups being closed. The plot progress dialog box is not closed.

2007-03-28 - SmartPurger 2.4
-Support for AutoCAD 2008 based products. Plotstyles and textSTyles are also purged when using Purge All option.
-Support for Windows Vista

2006-03-21 - SmartPurger 2.3
-Support for AutoCAD 2007 based products.

2005-08- - SmartPurger 2.1
-Support for AutoCAD 2006 based products.
-Clean up DWL files if the AutoCAD processed is killed due to timeout.
-More pop ups that might halt execution are closed automatically now.
-Minor issues fixed.

2004-04- - SmartPurger 2.0
-Support for AutoCAD 2005 based products added.
-Added: For AutoCAD 2005 based products you can purge Regapps and Table styles.
-Added: Purge all named object dictionaries (Be very cautious to use this feature since DWG logic can be lost)
-Script or lisp files can be executed.
-Abitiliy to control INDEXCTL
-Abitiliy to control ISAVEPERCENT
-Abitiliy to control PROXYGRAPHICS
-Abitiliy to control RASTERPREVIEW
-QAFLAGS restored to 0
-"AutoCAD Error Report" dialogs are closed it they appears.
-Status that shows the progress when adding and deleting files.
-SmartPurgerDeletedFiles.log is created in the temp folder during deletion of files. It's a semicolon separated text file including the path and filename, the base name, the file extension and the file size in kb. The file can for example be opened in Excel.
-Import List from Log File. This can be used if you have Exported a list previously and want to use it several times. One reason could be that you had to halt a previous large batch that you later want to continue on.
-A bug has been fixed that in some situations stopped when more then 15384 files where run.
-Now when you stop a batch and AutoCAD is running you can chose to terminate it.
-Minor issues fixed.

2003-03-03 - SmartPurger 1.6.7
-Intermediate fixes to for AutoCAD 2004 based products.

2003-01-28 - SmartPurger 1.6.4
-DXF files can now be batched. Some non standard formatted DXF's are not version identified but might be run anyway. The version is set to "DXF?". Until anyone wants it (just send an e-mail to info@jtbworld.com) the DXF are saved to the closest matched DWG version. Filter to include DXF files added to the Options> Settings.
-Files that have a status have to have the status resetted to be run a second time.
-Simplified installation that can be silently installed as well with the command line option /SILENT
-The installation package is minimized not including Visual Basic 6.0 SP5 Run-Time Files and HTML Help Package since most users already have it. It can be downloaded and installed separately.

2003-01-24 - SmartPurger 1.6.3
-The price has been lowered.
-Unlocked versions can be ordered based on an agreement.
-The status column shows more different statuses.
-The information during a batch is showing the drawing that is processed.
-Accumulated and total time for the batch is showed.
-The licensing is changed to make it easier for the customer.
-An option to audit the drawings have been added.
-Added: Delete all Page Setups
-Added: Delete all Filter states
-Added: Delete all Layer states
-Added: Delete all Layer manager states (Express Tools)
-Added: Delete all Line objects without length
-Added: Delete all Text objects without text
-Added: Delete all embedded VBA code
-Added: Purge all registered applications collection
-Added: Purge all Anonymous Groups
-Added: Purge all Groups
-The drawing list steps forward as the program progresses, so you can always see what drawing it is working on.
-A log file can be exported from the list of drawings with status, size, etc. Right click in the file list area...
-More validation done for Windows XP
-Minor issues fixed.

2001-12-21 - SmartPurger 1.5
-Some random read only errors that halted SmartPurger fixed.
-UNC file format supported fully.
-Improved performance.
-Improved resize function to avoid screen flickering.
-Added deletion possible of DWL, DWK lock files and PLOT.LOG files.
-Bug fixed when empty drawing files where created in some cases.
-Explorer shell context menu. Shortcut can be added for quick start from Explorer. Select the drawing files in Explorer, right click and select SmartPurger.
-Prevent multiple sessions.
-Command line argument for /nologo and one file is added.
-Added right click functionality for the drawing list view.
-Status can be set to skip selected drawings.
-File properties on right click
-It's possible to start AutoCAD from SmartPurger with right click

2001-11-21 - SmartPurger 1.4
-Shape and Font and Proxy dialog boxes are closed automatically. One reason is since FONTALT doesn't work as a solution when it comes to big fonts. Macro warning dialog boxes are also escaped from.
-Option added to be able to toggle between having SmartPurger on top or not.
-Columns added with the size and date of the file before and after.
-Information after a run of how many files where run, the total size of the files before and after.
-More information is given during the run to inform of the progress.
-Column header sizes and positions are saved to enable personal look. Can be reset with the Reset function.
-Control that it's possible to zoom. Could be in perspective view.
-It's possible to save to another location. Useful if you want to send drawings and don't want to touch the originals.

2001-11-01 - SmartPurger 1.3

2001-10-11 - SmartPurger 1.2

2001-09-17 - SmartPurger 1.1

2001-08-05 - SmartPurger 1.0

License agreement

The license agreement is found here.

Customers

"You provided an excellent product in “SmartPurger”. This application suits us perfectly. A powerful and multi-faceted application equals value for lower cost." - Clint Hill

Some JTB SmartBatch customers

ARUP

Seamon, Whiteside & Associates. (SWA)

McKim & Creed

Peter Basso Associates, Inc.

AECOM USA

BSA Limited

Innophos

Ing.byrån Intermanage Esslé AB

Centara Ltd

NIRAS

Burns Engineering

CompuIntegration, LLC

TORRI SPA

Studio Sofield

LiftPlanner Software LLC

Bloomberg LP

Domtar

ArchSmarter

Thomas Juul-Hansen, LLC

Bulk Handling Systems

White-Daters

CS&P Architects Inc.

Carriere Industrial Supply Ltd.

Formby Surveys Ltd

Alliant Engineering Inc

Pinnacle Engineering Group

Burton Studio

CANDELA BI Spółka z ograniczoną odpowiedzialnością Sp.K.

Palmer Engineering

Project Design Consultants

Alloy Architecture

Blowtherm S.p.A.

PSC, Inc.

Omni Glass & Paint Inc

Vanair Manufacturing, Inc.

Design Systems, Inc.

CADAMP LTD

More customers are found here.

About

Multiple drawings can be automatically created from a typical drawing or updated based on a control file that can be created with an Excel template. Make the changes in Excel and let the program do all the work for you. This is a real time saver if you need to make adjustments on hundreds or thousands of drawings.

Optionally an AutoLISP file (*.lsp;*.vlx;*.fas) can be loaded for each drawing. Each drawing can use a separate AutoLISP file if needed. This gives you almost unlimited flexibility when it comes to what task you want to automate.

Example of usages: Add a stamp block; insert a title block; update text or attributes in the title block; insert text, block or xref; change text or attribute values and more. Change all external references (xrefs) from absolute paths to relative paths for archive purpose. Find and replace attribute or text values.

Bulk updating AutoCAD or BricsCAD drawings in most any way that you would like.

If you have an idea of what you want to automate but don't know how to realize it, contact us for a solution.

AutoGen

AutoGen creates new drawings based on one or more template drawings based on the control file. In the process text, mtext and block attribute values can be changed individually on each new drawing.

It is possible to change only a part of the text string. If the template drawing contain the text "SHEET #sheetno#" it can be updated to for example "SHEET 1" by specifying #sheetno# as the text to change.

Depending on your computer performance and the complexity of the drawing you can generate around 100 drawings in just 60 seconds.

AutoGen has been used by customers creating instrumentation drawings, loop diagrams (loop drawings), schematics in an automated way based on data in a spreadsheet.

AutoIns

AutoIns inserts text, blocks or xrefs into drawings based on the control file.

These are the properties that can be set using the control file.

In case you want to insert for example a circle or more complex geometry you can make a block of it and the insert it with the Explode property set to Yes.

AutoUpd

AutoUpd updates existing drawings based on the control file.
In the process text and attribute values can be changed individually on each new drawing.

It is possible to change both the whole text string or only a part of the text string. If the template drawing contain the text "SHEET #sheetno#" it can be updated to for example "SHEET 1" by specifying #sheetno# as the text to change.

It is also possible to update text found at a location by defining a rectangle with two coordinates. This is for example useful if a title block contains mtext or text objects not being part of a block object.

With the Import from drawings functionality you can get block and attribute information from one or many drawings.

Example on how to search and replace attribute values or text.

Download video showing usage of AutoUpd or see it on YouTube.

Download

A trial of JTB CAD Automation Tools can be downloaded and installed as an app from the Autodesk App Store site or by contacting us. Purchase is also available through this site.

Full support is provided during trial period that is up to 30 days.

If purchase has been done via Autodesk App Store the download is available on the My Downloads page. Sign in with the same account used when purchasing.

If you need JTB CAD Automation Tools for AutoCAD 2012 or older please contact us.

JTB CAD Automation Tools 5.7.1.exe for BricsCAD 15 or later, or AutoCAD. 

Customers can contact us directly for access to download the full version.

Newsletter

Subscribe to our JTB CAD Automation Tools newsletter or any of our other Newsletters.

System requirements

AutoCAD 2000 or later or verticals based on AutoCAD, BricsCAD 15 or newer.
Tested on AutoCAD 2004 up to AutoCAD 2021 and BricsCAD 15 up to BricsCAD 19.

All verticals or flavors based on AutoCAD should be working like AutoCAD Architecture (ACA), Architectural Desktop (ADT), AutoCAD Civil 3D, AutoCAD Electrical , AutoCAD Map 3D, AutoCAD Mechanical, AutoCAD MEP (AMEP, ABS), AutoCAD P&ID, AutoCAD Plant 3D, Autodesk Advance Steel.

Compatible with those operating systems AutoCAD runs on like Windows XP, Windows Vista, Windows 7, Windows 8, Windows 8.1 and Windows 10.

Contact us if support for other CAD software.

Purchase

New license: 50 USD for one license or less depending on the amount of licenses.

Upgrade license: 25 USD for one license less depending on the quantity of licenses. If you purchased on or after July 1, 2018 the upgrade is free of charge. 

The license is perpetual. Support and upgrades is included for a minimum of 2 years after purchase. If you have more than one computer and you are the only user of the application one license is enough. 

See activation instructions here: JTB World Apps Licensing. 

If you have really many users that you want to give access to this software we can discuss a discounted price based on your particular situation. Educational discounts available.

JTB CAD Automation Tools can also be downloaded, installed and purchased as an app from the Autodesk App Store site.

Documentation

Installation

Run the installer. Installation path is %ProgramData%\Autodesk\ApplicationPlugins\JTBW-CADAutomationTools.bundle for AutoCAD and %ProgramData%\JTBW-CADAutomationTools for BricsCAD. 

Loading

The application will automatically load and also add the Automation Tools panel to the Ribbon tab Plug-ins/Add-ins. Sometimes 'JTB CAD Automation Tools.VLX' needs to be located, it is found in any of the folders of "%ProgramData%\Autodesk\ApplicationPlugins\JTBW-CADAutomationTools.bundle\Contents\Windows" depending on AutoCAD version.

License Activation

See activation instructions here: JTB World Apps Licensing. 

Control file creation

The copy button can be used to copy sample files that are in (%ProgramData%\Autodesk\ApplicationPlugins\JTBW-CADAutomationTools.bundle\Contents\JTB CAD Automation Tools for AutoCAD or %ProgramData%\JTBW-CADAutomationTools\Contents\JTB CAD Automation Tools for BricsCAD) to the C:\JTB CAD Automation Tools folder.

This shows an example how to use AutoGen and the steps are similar for the other commands.

Open AutoGenTemplate.xls

Specify path and name for the drawing to be created as well as the path and name for the template to be used.

Use a button to select and populate the template sheet with the path and name for the drawings.

Use a button that automatically save the Excel template to the correct format.

The Control file should be in TXT tab delimited format.
Start with AutoGenTemplate.xls and when ready save as Text (Tab delimited) (*.txt).

Excel 2007 and newer versions supports more than 256 columns. Make sure to save the Excel file to the XLSM format that allows macros.

Usage

Recommendation is to close all drawings and start a new empty drawing.
Start with the commands AutoGen, AutoIns or AutoUpd.
The first time you may be asked for the location of program file.
When asked for control file browse for and select the control file to be used.

AutoGen

Creation of control file

The Control file should be in TXT tab delimited format.

Start with AutoGenTemplate.xlsm and when ready save as Text (Tab delimited) (*.txt).

For an example of the usage take a look at AutoGenSample.xlsm.

The rows 5 and higher are used to define the new drawings to be created.

Column A (row 5 and higher) holds the path to the drawing that will be created.

Column B (row 5 and higher) holds the name of the drawing.

Column C (row 5 and higher) holds the path for the type drawings.

Column D (row 5 and higher) holds the type drawing name that is an existing drawing.

Column E (row 5 and higher) holds the full path to an AutoLISP application that should be loaded. *.lsp;*.vlx;*.fas are supported. This is optional.

Column G and higher are used to define what should be changed in the template before it is saved to a new drawing. Do not leave empty columns in between. For cell G5 and higher add the value that should be updated or added alternatively “**IGNORE**” without the double quotes and it will not be considered.

When only row 1 and 2 has values it is a Block attribute and all instances of that block with that attribute should get the value.

When only row 2 has a value it is an Attribute definition. This is not a good solution but sometimes users explode blocks and edit the attribute definition thinking it is plain text. What is to be done here is that the Attribute definition should be converted into a Text object with the same properties and the new value.

When row 1,2 and 3 has values it all matches should get the value listed. The value will be searched for and replaced. For example: 1111 will search for all occurrences of the text 111 and replace it with the value listed.

When only row 3 has values it is either Text, Mtext, Multileader or Table objects that should be searched and replaced.

Sample

Here is what the template file AutoGen template 1.dwg look like.

After running the command it would look like this. TEST1.dwg

Usage

Recommendation is to close all drawings and open a new empty drawing.

Start with the command AutoGen.

When asked for control file (.TXT) browse for and select the control file to be used.

Test drive

The copy button can be used to copy sample files that are in (%ProgramData%\Autodesk\ApplicationPlugins\JTBW-CADAutomationTools.bundle\Contents\JTB CAD Automation Tools for AutoCAD or %ProgramData%\JTBW-CADAutomationTools\Contents\JTB CAD Automation Tools for BricsCAD) to the C:\JTB CAD Automation Tools folder.

Follow the instructions described under the subheading Usage. Run the AutoGen command and browse for the file AutoGenSample.txt and the resulting new drawings will be created in the NEW folder.

AutoIns

Creation of control file

The Control file should be in TXT tab delimited format.

Start with AutoInsTemplate.xlsm and when ready save as Text (Tab delimited) (*.txt) or use the button Export.

For an example of the usage take a look at AutoInsSample.xlsm.

The rows 23 and higher are used to define the drawings to be updated. To add files the Add files button can be used.

Column A (row 23 and higher) holds the path to the drawing.

Column B (row 23 and higher) holds the name of the drawing.

Column C (row 23 and higher) holds the full path to an AutoLISP application that should be loaded. *.lsp;*.vlx;*.fas are supported. This is optional.

Column E and higher are used to define what should be inserted to the drawing. Do not leave empty columns in between. Row 1 must be any of these values: TEXT, BLOCK or XREF. For blocks and xrefs to be inserted/attached an X should be added in the column in row 23 or higher. For cell E23 and higher add the value “**IGNORE**” without the double quotes and it will not be considered.

See the sample files for how Text, Blocks and Xrefs can be added to existing drawing.

Usage

Recommendation is to close all drawings and start a new empty drawing.

Start with the command AutoIns.

When asked for control file (.TXT) browse for and select the control file to be used.

Test drive

The copy button can be used to copy sample files that are in (%ProgramData%\Autodesk\ApplicationPlugins\JTBW-CADAutomationTools.bundle\Contents\JTB CAD Automation Tools for AutoCAD or %ProgramData%\JTBW-CADAutomationTools\Contents\JTB CAD Automation Tools for BricsCAD) to the C:\JTB CAD Automation Tools folder.

Follow the instructions described under the subheading Usage. Run the AutoIns command and browse for the file AutoInsSample.txt and the resulting new drawings will be created in the NEW folder.

AutoUpd

Description

AutoUpd updates existing drawings based on using a specified control file.

In the process text and attribute values can be changed individually on each drawing.

Find and replace of text or attribute values throughout the whole drawing is supported.

Creation of control file

The Control file should be in TXT tab delimited format.

Start with AutoUpdTemplate.xlsm and when ready save as Text (Tab delimited) (*.txt) or use the button Export.

For an example of the usage take a look at AutoUpdSample.xlsm.

“Import from drawings” button will open “Import from Drawings” sheet that makes it possible to get existing block and attribute information from one or many drawings.

The rows 10 and higher are used to define the drawings to be updated. To add files the Add files button can be used.

Column A (row 10 and higher) holds the path to the drawing.

Column B (row 10 and higher) holds the name of the drawing.

Column C (row 10 and higher) holds the full path to an AutoLISP application that should be loaded. *.lsp;*.vlx;*.fas are supported. This is optional.

Column E and higher are used to define what should be changed in the drawing. Do not leave empty columns in between. For cell E10 and higher add the new value to be used or add the value “**IGNORE**” without the double quotes and it will not be considered.

When only row 1 and 3 has values it is a Block attribute and all instances of that block with that attribute should get the value as specified in row 10 and higher.

When row 2 (Block Handles) is used specific instances of blocks will be processed.

If that Block Handles cell is empty, then, in all drawings, at that layout tab, all blocks of specified “BLOCK ABC” name will have specified attribute “ATTXYZ” updated.

When your drawing model or layout has many “BLOCK ABC” with attributes “ATTXYZ”, and you want to change the attribute value per each block, you have to specify the block handle. Since there is a list of 10 drawings, so, it should be 10 block handles each column.

• If in a drawing, you don’t want any change in that column, you can just leave a space there, for example: Block Handles = 125, , , , 555
• A special block handle value = * can be used. So, if you want to update all blocks in just a chosen drawing, you can put Block Handles = 125, ,*, 555.
• To be compatible with old AutoUpd spreadsheet, Blocks Handles = “” (empty), all drawings and all found blocks in the layout will be updated.

When only row 3 has a value it is an Attribute definition. This is not a good solution but sometimes users explode blocks and edit the attribute definition thinking it is plain text. What is to be done here is that the Attribute definition should be converted into a Text object with the same properties and the new value.

When row 1, 3 and 4 has values it all matches should get the value listed. The value will be searched for and replaced. For example: 1111 will search for all occurrences of the text 111 and replace it with the value listed.

When row 5-8 contains values defining coordinates for a rectangle any Text, Mtext, Multileader or Table objects crossing or within will be searched and replaced. If the value in row 4 is empty existing value will be completely replaced.

When only row 4 has values it is either Text, Mtext, Multileader or Table objects that should be searched and replaced.

Row 9 is used to specify what layout will be updated.

For search and replace of attribute values in the whole drawing:

To have it working add * in Block name (row 1) and/or Attribute Tag (row 3). This way you can find and replace among all attributes for one specific block or all blocks.

You can also find and replace on a specific attribute tag or any attribute tag. Examples of combinations that work: 
Block name: * 
Attribute Tag: *

Block name: * 
Attribute Tag: NAME

Block name: FRAME 
Attribute Tag: *

Block name: FRAME 
Attribute Tag: NAME

Usage

Recommendation is to close all drawings and start a new empty drawing.

Start with the command AutoUpd.

When asked for control file (.TXT) browse for and select the control file to be used.

Test drive

The copy button can be used to copy sample files that are in (%ProgramData%\Autodesk\ApplicationPlugins\JTBW-CADAutomationTools.bundle\Contents\JTB CAD Automation Tools for AutoCAD or %ProgramData%\JTBW-CADAutomationTools\Contents\JTB CAD Automation Tools for BricsCAD) to the C:\JTB CAD Automation Tools folder.

Follow the instructions described under the subheading Usage. Run the AutoUpd command and browse for the file AutoUpdSample.txt and the resulting new drawings will be created in the NEW folder.

This shows AutoUpd sample 1.dwg before updated.

This shows AutoUpd sample 1.dwg after updated.

Vault tips:

Check out a folder to Work Space.
Run the tools on the files.
Check folder back into vault.

Tips and tutorial from the blog:

• AutoCAD Automation Tools attribute text search and replace

**IGNORE** can be used as a value if you don't want JTB CAD Automation to affect the value for a specific combination of drawing and attribute/text.

Trouble Shooting

If the program is not working as expected run "Reset JTB CAD Automation Tools.reg" found in the installation folder and merge it to the registry to reset the paths.

Check AutoCAD's or BricsCAD's command line when you start a new drawing and see if there are some errors. This can cause the program to halt. One indication on this problem is that AutoGen produces the new drawings but does not update them.

If you have old templates they might not be compatible with most recent template format. Check that they are matching.

Contact us for further support.

Known limitations

• Search and replace is case sensitive
• Wish: add support for handling dynamic blocks and their special properties
• Wish: add support for handling dynamic blocks for AutoUpd Excel sheet "Import from drawings" function

License agreement

The license agreement is found here

Version History

• 2020-07-25 - version 5.7.1
  • Upgraded to License 4.3
• 2020-05-08 - version 5.7.0
  • Added AutoCAD 2021 support
• 2019-10-15 - version 5.6.4
  • Fixed bug in AutoIns when block has attributes.
  • Fixed restoring of some system variables.
• 2019-06-30 - version 5.6.3
  • Add notification when AutoCAD has no license to run
  • One installer for AutoCAD and BricsCAD
  • After purchase the download you get will give you 30 extra days before you need to request and apply the license key
• 2019-04-22 - version 5.6.2
  • Fixed restoring some system variables after using the app
  • AutoUpd updated with flexibility of using handles
  • Installer now installs to %ProgramData%
  • Uninstall previous version before updating
• 2019-03-28 - version 5.6.1
  • Added support for AutoCAD 2020.
  • Updated installer.
• 2018-05-21 - version 5.6
  • Updates to documentation
• 2018-03-22 - version 5.5 update
  • Added support for AutoCAD® 2019 (no version number change)
• 2018-03-13 - version 5.5
  • Added support and installer for BricsCAD up to version 18.
  • Add block handles row in AutoUpd. In case there are 2 or more blocks of same name, this handles row helps to identify and populate changes to each block accordingly.
  • Add new licensing function, including Network license feature.
• 2017-08-16 - version 5.3
  • Fixed bug in AUTOINS command that showed error "no function definition: XREFPATHTYPE".
• 2017-07-20 - version 5.2
  • Fixed bugs in AutoUpd command
  • Fix bugs when attribute text is changed by Excel because it is formatted as number or formula
  • Add sorting options in AutoUpd Excel file
  • Minor changes for better user experience
• 2017-05-31 - version 5.1
  • Fixed bug where Add drawings button may add a drawing on row 9
  • Fixed bug where processing of custom LSP files did not work as expected
• 2017-03-21 - version 5.0 update
  • Added support for AutoCAD® 2018 (no version number change)
• 2016-05-25 - version 5.0
  • Updated Excel files to handle export when cells contains only . or , characters.
  • Fixed issues in AutoUpd Excel files that could cause issues between 32-bit and 64-bit.
  • AutoUpd Excel files function to Import from Drawings updated.
  • Changed from using .XLS to .XLSM files.
  • Excel export supports different language settings for decimal symbol and date formats and other custom formats.
  • Digitally signed .XLSM files.
  • Some bugs fixed.
• 2016-03-22 - version 4.2
  • Added support for AutoCAD® 2017 (no version number change)
• 2015-04-14 - version 4.2
  • AutoCAD 2016 support
  • AutoUpd can now import block and attribute data from drawings
  • New app name: JTB CAD Automation Tools
• 2013-05-12 - version 4.1
  • AutoCAD 2014 support
  • AutoUpd got added support for finding text within a rectangle defined by a couple of coordinates and have it updated.
• 2012-07-09 - version 4.0
  • AutoCAD 2013 support
  • Support for multiline attributes
  • Support for table objects
  • Support for multileader text
  • Support for mtext with more than 250 characters can be searched and replaced
  • Search and replace, replaces not only the first found occurrence now
  • -AutoGen, -AutoInst, -AutoUpd working as command line versions
  • AutoGen has the option to quit AutoCAD when run as the command line version -AutoGen
  • AutoUpd now supports what tabs to be affected
  • More options to determine tabs/layouts to be affected. Thus old Excel or txt templates may not work as expected. AllLayouts* is renamed to LayoutTabs*. "Model space" renamed to ModelTab*. "Paper space" renamed to CurrentLayoutTab*
  • Miscellaneous bug fixes
  • Solved a problem to run on some older AutoCAD versions
• 2011-06-14 - version 3.5
  • AutoUpd has support for layouts
  • It is possible to search for a part of TEXT, MTEXT or block attribute and replace the whole with a new value.
  • 30-day trial available
  • Wcmatch logic used to search for values using wildcards.
  • The Excel templates have been changed, make sure to use the new ones.
• 2010-08-03 - version 3.4
  • Support for dynamic blocks added to AutoGen.
  • Cells with “**IGNORE**” will not be considered.
  • Fixed bug so that different AutoLISP files can be loaded on different drawings.
  • Minor bug fix in reading the control file.
• 2010-01-03 - version 3.4 beta available upon request
  • Support for dynamic blocks added.
• 2010-01-02 - version 3.3
  • Minor fixes to improve export from Excel
• 2009-12-23 - version 3.2
  • Minor fixes that for some users might make the commands not working at all.
• 2009-12-14 - version 3.1
  • Fixes some problems found after version 3.0
• 2009-11-09 - version 3.0
  • Works now with MDI (SDI=0) instead of SDI (SDI=1).
  • Find and replace attribute values.
  • Works with Bricscad 10.
  • After upgrading you might need to recreate the control
  • files with the new Excel sheet.
• 2009-06-08 - version 2.2
  • Makes it possible to insert objects to all layouts with the AutoIns command.
  • Remember the folder browsed for.
  • Minor bug fixes.
• 2008-12-06 - version 2.1
  • Minor update to allow only execution of an AutoLISP file without having to add any other action.
  • Installer added to simplify the installation process.
  • Add files in the Excel templates improved. Now a folder can be selected and all drawing files in the folder and subfolders are added. New files are also added at the row you have selected making it easier to select files from different folders.
• 2008-07-14 - version 2.0
  • Added support to execute an optional AutoLISP file on each drawing.
• 2008-03-11 - version 1.0
  • First release 

Customers

Customer testimonials

"I am very happy with this product."

One user had "4700 drawings to update" with different title blocks and was able to do it quickly with JTB CAD Automation Tools.

"This is a super helpful tool for us and I cannot describe how many hours I have saved thanks to this program" - says a happy user.

"This product is very helpful and worth every penney."

"The AutoCAD Automation Tools from JTB World save me a lot of time when editing individual files, and there have been many times when I couldn’t have met deadlines without them."
Don McLeod, Electrical Engineer
PENTA Engineering, P.A.
Charlotte, NC

Gannett Fleming, Inc.

Jedson Engineering Inc.

EDG Engineering Consultant Firm

Santos Australia

IKKAB

PENTA Engineering

The Newtron Group

Star Seismic

BIMcorp

Quantum Design

Roberts

HH Technology

Cybertech Group of Companies

HeavensHillsideFarms&More, Inc

Triad Control Systems

Emerson Process Management PWS India Pvt. Ltd.

STEPAN

Graphikee Technologies Pte Ltd

Mott MacDonald Australia

Cad3 Limited

ITAC

Alliance Automation

Qualitek

Novozymes

Cadit Solutions Pty Ltd

Infelmar Oy

Emerson Automation Solutions

Jord International

GOIZEA, S.L.

More customers are found here.

About

Edit properties on multiple sheets belonging to Sheet Set Manager (SSM) for AutoCAD, GstarCAD and BricsCAD, NanoCAD Plus/Pro, Graebert's ARES Commander 2022 and newer, or AutoCAD Architecture's Project Navigator (PN) Sheet Set View with ease. If you want to change properties like a revision, date or name on two or more sheets at the same time SSMPropEditor is for you. Your productivity will increase and you will save time avoiding a lot of manual work.

Sheet Set Properties, Sheet Set Custom Properties, Sheet Properties and Sheet Custom Properties can be edited and bulk updated.

Copy Sheet Properties from one sheet to one or multiple other sheets.

Copy Sheet Set Properties from one Sheet Set to another. If the property itself is not existing in the destination Sheet Set it will be created.

Increment revisions quickly on multiple sheets.

Paste the total sheet count to any property.

Optionally rename the actual drawing file associated with the sheet.

Optionally rename actual layout name on the drawing file associated with the sheet.

Export all Sheet or Sheet Set Properties information to a text file or an Excel file.

Import back the exported file after manual changes have been made. Search or Find and replace can be used for example in Notepad or Excel.

Find and replace text values on properties. 

Launch your DWG application from the tree view opening the sheet drawing. The application could for example be AutoCAD, AutoCAD LT or TrueView.

Workaround when sheet title contains unsupported characters? Have you got “The name cannot be longer than 64 characters”? SSMPropEditor can help with this.

Integration with Vault and vaulted Sheet Sets and support for DSS, DSU and DSH files. 

Can be used without any CAD software being installed. 

SSMPropEditor will save you time and money and make you less frustrated when you don't need to edit one sheet at a time.

Update and correct non-existing paths to improve performance of the Sheet Set Manager.

The installer now adds Edit With SSMPropEditor to Windows Explorer context menu for DST files. "Add Edit With SSMPropEditor to Explorer.reg" and "Remove Edit With SSMPropEditor to Explorer.reg" are added to installation folder and can be used manually.

When it comes to Sheet Set Manager performance within AutoCAD (and possibly other CAD applications) there can be several reasons. There are a few things that can be done to tune it in. Take a look at these posts:
Performance tips when using SSM
Sheet Set Manager performance tips
Try also to temporary disable the anti-virus and then try SSM. If it is quicker there might be ways to configure it to exclude AutoCAD.

DST Converter

The DST converter is useful for IT or CAD Managers to correct performance problems with SSM Sheet Sets that started to perform badly. The program converts a DST file to an XML file that can be edited in an XML editor or Notepad and then converted back to DST. One customer used it to replace some dead paths in an SSM file and made a 50 sheet set of construction dwgs each open in 20 seconds instead of the 1½-2 minutes it was taking. Another customer found that the size of the DST was increasing more than reasonable and was able to manually compress and remove erroneous data. Eventually found out that changing the "include in publish" status was what caused the bloat.

There is no trial for DST Converter but if you open a DST file in SSMPropEditor a corresponding XML file will be created in the %TEMP% folder so you can review the format of it. Purchase details.

For one customer there were two "nodes" in this path: AcSmDatabase\AcSmSheetSet\AcSmPublishOptions each named "AcSmCustomPropertyBag" that each contained over 8MB of data. He deleted these nodes and converted the XML back to a DST and everything is OK.

So for some reason, it looks like changing the "include in publish" status (at least in this particular SS) is causing the bloat.

DST Converter can also be used to merge Sheet Sets.

Merge, purge and convert Sheet Set DST files for AutoCAD, BricsCAD, GstarCAD, NanoCAD Plus/Pro and any other CAD software using Sheet Set DST files with our JTB DST Tool.

Download

SSMPropEditor works for 30 days in trial mode with full functionality. If you purchased on or after October 1, 2018 the upgrade is free of charge. 

Current version is 2020.9.0. This installer will also install SSMPropEditor as AutoCAD app. This will install a Plug-ins/Add-ins Ribbon tab panel in AutoCAD 2012 up to AutoCAD 2021 as well as verticals. (Menu will not show up in AutoCAD LT).

• SSMPropEditor 2020.9.0 installer.exe
• Older version 6.4 here. 

SSMPropEditor can be downloaded and installed as an app from the Autodesk App Store site. Purchase is also available through this site.

If purchase has been done via Autodesk App Store the download is available on the Autodesk App Store My Downloads page. Sign in with the same account used when purchasing.

Newsletter

Subscribe to our SSMPropEditor newsletter or any of our other Newsletters.

System requirements

.NET Framework 4.7.2 or later. 

Operating system - Windows 10, Windows Server 2016. Both 32-bit and 64-bit.
Contact us if there's a need for support for older Windows versions. Windows 8.1, Windows 8, Windows 7, Windows Server 2012 R2, Windows Server 2012, Windows Server 2008 R2, Windows 2008 Server might still work. 

To rename the actual layout name full AutoCAD 2013 or newer needs to be installed.

The software runs stand-alone and does not require AutoCAD or other CAD software to be installed unless renaming of actual layout name should be done.

Compatible with AutoCAD versions (2005 and up to AutoCAD 2021) that has Sheet Set Manager (SSM). Works with all flavors/verticals based on AutoCAD like AutoCAD Architecture (ACA), Architectural Desktop (ADT), AutoCAD Civil 3D, AutoCAD Electrical , AutoCAD Map 3D, AutoCAD Mechanical, AutoCAD MEP (AMEP, ABS), AutoCAD P&ID, AutoCAD Plant 3D.  Compatible with AutoCAD Architecture, AutoCAD LT, etc.
Compatible with BricsCAD V13 and newer.
Compatible with GstarCAD 2015 and newer.
Compatible with NanoCAD Plus/Pro 8.0 and newer.

Purchase

SSMPropEditor

New license: 95 USD for one license of SSMPropEditor or less depending on the quantity of licenses. 

SSMPropEditor can also be downloaded, installed and purchased as an app from the Autodesk App Store site. Use this link to purchase.

Upgrade license: 45 USD for one license of SSMPropEditor or less depending on the quantity of licenses. If you purchased on or after October 1, 2018 the upgrade is free of charge. 

If you have really many users that you want to give access to this software we can discuss a discounted price based on your particular situation. Educational discounts available.

The license is perpetual. Support and upgrades is included for a minimum of 2 years after purchase. If you have more than one computer and you are the only user of the application one license is enough.

The network license system is available at no extra cost and normally most useful for companies with quite many licenses. The network license is priced the same but you basically need a license per user anyway as the license will be locked to that user for 4 weeks after last usage.
Reason is that this app is not such that you keep it running for an extended time. But the network license helps when you have many licenses as each computer does not need to be activated through us.
There is volume discount available with purchase of multiple licenses.

DST Converter

10 USD for one license of DST Converter or less depending on the quantity of licenses. When your purchase is completed you will get an email with the DST Converter download.

If you want more functionality and ease of use take a look at our JTB DST Tool as it can merge, purge and convert Sheet Set DST files for AutoCAD, BricsCAD and any other CAD software using Sheet Set DST files.

If you have really many users that you want to give access to this software we can discuss a discounted price based on your particular situation. Educational discounts available.

The license is perpetual (as a minimum for the version available when purchased) and support is included. If you have more than one computer and you are the only user of the application one license is enough.

Documentation

Version History

Known issues in latest release and possibly older releases:

• Editing model view paths is not working.

• Changing language within the application requires to restart it to avoid unexpected problems.

• Vault 2021 is by default supported. Contact us for other versions to be supported.

Most recent and previous versions:

• 2020-09-26 - version 2020.9.0

  • More editing functionality for Label block for views, Callout blocks, Page setup overrides file, Sheet storage location and Sheet creation template.

  • Silent command line installation is now also uninstalling previous version  unattended.

  • Chinese localization.

  • Graphical issues fixed that could happen in some systems due to text scaling and DPI.

• 2020-07-05 - version 7.5.0

  • Upgraded to JTB License 4.3.0.1

  • Licensing update with encryption compliant with Federal Information Processing Standards(FIPS).

  • Bug fix for network licenses where Unknown could show as PC name in the License Server Dashboard.

• 2020-06-18 - version 7.4.4
  • Fixed bug with Lock/Unlock button.
• 2020-06-15 - version 7.4.3
  • Updated licensing functionality.
• 2020-05-23 - version 7.4.2
  • Fixed Vault connection issue.
  • Updated licensing functionality.
• 2020-05-02 - version 7.4.1
  • Fixed silent install issue.
• 2020-04-24 - version 7.4.0
  • AutoCAD 2021 supported.
  • Vault 2021 is by default supported. Contact us for other versions to be supported.
  • Fixed oversized icon on the AutoCAD Ribbon that happened to one customer.
  • Installs for AutoCAD in ProgramData to allow one user to install and another user to use the app from within AutoCAD.
  • Fixed silent install issue.
  • .NET Framework 4.7.2 or newer needed.
• 2019-09-01 - version 7.3.1
  • Fixed a bug that could cause path to sheet being deleted.
  • Fixed a bug that could cause file missing problems after importing.
• 2019-08-19 - version 7.3 
  • Added ability to drag and drop sheets or subsets in the tree view.
  • Fixed "Edit with SSMPropEditor" in Explorer.
  • Sheet Creation template path can be edited.
  • Relative path can be edited.
  • Added ability to install silently and specify license server.
  • If one or more sheets are missing custom sheet properties they can now be copied from another sheet that has them. This can be the case with ProjectWise and DMS Location and SheetID.
  • Fixed a bug related to being installed as app for AutoCAD 2020.
  • Fixed problem with changes being saved in some situations.
  • Fixed some sorting bugs.
  • Fixed increment bug that caused increments of 2 instead of 1 as expected.
  • Allow editing sheet number and/or name to fix problem if two are named the same already.
• 2019-03-28 - version 7.2 update
  • Added support for AutoCAD 2020
• 2019-02-18 - version 7.2
  • Fixed a problem to drag and drop a DST file into the app. 
• 2019-02-01 - version 7.1
  • Performance enhancements for renaming of actual layout names
  • Added Edit with SSMPropEditor when right clicking on a DST file in Explorer
  • Merged installer for Windows and Autodesk app
  • Installer allows user to select installation location
  • Fixed problem with renaming of actual layout name that could happen in some cases causing the app to hang
  • Import problems fixed that could cause sheet numbers missing
  • Fixed import problems when a property includes the ‘ character
  • Copy and paste problem fixed
  • UI glitches fixed
  • Fixed a problem with Windows scaling of 125% or more
  • Various improvements and fixes
• 2018-11-19 - version 7.0
  • New licensing system being used, network licenses are available
  • UI glitches fixed
  • Fixed a problem where sorting were not saved in some cases
  • Fixed a problem where the sheet title and number was not saved when changed
  • Fixed a problem with sheet indexing that could cause erroneous result
  • Fixed some export/import problems
  • Fixed problem to copy and paste between sheet sets
  • Fixed a problem with renaming of sheet file name
  • Fixed problems with paths not showing correctly for properties Label block for views, Callout blocks and Page setup overrides file
  • Fixed issue when a property includes the character ‘ causing problems with import and export
  • Fixed a problem that did not update 'Include for Publish', after importing from text or Excel
  • Improvements in the UI to show more properties when possible on screens with large resolution
  • UI fixes for the Ribbon where in some cases the lower buttons could not be seen fully
  • Fixed problem to export and/or import to/from Excel in some cases
  • Fixed some problems related to Vault. Still waiting for Autodesk's help for some issues
  • Minor bug fix with Sheet indexing showing an error even though it was no error
  • Fixed a problem with Windows scaling of 125% or more
  • Various performance improvements
• 2017-03-21 - version 6.4 update
  • Added Autodesk® AutoCAD® 2018 support.
• 2017-01-20 - version 6.4
  • Export and Import to Excel files does not require Excel to be installed. This makes it work with other software that can edit XLSX files
  • Natural sorting implemented for sorting of sheets in the tree view. Before it was for example sorted like S-001, S-1001, S-101 but now as S-001, S-101, S-1001
  • Fixed a problem with renaming of actual Layout name when "Rename Layout in drawing" checkbox is used in Options. In some cases the layout could not be renamed as expected
  • Fixed problem that sorting not always was saved as expected
  • Fixed problem with selection of multiple sheets in the tree view that sometimes failed to work as expected
  • Fixed problem with Sheet Indexing not working for the Layout property
  • Fixed problem with Find and Replace not working in some cases
  • Fixed some problems related to Vault
  • Fixed some performance issues
  • Other minor fixes
  • Version 6.3 was not released to the public
• 2016-03-01 - version 6.2
  • Fixed a problem changing language that was introduced in version 6.1
  • Fixed a problem where using copy and paste did cause the right pane to be empty
  • Fixed a problem where using copy and paste did caused collapsed and expanded subsets to change state
  • Fixed a problem when importing Excel files in certain cases could cause issues with paths and renaming of dwg files.
  • Improvement of performance in some cases when paths to dwg files are not found.
• 2016-01-21 - version 6.1
  • One installer for 32-bit and 64-bit as well as for different languages.
  • Fixed an issue in version 6.0 that could cause problems if an earlier version was installed.
  • Makes SSMPropEditor to use the last run version of AutoCAD if multiple versions of AutoCAD are installed.
  • Handle non existing UNC paths by giving the user the choice to ignore these paths during the remainder of the session and giving the recommendation to fix the paths if there's a need for it.
  • Solved some bugs when copying properties and then pasting them that could result in the order of the sheet custom properties to be changed.
  • Solved a bug where the Sheet Set file is automatically saved during copy/paste of properties.
  • Cleared the pasting issue that resulted in empty grids on the right side.
  • Solved a problem related to Sheet Set created in ProjectWise.
  • Performance improvement.

• 2015-12-01 - version 6.0
  • SSMPropEditor saves the DST in more compressed way than before making the DST file smaller.
  • .NET Framework 4.5.1 needed
  • New properties can be added when copying from one sheet set to another
  • Autodesk Vault support added (first release for this functionality so start testing against a Sheet Set copy)
  • Sort option added to tree view right click menu so sorting can be done by either sheet number and sheet title or only sheet title
  • Correct how sheet is named in tree view when sheet number is not used
  • Fixed a sorting issue for the tree view
  • Fixed an issue when a sheet set contains & in the name
  • Fixed an issue causing error during saving
  • Find and Replace has been improved, with better performance and got some bugs fixed
  • Fixed an issue where the tree view scroll to top
  • Fixed an issue when using select all
  • Fixed issue during import
  • As well as other minor fixes

• 2015-03-18 - version 5.2
  • Find & Replace of property text has been added.
  • Added possibility to rename the actual layout name on drawings.
  • Added two new buttons to check or uncheck all properties when the Selection column is used.
  • Added sorting of sheets to the right click menu in the tree view area.
  • Visual Studio 2012 Light theme added.
  • Fixed problem with broken sheet view numbers, titles, scales on callouts after certain changes have been done in SSMPropEditor.
  • Bug fixed: After incrementing sheet numbers the tree view is not updated.
  • This bug has been fixed: Select multiple sheets and use increment value on the sheet number and it is not updated in the tree view. To see the change, save, close and open the Sheet Set.
  • Several other minor or odd bugs have been fixed.
• 2014-03-02 - version 5.1
  • Added Polish language.
  • 30-day trial added without need to request a trial license.
  • Added ability to drag and drop a DST file into SSMPropEditor to open the Sheet Set.
  • Improved performance while exporting and importing to and from Excel.
  • Added functionality to rename matching XML file when renaming sheets belonging to Project Navigator.
  • Fixed bug when exporting sheets to Excel in non-English languages.
  • Fixed a problem when importing from from Excel or text when French is used.
  • Fixed a problem when exporting sheet set data and the sheet set title contained characters not allowed in file names.
  • Fixed a problem where some custom sheet properties did not show up on the sheet set node.
  • Fixed some language translation issues.
  • Fixed bug: Export to Excel does not retain values with only a space or Alt+0160 (blank space).
  • Solved a bug where the tree view structure (collapsed and expanded folders) was lost when pasting properties.
  • Now it's possible to use Alt-Tab to activate SSMPropEditor while the Options dialog box is open.
  • Fixed bug: If you right click on a sheet "Select all sheets in this subset" does not select all sheets.
  • Updated installer for the Autodesk App version to support AutoCAD 2015 and verticals.
• 2013-03-10 - version 5.0
  • Direct export/import to Excel. Export to Excel does not retain values with only a space or Alt+0160 (blank space or Non-break Space). A fix is available upon request.
  • Export/Import Sheet Set properties added.
  • Added localization for Italian.
  • In Options dialog box language can be selected.
  • Sheet Indexing lowest start number changed from 1 to 0.
  • Bug fix with export/import to text file that could happen in some Windows languages/regional settings.
  • UI style updates.
  • Minor bug fixes.
• 2012-09-03 - version 4.6
  • Added localization for Spanish and French.
  • Bug with renaming of sheets when views are used fixed.
  • Fixed UI problem when Windows is set to another text size (DPI) than 100%.
  • Other bug fixes.
• 2012-04-03 - version 4.5
  • Added compatibility for AutoCAD 2013.
  • Start Sheet Set associated with the current drawing when started from AutoCAD.
  • Start Sheet Set by specifying DST file as argument when running the SSMPropEditor.exe.
  • Bug fixes.
• 2012-02-05 - version 4.4.2
  • Tab movement settings is now saved as it should after restarting SSMPropEditor.
  • Bug in SSMPropEditor that the grid is moved to left when checking the selection checkboxes.
  • Bug fixed when importing from another location than where the DST is located.
• 2011-09-25 - version 4.4.1
  • Fixed path issue with export.
  • Fixed problem to remove some of the paths.
  • Fixed browsing for sheet path.
• 2011-08-23 - version 4.4
  • If copying properties from one sheet set to another any non-existing properties will be created.
  • Added check for update making it possible to see if a newer version is available.
  • Fixed a problem with single click on selection checkboxes.
  • Fixed paste of new properties (sometimes it is needed to click on paste twice (to refresh) if the new properties does not show up directly)
  • A few minor bug fixes.
• 2011-06-12 - version 4.3.3
  • Made it possible to single click on selection checkboxes.
  • Fixed a problem with import/export related to hard spaces.
  • Added version to application title.
• 2011-05-12 - version 4.3.2
  • AutoCAD 2012 based autoloader Plug-Ins support.
  • Fixes a memory bloat issue that can happen under some circumstances.
  • Fixes the issues in 4.3 and 4.3.1 related to relative path not working and file name being emptied.
• 2011-04-28 - version 4.3.1
  • Fixed some issues that made right click open drawing and folder not working.
  • Fixed a problem when sometimes AutoCAD shows that it does not find the sheet after making a change in SSMPropEditor.
  • Fixed a problem with importing of txt file.
  • Fixed a minor problem with recent sheet set list tooltip.
  • Potential issues in this version:
    • A couple customers have reported that the relative path is cleared after making changes to some properties in SSMPropEditor so that the sheets shows a question mark in SSM. To avoid the problem have "Use Show Properties" checked.
• 2011-04-11 - version 4.3
  • Added tooltip to recent sheet set list.
  • It is now possible to add just a space for properties to avoid the dots showing in AutoCAD.
  • Possible to add spaces at the beginning and end of Sheet Indexing prefixes or suffixes.
  • German translation.
  • Bugs fixed:
    • The tree view expansion/collapse is not restored in certain cases.
    • Sheets with .DWG in capital letters are incorrectly showing with an extra .dwg suffix.
    • Renaming and repathing/moving of the actual dwg files is not always working.
    • Export is not working in some cases.
    • Removed save dialog when unlocking or closing a sheet if no changes have been done.
    • Some other minor issues.
• 2011-02-23 - version 4.2
  • Added more abilities to control the paths to sheets. This affects renaming of sheet paths and also makes it possible to correct performance issues due to non existing paths.
  • Added Options>Show found path.
  • Added Options>Advanced: Show internal paths.
  • Improved the treeview control that lists the sheets so it retains selection after applying changes.
  • Bug fixed solving a problem copying properties between sheet sets during some circumstances.
  • Saving glitches fixed.
  • Known issues in this version:
    • The tree view expansion/collapse is not restored in certain cases.
    • Sheets with .DWG in capital letters are incorrectly showing with an extra .dwg suffix.
    • Renaming and repathing of the actual dwg files is not always working.
    • Export is not working in some cases.
    • German translation not ready.
• 2010-10-08 - version 4.1.1
  • German localization update.
  • Bugs found after release of 4.1 fixed. The bugs are related to when using "renaming of actual .dwg file".
• 2010-09-27 - version 4.1
  • Import of exported file. Making it possible to edit the exported file and import it back.
  • Renaming of actual .dwg file. Available as an option.
  • Change path of .dwg file and added browse button.
  • UI improvements.
  • Bug fixes.
• 2010-06-17 - version 4.0
  •  Indexing/renumbering functionality making it possible to renumber all or selected sheets in a sheet set
  • Easy to add Sheet count to a property so you can have text on the drawing showing for example “Sheet 5 of 18”.
  • File Path, File Name and File Layout is possible to edit on one or multiple sheets at a time.
  • Performance improvements when selecting sheets in the tree view.
  • Recent list have the option to delete not found shortcuts.
  • Optionally use tab to move between property cells.
  • Close of Sheet Set without closing the application.
  • UI improvements.
  • Bug fixes.
• 2009-05-21 - version 3.0.3
  • There is a Ribbon, Application Menu, Quick Access Toolbar.
  • Increment values. Think of revisions for example. Even if you have different revisions on different sheets they will be incremented individually. You can even use custom incremental series if needed for each Sheet Set.
  • Sheet Set Properties and Sheet Set Custom Properties can be edited.
  • An option to always have a backup of the Sheet Set DST file created whenever you open a Sheet Set.
  • Disable ToolTips if you want.
  • Choose if you want to show properties as soon as you make a selection in the tree view or if you want to show them when you press the button. The reason there is a manual way is that it is quicker if you make large selections of sheets.
  • Copy properties from one sheet to one or many other sheets, even between sheet sets. Check the “Show Copy Checkboxes” checkbox first and then select what properties you want to copy and paste.
  • There is a button allowing you to paste the Sheet count of the Sheet Set into the currently selected property.
  • Export data to a format that you can use in Excel for example.
  • Create reports that you can print.
  • Access to previously opened Sheet Sets.
  • Unlock/Lock button that let you release the lock of the Sheet Set so you can see changes directly in AutoCAD.
  • Have changes applied automatically as an option.
• 2009-02-19 - version 2.2.0
  • Localized to German. German page here.
  •  If the Sheet Set is locked you can open it Read Only in SSMPropEditor and if it is not locked SSMPropEditor will add a lock on it so you cannot modify it within AutoCAD even though you can open it. The aim is that it should play more nice with AutoCAD this way.
  • A confirmation dialog have been removed to speed up the usage.
  • Some bugs fixed.
• 2008-10-01 - version 2.1.0
  • Not publicly released. More of a beta for 2.2.
• 2008-09-02 - version 2.0.0
  • Performance when selecting sheets in large sheet sets.
  • After Save the selection remain and the new values are seen in the Properties list.
  • Added ability to edit the Sheet title, Sheet number and Include for publish.
  • Export as tab separated text file that easily can be opened with Excel.
  • Added Include for publish, Sheet title and Sheet number and corrected the Sheet Properties sort order to mach AutoCAD's.
  • Open the sheet in the program that you have associated to open DWG files.
  • Open the folder in Windows Explorer where the sheet DWG file is located in.
  • Some minor bugs fixed.
• 2008-07-15 - version 1.1.0
  • Now Shift can be used to select multiple sheets in the tree view.
• 2008-07-10 - version 1.0.1
  • Bug fix related to some sheets that could not show the properties.
• 2008-07-08 - version 1.0
  • First release

Wishes and feature requests

• Optionally have a spread sheet view or grid to edit the values in.
• To manually rearrange the sheets or subsets and view categories.
• Rename categories. (Can be done with help of our JTB DST Tool)
• To be able to plot using for example AutoCAD or AutoCAD LT.
• Ability to rearrange the “Locations” (folders) under the Model Views Tab and the same ability to rearrange the “Categories” under the Sheet Views Tab.
• Support to manipulate the .APJ project files for AutoCAD, Inventor and more..
• The ability to move sheet views from one sheet to another, while maintaining linked callouts. ref
• Add new or delete custom properties.
• Change case. (Workaround is to export to Excel, change case and import)
• Spell check. (Workaround is to export to Excel, spell check and import)
• Delete selected sheets or subset including sheets.
• Tool to help migrate data from old title blocks with normal attributes to attributes with fields connected to the sheet set.
• Create a new sheet set from scratch based on data in an Excel file or the like with either using existing drawings or creating new ones. (Can be done with help of our JTB Sheet Set Creator)
• Enable the use of page up / page down for moving from one sheet to the next while maintaining the focus on same property (for example, editing sheet title on page 5, press page down, and your cursor is in the position to edit the sheet title on page 6.. page 7 etc)
• Ability to add prefix or suffix to an existing property, including the ability to add to multiple sheets (similar to indexing’s functionality, but maintaining the existing value for each page).
• To sort properties in a custom order. Saved settings in a separate file saved in same folder as the DST. Still this sort order will not show when you run SSM within AutoCAD.
• Create subsets.
• Duplicate existing subset.
• Ability to remove multiple subsets at once or even deleting a subset and all the sheets associated with it. Having to delete multiple sheets is at once is excellent but would like to do the same with subsets.
• Edit subset properties.
• Edit subset custom properties. Not yet available in AutoCAD's Sheet Set Manager.
• Add alphabetic indexing as an option to Sheet Indexing.
• Combine Sheet Sets / Merge Sheet Sets. (Can be done with help of our JTB DST Tool)
• Split Sheet Set in two or more Sheet Sets. (Can be done with help of our JTB DST Tool)
• Edit saved sheet selections.
• Rename subsets within the application. (Can be done with help of our JTB DST Tool)
• Rename drawings similar to what is possible in the Sheet Set Manager by adding sheet number to the file name.
• Rename Sheet Custom Property names and Sheet Set Custom Property names. (Can be done with help of our JTB DST Tool)
• Include all functionality that SSM has. (this is not likely to happen)
• Edit Sheet Views information. Possibly export/import to Excel.
• Support for cloud storage like Autodesk BIM 360. 

If you too have a need for any of these wishes please contact us so we know how big the need for it is and can prioritize accordingly.

License agreement

The license agreement is found here.

Customers

Some SSMPropEditor customers and their comments

"I have been using this for years. ... if you're using sheet set manager, this program is a must have. You can renumber hundreds of sheets within seconds. The investment is well worth it." - James Mcclendon

"JTBWorld has some really great tools on his site. I actually bought a personal license for his Sheet Set Property Editor that makes backups of your DST file each time you open one in the application. If you use Sheet Set Manager for your projects, I'd recommend getting yourself a license as well. It's so helpful." - Archie Dodge

"I've been using this for years, it's straightforward, constantly updated, extremely useful for fixing bloated sheetset managers that end up with hard coded paths pointing to null server locations and other problems easily edited with notepad++" - John Hammer

"Sheet Set Savior - I purchased the full version and its worth every penny. If you deal with Sheet Sets often, especially large lets, this product will save you time if you have to renumber a set i.e. "5 of 80". It took me about 20 seconds to renumber a 120 page plan set." - James Mcclendon

"This program is one of the best values for the money we spent. I have mentioned this to management several times. The program and the support is above and beyond. "

"I love the SSMPropEditor, by the way. It's the coolest thing since sliced bread."

“I love your SSMPropEditor. I’ve used it on two major projects this past week and it has saved me at least a day, maybe two, over others here not using the SSM. The SSM speeds up productivity, but the SSM Properties Editor makes it feasible considering you can have titles 64 characters long and longer, plus special characters. The ability to change properties on multiple sheets at once is something that really makes this worth having. I was able to change 45 sheet title blocks in a matter of minutes.” - Archie Dodge

"I've just sent out a final issue of some 40-50 drawings for a project that I've been working on all year. I only needed to use the Prop editor once, but it worked 'exactly like it said on the tin'. Excellent! Why don't Autodesk do this already?
Great product." - Happy customer.

I've purchased The SSMPropEditor and It's the best investment I have made in my life. I'm editing custom sheet set data regarding drawn-by and checked by and lot of other data for hundreds of sheets in seconds while it took me days to do it - quote on AUGI

Thanks for your support Jimmy. We managed to rename the Layouts as well. This app deserves 10 stars unfortunately I can only give 5. Best AutoCAD app available out there. - Francisco Barbieri

A new customer about SSMPropEditor: It's like Christmas and Birthday together! :-)

Really wish I would have had this program several times in my career.  It would have saved me a ton of work.

"Excellent!!! Huge time saver
I haven't done extensive testing on this app yet but it's already saved me tons of work. Templates are great but there are simply times when you need to "retrofit" elements to existing sheet sets. In my case I was looking to roll out a drawing revision block that is driven by Sheet Set custom properties across +15 sets with 20+ sheets. This app has allowed me to just copy/paste. Honestly I think this functionality should be baked into AutoCAD from the get go but JTB World has done a great job filling the gap! I strongly recommend it."

"As a Cad Support person with Brisbane City Council (Australia) I have been responsible for the implementation of Sheet Set Manager within AutoCad and AutoCad Map 3D. This initiation was overall excepted well, however one of the few complaints I have received is the inability of editing multiple drawing (often in excess of 100 drawings) Titleblock information (SSM Titleblock Fields.

I found "SSMPropEditor" on JTB World's Website (a website I visit regularly). I organised for an evaluation licence and used SSMPropEditor on a number of large projects Brisbane City Council are currently involved with. All Cad Users involved with these Projects and using SSMPropEditor commented how much easier and quicker it made editing mutiple drawings. The main comment was ... "when can we buy it".

As a result Brisbane City Council will be purchasing "SSMPropEditor" (multiple copies) and are extremely happy with exactly how this software works. It enhances the use of Sheet Set Manager within AutoCad products.

A big thank you to JTB World"

Glen McCarley
Design Project Manager
City Design - Engineering Group
Roads and Traffic
Brisbane City Council

"I believe everyone should be using AutoCAD's Sheet Set Manager, as it greatly improves drawing management. I also believe everyone should be using your Sheet Set Property Editor and Sheet Set Path Editor. Both tools greatly improve AutoCAD's Sheet Set Manager. Our users have indicated that using your software allows them to update the title block data more effectively and efficiently, thus saving time with drawing revisions and submissions." - Keith Biggs, CAD Technical Coordinator, RF Binnie & Associates Ltd.

HOLY COW THERE MR JB where has this software been all my life, thanks for taking off at least a day of frustration per job now it takes only 15 min.

"This tool is a lifesaver!"

"I would be lost without this APP!!! Such a huge time saver!"

What I have used it for today, it’s awesome.  I hate to think how many hours I’ve wasted without it in the past. - Kevin

This makes a WORLD of difference applying the same properties to multiple custom sheet properties!

I really appreciate your support. SSMPropEditor is by far the best app I've seen for AutoCAD it will safe us a lot of time. We will be certainly buying a license.

"Thank you again for such a wonderful program and the support that you have given since our purchase.  This has to be one of the best values for our money. Highly recommend this program for anyone who uses SheetSets."

This software is a huge boost to production!

More customers are found here.

About

Merge, purge and convert Sheet Set DST files for AutoCAD, BricsCAD, GstarCAD, NanoCAD Plus/Pro, Graebert's ARES Commander 2022 and newer, and any other CAD software using Sheet Set DST files. For example AutoCAD's Sheet Set Manager (SSM) or AutoCAD Architecture's Project Navigator (PN) Sheet Set View.

Merge one or more sheet sets into another.

Fields for Sheet Views will be updated (requires AutoCAD) as needed. 

The purging is useful for IT or CAD Managers to correct performance problems with SSM Sheet Sets that started to perform badly. Sometimes the DST file can grow unreasonable large and the purging can help.

After converting from DST to XML advanced edits can be made like renaming Sheet Set Custom Property names, Sheet Custom Property names, subset names, view category names and most anything else and then convert the XML back to DST. Edits of the XML can be done in Notepad or an XML editor.

Fix File Path option 1: automatically find and fix reference file and folder paths.
If you move your project files, restructure the folders, you may find that in your Sheet Sets, many file and folder paths are marked as missing or not found. Click this command button will help you fix the issue. Assuming the dst file is in the out-most folder, the app will try to find all missing files and folders paths inside the dst file's folder structure.

Fix File Path option 2: find and replace a text portion in all reference file and folder paths. This is replacing our old JTB SSM Path Edit (SSMPathEdit) app. 

Download

The JTB DST Tool trial is limited to work with 3 sample files that are included.

Current version is 2.0.0. This is a freestanding app running with no need for any CAD software. 

• JTB DST Tool Setup.zip

JTB DST Tool trial as AutoCAD app

For AutoCAD 2015 and newer purchase or download JTB DST Tool trial as an AutoCAD app on Autodesk App Store site.

If purchase has been done via Autodesk App Store the download is available on My Downloads page. Sign in with the same account used when purchasing.

After purchase click on the "Activate" button and follow instruction to receive the activation key from JTB World. See activation instructions here: JTB World Apps Licensing. 

Newsletter

Subscribe to our JTB DST Tool newsletter or any of our other Newsletters.

System requirements

.NET Framework 4 or later - Download at Microsoft.com

Operating system - Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista, Windows 2003 Server, Windows 2008 Server, Windows 2012 Server.
Both 32-bit and 64-bit.
Older Windows versions might also work but are not directly supported.

The software runs stand-alone and does mostly not require AutoCAD or other CAD software to be installed. For merging Sheet Views AutoCAD is required. 

Compatible with AutoCAD versions (2005 and up to AutoCAD 2021) that has Sheet Set Manager (SSM) as well as AutoCAD LT. Works with all flavors/verticals based on AutoCAD like AutoCAD Architecture (ACA), Architectural Desktop (ADT), AutoCAD Civil 3D, AutoCAD Electrical , AutoCAD Map 3D, AutoCAD Mechanical, AutoCAD MEP (AMEP, ABS), AutoCAD P&ID, AutoCAD Plant 3D, Autodesk Advance Steel.
Compatible with BricsCAD V13 and newer.
Compatible with GstarCAD 2015 and newer.
Compatible with NanoCAD Plus/Pro 8.0 and newer.

Purchase

New license: 50 USD for one license or less depending on the quantity of licenses. After purchase click on the "Activate" button and follow instruction to receive the activation key from JTB World. We normally try to reply within 24 hours.

Upgrade license: 25 USD for one license less depending on the quantity of licenses. If you purchased on or after July 1, 2018 the upgrade is free of charge. 

Purchase JTB DST Tool from the Autodesk App Store site.

If purchase has been done via Autodesk App Store the download is available on the Autodesk App Store My Downloads page. Sign in with the same account used when purchasing.

If you have really many users that you want to give access to this software we can discuss a discounted price based on your particular situation. Educational discounts available.

The license is perpetual. Support and upgrades is included for a minimum of 2 years after purchase. If you have more than one computer and you are the only user of the application one license is enough. 

See activation instructions here: JTB World Apps Licensing. 

Documentation

Setup procedure

1. Run installer .exe to install JTB DST Tool and follow the instructions. Default installation folder is C:\Program Files\JTB World\JTB DST Tool. Alternatively for AutoCAD app installer it is %appdata%\Autodesk\ApplicationPlugins\JTB DST Tool.bundle.
2. To run the program you find it on the Windows Start menu>All Programs>JTB DST Tool alternatively for AutoCAD app on the Plug-ins/Add-ins tab within AutoCAD.
3. If purchased, click on Activate button. See activation instructions here: JTB World Apps Licensing. 

To install unattended here's an example:
"JTB DST Tool <version>.exe" /VERYSILENT /NORESTART /SUPRESSMSGBOXES /LOG=”%TEMP%\JTB DST Tool.LOG”

To install unattended and also activate a network license here's an example:
"JTB DST Tool <version.exe" /server="myservernamehere" /port=56712 /VERYSILENT /NORESTART /SUPRESSMSGBOXES /LOG=”%TEMP%\JTB DST Tool.LOG”

Usage

Run JTB Sheet Set DST Tool.exe from the installation folder or start JTB DST Tool from the Windows Start menu.

If JTB DST Tool app for AutoCAD has been used for installation the application will automatically load in AutoCAD and also add the JTB World panel to the Ribbon tab Plug-ins/Add-ins. 

Run DSTTOOL command in AutoCAD or click on the button in the Ribbon menu. This app will help you:

+ Merge DST files. If similar subsets found, they will be merged into 1 subset. Sheet View text fields in drawings will be updated by a batch run via AutoCAD's Core Console.

+ Merge-Copy DST files: using this method, regardless subsets duplication, DST files data will be added one after another. Sheet View text fields in drawings will be updated by a batch run via AutoCAD's Core Console.

+ Purge unused info in DST files to reduce filesize.

+ Convert DST files to XML format and back. Useful for if manual edits needs to be done to the file. Use for Notepad or XML Notepad or other XML editor.

+ After converting from DST to XML advanced edits can be made like renaming Sheet Set Custom Property names, Sheet Custom Property names, subset names, view category names and most anything else and then convert the XML back to DST. Edits of the XML can be done in Notepad or an XML editor. See our blog post How to rename Sheet Set or Sheet Custom Property names for details.

After modified, DST file will be backed up in the same folder.

Fix File Path option 1: automatically find and fix reference file and folder paths.
If you move your project files, restructure the folders, you may find that in your Sheet Sets, many file and folder paths are marked as missing or not found. Click this command button will help you fix the issue. Assuming the dst file is in the out-most folder, the app will try to find all missing files and folders paths inside the dst file's folder structure.

Fix File Path option 2: find and replace a text portion in all reference file and folder paths. This is replacing our old JTB SSM Path Edit (SSMPathEdit) app. 

Some Sheet Set Manager resources:

• Sheet Set Manager performance issue with Windows 2008 R2 server with SMB V2 active
• Slow Sheet Set Manager solution
• How to use unsupported characters in Sheet Set Manager
• Sheet Set Manager productivity tips on sheet indexing
• How to rename a Sheet Set dst file
• Sheet Set Manager performance tips
• Sheet Set Manager tutorial, tips and tricks
• Clear sticky Sheet Sets from Recent Documents List in AutoCAD
• Add a comma to the sheet title of a sheet in AutoCAD
• Performance tips when using SSM
• AutoCAD Sheet Set Manager properties shows '----' when you don't want to
• Sheet Set Manager Documentation
• How to rename Sheet Set or Sheet Custom Property names

Version History

• 2020-11-20 - version 2.0.0
  
  • Added support for Sheet Views to merge and update to Merge command. Sheet View text fields in drawings will be updated by a batch run via AutoCAD's Core Console.
• 2020-08-09 - version 1.8.0.2
  • Fixed a file missing error in the installer
• 2020-07-25 - version 1.8.0.1
  • Fixed a file missing error in the installer
• 2020-07-20 - version 1.8.0
  • Upgraded to License 4.3
  • Fix reference paths: Find and Replace option added
• 2020-05-08 - version 1.7.0
  • Added Autodesk® AutoCAD® 2021 support.
• 2019-03-28 - version 1.6.1
  • Added Autodesk® AutoCAD® 2020 support.
  • Add "Fix File Paths" command.
• 2018-03-22 - version 1.5
  • Added Autodesk® AutoCAD® 2019 support.
  • Minor adjustments.
• 2017-10-23 - version 1.4
  • Added ability to merge custom properties when DST files are merged.
  • Added network license feature.
• 2017-03-21 - version 1.3
  • Added support for AutoCAD® 2018
• 2017-02-14 - version 1.2
  • Fixed a bug in trial mode, related to decimal symbol
• 2016-10-03 - version 1.1
  • First public release

License agreement

The license agreement is found here.

Customers

CDG Engineers

Engel & Company, Inc.

FMJ Projects

Taylor Engineering

Moffatt & Nichol

Olsson Associates

Reardon Smith Architects Ltd.

Precision Geomatics Inc.

BL Companies

Freese and Nichols, Inc.

PulteGroup Inc

Rail Planning Services

Brisbane City Council

RFS Architects

Rail Planning Services

PulteGroup Inc

Engel & Company, Inc.

Freese and Nichols, Inc.

FMJ Projects

BL Companies

ANDDES ASOCIADOS S.A.C.

More customers are found here.

About

Make use of AutoCAD together with an external database. Block attribute values can automatically be updated back and forth to one or many external databases. If you make changes to the attribute values they can be synchronized back to the external database or the other way around.

There are three sync methods available and can be set individually for each attribute to synchronize.

• Sync in both directions.
• Sync only from the drawing to the database.
• Sync only from the database to the drawing.

Some information might be useful to sync in both directions while other information like dimensions needs AutoCAD to be the owner. Other information like price might best be owned by the database.

Information in the title block as well as revisions is something that can be synchronized.

More flexibility and functionality than the standard AutoCAD commands EATTEXT, DATAEXTRACTION, ATTIN and ATTOUT.

ACAD_db will improve your work process and experience and will improve quality of your data and remove redundancy and conflicts of data and information.

Support for blocks in both model space and paper space and in multiple layouts. Fields of all types like Sheet Set Manager properties are supported but then sync only from drawing to the database.

Dynamic blocks are supported.

A Setup Window for the database table JTBW_AttSync is available to ease the task to create the connection between the database and the drawing. 

Advance Edit Row:

Multi-line attributes are not yet supported but support for them can be added if and when needed.

Download

Installer for version 4.1.1: JTB ACAD_db_4.1.1.exe.

Sample Access database and drawing are included with the installer.

ACAD_db_SQL.zip (114KB). Sample database for SQL Server/SQL Server Express.

ACAD_db_Oracle.zip Needed if Oracle will be used as database.

Newsletter

Subscribe to our ACAD_db newsletter or any of our other Newsletters.

System requirements

AutoCAD 2008,AutoCAD 2009, AutoCAD 2010, AutoCAD 2011,AutoCAD 2012, AutoCAD 2013, AutoCAD 2014, AutoCAD 2015, AutoCAD 2016 , AutoCAD 2017, AutoCAD 2018,  AutoCAD 2019, AutoCAD 2020, AutoCAD 2021. Verticals with version 2008-2020 like AutoCAD Architecture, AutoCAD Civil Design, AutoCAD Civil Design 3D, AutoCAD Civil Design Professional, AutoCAD Electrical, AutoCAD Civil 3D, AutoCAD Map 3D, AutoCAD Mechanical, AutoCAD MEP, AutoCAD P&ID, AutoCAD Plant 3D, Autodesk Advance Steel and AutoCAD Structural Detailing.
Both 32-bit and 64-bit is supported.
AutoCAD LT is not and will not be supported.

Any database like Access (MDB or .accdb) or SQL Server that can be connected with dbConnect within AutoCAD is supported. Other examples are SQL Server Express,  Oracle, ODBC, etc. AutoCAD 64-bit does only support Access 2010/2013/2016 64-bit or the free Microsoft Office 12.0 Access Database Engine OLE DB Provider/Microsoft Access Database Engine 2010 Redistributable or Microsoft Access Database Engine 2016 Redistributable.
Excel is not supported as it is not a real database.

If you run 64bit AutoCAD you cannot have 32bit Office installed and also connect to MS Access database. If installing Office 64-bit is not an option, some have said that it works to uninstall Office, then install the Microsoft Access Database Engine 2010 and after that install Office again. Another workaround could be to use SQL Server or SQL Server Express as backend and then MS Access 32-bit as a frontend.

Any operating system that can run the above is supported from Windows XP, Windows Vista, Windows 7, Windows 8, Windows 8.1 and Windows 10.

Contact us if support for other CAD software is needed like BricsCAD.

Purchase

New license: 150 USD for one license or less depending on the amount of licenses. When your purchase is completed you will get an email (sent manually) typically within 24 hours with the license file.

When your purchase is completed you will get an email with a link to the download.

Upgrade license: 75 USD for one license or less depending on the quantity of licenses. If you purchased on or after January 1, 2018 the upgrade is free of charge.

If you have really many users that you want to give access to this software we can discuss a discounted price based on your particular situation. Educational discounts available.

The license is perpetual. Support and upgrades is included for a minimum of 2 years after purchase. If you have more than one computer and you are the only user of the application one license is enough. 

Click here to see how to activate the license. 

Documentation

Documentation for version 4.0.5 here.

Setup procedure

Using the JTB ACAD_db <version>.exe installer will install to program into %ProgramData%\Autodesk\ApplicationPlugins\JTBW-ACAD_db.bundle (Sample Access database and drawing in C:\ProgramData\Autodesk\ApplicationPlugins\JTB ACAD_db.bundle\Contents\) 

Loading to AutoCAD will be done automatically and menu available on the Add-ins tab.

Activation

See activation instructions here: JTB World Apps Licensing. 

Usage

Prepare the database that holds information on what block and attributes to synchronize and where.

Make sure there is an UDL file (data source) that points out the location of the main database.

In the CAD program use AcDbSettings command to specify what data source to use as the main database.

Run the AcDbMake command to make new/existing drawing possible to sync.

Now use either just open and save/close the drawing or use any of the commands AcDbOut or AcDbIn to sync information into CAD or out from CAD.

The command line will show full details on if there are any problems and what data has been synchronized.

Tutorial on How to sync block attribute values with a database using ACAD_db.

For more details see the Documentation. 

Version History

• 2020-07-24 - version 4.1.1

  • Upgraded to License 4.3

• 2020-05-09 - version 4.1.0

  • Added support for AutoCAD 2021

• 2019-08-19 - version 4.0.5

  • Added error handler when user adds an invalid column name.

• 2019-07-30 - version 4.0.4

  • Added error notification when the DBID column is missing.

  • Automatically add ParentBlockName and ParentBlockHandle columns.

  • Updated sample database. 
• 2019-07-15 - version 4.0.3
  • Fixed compatibility issue with the new version of the grid.
• 2019-05-28 - version 4.0.2
  • Remember last used selections in Settings window of JTBW_AttSync.
  • Fully upgraded the source code and installation.
  • Settings window of JTBW_AttSync.
• 2019-03-28 - version 3.0 update
  • Support for AutoCAD 2020 based products.
• 2018-04-12 - version 3.0
  • Support for AutoCAD 2019 based products.
  • Added support for future versions of ACE OLEDB database provider
  • Installer added
  • Various bug fixes
• 2012-10-08 - version 2.0
  • Support for AutoCAD 2013 based products.
  • Support for Oracle database.
  • Fixed a sync bug when NETLOAD is used.
• 2010-08-23 - version 1.1 beta
  • Support for MS Access 2010 64-bit and the free Microsoft Office 12.0 Access Database Engine OLE DB Provider.
• 2009-10-26 - version 1.0
  • First public release.

License agreement

The license agreement is found here.

Customers

More customers are found here

About

Make use of AutoCAD Architecture, AutoCAD MEP or AutoCAD Civil 3D more fully in your BIM process. Property Set values can automatically be updated back and forth to one or many external databases. If you make changes to the Extended Data values within a Property Set they can be synchronized back to the external database. Any Property in a Property Set Definition can be exported and all editable Properties can be imported.

ACA_db will improve the BIM process and experience and will improve quality of your data and remove redundancy and conflicts of data.

Download

Try it for free for 30 days. 

ACA_db 6.0.1 ACA 2017, ACA 2018, ACA 2019, ACA 2020 and ACA 2021. Version 6.0

ACA_db_samples.zip Access and SQL Server sample databases.

Script to create MySQL database. 

Alternatively download from Autodesk App Store.

If purchase has been done via Autodesk App Store the download is available on the Autodesk App Store My Downloads page. Sign in with the same account used when purchasing.

Older versions:

aca_db 2017-2020.zip (228KB) ACA 2017, ACA 2018, ACA 2019 and ACA 2020. Version 4.2

ACA_db_2016_4_1.zip (157KB) only for 2016. Version 4.1 supporting 32-bit and 64-bit.

ACA_db_2013_4_1.zip (156KB) only for 2013, 2014 and 2015. Version 4.1 supporting 32-bit and 64-bit.

ACA_db_2010_4_1.zip (159KB) only for 2010, 2011 and 2012. Version 4.1 supporting 32-bit and 64-bit.

ACA_db_2010.zip (236KB) only for 2010, 2011 and 2012. Version 3.0. 32-bit only.

ACA_db_2009.zip (236KB) only for 2009-versions. Version 3.0. 32-bit only.

ACA_db_2008.zip (236KB) only for 2008-versions. Version 3.0. 32-bit only.

Newsletter

Subscribe to our ACA_db newsletter or any of our other Newsletters.

System requirements

AutoCAD Architecture 2021 (ACA 2021) or AutoCAD MEP 2021 (AMEP 2021) or AutoCAD Civil 3D 2021 (and older).

AutoCAD Architecture 2020 (ACA 2020) or AutoCAD MEP 2020 (AMEP 2020) or AutoCAD Civil 3D 2020 (and older).
AutoCAD Architecture 2019 (ACA 2019) or AutoCAD MEP 2019 (AMEP 2019).
AutoCAD Architecture 2018 (ACA 2018) or AutoCAD MEP 2018 (AMEP 2018).
AutoCAD Architecture 2017 (ACA 2017) or AutoCAD MEP 2017 (AMEP 2017).
AutoCAD Architecture 2016 (ACA 2016) or AutoCAD MEP 2016 (AMEP 2016).
AutoCAD Architecture 2015 (ACA 2015) or AutoCAD MEP 2015 (AMEP 2015).
AutoCAD Architecture 2014 (ACA 2014) or AutoCAD MEP 2014 (AMEP 2014).
AutoCAD Architecture 2013 (ACA 2013) or AutoCAD MEP 2013 (AMEP 2013).
AutoCAD Architecture 2012 (ACA 2012) or AutoCAD MEP 2012 (AMEP 2012).
AutoCAD Architecture 2011 (ACA 2011) or AutoCAD MEP 2011 (AMEP 2011).
AutoCAD Architecture 2010 (ACA 2010) or AutoCAD MEP 2010 (AMEP 2010).
AutoCAD Architecture 2009 (ACA 2009) or AutoCAD MEP 2009 (AMEP 2009).
AutoCAD Architecture 2008 (ACA 2008) or AutoCAD MEP 2008 (AMEP 2008).

AutoCAD Civil 3D

Both 32-bit and 64-bit is supported.
Any database like Access (MDB or .accdb) or SQL Server that can be connected with dbConnect within AutoCAD is supported. Other examples are SQL Server Express,  MYSQL, MariaDB, Oracle, ODBC, etc. AutoCAD 64-bit does only support Access 2010/2013/2016 64-bit or the free Microsoft Office 12.0 Access Database Engine OLE DB Provider/Microsoft Access Database Engine 2010 Redistributable or Microsoft Access Database Engine 2016 Redistributable.
Excel is not supported as it is not a real database.

If you run 64bit AutoCAD you cannot have 32bit Office installed and also connect to MS Access database.

Any operating system that can run the above is supported from Windows XP, Windows Vista, Windows 7, Window 8, Windows 8.1 and Windows 10.

JTB World is an Autodesk Authorised Developer

Purchase

New license: 150 USD for one license or less depending on the amount of licenses. 

Upgrade license: 75 USD for one license or less depending on the quantity of licenses. If you purchased on or after January 1, 2018 the upgrade is free of charge.

If you have really many users that you want to give access to this software we can discuss a discounted price based on your particular situation. Educational discounts available.

The license is perpetual. Support and upgrades is included for a minimum of 2 years after purchase. If you have more than one computer and you are the only user of the application one license is enough. 

Purchase Jfrom the Autodesk App Store site.

If purchase has been done via Autodesk App Store the download is available on the Autodesk App Store My Downloads page. Sign in with the same account used when purchasing.

Documentation

Installing

For the version 5.0 or later run the installer. 

Activation

See activation instructions here: JTB World Apps Licensing. 

Usage

Commands:

	AcDbSettings	Choose an ACA_Db master database to sync. This needs to be done once per drawing. Your drawing should be saved after setting.
	AcDbMake	Register current drawing to Database to enable sync attributes data. This needs only to be done once per drawing.
	AcDbIn	Sync values from database based (on sync dir) to Property Set values in the current drawing.
	AcDbOut	Sync Property Set values in the current drawing to the connected database.
	JTBW_ACTIVATE_APPS	Open Activation Form to activate the app. This command is available in command line only. See activation instructions here: JTB World Apps Licensing.