×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Two part properties in one BOM cell

Two part properties in one BOM cell

Two part properties in one BOM cell

(OP)
I'm trying to create BOM template for our company. We would like to have a part description in two different languages in one BOM cell (german over english or something similar). I have created custom property file for properties creation with two different properties for part description. Now I would like to create BOM template.

I've tried everything. thread559-101590: Carriage Return has helped me a lot but I can't copy carriage return symbol. I think that it has to do with older SW versions, because that thread is quite old. I can get two properties in one cell in same line with equation writen like this:
=`German description property`{}`English description property`

Can someone help me with dividing this two into separate lines. And maybe one more question. I create new BOM template and I lock row heights and column widths and then I save this as new BOM template. When I insert this BOM template next time, column widths are not locked. Can someone tell me why?

RE: Two part properties in one BOM cell

try ctrl+Enter to move the value to new line in cell.

Regards,
Artem Taturevych
Application Engineer at Intercad
http://intercad.com.au/
Tel: +61 2 9454 4444

RE: Two part properties in one BOM cell

Excuse me, just realized that you are asking for different thing

Regards,
Artem Taturevych
Application Engineer at Intercad
http://intercad.com.au/
Tel: +61 2 9454 4444

RE: Two part properties in one BOM cell

I'm not sure how to do what you're asking.
Can you create an external Excel BOM and insert it into your drawing?

Chris
SolidWorks 11
ctopher's home
SolidWorks Legion

RE: Two part properties in one BOM cell

(OP)
No, we would like to have standard SW BOM template, not excel BOM. I think it should be possible to get two properties in two different lines, I just need the symbol for carriage return to put it between two properties in equation definition. If that kind of symbol exists. I also still didn't find out how to keep column widths locked in BOM template...

RE: Two part properties in one BOM cell

I know this isn’t the answer you are looking for, but could you just add a column to the BOM for the 2nd language? This would give you a column for German desc, and a column for English desc.

RE: Two part properties in one BOM cell

(OP)
This is an option. But how do you do that to save BOM template? Can you describe?

RE: Two part properties in one BOM cell

Link

Then, right click the BOM and "save as"

RE: Two part properties in one BOM cell

(OP)
I'm sorry. I missunderstood you. I thought you said to add another row for another language. That is not possible to save as template, as far as I know, because when I insert that BOM template, that manually created row is gone. I curentlly don't want to add another column, beacuse of space limitations in my BOM. It seems such a simple problem, but yet it is hard to find anything to solve it.

What about my second question? Locking BOM column widths. Always when I enter BOM template, columns become unlocked...

RE: Two part properties in one BOM cell

Do you have the Tools > Options > Document Properties > Tables > Use template settings option selected?

RE: Two part properties in one BOM cell

Maybe configurations in each part that have the languages in the properties, then show the configs in the BOM?

Chris
SolidWorks 11
ctopher's home
SolidWorks Legion

RE: Two part properties in one BOM cell

(OP)
CorBlimeyLimey: Yes, I have Tools > Options > Document Properties > Tables > Use template settings selected, so I don't see why columns don't stay locked. Can someone tell me if he is experiencing same problem (maybe it is a bug).

ctopher: Thanks for idea, but that is too complicated at the time. We would like to manage this without configurations.

RE: Two part properties in one BOM cell

Save the BOM template as a different name. Is the BOM already inserted into your standard drawing template? If so, update it and then resave the drawing template.

-Dustin
Professional Engineer
Pretty good with SolidWorks

RE: Two part properties in one BOM cell

Create a new part property using concatenate two different property along with a carriage return or simply property with both description and carriage return in part property itself and then use that directly into the BOM..

Deepak Gupta
CSWE, CSWP, CSDA
SW 2012 SP5.0 & 2013 SP 1.0 EV
Boxer's SolidWorks™ Blog
SolidWorks™ Rendering Contest

RE: Two part properties in one BOM cell

(OP)
It works! At least I solved the problem with two properties in separate lines. I will try to explain. You select column type as equation. Then you write an equation with two custom properties. If you want to have these two properties in same line you define equation like so (be aware of space between quotation marks!):
=`1st property`{}" "`2nd property`

Now if you want to have 2nd property in new line you have to write equation like so:
=`1st property`""`2nd property`
Here you have to copy carriage return symbol between quotation marks. But there is a problem to get that symbol. I found a way around. When you edit BOM head you can type something into new line with "Alt+Enter". We can use this. When you are defining equation for two line column you write in this order:
1) Select 1st property from custom prperties
2) Then type "
3) Then select that BOM head description where you used "Alt+Enter". You will see that it has a symbol between two written words. You delete these words, so you have only symbol for carrige return.
4) Type another "
5) Select 2nd property from custom properties
6) It works!
6) Save template

I hope it is understandable. If not I will try to explain it better.

Still don't have solution for column locking. ShaggyPE's solution doesn't work. It bothers me because when a property is long enough it will adapt column width beacuse it is not locked.

RE: Two part properties in one BOM cell

You should be able to generate the carriage return symbol by holding down the ALT key, typing 0010 on your number pad, and releasing the ALT key. It has to be the number pad and not the numbers at the top of the keyboard.

Eric

RE: Two part properties in one BOM cell

EEnd - Eric,

Good tip with the Alt Key. I knew that was a way to do it but forgot the #### code 0010 used.

The BASWUG or Boston Area SWUG or "SolidWorks User Group" had a town hall type meeting with The Product Development Team and a few of the Software Developers and the Carriage return via Alt #### method was mentioned. I suggested using a Shift + Enter technique which works on g00gle talk and some other chat and email applications so hopefully the Alt technique won't be required for too long.

Alt+248 on numpad gives º
Alt+171 on numpad gives ½
Alt+172 on numpad gives ¼

Alt+176 on numpad gives
Alt+177 on numpad gives
Alt+178 on numpad gives

For all you Baseball Fans out there check out this simple baseball diamond
---♦---
-♦(•)♦-
....⌂...

Open Notepad using "Lucida Console" as font and the symbols will work for that font but not all fonts.

"It's not the size of the Forum that matters, It's the Quality of the Posts"

Michael Cole
Boston, MA
CSWP, CSWI, CSWTS
Follow me on !w¡#$%
@ TrajPar - @ mcSldWrx2008
= ProE = SolidWorks

RE: Two part properties in one BOM cell

Why not make two BOM templates, one for your native language, one for german.
Insert the required BOM (You have a choice option on inserting BOM).

Alas- you will anyway have to decide, if resulting drawing should have german or other language.
The german BOM could be a copy of the first, where you replace the column with the text/title etc.. Not a difficult thing to make, nor to keep up for maintenance.

Regards

Morten K. Thillemann

RE: Two part properties in one BOM cell

(OP)
I know, but our philospohy is to make documentations in two languages, mostly in Slovenian and English, so we keep ourselves from double work. We have custom property file with original name and foreign name properties, so this is fast made. This BOM template I made now works great. Thanks for help, but I couldn't get to work that Alt+0010 combination. My solution works good...

RE: Two part properties in one BOM cell

(OP)
I forgot. If someone will tell me why BOM columns don't stay locked when I save BOM template, I will be very happy. If I find the solution before, I will post it.

RE: Two part properties in one BOM cell

JerinG,

I have the same problem, I have to make a BOM with two languages. I follow your tips and works in a single cell

Did you make your BOM like the one in attachment? I would like to make a BOM, that each item row was divided in two, in some cells, and in them the names were written in each respective language. I would like also, that the abbreviations ENG / GER appear as in the example.

RE: Two part properties in one BOM cell

(OP)
HugoCarmo: You can't have a line between two properties that are in two lines in same cell. I've tried this in many ways, but it doesn't work. Or if maybe someone will find out how to do it.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources