4 ms·
I created an inventory management for a state government organization. The department was paying contracting companies to inventory assets. At the end of the
by nmonsey 4y ago
I created an inventory management for a state government organization.
The department was paying contracting companies to inventory assets.
At the end of the inventory, the contracting company would deliver the inventory on paper which would be filed in a managers office for a few years.
The inventory database was fairly simple just a few tables when the application was first developed.
Eventually a different manager decided the electronic data entry would be useful.
We added a few forms for data entry using a tablet.
With the data in a database, the person doing the inventory could pull up the inventory from the previous years and check off the equipment that was still at the location.
There was a form for entering new equipment and a form for transferring equipment between locations.
The manager who helped me got an award for reducing the time required for the inventory from months down to a few weeks.
I initially started the project just to maintain my development skills.
The inventory database remained in use for several years with very little maintenance except for writing a few reports and showing a few people how to use the reports.
Instead of a not very useful pile of paper, we had a database that contained the inventory.
When a manager wanted to know how many laptops or desktops needed to be refreshed each year, he could run a report listing the devices with specific attributes like how much memory or which CPU type and use the report to budget for the next years equipment refresh.
This was over ten years ago, and the sites were managed by different IT organizations, so at the time, it was just a simple task to save time for people on a different team.
- 7373737373 4y agoWhat kind of database (schema) did you use that supported so many attributes?
- weird-eye-issue 4y agoFor user defined attributes then EAV can work just fine so that would be my guess, assuming it was a SQL database
- nmonsey 4y agoThe database was Microsoft Access. I used Microsoft Access, because the users usually have a Microsoft Office Professional license. Another reason for using Microsoft Access, is that I can teach average people how to use Microsoft Access in a few minutes.
- logicalmonster 4y ago> The manager who helped me got an award for reducing the time required for the inventory from months down to a few weeks. I don't know how state government works, but just curious if you got any kind of recognition for that rather than just your manager?