JTB BatchAttEdit

JTB BatchAttEdit

Win32 and 64, English

JTB World Inc.
Powerful spreadsheet app to batch edit attributes of blocks across multiple drawings.

General Usage Instructions

  • Run JTB_BatchAttEdit command from the command line or from the ribbon button on Add-ins (or Plug-ins) tab.

  • JTB BatchAttEdit window will show up. On the left panel, there are drawing lists and a log text box. On the right panel, there are block name wildcards, and a wide spreadsheet to display and edit attributes.

  • Enter Block Name Wildcards. You can specify more than 1 wildcard by separating them with ";". E.g. *title block*; *A3*. Click the drop-down arrow button to access recent wildcards that you have entered.

  • Click the "Add" button to add drawings to a drawing list. This also triggers the app to scan all drawings. Firstly, it finds blocks that match the block name wildcard. Then, in each found block, attributes will be collected and shown on the spreadsheet.

  • Hint: after scanning the drawings, the log text box will list all block names in all drawings. If you don't find your block in the spreadsheet, check this list and edit your block name wildcard, hit Enter key to scan drawings again.

  • Check or uncheck the Attribute Sync option. If Attribute Sync is checked, attributes of each found block will be synced with the block definition. Attributes that are not in definition will be deleted. Missing attributes will be created, using a default attribute value.

  • Right-click on a drawing list and/or spreadsheet to access the popup menu of commands.

  • When working on the spreadsheet, you can select multiple cells, and use keyboard shortcuts Ctrl+D to copy a cell down; Ctrl+R to copy a cell right; Ctrl+L to copy a cell left; Ctrl+C and Ctrl+V to copy and paste the text. Undo and Redo features are also available via Ctrl+Z and Ctrl+Y keyboard shortcuts.

  • Finally, click "Apply Attribute Changes".

Screenshots

Commands

Ribbon/Toolbar Icon Command Command Description

JTB_BatchAttEdit

JTB BatchAttEdit window will show up. Select drawings, and enter block name wildcards. Then the app will scan all drawings, collect attributes in all blocks that match the block name wildcards, then display them in a wide spreadsheet. Edit those attribute texts as you are working with Excel. Once done, click "Apply Attribute Changes". Attribute values will be updated to drawings.

JTBW_Activate_Apps

Use this command to activate the app.

Installation/Uninstallation

The installer that ran when you downloaded this app from Autodesk App Store will start installing the app. Or, double-click the downloaded installer to install the app. You may need to restart the Autodesk product to be able to run the app.

To uninstall this app, exit the Autodesk product if you are currently running it.

On Windows 11 and 10 version 1703 or later press Windows+I on the keyboard to access Settings or click or right-click the Windows Start button and then select Settings. Click on Apps (optionally followed by Apps & features). On older Windows versions click Control Panel > Programs > Programs and Features or Control Panel > Add.

Additional Information

Known Issues

This app doesn't work with nested Mleaders. Contact us if you have the need for this functionality. 

We got one report that the parts list in Autodesk® AutoCAD® Mechanical was broken. It did not happen all the time so it might be due to other things than JTB BatchAttEdit. 

Contact

Company Name: JTB World Inc.
Support Contact: info@jtbworld.com

Author/Company Information

JTB World Inc.

Support Information

For support visit our Contact page.

Version History

Version Number Version Description

4.8.0

Added support for Autodesk® AutoCAD® 2024. Fixed error in Copy and Paste non attribute cell on the spreadsheet.

4.7.0

Licensing bug fixed. (no version change).

4.6.0

Added AutoCAD 2023 support.

4.5.2

Minor improvements in options.

4.5.1

Minor improvement: added option to set up a default location for export.

4.5.0

Added "Clone selected blocks" command. Fixed editing position error: attributes didn't move with host block. Enhanced multi-line attribute editing UI.

4.4.0

Enhanced column filter. Fixed shading in highlighted modified cells. Fixed error when using (Ctrl + C) to copy more than one cells in a row, but (Ctrl + V) paste only the first cell.

4.3.1

Export to Excel: prompt text row moved to header cell's comment (i.e. cell note)

4.3.0

Exporting to Excel: format sheet as table with auto filter. Detect architectural length texts when sorting column. Fixed an overflow bug in natural sorting. Fixed a bug made length shown as ".5" instead of "0.5".

4.1.1

Fixed an error in working session initialization.

4.0.0

New features added: edit insertion points and dynamic block properties. Working session can be saved to file. Modified cells are highlighted and many more enhancements in the UI.

3.6.0

Added AutoCAD 2022 support

3.5.0

Enhanced the display and editing of fields Fixed FillWeight error in spreadsheet if 650+ attribute columns is loaded. Added natural sorting option

3.4.0

Fixed bug: attribute exported to Excel was converted to date and lost its original text value. Fixed bug in multiple wildcard filter. Sorting upgraded to detect numbers. Fixed bug show/hide columns setting is not saved within a session.

3.3.0

Fixed edit MLeader error in AutoCAD Upgraded to License 4.3

3.2.2

Minor change

3.2.0

Added AutoCAD 2021 support

3.1.1

Fixed error when attribute can't be edited if tag contains space.

3.1.0

Under the [Add][+] menu, new "Select blocks on screen" option is added for you to edit a selection, rather than the whole drawing.

3.0.2

Fixed a critical bug in loading the spreadsheet Solved an issue in the network license

2.5.4

Added AutoCAD 2020 support. Upgrade of the installation.

2.5.3

Fixed an unhandled error.

2.5.2

Fixed an error when importing empty cells, value = null.

2.5.1

Added "Options In Detail" window to clarify the process. Added "Fit All Columns" command button. Fix bug when Block Name Wildcards are multiple wildcards separated by ;. Minor UI enhancement

2.4.0

Added support for MLeader's block.

2.3.0

Added quick scan option to speed up the process in case a drawing has thousand blocks. Zoom to block: including thaw its layer if layer is frozen (with a message at command prompt), Fixed the Open File Dialog to include link source files Fixed issue in a case the [Zoom To] and [Select Block On Screen] buttons are disabled while they should be enabled. Fixed bug since version 2.1: can't clear attribute value. Other minor issues fixed.

2.2.0

Fixed error dynamic block not shown in the list. Enhanced the spreadsheet to show very long attribute text. Removed wrong log text of Import routine.

2.1.0

Add support for Autodesk® AutoCAD® 2019 Add support for editing multiline attribute. Add support for editing field code in attribute

2.0.0

Added Import / Export to Excel. Add filter for each column. Fix bugs in columns of attributes with similar tag. Find block on screen. Zoom to selected block Fix bug if block is on locked layer. Enhance performance. Fix bug in some automation cases.

1.0.0

First release
Go top