This is a DiscontinuedProject. It has been finished and is in a stable state now. Currently, no effort is made for further work here. The inventory system works fine, and does everything I wanted it to do. Meanwhile, though, I have found more and more useful features for this, which I am currently implementing. I plan to generate a releasable version of this in the nearer future, with documentation and the possibility of easy adoption for other people's use.

For my CategoryElectronics projects, I need several small parts in small to huge quantities. It is critical to keep an overview of which parts are in stock, which are needed for specific projects, and which I should order.

For this, I have started to implement an web-based electronics inventory management system, based on python and mysql. Currently, I use it with manual data input, that is, whenever I add things to the inventory or take parts out of it, I have to manually search the right inventory item, and correct the number of things in stock.

I have written some script to generate barcoded labels for the bags and boxes I keep my parts in, use a barcode reader for easy input to keep the stock database current. The script also includes another file, where some checksumming routine is defined: tags.py

As the barcode reader I have had "in stock" had quite a hard time reading the codes from plastic bags, I have now ordered a more professional hand-held USB barcode reader and will develop (and publish) more software later. For example, a working prototype of a small X application (also written in Python using PyGTK) exists that provides a quick method for adding to and removing from the inventory database. Pick the right box or bag, swipe the reader over it, and a part at a time will be booked out of the inventory for use in projects.

Documentation

User

As an example of the features implemented so far, a few screenshots... I will write more documentation when I have finished writing code.

Main menu

Bill of materials

Product information

Part info page

Order list

Order archive

Part categories

Packages/part types

Partlist import

Developer


CategoryComputer CategoryElectronics


THIS DATA IS PROVIDED BY THE AUTHOR AND CONTRIBUTORS ``AS IS'' AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE AUTHOR OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS DATA, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

All product and brand names mentioned on there pages and in the source code are registered names and/or trademarks of the respective owner and are mentioned for identification purposes only.

For a full copyright notice, please see this link. For imprint and contact information, please see http://www.thiemo.net/.

EloInv (last edited 2011-12-16 10:30:01 by ThiemoNordenholz)