Even these are internationalised - I use Malaysia versions of RS and Element14, priced in MYR.
For hobbyist or very small business, not requiring concurrent multi user write access, sqlite is lightweight and could even be distibuted with KiCad as it is in the public domain
I think this is a brilliant tool , with possibilities to grow into something biger
web -> SQL -> Kicad
And i think about components
you could basically automate all your component libraries creation
but i think mostly of caps and resistors that goes in long series of values
lets say you ask the tool to grab all the murata grm15** series capacitors from mouser.
push into sql and make parts from a template for symbol and footprint
but take all the values from mouser
Part-no (Value)
Real value (Value2)
tolerance
manufacturer
rating
dielectric
etc
etc and automatically generate the whole series of caps into your murata library
nice
the sql database becomes your real library
2 different tools, collect and generate
SQL in the middle
Now mariadb
https://mariadb.org/
Made by the original developers of MySQL. Guaranteed to stay open source.
I was sourcing resistors from RS and there were significant price variation between brands at each value. The trouble was that for each value the cheapest was different. If you focus on one brand, your BOM cost will be inflated, so being lazy is punished
Hm… going for stackpole resistors at digikey in 0805 usually works for me… panasonic are in the low ball park mostly as well.
Hi, I want to try this out but when I try to install it (on Windows 10, via CMD (as admin and not as admin)) I get an error:
C:\WINDOWS\system32>easy_install kicost
Searching for kicost
Best match: kicost 0.1.21
Processing kicost-0.1.21-py3.5.egg
kicost 0.1.21 is already the active version in easy-install.pth
Installing kicost-script.py script to c:\users\nils\appdata\local\programs\python\python35\Scripts
Installing kicost.exe script to c:\users\nils\appdata\local\programs\python\python35\Scripts
Using c:\users\nils\appdata\local\programs\python\python35\lib\site-packages\kicost-0.1.21-py3.5.egg
Processing dependencies for kicost
Searching for lxml>=3.3.3
Reading https://pypi.python.org/simple/lxml/
Best match: lxml 3.6.0
Downloading https://pypi.python.org/packages/source/l/lxml/lxml-3.6.0.tar.gz#md5=5957cc384bd6e83934be35c057ec03b6
Processing lxml-3.6.0.tar.gz
Writing C:\Users\Nils\AppData\Local\Temp\easy_install-a64lozia\lxml-3.6.0\setup.cfg
Running lxml-3.6.0\setup.py -q bdist_egg --dist-dir C:\Users\Nils\AppData\Local\Temp\easy_install-a64lozia\lxml-3.6.0\egg-dist-tmp-gk9cgy9q
Building lxml version 3.6.0.
Building without Cython.
ERROR: b"‘xslt-config’ is not recognized as an internal or external command,\r\noperable program or batch file.\r\n"
** make sure the development packages of libxml2 and libxslt are installed **
Using build configuration of libxslt
error: Setup script exited with error: Unable to find vcvarsall.bat
I’ve tried installing libxml2 with easy_install but it can’t find a package named libxml2. What am I doing wrong? I have Python 2.7 and Python 3.5 installed, maybe that creates an issue?
It looks like you’re having a (not uncommon) problem installing lxml on Windows. You may have to resort to installing a precompiled version of it. Go to http://www.lfd.uci.edu/~gohlke/pythonlibs/#lxml and download lxml-3.4.4-cp27-none-win32.whl (for 32-bit python 2.7) or lxml-3.4.4-cp35-none-win32.whl (for 32-bit python 3.5). Then install the .whl file with pip or easy_install.
Thank you, it has installed now
The self-resonant frequency of that capacitor seems to be around 5MHz, not 5GHz. If there are 1uF caps with an SRF of 5GHz (or even 1GHz), I sure would appreciate a pointer to them!
is there any way to declare a component not mounted, and therefor ignored by Kicost?
KiBom has a special field ‘fit_field’
that can be ‘DNF’ to avoid taking care of the part
It would be nice if the same do not fit ‘fit_field’ could be take in care also in KiCost.
BTW @devbisme great plugin! Thx
Hi @devbisme
I have two questions related to KiCost:
thx again for this useful tool
Maurice
I’ll take a look at adding Avnet. TBH, not high on my list of things I want to do.
You can send your XML file to devb@xess.com. The RS webscraper was written by someone else. I’ll take a look at it.
sent a pm through the forum …
thx
Maurice
Problem with RS is fixed. KiCost version 0.1.35
Thanks @davidsrsb! Just tried your version 0.1.35 and it works great for me.
BTW, I had to do “pip install lxml” after creating “virtualenv” and before “kicost” can work for me.
I installed it using “python setup.py” inside the cloned source tree.
Im having trouble finding out how to make a component DNP/DNM etc in order words make kicost skip a certain component.
Is variant the proper way to do it?
@devbisme Im trying to use variant but cant figure out what im doing wrong.
all of my components have a field called “MPN” with the number in.
A few of the components has a field called “kicost.v1:manf#” instead of the field called “MPN” (should I have both?)
when r unning “kicost -i BOM_TEST.xml --overwrite” I still get the kicost.v1:manf# components inside the xlsx file.
if I try “kicost -i BOM_TEST.xml --overwrite --variant v1” I get the exact same result as without “–variant v1”.
what am I doing wrong? 
