Altium NEXUS Documentation

Including Design Data in the Excel BOM

Modified by Susan Riege on Apr 11, 2017

All Contents
Design data can be passed from Altium NEXUS into an Excel Bill Of Materials by including special statements in the Excel template used to create the BOM.

For detailed information about creating a Bill of Materials, click here.

When creating the Bill of Materials template in Excel, a combination of Fields and Columns can be used to specify the desired layout. Several example templates are provided with Altium NEXUS in the \Templates folder of the installation user-files. A full list of available fields is provided below.

Fields

Fields provide project-level information. These are not usually attached to each item in the BOM, but are often used in the header of the document. Fields are used in the format Field=FieldName (e.g., Field=Currency). The available fields are:

  • Currency
  • DataSourceFileName
  • DataSourceFullPath
  • GeneratorDescription
  • GeneratorName
  • OutputName
  • OutputType
  • ProductionQuantity
  • ProjectFileName
  • ProjectFullPath
  • ReportDate
  • ReportDateTime
  • ReportTime
  • Title
  • TotalQuantity
  • VariantName

Columns

Columns provide information that is supplied on a per-component basis, and would usually appear on each line in the BOM. Columns are used in the format Column=ColumnName (e.g., Column=Description). Column information can be taken from several sources, including:

  • Default component parameters (such as Designator or Description).
  • User-defined parameters added to components.
  • PCB data.
  • Supplier data.

These are discussed separately below.

Default Parameters

The following columns are provided for all components:

  • Comment
  • ComponentKind
  • Description
  • Designator
  • DesignItemId
  • Footprint
  • LibRef
  • LogicalDesignator
  • PartType
  • PhysicalPath
  • Quantity
  • UniqueIdName
  • UniqueIdPath  

Document Parameters

The following document parameters are available for all components by default. They are obtained from the schematic document that contains the component.

  • Address1
  • Address2
  • Address3
  • Address4
  • ApprovedBy
  • Author
  • CheckedBy
  • CompanyName
  • ConfigurationParameters
  • CurrentDate
  • CurrentTimeDate
  • DocumentFullPathAndName
  • DocumentName
  • DocumentNumber
  • DrawnBy
  • Engineer
  • ImagePath Index
  • ModifiedDate
  • Organization
  • Revision
  • Rule
  • SheetNumber
  • SheetTotal Time

PCB Parameters

Pick and Place information can also be included from the PCB. In order to use these columns, the checkbox Include Parameters From PCB must be enabled in the Bill Of Materials Report Manager dialog.

  • Center-X(Mil)
  • Center-X(mm)
  • Center-Y(Mil)
  • Center-Y(mm)
  • Layer Pad-X(Mil)
  • Pad-X(mm)
  • Pad-Y(Mil)
  • Pad-Y(mm)
  • Ref-X(Mil)
  • Ref-X(mm)
  • Ref-Y(Mil)
  • Ref-Y(mm)
  • Rotation

Supplier Data

In Altium NEXUS, it is possible to retrieve online data from suppliers and feed that into the BOM. Note that these are updated live and are retrieved when the BOM is generated. Multiple suppliers can be set up for each component. 

  • Manufacturer x
  • Manufacturer Part Number x
  • Supplier x
  • Supplier Currency x
  • Supplier Order Qty x
  • Supplier Part Number x
  • Supplier Stock x
  • Supplier Subtotal x
  • Supplier Unit Price x

Custom Parameters

Additional information also can be imported from a database library or from parameters added to components by the user. In these cases, simply use the parameter name as the column name.

 

Found an issue with this document? Highlight the area, then use Ctrl+Enter to report it.

联系我们

联系原厂或当地办公室

We're sorry to hear the article wasn't helpful to you.
Could you take a moment to tell us why?
You are reporting an issue with the following selected text
and/or image within the active document:
Altium Designer 免费试用
Altium Designer Free Trial
我们开始吧!首先,您或者您的公司已经在使用Altium Designer了吗?

如果您有任何需求,请点击这里联系获取当地办公室销售代表联系方式。.
Copyright © 2019 Altium Limited

既然您在使用Altium Designer,为何仍需要试用?

如果您有任何需求,请点击这里联系获取当地办公室销售代表联系方式。.
Copyright © 2019 Altium Limited

好的,实际上您无需下载一个试用版本。

点击下方按钮下载最新版本的Altium Designer安装包

下载Altium Designer 安装包

如果您有任何需求,请点击这里联系获取当地办公室销售代表联系方式。.
Copyright © 2019 Altium Limited

填写下方表格,获取Altium Designer最新报价。

点击[获取免费试用],并同意我们的隐私政策。您会接收到来自Altium的资讯,并允许其改变您的通知首选项。

如果您是Altium维保期内客户,您不需要下载试用版本。

如果您不是Altium维保客户,请填写下方表格免费试用。

点击[获取免费试用],并同意我们的隐私政策。您会接收到来自Altium的资讯,并允许其改变您的通知首选项。

您为何想要试用Altium Designer?

如果您有任何需求,请点击这里联系获取当地办公室销售代表联系方式。.
Copyright © 2019 Altium Limited

那您来对地方了!请填写下方表格申请试用吧。

点击[获取免费试用],并同意我们的隐私政策。您会接收到来自Altium的资讯,并允许其改变您的通知首选项。

Great News!

Valid students can get their very own 6-month Altium Designer Student License for FREE! Just fill out the form below to request your Student License today.

点击[获取免费试用],并同意我们的隐私政策。您会接收到来自Altium的资讯,并允许其改变您的通知首选项。

好的,您可以下载免费的Altium Designer Viewer查看文档,有效期6个月。

请填写下方表格申请。

点击[获取免费试用],并同意我们的隐私政策。您会接收到来自Altium的资讯,并允许其改变您的通知首选项。

好棒!创作是一件超酷的事情,我们可以为您提供完美的设计软件。

Upverter是一个社区导向的交流平台,专为您这样的创客量身定做。

点击这里看看吧!

如果您有任何需求,请点击这里联系获取当地办公室销售代表联系方式。.
Copyright © 2019 Altium Limited

好的,您可以下载免费的Altium Designer Viewer查看文档,有效期6个月。

请填写下方表格申请。

点击[获取免费试用],并同意我们的隐私政策。您会接收到来自Altium的资讯,并允许其改变您的通知首选项。