Two part properties in one BOM cell 1

[JerinG]

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 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?

 

[ArtemTat]

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

 

[ArtemTat]

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

 

[ctopher]

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

 

[JerinG]

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...

 

[CADFlyer]

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.

 

[JerinG]

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

 

[CADFlyer]

Link

Then, right click the BOM and "save as"

 

[JerinG]

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...

 

[CorBlimeyLimey]

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

 

[ctopher]

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

 

[JerinG]

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.

 

[ShaggyPE]

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

 

[Gupta65]

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

 

[JerinG]

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.

 

[EEnd]

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

 

[mjcole]

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

 

[MortenDK]

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

 

[JerinG]

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...

 

[JerinG]

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.