Bom Export

I might be able to help with this one:  on the left of the BOM configuration window there are lists of 'grouped columns' and 'all columns'.  You'll need to find the field that contains the part number and check that the 'show' box is ticked.  You can drag the field name from 'all columns' to 'grouped columns' if you want to group components with the same part numbers.

I hope that helps.

You can create a Excel Template File so you can create automatically with some klicks a complete BOM. But before you create the BOM you must create a Component Library. Every element in my library get some parameter like this:

• Addition 1
• Addition 2
• Addition 3
• Addition 4
• Addition 5
• Alternative allowed
• Checked by
• Manufacturer
• Manufacturer Part Number
• Mounting Type           
• Package
• ROHS               
• Status
• Supplier 1
• Supplier 2
• Supplier 3
• Supplier Part Number 1
• Supplier Part Number 2
• Supplier Part Number 3
• Type
• Version

One example for a Capacitor :

Name                               Value

Addition 1                        10pF

Addition 2                        ±5% 

Addition 3                        50V  

Addition 4                        C0G 

Addition 5                        Surface Mount

Alternative allowed          No   

Manufacturer                  Kemet

Manufacturer Part Number    C0603C100J5GACTU

Mounting Type              Surface Mount

Package                        0603 (Case-EIA)

ROHS                             ROHS Compliant

Supplier 1                        Digi-Key

Supplier 2                        Digi-Key

Supplier 3                        Mouser

Supplier Part Number 1    399-1049-1-ND

Supplier Part Number 2    399-1049-2-ND

Supplier Part Number 3    80-C0603C100J5G

Temperature Coefficient    C0G

Tolerance                        ±5%

Type                             SMD Ceramic Capacitor

Value                             10pF

Voltage Rated              50V

This is my BOM:

This is my empty BOM Template:

Sorry Frog this was already done.   I used the word Number for the title in the parts library.   It is show up in the left corner and the column but it does not export correctly.

Hi Michael

I believe I have done this already.   Manufacturer works fine.   Do you have to uses the word Manufacturer Part Number?  I have not add most of what you did for your parts either, but I am not really interested in using that info on my BOM right now.

Daniel

Can you show a screenshot?

'Column=Designator

'Column=Quantity

'Column=Type

'Column=Manufacturer

'Column=Manufacturer Part Number

'Column=Package

In this directory are some example templates

C:\Users\Public\Documents\Altium\CS\Templates

• BOM Manufacturer.XLT
• BOM Purchase.XLT
• BOM Variant Template.XLT
• BOM Simple.XLT

All parameters you want to export must be checked. See Arrow

But you'd think that if the heading is present in the spreadsheet then the data should be there too.  Daniel's screenshot appears to indicate that the headings are there but the content isn't.  Daniel, have you tried exporting as CSV and then inspecting the file with a text editor.

I still don't know what the problem was but when I try it in a new project it works fine.   It seems to have some thing to do with that project.   I will try what Frog says tomorrow when I have access to the old project. I also had problems with it giving all of the components.     Thanks guys for trying to answer it.  Right now I see nothing wrong with it.