"connection_string": " DATABASE=file:///media/cioma/my/project/kicad/library/kicad.sqlite DRIVER=SQLite3 " "description": "KiCad components database", Sqlite3 -csv /media/cioma/my/project/kicad/library/kicad.sqlite '.import /media/cioma/my/project/kicad/library/kicad.csv component'Īs you can see I keep all the components in a single database table named “component” but you might have several table if you wish. Rm /media/cioma/my/project/kicad/library/kicad.sqlite I save the second sheet (named “kicad”) as a CSV file.Īnd then I recreate SQLite database from that CSV file: I use this Google spreadsheet as a source: link User data sources are held in ~/.odbc.ini System data sources are held in /etc/odbc.ini I don’t use data sources but you could set them up if you like: Check if SQLite ODBC driver was added to the odbcinst.ini file:.Sudo apt-get install unixodbc sqlite3 libsqliteodbc sqlitebrowser Install UnixODBC, SQLite command-line tool, SQLite ODBC driver, SQLite Database Browser (optional):.It was done on Ubuntu 22.04 with latest KiCad v6.99 nightly build. So here is what I did to set up an SQLite ODBC database in KiCad. I’m pretty sure I don’t have the ODBC Datasource Admisistrator page setup correctly.Īny help would be greatly appreciated. Could not connect to database library: could not connect I told KiCad (nightly build) to connect to the. I installed SQLite ODBC Driver 64 bit.I have the database made from the Altium Excel file I made the KiCad database for the parts using. made resistor & capacitor symbol & footprint libraries from the Altium parts.We are looking into using KiCad & I have. We made an Excel sheet with all the parts, then Altium made the database. The designers had their own symbols & footprints so all schematics looked somewhat different & not all footprints were good. I have been working with a company that uses Altium.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |