Electronic Components Library

Electronic Components Library

Work in progress

Project to create a digital library of electronic components available in the Maker Space, and where to find them.

Starting with a set of CSV spreadsheet files which could be used to feed a "real" (SQL type) database, if additional features should be implemented.

Specification

File: inventory.csv

inventory.csv contains one record (data line) per part and storage location (combination of Location and SubLocation columns). There may be multiple records for the same part (if it can be found at different locations) and multiple records for a location (for a box containing different parts).

Column descritions

Column Header	Example Content	Comment
PartType	Transistor	Describes the type of the part, very roughly. Do not introduce new PartTypes without a good reason.
PartSubType	NPN	More detailed type, possible values depend on PartType
PartName	2N3055	You guess it?
Case	TO-3	May be empty, type of case. SMD parts should use "SMD" as Prefix
DataSheet	<https://cdn-reichelt.de/documents/datenblatt/A100/2N3055-ISC.pdf>	URL to a data sheet, if available. Multiple URLs are possible.
Location	Drawer 05	Rough location of this part. The location should be labeled so that it can be found without digging through closets or drawers.
SubLocation	Label 2N3055	Hint on where to find the part inside the "main" location. Ideally a readable label, but "front right side2 is also better than nothing. You may be creative here.
Amount	3	Don't rely on this, it also may a rough guess, especially with bigger numbers. If you notice a different amount, please correct the value.
Obsolete	Y	If this is not empty then the part is obsolete. That is that there exist better suited parts for typical applications of this part. Ideally these replacement parts should be named in the InfoText column
InfoText	A once popular power transistor used for example in low voltage power supplies.	Everything you know about the part, which is not part of the data sheet... ;-)
Characteristics	~50V, 15A, gain 20-70, max. Pc ~100W	Rough stats, why should I select this part for my design? Keep it short, details are in the data sheet.
GUID	7c560742-c104-4961-a4cc-d0a2f401c240	A unique string to identify the data record. May be a GUID, as in this example, or a different random string long enough to make is very improbable that someone else will randomly create the same string. Try <https://www.random.org/passwords/?num=5&len=15&format=html&rnd=new> for 5 random strings which should be long enough. Whenever you create a new data record, choose a random GUID. Otherwise do not change it.
ChangeTS	2026-10-11T22:04:00+0200	A modification timestamp, to help versioning of data records. Update it to the current timestamp when you modify the record. Usually the date should be enough, but if it is no big effort you should add the complete timestamp.