AD应用自定义BOM料单模板 |
您所在的位置：网站首页 › 脚本的模版 › AD应用自定义BOM料单模板 |
AD应用自定义BOM料单模板
|
1.新建一个Excel，并在自己设计对应的区域填入 字段=字段名字 2.字段的第一类是Field，用于映射项目信息，BOM表头以及文档和项目参数。 可用的系统级字段名字有： 字段描述CurrencyThe currency that has been chosen in the Supplier Options region of the Report Manager dialog.DataSourceFileNameThe filename of the source used for the BOM data.DataSourceFullPathThe full path + filename of the source used for the BOM data.GeneratorDescriptionFor a BOM, this field displays Bill of Materials.GeneratorNameName of the generator - BOM when output is generated by the Report Manager.OutputNameTitle of the BOM, as displayed in the Report Manager (excluding the text “For BOM Document []”).OutputTypeFor a BOM, this field displays BOM_PartType.PCBDataSourceFileNameThe filename of the PCB data source.ProductionQuantityProduction quantity defined in the Report Manager dialog.ProjectFileNameName of the PrjPcb file (including file extension).ProjectFullPathFull path + the project filename.ReportDateDate on which the report was created.ReportDateTimeDate and time at which the report was created.ReportTimeTime at which the report was created.TotalQuantitySum of the values in the BOM Items Quantity column.TitleTitle displayed at the top of the BOM Reports dialog.VariantNameName of the variant, as defined in the Variant Management dialog.VersionControl_RevNumberCurrent revision of the BomDoc.VersionControl_ProjFolderRevNumberCurrent revision of the project (incremented when a Commit Whole Project is performed).Displays the value assigned to the user-defined UserProjectParameter-n.可用的文档和项目字段名字： Address1，Address2，Address3，Address4， ApprovedBy，Author，CheckedBy，CompanyName， ConfigurationParameters，CurrentDate， CurrentTime，Date，DocumentFullPathAndName，Docu mentName，DocumentNumber，DrawnBy，Engineer，ImagePath，Index，ModifiedDate，Organiz ation，Revision，Rule，SheetNumber，SheetTotal， Time 字段的第二类是Column，用于映射BOM的条目信息。 component参数的字段名字有: Comment，ComponentKind，Description，Designator，DesignItemId，Footprint，LibRef，Logical Designator，PartType，PhysicalPath，Quantity，UniqueIdName，UniqueIdPath， PCB的component参数的字段名字有: Center-X(Mil)，Center-Y(Mil)，Center-X(mm)，Center-Y(mm)，Pad-X(Mil)，Pad-Y(Mil)，Pad-X(mm)， Pad-Y(mm)，Ref-X(Mil)，Ref-Y(Mil)，Ref-X(mm)，Ref-Y(mm)，Layer，Rotation 供应商数据的字段名字有: 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 以及用户自定义的字段名 下面给出两个实例图片: 第一张图为模板的字段=字段名字设置: |
第二张图是导入BOM之后的效果: 
Excel填写完成之后还得将此Excel粘贴到AD软件安装目录->Templates目录下，之后进入AD元件BOM料单管理之后，点开template列表即可看到自己的BOM模板，选中进行导出就完事了！
最后附上AD官网的连接: AD官网BOM料单模板连接【本文地址】
今日新闻 |
推荐新闻 |