So I poked around several months ago, to make some PCB’s for a coworker, and figured out what I needed to, to make the PCB’s. Suitably impressed, and way cheaper than the tool I use in my day job (Altium). Which leads me to the one thing I haven’t figured out: linking to an Excel “database”.
Yes, yes, I know, I know… evil. But I figured out how to do that years ago, and it served me well. All my passives, and most of my commonly used parts, live in a multi-tab “database” that is easily read, edited, and updated. I link to it by library reference, comment and footprint; it works well for my needs. I can do all my schematic entry, get what I want drawn up, link to the database, pull all the parameters. Check the report to see what didn’t pull parameters, update just those manually, done.
So I’ve been poking around, and I see some InvenTree link, which I should check out. But… end of the day, if I copy my Excel file into Libre Office(?), can I wind up with a workflow that I am already used to? [Part of my goal is to move my hobby PCB’s out of Altium, on my work PC, to my home PC, which is Linux. At the same time, I do see a need at work to use KiCAD so pulling from both Excel and Libre might be something I wind up doing.]
I’m probably overlooking some feature (Active BOM?) and should just re-calibrate my workflow, but one step at a time.
I did flip through the manual, on how to link to database, but I’m not sure if ODBC linking does this? I have a few other things to read up on as I get KiCAD installed and I figure out how I want to set it up for my purposes. I am no programmer, much less database knowledgeable. Am I just missing the obvious, and need to do more RTFM?