TurboCAD Forums

The Ultimate Resource for TurboCAD Knowledge

Register
 
Be sure your post is relevant to the current discussion.  Create a new topic within the appropriate board if you are unsure.

BoM Numbering
Read 404 times
* July 16, 2017, 09:38:34 AM
I can create a bill of material through the database report but.... 

How do you match the part numbering to the associated part description in the BoM?

Up to now I've just been manually adding a column and typing the numbers in but now I have around 20 parts in the BoM and am looking for a way to do this automatically.

Thank you,

Matthew

Logged
Just a hobby user.
TurboCAD Vr. 18.2 Platinum
TurboCAD Vr. 2015 Platinum
TurboCAD Vr. 2016 Platinum
PC - Intel i7, 3.2 GHz, 32GB RAM, Window 10 64bit
Graphics ATI Radeon HD 5700 Series, 1GB RAM


* July 16, 2017, 10:53:32 AM
#1
Would adding a property set using auto interger work?
https://turbocaddoc.atlassian.net/wiki/display/T2UG/Property+Set+Definitions
« Last Edit: July 16, 2017, 11:22:27 AM by nikkipollard »

Logged
Nikki
TC20 platinum
TC 2015 platinum
TC 2017 with lightworks


* July 16, 2017, 11:19:43 AM
#2
Would adding a property set using auto interger work?

I don't know lol...... I looked at that and entity marks but unfortunately I'm going to need specific set up instructions as reading the pdf manual there is something I'm not comprehending to make it work...... 

Matthew

Logged
Just a hobby user.
TurboCAD Vr. 18.2 Platinum
TurboCAD Vr. 2015 Platinum
TurboCAD Vr. 2016 Platinum
PC - Intel i7, 3.2 GHz, 32GB RAM, Window 10 64bit
Graphics ATI Radeon HD 5700 Series, 1GB RAM


* July 16, 2017, 08:15:07 PM
#3
I can create a bill of material through the database report but.... 

How do you match the part numbering to the associated part description in the BoM?

Up to now I've just been manually adding a column and typing the numbers in but now I have around 20 parts in the BoM and am looking for a way to do this automatically.

Thank you,

Matthew

Matthew,
are you looking for a "quantity" from a "summary" report?
I think there's a bug in 64 bit.
I use 32 bit for all database work.
Your question could mean a few different things, can you be more specific.

Logged
"What do I know, I'm still learning"..
Windows 7 64 bit HP > on a stock HP laptop with 4gb-2.4 GHz.Turbocad 2016-2017, TurboCad Platinum 21(Best working version,IMHO) Using Lightworks for reliability/stability and testing redsdk, Anilab lab 5, Renditioner Pro V3. ATI Mobility Radeon HD 4500/5100


* July 16, 2017, 10:34:06 PM
#4
I also use 32 bit for database stuff.
I do think you want to use property sets. They have the advantage over "custom properties" as you can use the information in conjunction with entity marks to label your items too. I presume the parts are in blocks. Unfortunately, you cant use groups with property sets.
step 1
In the style manager palette
go to property set definitions
click the new icon (at the top)
give your property set a name (I called mine "part")
click the empty block under value and a palette should pop up
tick block reference. (bottom section)
There are a few types of property sets you can choose from
"Automatic" - would be attributes that are already known about the block ie: name, layer, colour etc
 "manual" would be user defined ie manufacturer, part number etc
I mainly use "text" or "auto increment integer" or "auto increment character"
Click on manual choose the type of property from the drop down list
give it a name and a default value. You can have a list of definitions for one part.

Step 2
Make the block used for the entity mark.

Use block attributes in the block.
the tag needs  the name of the property : the name of the definition
eg part:number
create block

step 3

define entity mark definition in the style manager
give the entity mark a name
then click on the empty space below value
click on add and choose the block you want to use as your entity mark.
on the right you can select the angle you want to see the entity mark from ie: the top, left or right view.
So you can have 3 different blocks showing different definitions depending on the angle you are viewing the part from.- that gets complicated though.

step 4
select the items in your drawing that you are going to give these properties to.
in the selection info palette under general, property sets click the value column next to property sets and choose the property set you want to use.
You can change the values for each item individually here.

use the entity mark to label the items.

This seems a lot of effort.
but if you set them up in your template then you only have to do it once.


« Last Edit: July 16, 2017, 10:36:07 PM by nikkipollard »

Logged
Nikki
TC20 platinum
TC 2015 platinum
TC 2017 with lightworks


* July 17, 2017, 02:20:02 PM
#5

are you looking for a "quantity" from a "summary" report?
I think there's a bug in 64 bit.
I use 32 bit for all database work.
Your question could mean a few different things, can you be more specific.

Dean,

I'm able to get the quantity with a summary report in 64 bit.  The only issues I have come across so far is there is a row add for total count of all parts and it puts the title row in even though the table style omits it.

For more specific explanation see red text in attached png. for example.

Nikki,

Thank you for the instructions.

In this case everything should be a block.

I'll work with them and see how it goes.

Matthew





Logged
Just a hobby user.
TurboCAD Vr. 18.2 Platinum
TurboCAD Vr. 2015 Platinum
TurboCAD Vr. 2016 Platinum
PC - Intel i7, 3.2 GHz, 32GB RAM, Window 10 64bit
Graphics ATI Radeon HD 5700 Series, 1GB RAM


* July 17, 2017, 04:24:50 PM
#6
Nikki,

Here is what I got on the first run through your instructions. I assume the entity marks considered separate from the objects in the report is the 64bit bug?<--- Because they are seperate based on the report criteria I had at the time.

Matthew

Edit: I have it working but both the 32bit and 64bit I can't sort the auto integer column. The auto integer also comes out like "(1 0 0)" not "1" in the report.
« Last Edit: July 17, 2017, 07:07:54 PM by RCFlyingKnight »

Logged
Just a hobby user.
TurboCAD Vr. 18.2 Platinum
TurboCAD Vr. 2015 Platinum
TurboCAD Vr. 2016 Platinum
PC - Intel i7, 3.2 GHz, 32GB RAM, Window 10 64bit
Graphics ATI Radeon HD 5700 Series, 1GB RAM