Skip to main content

TL Title Block

Todor Latev

TL Title Block

Todor Latev

Automatically update Autodesk® AutoCAD® title block attributes from a Microsoft Excel spreadsheet.

$20.00/year

The TLTitleBlock for Autodesk® AutoCAD® app is designed to eliminate the tedious and error-prone manual task of keeping drawing title block attributes in sync with a centralized Excel project registry. No more exporting/importing attributes!

Once properly set up it provides two non-interactive "one-click" commands to update all title block attributes with the contents of your project Excel spreadsheet:

  • TLTitleBlockUpdateCurrentLayout - updates all title block attributes on the current layout with the contents of the project Excel file
  • TLTitleBlockUpdateAllLayouts - invokes the TLTitleBlockUpdateCurrentLayout command on all Layouts found in the current drawing

Upon invocation, the app will check whether the required custom properties are found in the current drawing and if so will look for and read the contents of the configured project Excel file sheet. Then it will scan the drawing Layout for Title Block references and if found will match and update all block attributes with the contents of the Excel sheet. Finally, if user commands are configured the app will invoke each one once per drawing layout.

All of the above steps are instantaneous and require no input from the user.

Features:

  • "One-click" functionality - fully automated, non-interactive interface
  • Fast Excel file read functionality provided by ExcelDataReader
  • Four different Log Level Modes supported: Error, Warning, Info, Debug
  • Designed to be used in a multi-disciplinary, corporate environment
  • Support for special fields in the Excel file path
  • Per drawing project Excel file with multiple layouts supported
  • Third-party document management systems support
  • Designed to be as generic as possible to accommodate multiple workflows
  • Slots for up to three user commands provided

What's included:

  • Full setup documentation with detailed instructions (offline only)
  • Sample project title block file
  • Sample project drawing
  • Sample 'propulate template file
  • Sample Excel spreadsheet file

Please refer to the TLTitleBlock Help Document for setup/workflow instructions

Details

Operating system

win64-platform-icon

Release date

Jun 18, 2021


Last updated

Apr 11, 2023


Version

2021.11.26


Language

English

Compatible with

ACD-icon

ACD

2019, 2020, 2021, 2022, 2023, 2024

CIV3D-icon

CIV3D

2019, 2020, 2021, 2022, 2023, 2024

ACAD_E-icon

ACAD_E

2019, 2020, 2021, 2022, 2023, 2024

BLDSYS-icon

BLDSYS

2019, 2020, 2021, 2022, 2023, 2024

AMECH_PP-icon

AMECH_PP

2019, 2020, 2021, 2022, 2023, 2024

ARCHDESK-icon

ARCHDESK

2019, 2020, 2021, 2022, 2023, 2024

Capabilities

Blocks

Data extraction

Documentation

Analysis and simulation

Tags

Reporting

Scheduling

Frequently asked questions (FAQs)

4. Existing drawing setup (Optional)
In the case of an existing project with a number of drawings already generated probably the easiest method to integrate the TLTitleBlock App is to take advantage of the PROPULATE Express tool most likely already installed along with your main Cad product.

From the official Autodesk documentation:
"Allows quick, automated population of the data fields in the Drawing Properties dialog box. This data is displayed with the DWGPROPS command or when viewing the properties of a DWG file with Windows Explorer.
Drawing Property data can be updated, listed or removed from the current drawing or a folder of drawings."

A custom dwg properties template can be created and easily applied to existing drawings thus providing the necessary initial configuration. Refer to the sample .PRP file provided.

Excel file access functionality
The App relies on functionality provided by the 'ExcelDataReader' and 'ExcelNumberFormat' .NET packages, available under the MIT license.
Excel file cell values are physically stored as numbers in the file along with their format strings and formatted according to regional/custom format settings upon displaying in Excel. The App attempts to process certain data types and their corresponding formats, however, results may vary from their native Excel representation. Therefore for best results, the recommended way to format the Excel table is to use Strings as data types in which case no further formatting will be necessary.

The following cell data types are currently supported: String, DateTime, Double, Float, Decimal, Int16, Int32, Int64, Boolean, Byte, Char

For questions/comments/suggestions/bug reports etc please email to: Todor.Latev@gmail.com

Found an issue?

Report a problem