Batch export/import block info to/from worksheet
Digitally signed app
Description
Remarks:
Since version 1.0.3, App is installed to %AppData%\Autodesk\ApplicationPlugins folder instead of %ProgramData%\Autodesk\ApplicationPlugins folder. The first session of AutoCAD and/or verticals after updating will have to update some registry keys due to path change, the App will NOT work in this session. Please close and re-open AutoCAD and/or verticals. The app will work properly from the second session onwards.
*
With this app, block reference 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, and 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;
Notes:
- 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);
- Users don't have to do anything with license registration;
- An enhanced version of this App, which performs much faster & can process multi-drawing files is published Here (Paid App, perpetual license)
Thanks for the idea of using Excel to edit block. It helps me a lot.
However, it would be better if the App run faster.
It saves me a lot of time manually editting attributes.
Thank you for your reply.
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.
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.
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