Linked properties in General Table

[Treads0322]

Hi all,

One of my company's major fields is producing fiberglass parts (FRP). As part of a push to better track expenses, we're calculating the inputs (resin, cloth, gelcoat, etc.) and their value for each part. So far that's happening in a bunch of calculation spreadsheets but eventually I'd like to move to capture it in the drawings (my dept). I've set up a general table with what I need, but I filled it by linking several cells to custom part properties (which I'm going to fill with a macro, that lets you pick the color, thickness, etc.). So far, so good. When I save the table template, it imports with all the calculations but none of the linked properties. Is there any way to make that part of the template, or will I need another macro or alternate method to re-link those each time I insert the table?
Thanks!
-Mark

 

[SBaugh]

I am having trouble following your process... Are you linking the Custom properties of a part to an external Excel sheet, or is the data inside a Design table within the Part file?

The other question is are you using SW PDM or another type of PDM system?

Scott Baugh, CSWP
Mechanical Engineer
Ciholas

https://www.ciholas.com/

"If it's not broke, Don't fix it!"

faq731-376

 

[drawoh]

Treads0322,

You should be able to interrogate SolidWorks and extract the volume of your part, as a parameter. If you add the percent fibre, you can work out the volume of resin and fibre in your finished product. This does not account for wastage. Are your CAD guys going to fill in your data?

--
JHG

 

[Treads0322]

@SBaugh - the goal is to show the data from a custom property in the .sldprt in a general table on the drawing. Desired result is below:

Here are the properties feeding it:

The surface area is filled by a global variable which takes SW-calculated surface area of the part. All the qty values are calculated by formulas in the table.

My goal is to save the table format so that I can insert it into a new drawing, associate it with a view, and keep the custom property links. Right now those cells all come out blank; the only cells that are filled are the plain text (header / row titles and units column) and the formulas (all zero since the sq. in. property is missing). If there's no way to save that linked property in the .sldtbt, then I'll create another macro to fill that out rather than doing it by hand, it's just a step I was hoping to find a workaround for.

Yes I'm using PDM, do you see that making a difference to use of the table template?

@drawoh - as above, I'm interrogating SW for the surface area and calculating the rest from that, including a % multiplier for wastage. The challenge is getting the linked property into the table without manually filling setting the value for that cell for each drawing.

 

[ctopher]

Add the table to the drawing template. Add custom props to table and parts. When add the parts to the dwg, it should read the props.

Chris, CSWP
SolidWorks
ctophers home

 

[Treads0322]

@ctopher Good suggestion! I like that option for new drawings; we don't currently have separate templates based on part type, but I have some similar work to do with providing more stock material information for sheet metal parts, so it may save some time to create all of these as separate templates. Unfortunately, I still have to deal with existing drawings, as we frequently copy an existing part / drawing and change the color or trim for a new project, but if I have to use a macro to fill those I'll live with it.

 

[SBaugh]

With PDM you might be able to add some of that data into the data card. I use an equation in my BOM to know which part number to use. It can either be our CPN number or Supplier number, by using a single check mark in the data card. "IF(`Purchased`=0;`CPN`;IF(`Purchased`=1;`Sup_PartNo`;`CPN`))".

Most of my custom properties are controlled from the data card. Then I link the BOM or areas of the drawing to the custom properties of the part or assembly that is supplied from the Data card. It might be nice to have that data linked to the card giving someone easy access to read the data there instead of looking at the drawing/table.

Scott Baugh, CSWP
Mechanical Engineer
Ciholas

https://www.ciholas.com/

"If it's not broke, Don't fix it!"

faq731-376