Ink/Toner database

[newpersn]

Has anyone made a database up for ink/toner collections?

 

Need to be ables to make reports each month of whats gone out and back in.

 

Any ideas?

[webman]

As discussed in this thread, I developed a web based solution in PHP/MySQL: PrintMaster.

[newpersn]

i would before a database really not a Website php. nice tho if i had more time i would try it,

[sionide]

i would [prefer?] a database really

 

All the data is kept in a MySQL database, so it is a database!! The website is just a nicer way to look at the data..

[LRSFC_DanJ]

Is the PrintMaster project still in active development? If not, is there any other similar product or project that fills this purpose? The existing printers database at my workplace is showing its age so we'd like to replace it.

[webman]

PrintMaster is still "alive" and useable at its current version. I just have rather limited time to work on it to add new features. My advice would be to just try it and see if it works for you

[LRSFC_DanJ]

PrintMaster is still "alive" and useable at its current version. I just have rather limited time to work on it to add new features. My advice would be to just try it and see if it works for you

 

I've already had a quick look at it and while it looks nice and seems like it would work well as far as it goes there is a bunch of stuff that it doesn't do yet that we would need it to do, which is why we were looking for a project still in active development.

 

Glad to hear it is still alive though; if I can't find anything else suitable I have considered the possibility of forking it and trying to add the features we need on my own (though that would be an option of last resort; I know some PHP but I am not great with SQL databases)

[webman]

I've already had a quick look at it and while it looks nice and seems like it would work well as far as it goes there is a bunch of stuff that it doesn't do yet that we would need it to do, which is why we were looking for a project still in active development.

 

Glad to hear it is still alive though; if I can't find anything else suitable I have considered the possibility of forking it and trying to add the features we need on my own (though that would be an option of last resort; I know some PHP but I am not great with SQL databases)

 

OK, that's fair enough What are the extra features you're looking for?

[LRSFC_DanJ]

OK, that's fair enough What are the extra features you're looking for?

 

We need to be able to set minimum and maximum stock levels for each type of consumable - we use this function to automatically generate order forms on a regular basis. We need to be able to track consumables that do not have a colour (e.g. waste toner cartridges) and also consumables that have colours other than the standard CMYK (we have photo printers that have weird and wonderful colours such as Vivid Light Magenta and Light Light Black). We need the system to be multi-user (i.e. technicians will log in with their own username and password so that it is recorded who booked in or out a cartridge or who made what changes) - bonus points for Active Directory/LDAP integration. We need to be able to record which person (if any; sometimes we install toners based on automated toner low notifications, rather than a report or request from a person) requested a toner cartridge and to which department it should be charged - again Active Directory/LDAP could help here as AD already "knows" (via group memberships) what department a person is in. We need to be able to produce a "recharge report" of all the cartridges charged to each department during a given calendar month. It would be nice to be able to book in/out cartridges using the barcodes on them - we have barcode scanners, these are basically keyboard emulators that produce the number of the barcode along with a newline.