| Author |
 Topic  |
|
|
Brandon
United Kingdom
15 Posts |
 Posted - 15 Apr 2015 : 15:58:39
|
Hi,
I did find some previous posts on this matter, but I dont believe there was ever a full answer.
If I generate a BOM, the BOM contains separate lines of the same library part.
Even parts from the EASYPC library (R-SM) 10K, just taken from the component bin and added around the schematic.
This also happens to parts I have created, yet again, they are just copied from the components bin, so should be identical.
I'm using 17.07. I understand 18 has a new fangled report creator, does this have the same issue? can I fix my 17.07 to create a BOM with single line identicals?
Brandon |
|
|
edrees
United Kingdom
779 Posts |
Posted - 15 Apr 2015 : 16:25:15
|
Until BOM Composer was released in V18, BOM creation was always a bit of a hit and miss affair. After hours and hours of experimentation I did eventually get the pre-V18 BOM reports to work as I expected (I still have the template file if you want it).
Upgrade to V18 just for the BOM Composer feature, -it's well worth it! |
 |
|
|
Brandon
United Kingdom
15 Posts |
Posted - 15 Apr 2015 : 16:36:49
|
Hi,
Yes I would appreciate your template, if you have a copy still.
Yes the V18 update is tempting, but as I'm using this at work, I have to convince the powers that be to spring for the upgrade.....
Brandon
Brandon |
|
|
|
edrees
United Kingdom
779 Posts |
Posted - 15 Apr 2015 : 16:53:48
|
Save the following as "My_BOM.rft"in My Documents/Easy-PC/Report Templates.
Then call it up using Output=>Reports where it should appear under User Reports. Hope it gives you what you require.
(ReportTemplate
(Header
(Version 2)
(Context 3)
)
(Variants
(VariantMode 0)
(VariantName "")
)
(TEXTBLOCK
(TEXT
(STRING "Bill of Materials")
(NEWLINE TRUE)
(UNDERLINE TRUE)
)
(TEXT
(STRING "")
(NEWLINE TRUE)
(UNDERLINE FALSE)
)
(DESIGNHEADER)
)
(CompList
(SETTINGS
(CSV TRUE)
(CSVQUOTED TRUE)
(CSVSEPARATOR ",")
(HEADERCAPTIONS TRUE)
(HEADERUNDERLINE TRUE)
(KEEPREPEATS FALSE)
(GRANDTOTAL TRUE)
(REVERSEROTATION FALSE)
(SELECTIONMODE 0)
(IGNORESUPPRESSION FALSE)
)
(COLUMN
(FIELD PARTNAME) (ALIGN LEFT)
(CAPTION "Component")
(COLLATE FALSE)
(COLLATESEPARATOR "")
(WIDTH 30)
(SUM FALSE)
(PRECISION 0)
(VISIBLE TRUE)
(TEXT "")
(JOINCOLUMNS FALSE)
(JOINSEPARATOR "")
(NEWLINE FALSE)
)
(COLUMN
(FIELD PACKAGE) (ALIGN LEFT)
(CAPTION "Package")
(COLLATE FALSE)
(COLLATESEPARATOR "")
(WIDTH 10)
(SUM FALSE)
(PRECISION 0)
(VISIBLE TRUE)
(TEXT "")
(JOINCOLUMNS FALSE)
(JOINSEPARATOR "")
(NEWLINE FALSE)
)
(COLUMN
(FIELD ATTRIBUTE
(NAME "VALUE")
(NAME "R")
(NAME "C")
(NAME "L")
)
(ALIGN LEFT)
(CAPTION "Value")
(COLLATE FALSE)
(COLLATESEPARATOR "")
(WIDTH 20)
(SUM FALSE)
(PRECISION 0)
(VISIBLE TRUE)
(TEXT "")
(JOINCOLUMNS FALSE)
(JOINSEPARATOR "")
(NEWLINE FALSE)
)
(COLUMN
(FIELD QTY) (ALIGN RIGHT)
(CAPTION "Qty")
(COLLATE FALSE)
(COLLATESEPARATOR "")
(WIDTH 10)
(SUM TRUE)
(PRECISION 0)
(VISIBLE TRUE)
(TEXT "")
(JOINCOLUMNS FALSE)
(JOINSEPARATOR "")
(NEWLINE FALSE)
)
(COLUMN
(FIELD BLANK) (ALIGN LEFT)
(CAPTION "Blank")
(COLLATE FALSE)
(COLLATESEPARATOR "")
(WIDTH 3)
(SUM FALSE)
(PRECISION 0)
(VISIBLE TRUE)
(TEXT "")
(JOINCOLUMNS FALSE)
(JOINSEPARATOR "")
(NEWLINE FALSE)
)
(COLUMN
(FIELD COMPNAME) (ALIGN LEFT)
(CAPTION "Name")
(COLLATE TRUE)
(COLLATESEPARATOR " ")
(WIDTH 20)
(SUM FALSE)
(PRECISION 0)
(VISIBLE TRUE)
(TEXT "")
(JOINCOLUMNS FALSE)
(JOINSEPARATOR "")
(NEWLINE FALSE)
)
(GROUP
(FIELD PARTNAME)
(ORDER ASCENDING)
(TOGETHER TRUE)
)
(GROUP
(NAME "Value")
(ORDER ASCENDING)
(TOGETHER TRUE)
)
(GROUP
(FIELD COMPNAME)
(ORDER ASCENDING)
(TOGETHER TRUE)
)
)
) |
|
|
|
Brandon
United Kingdom
15 Posts |
Posted - 16 Apr 2015 : 09:27:39
|
Hi,
That's great, thank you, yes it does the trick.
Brandon |
|
|
| |
Topic |
|
BOM Reports