Hello
I am trying to customize a BOM. What I would like to do, is to add headers.
I would like the BOM in the picture:
To look more like this, with a header:
I would like for it to look like that every time I create a BOM on a drawing, with all the information as the first picture shows, so I can export it to Excel.
Any ideas are welcome.
Is it possible, not possible?
I can't seem to add rows above the existing header and I can't move it either.
Yes, I can insert a general table, insert a BOM and align them, but they are not one table. They can still be seperated.
Can they be linked to eachother or combined in to one table?
How would I go about a sketch block?
Could I create a BOM, with the links to weldment length etc., as a sketch block?
Here are some working options
With SW Bom tables:
You cannot do it with SW Bom tables functionality only. You can automate the process somewhat.
API Insert TBL1 & 2,Import data into TBL1, Export TLB 1 & 2, Merge data in EXCEL
With EXCEL Bom tables:
You can have a single table but you need to automate the process to input the header information.
Elmar
Addendum:
If your table header is conform to a set layout, then I would suggest you do:
- Make a general table template with all the cell info linked to component or drawing
- Insert the general table and give it a name
- Make a general BOM template & nsert it manually (you can read the coordinates of your first table and use it to place the bom instead)
- Name the BOM table
- Make an EXCEL sheet and add the code to read out the given general table and BOM and insert into EXCEL
I don't know much about API.
How do I automate the process of inputing the header info?
How do I link info from a component to a cell in a general table?
Will the linked general table fill in the info, just like the BOM?
Could I hypothecially, create a general table, that would read the info from a part/assembly file?
So it would look like a BOM?
how about modifying one to what u want it to be, and saving as a template
I can modify it, but I can't add multiple headers.
Hi, Marc
You are not the first
how to display density in bill of material
Now it`s impossible to do, but we`ve created ER for this, look here please Idea!Add ability to add additional rows to BOM header
That's true. I was hoping for some inspiration, maybe som ideas.
I did write an ER about multiple headers. Now I just really need the ability to add and modify headers.
Hi Marc,
No default option. But you can use either a second general table or a sketch block and linke the cell value to document properties.
Then attach the BOM to it. If you have special column alignment requirements then you will need to manually do that.
Column width control is dependent on your font type & size but also on linked cell syntax i.e. $PRP:"XXXXXX"
You can export both tables and merge them in excel.
Elmar