Dynamic note in a drawing
Dynamic note in a drawing
(OP)
I need to create a dynamic note annotation in a drawing. The note should be updated from an excel spreadsheet.
For instance, I have an optical property for a lens that needs to be on the drawing (glass type, aspheric parameters, etc) but it isn't a dimension that I can add to the part. How can I create a note on my drawing that will automatically update its value based on either an external Excel spreadsheet, a custom property that is linked to an external Excel spreadsheet, or a design table in the part file?
For instance, I have an optical property for a lens that needs to be on the drawing (glass type, aspheric parameters, etc) but it isn't a dimension that I can add to the part. How can I create a note on my drawing that will automatically update its value based on either an external Excel spreadsheet, a custom property that is linked to an external Excel spreadsheet, or a design table in the part file?






RE: Dynamic note in a drawing
Chris
SolidWorks 10 SP4.0
ctopher's home
SolidWorks Legion
RE: Dynamic note in a drawing
http
Use the design table in the part file to link the Excel table.
thread559-58647: SW/Excel link
Chris
SolidWorks 10 SP4.0
ctopher's home
SolidWorks Legion
RE: Dynamic note in a drawing
The issue is that I don't use this property in the part file anywhere, but I want it to be on the drawing. It's double the d8@sketch1 dimension.
RE: Dynamic note in a drawing
Try this out:
1. Go into sketch 1 and draw a construction line. Dimension it.
2. Add an equation that makes your dimension equal to twice your D8@Sketch1 dimension.
3. Add a custom property (2xD8) and for the expression click on your dimension
4. Go to your drawing. Create a note. Type in the following:
5. Here's what it should look like...
Jack Lapham
Engr Sys Admin
Dell M6400 Covet (24 Season 8, Ep 22)
Intel Core 2 Duo T9800, 2.93GHz, 1066MHZ 6M L2 Cache
8.0GB, DDR3-1066 SDRAM, 2 DIMM
1Gb nVIDIA Quadro FX 3700M (8.17.12.5896)
W7x64 | sw-01: 55.92
SolidWorks x64sp4 in PDMWxE
RE: Dynamic note in a drawing
File > properties > Edit List, I think.
You could probably add the custom property to your part template, so it's automatically there for each new part.
RE: Dynamic note in a drawing