Batch export/import block info to/from worksheet
Digitally signed app
Free
OS:
Language:
Description
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;
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)
About This Version
Version 1.0.0.2, 3/28/2023
- App can now work properly while multi AutoCAD & AutoCAD verticals instances opened at the same time; No need to track active AutoCAD & AutoCAD verticals instances;
- User can press ESC during processing to terminate a long process;
- Attribute reference in Dynamic block reference now display at proper position after import. No need to manually call ATTSYNC;
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