2 Properties in one cell

Discussion created by Guest on Jun 27, 2006
Latest reply on Feb 27, 2013 by Anthony Sambrano

Like • Show 0 Likes0
Comment • 8

Whenever our reseller created our drawing layout, they used 2 properties for the description ("description 1" & "description 2") in order to create 2 lines on the drawing... for word wrapping on the drawing. Well, that's all fine and dandy, but now when we put a part into a BOM that uses both description properties, we're not getting the full description since the BOM will only read and display "description 1."

I looked in the excel BOM Template, but it uses the cell names to control the property for that column and won't let me put both properties in that column. Is there another way to get it to show both properties in one column??

Thanks

Outcomes

8 Replies

Guest Jun 27, 2006 10:38 AM
Your description is confusing, but I'm guessing that perhaps the Concatenate function is what you need. Also, if you're using Office 2002 (as opposed to Office 2000) you might note that Excel has gotten a lot pickier about what kind of data it will allow in certain circumstances -- notably with Concatenate. I forget whether it's Text format or General format which WILL work (whereas the other won't).

Another instance of Micro$oft's dubious "enhancing" of their products.
EditDeleteLike • Show 0 Likes0
Actions
Guest Jun 27, 2006 10:38 AM
Read this: http://forum.solidworks.com/swforum/b.asp?m=30428

or

search " Multiple Custom Property" in Archive BOM
EditDeleteLike • Show 0 Likes0
Actions
- Andrew Carter @ Guest on Jan 15, 2007 10:49 AM
  That link seems to have died with the new forums. Can someone help me find it please!
  Like • Show 0 Likes0
  Actions
John Burrill Jan 15, 2007 11:22 AM
I don't think you'll be able to accomplish that directly using a Solidworks BOM and I've always found Excel BOMs difficult to manage, but I might have a work around for you.
Make a third property in your model file called FullDescription or something like that and make it's value: $PRP:"Description1" $PRP:"Description2"
Obviously, substitute your property field names for Description1 and Description2 and make sure that you match the case as well as the spelling. I tried it out, it works, pretty good.
Good luck
John
Like • Show 0 Likes0
Actions
- Andrew Carter @ John Burrill on Jan 15, 2007 12:02 PM
  It does work is the SolidWorks BOM, I have done it before.
  
  Except that now I need to do it again, I have forgotten how!
  Like • Show 0 Likes0
  Actions
Steve Hanwright May 8, 2007 9:52 PM
I cut this from a nother posting in this forum.

For Column properties, selectEquation and in the Equation box type
$PRP:"Property1" $PRP:"Property2"
Don't use the equation editor.

thanks to the original poster .

Steve h
Like • Show 0 Likes0
Actions
- Greg Van Arsdale @ Steve Hanwright on May 16, 2007 4:13 PM
  Does that approach ever give you issues with ubdesirable word wrapping ?
  Our apprroach addresses that issue. Here's how we do it.
  
  1. create a custom file property called Combined_Description
  
  2. Create a BOM template that has a column labeled description, but actually calls for the Combined_Description.
  
  3. Create a text file (wordpad) that simply lists the 2 parent custom file properties on the first 2 lines....
  
  $PRP:"Description_1"
  $PRP:"Description_2"
  
  I keep mine on my desktop, and it is the first file I open each morning, I highlight the text, edit-copy, then minimize the file.
  
  4. Back in SW, add the Combined_Description custom file property, and click in the Value/Text Expression cell, and Control+V. It will look like there is only one line of text in there, but they are both present.
  
  5. Insert your BOM template into your assembly drawing, and there it is !
  Like • Show 0 Likes0
  Actions
  - Anthony Sambrano @ Greg Van Arsdale on Feb 27, 2013 8:19 AM
    I've tried this approach for a 2-line description display and it works just fine. The only time it doesn't is when I have a sub-assembly. I've put this Combined_Description property in my sub-assembly but it doesn't show the value in my BOM. Would you know why this isn't working for sub-assemblies? Seems it should work the same as parts but it doesn't.
    Like • Show 0 Likes0
    Actions

2 Properties in one cell

Outcomes

Related Content

Recommended Content