Thissample uses AWS S3 storage to host client files and initiates forge design automation to compare two AutoCAD drawings, results the output drawing back to client, the output drawing contains visual graphical difference.
I read a few articles here and there regarding a way to generate multiple drawings from an excel file, but no one had explained step by step on how to do it. So, I am lost half way. I am very new to this kind of things, but I will try to follow, so please go slow on me.
I blieve I understand you, a shape 3 side a shape 4 side a shape 5 sides you can not have a auto solution, (you can but not right now) you need to post a excel that means something not just var1 var2 var3 etc we dont have a clue. I am more than happy to say you can draw an object from excel data, but it must make sense. The example I posted as a beam 4 lines and holes in it just cahnge some numbers in excel and get next beam.
Your solution is not what I am after and I am not planning to enter coordinates to DRAW anything but only to replace text/Block/etc within the original shop drawing and print out all the rest in either pdf or dwg into a folder.
Ok my final real big hint others know what I am talking about search here for "SHAFT" & Excel. Autocad about 10+ years ago supplied a sample drawing called "shaft" and a excel called "shaft" change the values a cell in the excel and watch the drawing of a shaft change in Autocad. I have no idea why they no longer put it in their samples.
When a .dwg file contains VBA macros, a Compound File Binary Format file (what I like to call an OLE file) is embedded inside the .dwg file. This OLE file contains the VBA macros. It's similar to .docm files, except that a .dwg file is not a ZIP container. More details on the file format can be found in my blog post "Analyzing .DWG Files With Embedded VBA Macros", but knowing these details is not a prerequisite to be able to perform an analysis as I show here.
This .dwg file that I was given contains indeed a VBA project, but it's an empty project, without actual code (remark indicator m for stream 3 and that stream 3 doesn't contain "real" VBA code, just the normal attributes).
I'm no longer an AutoCAD specialist (I used AutoCAD and AutoLISP a lot in the 90's), but as far as I know, subroutine names like Auto_Open, AutoOpen and Workbook_Open do not trigger automatic execution in AutoCAD. One needs to associate a subroutine with an AcadDocument event to trigger execution.
Like this sample, with exactly the same VBA source code (ignoring whitespace). This malicious Office document was submitted to VT one month earlier than the malicious AutoCAD drawing. And if we can trust the medata data of the Office document, then it's almost 2 years old.
So if you use AutoCAD in your organisation, know that drawings with embedded, malicious VBA code seem to be rare (caveat: my search was far from exhaustive), and that with modern versions of AutoCAD, VBA no longer comes pre-installed.
Welcome to the Autodesk Factory Design Utilities tutorials. This tutorial allows you to sample some advanced layout functionalities and efficient layout design workflows available in the Factory Design Utilities.
This tutorial workflow offers a one-to-one synchronization between your 2D AutoCAD drawings and 3D Inventor assembly models. Changes made in the 2D AutoCAD drawing propagate to the Inventor 3D layout, and changes in the 3D layout propagate back to the original 2D drawing. The bidirectional workflow provides veteran AutoCAD users with a familiar, easy-to-learn process for generating compelling 2D and 3D Factory layouts.
In Tutorials 1 through 3, we'll work through the basic 2D-to-3D workflow that is unique to Autodesk Factory Design. During the exercises in each section, we will use the 2D workflow in AutoCAD to easily create a rough layout of a work cell. When 3D elements are needed, we can use the Cross-Product Workflows tools to open your design in the Inventor environment where 3D modifications are easy to apply. Once the design is complete, the Cross-Product Workflows tools allows you to update all AutoCAD drawings. All of your layout's Factory Design data is also stored in a LayoutData file, keeping your data connected, centrally located, current, and up to date.
Specify changes to multiple drawings in Excel. Click a button to create a control file and run the command in Autodesk AutoCAD to do the work for you. AutoGen creates new drawings based on one or more template drawings based on the control file.
In the process text, mtext, and block attribute values can be changed individually on each new drawing. AutoIns inserts text, blocks or xrefs into drawings based on the control file. AutoUpd updates existing drawings based on the control file. In the process text and attribute values can be changed individually on each new drawing. For further documentation visit JTB World's JTB CAD Automation Tools page.
AutoGen creates new drawings based on one or more template drawings based on the control file. In the process text, mtext, and block attribute values can be changed individually on each new drawing.
The copy button can be used to copy sample files that are in (%ProgramData%\Autodesk\ApplicationPlugins\JTB-CAD Automation Tools.bundle\Contents\JTB CAD Automation Tools) to the C:\JTB CAD Automation Tools folder.
Run the JTBW_Activate_Apps command in AutoCAD on the command line to activate the app after purchase or to extend a trial. Follow the instructions and email JTB World for the license activation key.
The installer that ran when you downloaded this app from Autodesk App Store will start installing the app. Or, double-click the downloaded installer to install the app. You may need to restart the Autodesk product to be able to run the app.
On Windows 11 and 10 version 1703 or later press Windows+I on the keyboard to access Settings or click or right-click the Windows Start button and then select Settings. Click on Apps (optionally followed by Apps & features). On older Windows versions click Control Panel > Programs > Programs and Features or Control Panel > Add.
Reset JTB CAD Automation Tools.reg in the JTB CAD Automation Tools folder can be used to reset the file locations used by JTB CAD Automation Tools. This can be useful if any of the commands do not work as expected.
The following guidelines give a detailed step by step overview of how to set up your drawings for in AutoCAD Software. You can download a demo copy for free that you can use for up to 30 days.
If using our materials, we recommend using our drawing templates, they help to verify scale and material type. Materials come in all different sizes depending on the maximum sheet size supplied from the manufacturer.
Try and use templates that suit best the scale of your drawings. i.e. if your components can fit within a 1000mm x 500mm template, do not position your drawing on a 2000mm x 1000mm template with lots of excess.
If you have lots of small components from the same material, it is best to draft these on a series of smaller templates approximately 1000mm x 500mm rather than on one large template. Cutting & engraving densely populated files over large areas can cause the material to warp during the process.
If you have elements of your drawing that will only fit onto a large template but do not need to use a whole sheet, just leave the remaining areas blank. We will only charge you for the amount of material you need.
For all materials, we have established optimized settings. In vector engraving terms the marking is cosmetic. Our optimum settings are shallow and typically a balance between legibility and cleanliness. (The Strokes & Fonts sample (0.25pt) on the material pages demonstrates the clarity achievable on each material.)
It is rare to raster engrave from drawings drafted in AutoCAD, but it is possible. As it is a purely vector-based program no lines can be raster engraved. Make sure all your lines you require to be engraved are set to vector engrave.
We have established optimized settings for all materials. In raster engraving terms the marking is cosmetic, shallow and typically a balance between legibility and cleanliness. The Strokes & Fonts sample on the material pages demonstrates the clarity achievable on each material.)
If you would like to achieve a deeper result or an engraving a little heavier let us know your specification. In laser terms depth is usually specified in microns. Our standard engrave is approx. 0.25 microns (depending on material) and has excellent legibility.
It is achievable, but the laser must run slowly meaning the concentrated heat build-up makes the material appear quite burnt / heat scorched. It is also more expensive to process. Raster and vector engraving is not an absolute science in terms of depth specification and therefore not suitable for making mechanical grooves or any features requiring precise depths. Achieving a certain depth is balance in variation between the laser power and speed. A depth of engraving will always be within a tolerance of +/-0.2mm.
This is particularly important when scaling architectural drawings from real scale using a scale factor. Be sure to check your cut widths on your scaled drawing before sending. Something drawn in real scale (e.g., a window frame) might scale to a width that will not hold together when laser cut. You might need to adapt these details slightly as a compromise.
When drafting your drawing ensure that there are no duplicate vector strokes stacked up on one another. If you do not get rid of them the laser will cut / score these lines repeatable, ruining the material and damaging the laser bed.
The material drawing templates already have the material category name and reference rectangle dimension by default, you will just need to enter your individual material specification and drawing name. Make sure you give easily identifiable names to your drawings:
3a8082e126