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?
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
Regards,
Artem Taturevych
Application Engineer at Intercad
http://intercad.com.au/
Tel: +61 2 9454 4444
RE: Two part properties in one BOM 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
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
RE: Two part properties in one BOM cell
RE: Two part properties in one BOM cell
RE: Two part properties in one BOM cell
Then, right click the BOM and "save as"
RE: Two part properties in one BOM cell
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
RE: Two part properties in one BOM cell
Chris
SolidWorks 11
ctopher's home
SolidWorks Legion
RE: Two part properties in one BOM cell
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
-Dustin
Professional Engineer
Pretty good with SolidWorks
RE: Two part properties in one BOM cell
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
=`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
Eric
RE: Two part properties in one BOM cell
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
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
RE: Two part properties in one BOM cell
RE: Two part properties in one BOM cell
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