Author Topic: Electrical Parts Inventory/Management system (Read 36832 times)

CreMindES · « **on:** January 04, 2012, 12:19:33 pm »

Hi!

I'm just looking around and I'm interested which electrical part inventory/management system do you prefer or would you recommend for home use and which would you recommend for a small-mid sized business?

Regrads, Tamás

shebu18 · « **Reply #1 on:** January 04, 2012, 12:27:35 pm »

I am also interested in this.

There could be a program with a input of name, quantity, price and add it to a database and even specify the component type. Also there should be a search function for the part.

CreMindES · « **Reply #2 on:** January 04, 2012, 12:38:05 pm »

Yeah, I googled around a bit, and found a few one, for example PartKeepr looks nice, but I'm curious of some more experienced guys's opinion than me.

Ajahn Lambda · « **Reply #3 on:** January 04, 2012, 02:02:17 pm »

I simply use an Excel spreadsheet, and keep it in my Dropbox so I know what's in my lab wherever I go. I've created categories by simply keeping the sheets' names indicative of what's on it, e.g. Capacitors, Transistors, Resistors, and so on. I freeze the top line, which I use for part number, location, vendor, manufacturer, important nominal values like resistance or capacitance, and just keep adding any information that might help me find what I need in the future. Of course, you can use filters and the search functions, and organize by rows or columns. With a spreadsheet, your imagination is the only limit, regarding the types of data you want to store, be able to search, etc. You can even put in links to the parts' data sheets, and if you're good with macros and programming, much more can be done (like automagic part price updating).

CreMindES · « **Reply #4 on:** January 04, 2012, 10:42:55 pm »

Thanks your reply, actually I'm looking for a more sophisticated way, and just looking around to determine whether there is a free and good program for it or I shouldn't search it instead of trying writing one for my own requirements.

ashley.hughes · « **Reply #5 on:** January 05, 2012, 01:17:41 am »

I personally just wrote a small CoreData (Mac's built in database) application.

It allows me to store parts with names qty and pictures, in different Toolbox's (Locations) as most of my parts are in fishing box's.

If you have played around with software design and programming before, it is a fairly easy project to start with and is really rewarding.

Just don't do what I did and smash together different ideas as you go. Stop write down what you want how etc. Depending on the language you choose to go with there will be a lot of tutorials for working with databases around

Rutger · « **Reply #6 on:** January 05, 2012, 02:30:26 am »

Hi, if you are trying to build boards and keep track of parts on stock and order stuff etc. Google for BOM software (Bill of Material).

Rutger

DrGeoff · « **Reply #7 on:** January 05, 2012, 06:43:27 am »

I have all this and more in a package I wrote in php on a LAMP server. It's web driven and multi-user. I haven't packaged the source up and made it open source yet, but that's just because it's extra work for me

If you have a LAMP server running in your facility (for email, dns etc) then you can add this to it very easily.

ashley.hughes · « **Reply #8 on:** January 05, 2012, 06:59:06 am »

Quote from: DrGeoff on January 05, 2012, 06:43:27 am

I have all this and more in a package I wrote in php on a LAMP server. It's web driven and multi-user. I haven't packaged the source up and made it open source yet, but that's just because it's extra work for me
If you have a LAMP server running in your facility (for email, dns etc) then you can add this to it very easily.

I have been wanting to make a decent PHP based web app for a while. I have MySQL and PHP installed on my mac. You code the layout by hand or use a nice editor?

DrGeoff · « **Reply #9 on:** January 05, 2012, 07:16:15 am »

Layout is coded by hand, using a set of templates, making it easy to change things.

shebu18 · « **Reply #10 on:** January 05, 2012, 07:22:06 am »

Partkeepr looks very good. i will give it a try.

Jon Chandler · « **Reply #11 on:** January 05, 2012, 07:46:57 am »

I found Arena PartSaver today and it looks like a winner although perhaps not exactly what the origianl poster needs.

PartSaver is a java-enabled bookmark. When you're on a component at Digikey, Mouser, Newark or etc, clicking on this link extracts part number, description, price and so forth from the page, and gives you the option to save it into a Google Docs spreadsheet. It works with many vendors; the required info can be entered into a dialog box if not.

This works well for me and saves the usual copying and pasting I have to go through to find multiple sources and pricing.

You do have to have a Google Docs account (just a matter of opening a Gmail account) and give Arena access to it.

The above link has a video that shows how it works.

CreMindES · « **Reply #12 on:** January 05, 2012, 09:13:01 am »

Wow guys, I wasn't expecting such a relative big number of comments. Huge thanks. Actually, as I've written, I'm just looking around. I don't know exactly why, but I don't like the idea of a web based one, because it's not enough portable and - for me - not powerful enough, although it has its advantages.
All in all, I'm just playing with the idea of writing a multiplatform native app if I'll have the time for it.

ashley.hughes · « **Reply #13 on:** January 05, 2012, 12:22:21 pm »

Quote from: DrGeoff on January 05, 2012, 07:16:15 am

Layout is coded by hand, using a set of templates, making it easy to change things.

That is where me and PHP/HTML fall apart, I hate having to lay things out by code, send us a screen of what it looks like would be awesome

brizleciderarmy · « **Reply #14 on:** January 05, 2012, 01:18:51 pm »

I started working on a database/inventory program for my components too a few months back which uses PHP/MySQL.

I managed to get the basics done and get it functional but just haven't had the time to complete it. Fingers crossed over the next few months i can get it done. Once complete, anyone who who wishes for a copy is more than welcome.

I will let yous know when it is complete. Heres a current screenshot.

CreMindES · « **Reply #15 on:** January 05, 2012, 10:06:57 pm »

Looks promising, good luck with it brizleciderarmy

DrGeoff · « **Reply #16 on:** January 05, 2012, 10:28:39 pm »

I had to write this when I was packing up and moving a couple of times. I had so many parts in different places I was having difficulty trying to find something to complete various projects. Now I know where they are and how many I have (approximately), plus easy access to documentation for everything!

Making it web based on a server means that I can access it from any of the desktops or mobile devices, which is very convenient.

A few screen shots to tantalise...

Short Circuit · « **Reply #17 on:** January 06, 2012, 12:02:14 am »

Looks nice DrGeoff,
Is this project to be published or commercialized? (Ideally running on a typical LAMP server configuration of course.)
Does it also keep track of production? So that one can substract the partscount according BOM & qty produced from the stock?

DrGeoff · « **Reply #18 on:** January 06, 2012, 12:36:24 am »

Eventually I'll publish it as free software. There's a couple of things I'd like to add. I have been using it for several years now and made operational improvements along the way.
It keeps track of production units by serial number, allowing a test/repair log to be tracked (in case of systemic faults) and also MAC addresses/firmware assignments where applicable. It does not perform automatic adjustment of material inventory count through BOM issue, that's still a manual thing. I had not intended it to be a production level material inventory application.
It runs on a typical LAMP server (I'm using FC12 on the current server that also does mail and dns caching) and is written in PHP with some javascript, html and css as well.

brizleciderarmy · « **Reply #19 on:** January 06, 2012, 02:26:32 am »

Top notch DrGeoff. I like the look of that.

Ajahn Lambda · « **Reply #20 on:** January 06, 2012, 02:42:37 am »

Quote from: Jon Chandler on January 05, 2012, 07:46:57 am

I found Arena PartSaver today and it looks like a winner although perhaps not exactly what the origianl poster needs.

Wow, that's impressive! Thanks for sharing.

I like a few of the other solutions proposed in this thread too; my #1 concern is, do they allow the user to exercise customization of categories, much like the 'filtering' of columns or rows in Excel? Or am I 'stuck' using the defaults? As long as that freedom offered, I'm on board. Heck, even if not, I might give these a try anyway; even the screenshots show that a great deal of effort has been put forth. There's truly a demand out there for such software, as demonstrated by this thread.

DrGeoff · « **Reply #21 on:** January 06, 2012, 02:46:20 am »

Click the 'Categories' button and add/edit at will. Same goes for just about everything else.

shebu18 · « **Reply #22 on:** January 07, 2012, 09:29:07 am »

I found zparts. It looks very interesting. It saves the parts in some excel compatible file format. I think it is a java frontend for excel files.

Link: http://sourceforge.net/projects/zparts/

What would be reat is a search function, mysql database, bom file creation(so you know what to buy).

shebu18 · « **Reply #23 on:** January 22, 2012, 09:01:43 am »

Any news on thes theme? I tried zParts but it is a bit to basic.
PartKeepr has some problems with installing. I will try it again later.
Anybody found something new?

tyblu · « **Reply #24 on:** January 23, 2012, 06:51:47 am »

I keep the label in the box, and order a few more of the part when it's getting low.

shebu18 · « **Reply #25 on:** January 23, 2012, 06:57:41 am »

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 · « **Reply #26 on:** January 29, 2012, 09:36:15 pm »

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 · « **Reply #27 on:** April 05, 2017, 02:28:16 am »

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 · « **Reply #28 on:** April 05, 2017, 03:38:58 am »

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 · « **Reply #29 on:** April 05, 2017, 04:53:01 am »

A couple of screen shots.

The Parts page:

The Assemblies page:

rmacintosh · « **Reply #30 on:** April 05, 2017, 05:43:59 am »

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 · « **Reply #31 on:** April 05, 2017, 05:51:26 am »

Bugger its Linux!

It looks very good.

DrGeoff · « **Reply #32 on:** April 05, 2017, 05:57:22 am »

Quote from: rmacintosh on April 05, 2017, 05:43:59 am

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 · « **Reply #33 on:** April 05, 2017, 05:59:34 am »

Quote from: DTJ on April 05, 2017, 05:51:26 am

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 · « **Reply #34 on:** April 05, 2017, 06:13:08 am »

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 · « **Reply #35 on:** April 05, 2017, 06:45:42 am »

Quote from: DrGeoff on April 05, 2017, 05:59:34 am

Quote from: DTJ on April 05, 2017, 05:51:26 am
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 · « **Reply #36 on:** April 05, 2017, 10:22:59 am »

Quote from: DTJ on April 05, 2017, 06:45:42 am

Quote from: DrGeoff on April 05, 2017, 05:59:34 am
Quote from: DTJ on April 05, 2017, 05:51:26 am
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 · « **Reply #37 on:** April 05, 2017, 11:43:46 am »

Quote from: rmacintosh on April 05, 2017, 06:13:08 am

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 · « **Reply #38 on:** April 05, 2017, 09:52:10 pm »

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 · « **Reply #39 on:** April 06, 2017, 12:25:03 am »

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 · « **Reply #40 on:** April 06, 2017, 05:35:55 am »

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 · « **Reply #41 on:** April 06, 2017, 12:39:51 pm »

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 · « **Reply #42 on:** April 06, 2017, 04:00:08 pm »

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 · « **Reply #43 on:** April 06, 2017, 10:05:39 pm »

Quote from: rmacintosh on April 06, 2017, 04:00:08 pm

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 · « **Reply #44 on:** April 12, 2017, 10:14:44 pm »

There is also another thread covering similar discussions here:

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

DrGeoff · « **Reply #45 on:** April 20, 2017, 12:19:24 am »

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

doc sylver · « **Reply #46 on:** May 20, 2017, 03:22:13 pm »

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 · « **Reply #47 on:** May 20, 2017, 11:55:36 pm »

Quote from: doc sylver on May 20, 2017, 03:22:13 pm

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;

Quote from: doc sylver on May 20, 2017, 03:22:13 pm

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 · « **Reply #48 on:** May 21, 2017, 02:26:53 pm »

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 · « **Reply #49 on:** May 21, 2017, 10:40:04 pm »

Quote from: doc sylver on May 21, 2017, 02:26:53 pm

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.

DrGeoff · « **Reply #50 on:** May 22, 2017, 01:55:41 am »

Quote from: doc sylver on May 21, 2017, 02:26:53 pm

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.

When you used phpMyAdmin to create the database, did you also import the initial data? This will be required in order for you to log in and set up the system to suit.
If you have already created the database, you do not need to redo this step: 'mysql -uroot -p <axtparts-schema-R02.sql'. This is only required to create the empty database ready for importing the initial data. Another important step you do not mention is whether you have assigned the privileges to the axtparts user to be able to connect and use the parts database. This is the third step in the Database section of the document.

Add these 2 lines to the top of the schema file if not already there:
create database axtparts;
use database axtparts;

1. Create the database and table structure:
mysql -uroot -p < axtparts-schema-R02.sql

2. Import the initial data:
mysql -uroot -p < axtparts-initialdata-R02.sql

3. Assign the privileges and set a password:
mysql> grant select,insert,update,delete on axtparts.* to ‘axtpartsuser’@’127.0.0.1’ identified by ‘password’;
mysql> flush privileges;

Now edit the site/config/config-axtparts.php file to add the password for the database:
define ("PARTSPASSWD", "DB_PASSWORD");

doc sylver · « **Reply #51 on:** May 24, 2017, 12:26:02 pm »

Hello,

I'm sorry, but I can not do it, I'm more on Mac OS, in Linux, I do not know much, nor in Mysql.

Due to testing, I have the connecton window, but no login and password will work.

I uninstall all and reinstall, but it's still the same thing. I no longer remember any error messages.

I added the two lines: create database axtparts; And: use database axtparts;

Above the file: axtparts-schema-R02.sql and I had error messages, to try, I did the same thing to the file: axtparts-initialdata-R02.sql and other error messages .

Then, I think that PhpMyAdmin installs the database in ./var/lib/mysql/axtparts, while the doc says to place it in ./var/www/axtparts.

I connect with Firefox at 127.0.0.1/axtparts/index.php, but this is the basis I copied into ./var/www, I do not know how to connect to the base of PhpMyAdmin In Firefox.

I ...

In French, they say: I give my tongue to the cat.

Bye

DrGeoff · « **Reply #52 on:** May 24, 2017, 12:35:11 pm »

Quote from: doc sylver on May 24, 2017, 12:26:02 pm

Hello,

I'm sorry, but I can not do it, I'm more on Mac OS, in Linux, I do not know much, nor in Mysql.

Due to testing, I have the connecton window, but no login and password will work.

I uninstall all and reinstall, but it's still the same thing. I no longer remember any error messages.

I added the two lines: create database axtparts; And: use database axtparts;

Above the file: axtparts-schema-R02.sql and I had error messages, to try, I did the same thing to the file: axtparts-initialdata-R02.sql and other error messages .

Then, I think that PhpMyAdmin installs the database in ./var/lib/mysql/axtparts, while the doc says to place it in ./var/www/axtparts.

No, the database goes wherever the MySQL server is configured to put it. The software connects to the database server, and it is up to the MySQL server to manage the various files associated with the database.

You only need to add those two lines to the database schema, not the initial data import file. That contains data to go into the various tables to get you started.

Quote from: doc sylver on May 24, 2017, 12:26:02 pm

I connect with Firefox at 127.0.0.1/axtparts/index.php, but this is the basis I copied into ./var/www, I do not know how to connect to the base of PhpMyAdmin In Firefox.

If your web docroot is at /var/www then you can locate the axtparts site at /var/www/axtparts then use your browser to connect to the site according to how you have configured your Apache web server.

DrGeoff · « **Reply #53 on:** May 26, 2017, 03:39:05 am »

Quote from: doc sylver on May 24, 2017, 12:26:02 pm

Above the file: axtparts-schema-R02.sql and I had error messages, to try, I did the same thing to the file: axtparts-initialdata-R02.sql and other error messages .

The initialdata file contains the admin user, to allow you to log in and change password, setup user accounts etc. Also contains some common component categories, footprints etc as a starting point.

Once this data is loaded you can log in as admin and go to the admin tab/system page to see if everything is sane.

doc sylver · « **Reply #54 on:** May 26, 2017, 03:50:29 pm »

Hello,

I come to the news, I had to appeal to my brother who participated in the development of RED HAT at the time and he installed me and configure axtparts in a few minutes in command line.

I would have liked to do it myself, but I did not follow it.

The program works very well and if you allow me, I saw that I could replace the English language tabs with French, it's just for my personal use.

Now I'm looking to import my EXCEL data into .xlsm in the database.

If you have any ideas, I'm a taker.

A big thank you for your help and this super software.

Doc Sylver

DrGeoff · « **Reply #55 on:** May 26, 2017, 11:10:05 pm »

Quote from: doc sylver on May 26, 2017, 03:50:29 pm

Hello,

I come to the news, I had to appeal to my brother who participated in the development of RED HAT at the time and he installed me and configure axtparts in a few minutes in command line.

I would have liked to do it myself, but I did not follow it.

The program works very well and if you allow me, I saw that I could replace the English language tabs with French, it's just for my personal use.

Now I'm looking to import my EXCEL data into .xlsm in the database.

If you have any ideas, I'm a taker.

A big thank you for your help and this super software.

Doc Sylver

Good to hear that you have it all working for you.
It should be easy to replace tab and button text (and even table column headers) with labels in other languages, as it is mostly just text that is rendered when the page is built.

DrGeoff · « **Reply #56 on:** January 07, 2018, 10:32:54 pm »

axtparts-3.18 has now been released, which adds BOM copy functionality when creating a new BOM.
This allows a new BOM variant for an assembly to be directly copied from another variant and the relevant BOM lines edited.

https://axtsystems.com/joomla31/index.php/downloads/category/45-dl-axtparts

erniman · « **Reply #57 on:** February 26, 2018, 02:21:25 am »

Hi DrGeoff... first I have to say Thanks for this great "part management". I saw it here and I want to try it.

I´ve followed all the steps you describe in documentation (https://axtsystems.com/joomla31/index.php/downloads/send/45-dl-axtparts/115-dl-axtparts-doc) but when I try to login on the website I always get "login fail".

As is a fresh install, I´m using to login: admin / mypassword!

Can you help me with this problem?
Thanks!

DrGeoff · « **Reply #58 on:** February 26, 2018, 05:04:47 am »

Quote from: erniman on February 26, 2018, 02:21:25 am

Hi DrGeoff... first I have to say Thanks for this great "part management". I saw it here and I want to try it.

I´ve followed all the steps you describe in documentation (https://axtsystems.com/joomla31/index.php/downloads/send/45-dl-axtparts/115-dl-axtparts-doc) but when I try to login on the website I always get "login fail".

As is a fresh install, I´m using to login: admin / mypassword!

Can you help me with this problem?
Thanks!

Thanks. I hope you find it useful.

Firstly, did you import the initial data set? This import has the default admin user, with password set to 'mypassword!'. Don't forget the '!' as the last character.
If so, can you use the mysql command line tool to check that the admin user is present in the user table and imported correctly?
Let me know how you go.

- Geoff

erniman · « **Reply #59 on:** February 26, 2018, 05:45:21 pm »

Hello Geoff, thanks for your reply.

Yes, I´ve imported the initial data set as your manual said.

I checked that user "admin" was created and I changed the password (just in case) following the "mysql_secure_installation" recomendations on passwords strenght, and the problem continues.

I´ve also created another user with a simple password (12345678) and I have the same result.

Maybe I have some privilegies issue on my files?
Thanks!

DrGeoff · « **Reply #60 on:** February 26, 2018, 07:47:54 pm »

Quote from: erniman on February 26, 2018, 05:45:21 pm

Hello Geoff, thanks for your reply.

Yes, I´ve imported the initial data set as your manual said.

I checked that user "admin" was created and I changed the password (just in case) following the "mysql_secure_installation" recomendations on passwords strenght, and the problem continues.

I´ve also created another user with a simple password (12345678) and I have the same result.

Maybe I have some privilegies issue on my files?
Thanks!

That was the problem. Using MySQL to change the password was not in the instructions. The software has its own seeded hash password functions and does not,use MySQL to create passwords.
You need to restore the original default password hash that is in the initial data file and then use this to login. Go to the admin tab and you can select the admin user and change the password there and create new users etc.

erniman · « **Reply #61 on:** February 26, 2018, 08:18:47 pm »

Geoff...I have changed the password to the original default password hash that is in the initial data file.
I had to do it manually on MySql using the console, but the problem is still there when I try to login with
username: admin
password: mypassword!

Also I´ve tried on password: zZ0MXYLX07ks8rgt1vW48AFzBq9pWTR0RAYohA==

DrGeoff · « **Reply #62 on:** February 26, 2018, 08:58:16 pm »

Quote from: erniman on February 26, 2018, 08:18:47 pm

Geoff...I have changed the password to the original default password hash that is in the initial data file.
I had to do it manually on MySql using the console, but the problem is still there when I try to login with
username: admin
password: mypassword!

Also I´ve tried on password: zZ0MXYLX07ks8rgt1vW48AFzBq9pWTR0RAYohA==

The password should be entered as shown as mypassword!
The ssha password for this in the initialdata file is: 'zZ0MXYLX07ks8rgt1vW48AFzBq9pWTR0RAYohA=='
Another version (different seed) of mypassword! is 'f/vzOGXtpgHlx8/mGujPrtWaUbUgKDhYRYYxaA=='
And another one again, also 'mypassword!': 'ALJ8nkbSKhAqkeKgEOO66dK8PxswkJZ4JRBTdA=='

Any of these should work, provided you setup the database grant for the user entered into the configuration file.

erniman · « **Reply #63 on:** February 26, 2018, 10:24:34 pm »

Solved!

The problem was the "MySQL password policy level" !! It was on MEDIUM, so on MySQL console I ran:
SHOW VARIABLES LIKE 'validate_password%';
SET GLOBAL validate_password_policy=LOW;

And then I change password on config-axtparts.php (I use a simple one) , save the file and it works!

Thanks for your help Geoff!

DrGeoff · « **Reply #64 on:** February 26, 2018, 10:36:15 pm »

That's great! Hopefully you find the system useful.

donlydpa · « **Reply #65 on:** April 12, 2019, 08:15:33 pm »

Hi everyone,

for those of you who use a manually set up folder to sort the datasheets, like i do - I had posted this ready made folder structure some time ago. I also use the numbering scheme for libraries etc

https://www.eevblog.com/forum/eda/component-category-folder-structure-for-datasheet-organizer/

it can be regenerated based off an attached excel sheet using a batch file and has links in folders of similar subcategories falling under different parent nodes which point to each other. Hope it can be of some good use to somone!

Cheers

DrGeoff · « **Reply #66 on:** September 23, 2022, 06:38:46 am »

Just a note that AXTParts version 4 has now been released on GitHub.
There's a small update to the database as detailed in the Readme.
This version is responsive, allowing it to be used on tablets and phones as well as desktops.
It's on GitHub in case others want to fork it to customise their own features.

https://github.com/gswan/axtparts

rooppoorali · « **Reply #67 on:** September 25, 2022, 10:12:51 am »

Mouser has this free tool: https://www.mouser.com/inventory-management/

DrGeoff · « **Reply #68 on:** September 25, 2022, 10:57:57 pm »

Quote from: rooppoorali on September 25, 2022, 10:12:51 am

Mouser has this free tool: https://www.mouser.com/inventory-management/

Like several others, I think this one relies on you using the Mouser "cloud" rather than your own server on your own LAN.

DrGeoff · « **Reply #69 on:** April 19, 2023, 05:03:54 am »

For those still playing along, the website has been updated and links changed.
https://axtsystems.com/axtsystems/proj_axtparts.php

There's a live demo as well now to play with.


EEVblog Main Site	EEVblog on Youtube	EEVblog on Twitter	EEVblog on Facebook	EEVblog on Odysee

Author Topic: Electrical Parts Inventory/Management system (Read 36832 times)

Share me