Electrical Parts Inventory/Management system

[shebu18]

Would't it be great to make an "EEVblog electrical parts management software"?
-internal mysql database
-BOM
-user modifiable layout
-doc or txt export
-picture and datahseet for parts

[DavidJRobertson]

I'm working on a hosted web application to keep track of electronic components. It's called PartSorter.
It's nowhere near finished yet, but I'm working on it.

You can head over to http://partsorter.com/ and enter your email address and I'll let you know when I'm ready for launch.


David.

[DrGeoff]

After a lot longer than expected (well around 5 years) I have finally released this generally.

It's been in use for over 15 years now and has undergone several updates and enhancements along the way.
It's simple to install and use on a LAMP server and comes with some initial data to load into the database to help seed part categories and footprints.

http://axtsystems.com/joomla31/index.php/projects/30-cat-axtparts/44-art-projects-axtparts

[DrGeoff]

I'm using it with PHP-5.5.9, however the latest upgrade to the software should allow it to work with php-7.

[DrGeoff]

A couple of screen shots.

The Parts page:


The Assemblies page:

[rmacintosh]

Looks great!
I'm tired of my excel spreadsheet i've used since 2013.

That and i'm well overdue for an inventory count. I'll give it a try.

[DTJ]

Bugger its Linux! 

It looks very good.

[DrGeoff]

Looks great!
I'm tired of my excel spreadsheet i've used since 2013.

That and i'm well overdue for an inventory count. I'll give it a try.

Thanks.
The inventory location and counts were a later addition after using it for around 5 years. Having several thousand different parts here located in all manner of trays, boxes, crates, bins etc, I have found the inventory location and count to be particularly useful. Especially when you need to quickly locate a part and you know you have some but not sure which crate or tray or box they are in. It saves a lot of time when you want to pick the component for a prototype off the BOM.

- Geoff

[DrGeoff]

Bugger its Linux! 

Well is it server-based, supporting multiple users.
However you can setup Apache-PHP-MySQL on a Windows box if you like and host it there. Should not be a problem, however I have had no reason to try it.

- Geoff

[rmacintosh]

Should work with WAMP as well, for the windows users.


Anyway, setup was pretty painless. I'll play with it more when I have a bit more time.
 

[DTJ]

Bugger its Linux! 

Well is it server-based, supporting multiple users.
However you can setup Apache-PHP-MySQL on a Windows box if you like and host it there. Should not be a problem, however I have had no reason to try it.

- Geoff

I guess so, but by the time >I< worked my way through setting it up I'd be retired!

[DrGeoff]

Bugger its Linux! 

Well is it server-based, supporting multiple users.
However you can setup Apache-PHP-MySQL on a Windows box if you like and host it there. Should not be a problem, however I have had no reason to try it.

- Geoff

I guess so, but by the time >I< worked my way through setting it up I'd be retired!

Ha ha! Then it would make a good retirement project perhaps

[DrGeoff]

Anyway, setup was pretty painless. I'll play with it more when I have a bit more time.
 

Be sure to load the initial data, as it creates the default admin account so you can log in and change the password and create other accounts and roles for access to various parts of the system.
The initial data also includes some part categories and footprints, however you can edit these however you would like them to be.

[DrGeoff]

A BOM form screen shot. There is a printable form as well, intended for producing hard copies or pdf files of the BOM.

http://axtsystems.com/joomla31/index.php/projects/30-cat-axtparts/44-art-projects-axtparts

[DrGeoff]

Assembly documentation can also be included. This can include pdf circuit diagrams, PCB overlay, mechanical drawings etc.



http://axtsystems.com/joomla31/index.php/projects/30-cat-axtparts/44-art-projects-axtparts

[DrGeoff]

Adding part categories helps sort parts into distinct groups, which can be used for filtering on the Parts page.



http://axtsystems.com/joomla31/index.php/projects/30-cat-axtparts/44-art-projects-axtparts

[DrGeoff]

Clicking on a part number will show you the part details as well as components associated with the part (and component data sheet) and any assemblies using the part.

[rmacintosh]

Trying to add a component to an existing part I got this error....

I had all fields filled in the add component form, and chose a datasheet to upload as well.

Code: [Select]

Fatal error: Call to a member function free() on boolean in /site/axtparts/pop-component.php on line 211

[DrGeoff]

Trying to add a component to an existing part I got this error....

I had all fields filled in the add component form, and chose a datasheet to upload as well.

Code: [Select]

Fatal error: Call to a member function free() on boolean in /site/axtparts/pop-component.php on line 211

Thanks for finding that, an error when I updated it for php-7.

I've updated the package to 3.16 now with the corrections.
These are the files that changed:
pop-component.php
pop-assy.php
config-axtparts.php

http://axtsystems.com/joomla31/index.php/projects/30-cat-axtparts/44-art-projects-axtparts

[DrGeoff]

There is also another thread covering similar discussions here:

https://www.eevblog.com/forum/chat/component-organizer-software

[DrGeoff]

This link should work for the other thread.
https://www.eevblog.com/forum/chat/component-organizer-software/msg1189500/#msg1189500

[doc sylver]

Hello DrGeoff

Excuse me for my poor English.

Your software is very good, but I can not install it.
I started with LINUX and I am under ubuntu 16.04.02 and I have installed LAMP.
Could you help me, I block early and have several questions ?.

First question:
I have downloaded the program, I have extracted it in a temporary directory and I copied the two files of DATABASE in the directory of / var / axtparts.
I then make the command: mysql -uroot -p <axtparts-schema-R02.sql and I have the error: ERROR 1046 (3D000) at line 2: No database selected.

Where is the error?

I started PhpMyAdmin and I managed to create the database "axtparts" by the "import" tab, but I'm stuck and I do not know how to launch it.

Thank you for answering other questions.

Doc Sylver.

[DrGeoff]

Hello DrGeoff

Excuse me for my poor English.

Your software is very good, but I can not install it.
I started with LINUX and I am under ubuntu 16.04.02 and I have installed LAMP.
Could you help me, I block early and have several questions ?.

First question:
I have downloaded the program, I have extracted it in a temporary directory and I copied the two files of DATABASE in the directory of / var / axtparts.
I then make the command: mysql -uroot -p <axtparts-schema-R02.sql and I have the error: ERROR 1046 (3D000) at line 2: No database selected.

Where is the error?

Looks like I left a couple of lines missing from the top of the schema file:

create database axtparts;
use database axtparts;

I started PhpMyAdmin and I managed to create the database "axtparts" by the "import" tab, but I'm stuck and I do not know how to launch it.

Thank you for answering other questions.

Doc Sylver.

After creating the database you need to allocate the privileges and permissions (select, insert,update, delete) to the 'axtpartsuser' user on '127.0.0.1' to this database.
The password should be a random string and added to the config-axtparts.php file so that the site can access the database.

Launching is easy. It is a web site, so put the 'site' into your apache docroot, I'd suggest using https (http/ssl) to connect to it, so you need to configure the apache web server for your particular setup.

Once you have the site setup, just point your browser to it. There is a default admin user that will allow you to create new accounts and also check that you have things set up OK (in the Admin tab->system page). This checks the various permission to the database and directories for datasheets, documents etc.

[doc sylver]

Hello,

Thanks for your answers, but I do not see where these files are.

I tried to fend for myself, but I floundered. :-)

I create a database with PhpMyAdmin and I do not think it's in the same directory as var / www / https, so when I do the command in my browser, 127.0.0.1/axtparts/index.php, I'm not in the database that PhpMyAdmin supports.

Otherwise with the explanations of the pdf document, when I do: mysql -uroot -p <axtparts-schema-R02.sql, I have the error: ERROR 1046 (3D000) at line 2: No database selected.

I row a little, it's a shame, because the software I like.

Doc Sylver

[DrGeoff]

Hello,

Thanks for your answers, but I do not see where these files are.

I tried to fend for myself, but I floundered. :-)

I create a database with PhpMyAdmin and I do not think it's in the same directory as var / www / https, so when I do the command in my browser, 127.0.0.1/axtparts/index.php, I'm not in the database that PhpMyAdmin supports.

Otherwise with the explanations of the pdf document, when I do: mysql -uroot -p <axtparts-schema-R02.sql, I have the error: ERROR 1046 (3D000) at line 2: No database selected.

I row a little, it's a shame, because the software I like.

Doc Sylver

The MySQL database is handled by the MySQL server. Where the database files are kept will depend on the Linux distro you use. Sometime /var/lib/mysql, sometimes other locations. MySQL knows where to find these as they are configured in /etc/my.cnf.

The error you receive from creating the database stems from not having these two lines at the top of the sql schema file:
create database axtparts;
use database axtparts;

Just add these two lines at the top and run it again. Then you should be able to import the initial data in the same way.

Once you have the database and initial data loaded, use your web browser to open up the site.