The code in this repository connects Part-DB-server with Altium Designer. You can define a symbol and up to three footprints (comma separated) for a part under the EDA-Settings (that is originally used for the KiCad API). The parts are then browseable in Altium. Footprints and Symbols remains as files in Altium.
- PartDb is running with mySQL (and you have access to it)
- Altium is connected using ODBC
- Replace the "yourServerName" string in the SQL files with your servername or IP of the PartDb server.
- Setup the views parallel to the tables of PartDb on your mySql-Server. The files starting with "create..." are just a help if needed. HeidiSQL was a good tool therefor.
- src/allParts (required)
- src/datasheets (required)
- src/images (optional, if not used other views (files) have to be edited)
- The views for datasheets/images returns the first datasheet/image that is found for a part. This datasheet url can be used for the symbol (in Altium) as reference (See also: https://forum.live.altium.com/#/posts/258269/833879).
- Setup a ODBC connection mysql ODBC connector with your PartDb database.
- setup a database connection (DbLib) and connect to your database via ODBC
- use the settings from the image "AltiumSettings". Note that in your case the table/view is called "allParts" or the name that you have given.
- the symbols and footprints must be available in file libraries (PcbLib/SchLib)
After setting up the columns you should see something like the following.
- Footprints and Symbols are stored as Library-Files in Altium
- This is just an example and experimental
- The import into Altium is done with "views" wich means that this requires some performance from the database server.
Feel free to dive in! Open an issue or submit PRs.