In our workshop we currently use hard-copy printouts of our stock of production lighting fixtures and other devices and update them when they are repaired, have had maintenance or have had their lamps changed. This data then gets fed manually into an excel spreadsheet and then reprinted again for manual updating. We currently own around 2000 fixtures and other devices and is a lot of work to keep updated. Our ideal situation would be something like a PHP/SQL script that allows for a search for fixtures via a couple of different fields and updating of all fields within the search results. This would allow the database to be searched via a browser locally in the workshop over the network and occasionally on-site over the Internet if need be. The basic layout of the script would possibly be a search field that allows lookup of a few different fields and maybe a list of recently accessed units. The search results would then be displayed as hyper-links that would take you to a page that has all the relevant information that and allows fields to be updated, it would also be good to link each device to a generic image of that type of device to make sure that you are entering details for the right device. The project will need to be attacked in two stages, first we will need a way to migrate the data from excel into the new database, this could be a simple CSV to SQL script. The next stage is building the PHP script to be able to search and modify the database and have it displayed in a user friendly format.
The data for our lights at the moment is in the format of serial number, test and tag, name (maintenance), date (maintenance), new lamp, parts, part number, name, date
The serial number does not exist on every line as each new entry for either maintenance, new lamp or parts will sit underneath the first line for that unit. This is how most of our lights are organized, some lights have different fields and other device are not lights so will have a different set of data.
It would also be nice to have the addition of parts in the database so that they can be selected instead of manually entered with the option of adding them if they don't exist.