TopSolid'Forum

Hi!

There is property “MATTER_GRAIN_ORIENTATION” in TopSolid and I use it in many BOM templates. But I’d like to replace “YES” and “NO” values with “1” and “0” ones to avoid manual correction of table during BOM exporting to cutting machine. What do you think – is it possible?
I use two languages of TopSolid interface and I see that there are different values for this property in these interfaces – YES for English/ANO for Czech and NO for English/NE for Czech. It means that there is a chance to find configuration file or file of dictionary. I tried but I’ve not found it yet.

Are you exporting to excel or text for the output format?

Hi, Todd

I export BOMs to Excel.
It' possible to use Excel functions - I uderstand (if you mean it). But I'm just looking for chance to change a "few letters" in *.cfg or *.dic files to solve this situation. If there is no "internal" TopSolid way I'll develop "external" Excel one. (Sometimes I'm afraid of changes of standard templates because there are few TS users in our company, two languages of TS interface and many templates of BOMs and drafts ).

Yeah I understand. but odds are that the change your TopSolid files could be difficult if its evaluating it as a string/text and your try to convert it to an integer
NAME=MATERIAL_GRAIN_ORIENTATION
"DEF=<MATTER_GRAIN_ORIENTATION>"
TYPE=STRING try change this in your bom template to TYPE=INTEGER
ALIGN=LEFT
TITLE_ALIGN=LEFT
WIDTH=0.0127
VISIBLE=YES
;

Are you trying to show whether or not your material has grain orientation (being yes/no or 1/0) or are you trying to show the driver that you've used to drive grain orientation on your parts?

Try editing your BOM in TS and instead of using (TopSolid'Design - Material and Coating --> Material Grain Orientation) use
(TopSolid'Design - Physical Properties --> Grain orientation).

Or simply manually edit your BOM template and change "DEF=<MATTER_GRAIN_ORIENTATION>" to "DEF=<PART_GRAIN_SENSE>" and TYPE=INTEGER

I think what you're getting currently and this method both reference if you've set your material to have grain orientation when you manage materials.

Hi!

<PART_GRAIN_SENSE>" + TYPE=INTEGER - is exactly what I need.

Todd, JReimers, thank you for your help.