JTB Batch Change for AutoCAD JTB World

JTB Batch Change brings the AutoCAD ActiveX Object Model to your command via Excel design spreadsheets. Some feature examples are:

With Batch Rename Objects you can rename layers in hundreds of drawing by substituting text “Concrete” with “CONC”, or add a prefix of “AC ” to each layer’s name

With Batch Find and Replace you can find and replace text on multiple drawings.

You can import and update all blocks from a standard drawing to hundreds of other drawings.

You can replace all inserted blocks “DOOR-BD3” in layer “Archs” with block “DOOR-AC1”, and move them to layer “ARCH-FURN”

You can change all texts whose styles are not prefixed with “ELEC” to “ELEC Standard” style, then change all block’s attributes whose tag is “DATE” to current date.

You can for example change color and layer of all entities or specific entities like tex, mtext, dimensions. The options are almost endless.

You can convert all your inserted blocks from dynamic to static, or to anonymous blocks.

You can flatten all your drawing objects by setting all Z coordinates to 0.

You can Unload or Detach xrefs or change their name, file name or path.

You can update blocks like title blocks including their attributes with new ones. Guide, Sample Excel file, Sample DWG file.

Batch change drawing properties

Batch Change layers and their properties on many drawings.

Batch change attribute tags in title blocks and retain values.

Additionally, you can perform Batch Audit and Purge as well as much more.

When done with a batch processing you can see what has been processed in the log.

Advanced functionalities with formulas to change settings like layers on some objects

There are 6 working spreadsheets:

1. Rename spreadsheet: help you work with named object. You can rename, purge and audit Drawings; rename, delete, replace, merge Blocks, Layers, TextStyle etc. in selected drawings.
2. Find and Replace spreadsheet: find texts in AutoCAD Texts, MTexts, Dimensions, Attributes and Table, then replace it with other texts.
3. DwgProps spreadsheet:
   –  Change drawing properties
   –  Add or remove custom drawing properties
4. Import spreadsheet: import Blocks, Layers, TextStyles, Linetypes, DimStyles and/or PageSetups from standard drawing to your selected destination drawings. Current definitions in destination drawing will be overridden/redefined. Layer properties like On/Off or Freeze/Thaw will also be imported from the standard drawing.
   –  For example: you redefine some of your door blocks in a Master Plan.dwg and want to update those new block definitions to other drawings.
   –  Go to Import sheet, choose a row and then select one of the Block commands.
   –  Click “Select source drawing” and set the cell on the same row to Master Plan.dwg path
   –  Go to Find column and set it to Door*. If Find column is empty, it assumes all blocks.
   –  Click Run
   –  The app will run WBLOCK exports all Door* blocks from Master Plan to a temp folder. Then, it opens each drawing in your selected drawing list and import overwrite new block drawings to them
5. Change spreadsheet: This spreadsheet will drill deeper in to object properties to find value and make change.
6. Change CrossTab spreadsheet: Similar to the “Change” spreadsheet, but this sheet will show objects properties in a crosstab table, easier to use. Also, especially on this sheet, the command button of “Populate Objects Properties To Current Sheet” is available in the Run >>> Select commands and drawings window. With that command, similar to “Run”, but instead of find objects and change them, the app populate found objects properties to itself, so you can have a closer detail look to the objects, and determine to create more specific change commands.

This is a great tool in the hands of AutoCAD users or CAD managers.