Toner inventory Database

[p858snake]

I will share my PHP/MYSQL creation if anyone wants it, but it was never written for distribution and was developed in situ on the system it's currently running on, so there's a lot of references that point directly to parts of our system, very sloppy programming, but it works for us and I've never been bothered to go through and tidy the code up. Therefore it would be an absolute nightmare to get working on any other configuration.

Share it anyway, People might fix it up and make it more flexible (depending on what license you give it).

[tmcd35]

database is a bit overkill?
We use a google docs spreadsheet/form.

LOL, I have a box in the server room were we dump the empties. Every half term I go through the box and order whatever is in there. No need of databases, spreadsheets or google docs forms

[RabbieBurns]

LOL, I have a box in the server room were we dump the empties. Every half term I go through the box and order whatever is in there. No need of databases, spreadsheets or google docs forms

Wow. We have a box of empty toners that we send to the recyclers every other friday ;p

[webman]

Print Master is now available for download.

[IKWeb]

Stupid question how can i download this in one go? it lists the files one by one, which will take a while to grab. and the file path http://github.com/craigrodway/printmaster.git comes back with an error says file cant be found.

[localzuk]

Stupid question how can i download this in one go? it lists the files one by one, which will take a while to grab. and the file path http://github.com/craigrodway/printmaster.git comes back with an error says file cant be found.

Click the 'Download source' button in the top right of the page.

[webman]

Sorry, should have mentioned how to get it as a ZIP file Thanks localzuk.

[dgsmith]

Interesting project webman - very neat looking too. Will be giving this a whirl on Monday. I noticed at the bottom a "todo" of adding SNMP for printers - definately would be worthwhile. If this can also be used to track not only what consumables are available, but what are needed it's definately something that'll be worthwhile. Good work.

[john]

Looks nice and shiny well done mate Will point Pete to it next week if its quieter than the last 2 as it may help his stock control

[dgsmith]

What's the best way of importing the sql file without phpmyadmin? I have the mysql query and administrator installed though. Is there a command line? Google searching hasn't turned up anything useful..

[Edu-IT]

Do you have an SQL dump? If so the command line is:

mysql -u username -p password database_name < filename.sql

So in this case filename.sql will be printmaster.sql.

(Should work!)

[dgsmith]

Thanks - couldn't that to work either! Ended up figuring out that in mysql admin you can "restore" an SQL dump file as long as you ignore errors! Still, now getting this problem when browsing to index.php:

Context
-------

$_SERVER: Array
(
    [CommonProgramW6432] => C:\Program Files\Common Files
    [PHP_FCGI_MAX_REQUESTS] => 10000
    [PHPRC] => C:\Program Files (x86)\PHP\
    [ALLUSERSPROFILE] => C:\ProgramData
    [APPDATA] => C:\Windows\system32\config\systemprofile\AppData\Roaming
    [APP_POOL_ID] => DefaultAppPool
    [CommonProgramFiles] => C:\Program Files (x86)\Common Files
    [CommonProgramFiles(x86)] => C:\Program Files (x86)\Common Files
...and lots more like this, until..
)

$_POST: Array
(
)

$_GET: Array
(
)

$_FILES: Array
(
)

$_SESSION: {null}

$_COOKIE: Array
(
    [users_resolution] => 1440x900
    [fontSize] => 100
    [ja_purity_tpl] => ja_purity
)

Then a bit further down..

Uncaught fValidationException
-----------------------------
{doc_root}\consumables\index.php(22): include_once('C:\inetpub\wwwr...')
{doc_root}\consumables\inc\init.php(15): fSession::setPath('C:\inetpub\wwwr...')
{doc_root}\consumables\inc\flourish\fSession.php(450): fDirectory->__construct('C:\inetpub\wwwr...')
{doc_root}\consumables\inc\flourish\fDirectory.php(133)
The directory specified, C:\inetpub\wwwroot\consumables/session, does not exist or is not readable

Changes the db in init.php too. Is this php configuration that it isn't happy with?

[webman]

Create a directory called session (in your case, within c:\inetpub\wwwroot\consumables) and make it writeable.

Apologies - forgot to add that to the instructions.

[dgsmith]

Ah yes, jolly good, that sorted it. May I suggest you include some common manufacturers with the installation (like HP, Brother, Oki, Samsung etc)?

[webman]

Not a bad idea, will look at that.