AltiumDesigner integrated library design based on Access database
[Copy link]
This post was last edited by 5zhidandelion on 2022-8-14 18:37
Recently, I was looking at issues related to integrated libraries and found that some of the information on the Internet was not very clear in some places. The following is what I think is more comprehensive, so I would like to share it with you.
The following information comes from the Internet and is not written by me, but it has been verified to be correct.
1. The design methods of Excel database and Access database are similar, but Access database supports online modification of database files (when AD is open), while Excel database does not support it.
2. The Excel database can classify components (classify in Excel table) for easy management.
3. Access databases seem to be unable to be classified. (I haven't found a way to do this. If anyone has a way to do this, please share your opinion.)
Benefits of database integration library:
1. Convenient management;
2. Able to export component number, description, manufacturer, and price information to the BOM table.
Establishing Access database of components
As shown in the figure above, design the field names and data types in the table.
ID is a unique number that identifies a component.
Part Number is the material number that identifies the component
Part Type is the name of the component.
Description is a detailed description of the identified component
Value is the value of the identifier component
Library Ref is the name of the component in the schematic package library
Library Path is the path to the schematic package library that identifies the component
Footprint Ref is the name of the component in the PCB package library
Footprint Path is the path of the PCB package library that identifies the component
Other properties:
Tolerance is the accuracy of the identification component
ComponentLink2URL is the URL that identifies the component
Suppiler is a supporting manufacturer of identification components
Here, I use relative paths for Library Path and Footprint Path.
As shown above:
PCB and SCH library paths, access database files, and DbLib integrated library files are placed in the same directory.
Fill in the component-related information in the Access database and the database will be created.
Since there are many types of components, it will be cumbersome to build a database at the beginning.
Building the DbLib integrated library
As shown in the figure:
Select Database Library
Create an empty DbLib file.
Step 1: Open the Access file.
Step 2: Connect to the database. (When using Access 2007, you need to install the Access Database Engine 2007 support package), otherwise the connection will fail. I put the Access Database Engine 2007 support package in a compressed file.
As shown in the figure above, select Access 2007.
Single Key selects ID, (unique number) , the material number is not a unique number.
Set the Value to Visible.
Import the DbLib integrated library
Figure 1
Figure 2
Set the columns displayed:
Right-click the mouse at the arrow and choose Select Columns.
Add the columns you want to display.
After the settings are completed, the effect is as follows:
Draw an example:
Generate PCB:
Export BOM
As shown below:
The settings are as shown below:
After the settings are completed, click Export to export the BOM.
The BOM table is as follows:
Here, I borrowed the xtl template provided by AD officially.
Add the parameters you need to export in the xtl template.
The xtl template is set up as follows:
= Modify the parameters after that to your own needs. These parameters must exist in the database to be successfully exported.
| 
提升卡
变色卡
千斤顶
京公网安备 11010802033920号
