Enhanced block info to/from worksheet

Enhanced block info to/from worksheet

Digitally signed app

付费应用
操作系统:
语言:

描述

Enhanced version can work with multi-drawing files without opening on screen

A two-way (read & write back) lite version of Data extraction command with the help of Excel® Autofill

Best for:

  • Batch filling Title block attributes with the help of AUTOFILL.  No more complicated Sheet set FIELDS are required.
  • Read and update devices status with Multiple Visibility States dynamic blocks.

The typical workflow is Export - Edit - Reimport.

For Multi files processing, it's not necessary to open the drawing on-screen or manually select Excel data range, just add files to the list, fill in parameters per file, then export or import.

For active drawing processing, the drawing should be active, Excel data range should be pre-selected before export or import.

Exported /imported Information includes:

  • Block insertion point (X, Y, Z) & rotation angle (in radian)
  • Block attributes
  • Dynamic Properties

 What's new in this App

  • Unlike classic commands (ATTIN, ATTOUT), this app can extract coordinates, and layout names which are useful for sorting block refs.
  • Unlike the new powerful DATAEXTRACTION command, this app can re-import values from worksheets to update existing drawing block refs. Also, exporting/importing procedures are minimized to save time;
  • The enhanced version now supports multi-file processing with jet speed (10x-20x times faster than Free version)

 

Typical working scenarios are:

  • Batch numbering, naming .... title block refs: By using attribute blocks as a title block, users can export attributes (drawing number/ name/ title ...)  to Excel, and edit attributes... with the help of Excel Data sort & Autofill feature. Re-import those updated values and the nightmare manual work of incremental numbering is done with ease.
  • Rebuild the drawing list from the existing attribute block (used as drawing title block).
  • Update coordinate attributes of block references: Export block refs' positions, copy new coordinate values X Cad, Y Cad columns to attribute column; re-import from Excel to update.
  • Exported block coordinates can be used for inquiry Station- offset, use Station offset for further sorting/editing.
  • Read, update electrical, hydraulic ... devices status in a network.

 Notes:

1. This app cannot create new block references, just export - edit - reimport to update objects. Block reference objects are recognized by their Handle property (some kind of object ID in a specific drawing).

2. To create a new block from Excel data, users can try this App for free, unlimited time: Batch attribute block ref. creation from worksheet 

3. User can run this App with:

(a) A simple signing-in parent Autodesk® application with a valid Autodesk® ID that did the purchase.  In this way, the user can run this App from any computer, provided that an internet connection is available; or

(b) An offline license file that is physical computer hardware dependent. After purchasing, please run this App, open the About... panel, and manually copy & send your registration info to the NTCL support email NTCLApp1@gmail.com. For more details, please refer to the License registration Guide.

4. During waiting for an offline license file, this App still runs with full functions;

5. For purchasing volume of 50 or more licenses, assuming that all PCs work in the same local domain network, a specific domain-based license may be distributed instead of an individual license if required and such a domain-based license is technically feasible.

6. Users will get a message if this App package is launched from a virtual machine. App launched from a virtual machine will be limited in features.

关于此版本

版本 2.0.10.0, 2023/3/28
Bugs fixed: - Multi file processing option cannot export data to Excel if Excel is in edit mode - Unexpected exporting result in single sheet mode if 3 or more different blocks with different field (attribute, dynamic property) names are exported - Unexpected exporting result when first block has more fields than the second block - App won't work if Excel is closed after App is opened - Wrong number of Block refs. processed when importing - "Load Active Workbook" button discards unsaved content of opening workbook which saved to disk before - Esc key cannot terminate export/ import action, user click yes then the action still continue - When import from Excel, dynamic block references of the second drawing onwards are reset or got wrong dynamic properties - Reload last state button does not work properly - Single file processing mode does not filter block references properly - Attribute values are sometime changed accidentally because of Excel auto-format. - Confused license status report when signing-in to parent application & running App without an offline license file. Improvements: - Add an option "Uni Header": Combine all fields of all blocks from all drawings into a unique header row (nearly the same as Data Extraction command result) - Allow user to export data from multi block per one drawing - Better support Multi visibility state dynamic block: invisible attributes in a specific state won't be exported or imported. - Mtext attribute now export value without format code - Add 2 commands: Load and Save configuration to the context menu which appears when right click inside tables - Allow user to set value for some selected cells in Block name or Source column (Ctrl+Click to select cells, Right click in the last selected cell) - App starts with Multi file processing mode


屏幕截图和视频


客户评论

1 评论
获取技术帮助
  • Powerful, huge time saver
    Dung Le Van | 二月 14, 2023 验证的下载 (这是什么?)

    Amazing simple solution for batch numbering, naming bunch of drawing title blocks.  It may be much better if online office (like Google Sheet) is supported.

    NTCL Main (发布者) | 二月 22, 2023

    Thank you for your review & suggestion.

回到页首