Dynamic note in a drawing 2

[cliquot22]

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?

 

[ctopher]

Select note, go to "Text Format", select the icon "Insert Hyperlink".

Chris
SolidWorks 10 SP4.0
ctopher's home
SolidWorks Legion

 

[ctopher]

You can also create your own properties.

http://www.solidworkstips.com/content/index.php/solidworks-tips/61-custom-properties

Use the design table in the part file to link the Excel table.
thread559-58647

Chris
SolidWorks 10 SP4.0
ctopher's home
SolidWorks Legion

 

[cliquot22]

Thanks for the solidworkstips link, it was helpful. I can get the variables from my design table into custom properties. But now how do I define custom properties in the design table (see column I). It doesn't like $PRP:"ca1" as a definition of custom property "ca1".

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.

 

[evolDiesel]

Theia,

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

 

[moon161]

To create a custom property,
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.

 

[cliquot22]

EvolDiesel, that method is a bit cumbersome but it does what I need to do. Thanks for the help.