Batch export/import block info to/from worksheet

Batch export/import block info to/from worksheet

Digitally signed app

Kostenlos
Betriebssystem:
Sprache:

Beschreibung

With this app, block references information can be quickly batch exported to/re-imported from Microsoft® Excel® worksheet.
The typical workflow is Export - Edit - Reimport
Information including:

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

 

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.

Typical working scenarios are:

  • Batch numbering, naming .... sheet layout frame: By using attribute blocks as frames, the user can export them to Excel, edit drawing number/ name/ title... with the help of Excel Autofill feature to finish the attribute values. Re-import those update values and the manual work of adding incrementally is done;
  • Rebuild drawing list from existing attribute block (used as drawing frames);
  • Update coordinate attributes of crosshair block: Export block info, 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;


Note 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).
Note 2: Users don't have to do anything with license registration.

Informationen zu dieser Version

Version 1.0.0.1, 10.06.2022
- Bugs fixed: Warning message is minimized, app sometimes does not recognize the license file at first running, app may not work properly if multi AutoCAD & AutoCAD verticals instances are opened; - Minor improvements: a progress bar is added, block list is now able to suggest items when typing, add a mechanism of checking for active AutoCAD instance; - App is now digitally signed.


Screenshots und Videos


Kundenbewertungen

1 Bewertung
Technische Hilfe erhalten
  • export/import block ATTRIBUTE WITHOUT OPEN FILE
    Manesh Puthiyedath | Juni 27, 2022 Geprüfter Download (Was ist das?)

    Dear sir,

    this is very nice program. i was waiting from long time, sir It is possible to update in next version export/import block ATTRIBUTE WITHOUT OPEN dwg FILE.

    just select from directory. it will save too much time.

    please add a video tutorial aslo.

      thanks.

    NTCL Main (Herausgeber) | Juni 27, 2022

    Thank you for your review, the first review for my apps after ~800 downloads (T_T). 1. About your suggestion, I will consider for the next updates, if possible. Maybe the code need totally rewritten since the export/import speed is really slow, not suitable for multi files processing (I think). 2. About tutorial videos, you can find 2 videos at the end of "Screenshots and Videos" category above.

    Manesh Puthiyedath | Juni 30, 2022

    SIR, THANKS FOR YOUR GOOD REPLY . REGARDING - multi files processing NOT REQUIRE, ONE FILE FROM DIRCTORY AT A TIME UPDATE AND SAVE ONLY. ONE BY ONE ENOUGH. YOU CAN MAKE NEW APPS FOR DIRCTORY UPDATE AND SAVE. HOPE SOON WE WILL GET. THANKS

Nach oben