Toner inventory Database

[fiza]

Added it to the list @fiza

 

Thanks

[dcorwin822]

I had another idea that I think would be nice. Weekly reports that are emailed. Would be nice to have it automatically email a list of low and critical consumables to our purchasing department or to me.

[webman]

Thanks dcorwin822, that sounds like a useful feature as well. Added to the list

[Techie-v2]

Installed today, looks great and works well.

 

One suggestion I do have, we have quite a long list of printers so when installing a toner, we have to scroll back to the top after clicking on a printer lower in the list so would it be possible to either automatically jump back to the top of the page or have the available toners appear next to the printer you have selected.

[fiza]

Installed today, looks great and works well.

 

One suggestion I do have, we have quite a long list of printers so when installing a toner, we have to scroll back to the top after clicking on a printer lower in the list so would it be possible to either automatically jump back to the top of the page or have the available toners appear next to the printer you have selected.

 

If you know the printer name/location couldnt you use the search facility (on the install consumables page) and narrow down the printer names? In this way the printer appears at the top and the consumables next to it (once you highlight the desired printer).

Edited November 19, 2013 by fiza

[Techie-v2]

If you know the printer name/location couldnt you use the search facility (on the install consumables page) and narrow down the printer names? In this way the printer appears at the top and the consumables next to it (once you highlight the desired printer).

 

Yeah that works

 

Thanks!

[eskIT]

Is there a complete dummies guide to get this working on our internal network?

[fiza]

I followed the short guide here :https://github.com/craigrodway/printmaster

Also @webman is very good at answering questions if you ask him something directly on here.

 

We've been using it a while now and its excellent.

[eskIT]

I followed the short guide here :https://github.com/craigrodway/printmaster

Also @webman is very good at answering questions if you ask him something directly on here.

 

We've been using it a while now and its excellent.

 

 

Its exactly what ive been looking for but struggling to get it setup.

 

Any idea if this can use SQL 2012 instead of MySQL?

[eskIT]

* I have created the following path:

C:\inetpub\wwwroot\printmaster

 

and extracted the content of the .zip file downloaded.

 

* C:\inetpub\wwwroot\printmaster already has the Session folder created and readonly access removed

 

Now i need to import the .sql content but doing this in SQL2012 gives errors.

[plexer]

@eskIT Sorry but you can't use it as it stands and stick in a different sql server i.e MSSQL instead of MySQL.

 

Ben

[eskIT]

@eskIT Sorry but you can't use it as it stands and stick in a different sql server i.e MSSQL instead of MySQL.

 

Ben

 

 

Thanks for clearing that up

 

Will get MYSQL on my server....

 

It wont have any implications on MSSQL will it?

[fiza]

Thanks for clearing that up

 

Will get MYSQL on my server....

 

It wont have any implications on MSSQL will it?

 

I just created a VM just for Print Master - saves adding it as an additional application to an existing server.

[dcorwin822]

I currently use XAMPP. Had it up and running in under 10 mins from downloads to adding inventory. XAMPP allows for portability as well, I'm currently running it off of my desktop as i'm the only one managing our printing supplies.

[dcorwin822]

I created a simple XAMPP lite install, with the database stuff done to get PrintMaster to work. You can download it here. Download, extract, run "setup_xampp.bat", run xampp-control.exe, start mysql and apache, and login to 127.0.0.1/printmaster-master/

 

I did not set up any type of security or passwords. You will want to investigate those settings/options asap.

Edited November 25, 2013 by dcorwin822

[webman]

Thanks to those who have offered help here with regards to MSSQL

 

The database libraries I use in PrintMaster, in theory, support multiple databases - but the queries have to be written in a slightly different, generic, way. For most of the project I think that would be fine - but there are several queries in there at the moment that use mainly MySQL-specific functions and syntax, which would need to be updated.

 

So - if MSSQL was something that people really wanted to be supported, I could look into the possibility of updating the project to support it "out of the box". The only problem is that I don't know much about using MSSQL at all Do I just download SQL Server Express and away I go?

[dcorwin822]

Also can we get a supply for something other than a toner colour? Maybe icons for, fuser assemblies, imaging units (drums), toner collection units, rollers, and other "consumable supplies"?

[eskIT]

Thanks for the suggestions guys.

 

Id like to use this between 2 departments so will not be able to install just on My PC.

 

I have tried installing mysql on the server but will not allow me to create new database using the command line syntax CREATE DATABASE. Where am i going wrong?

 

Webman im not a pro at MSSQL but i assume just installing SQL Express would give you all required.

 

CANT WAIT TO USE YOU APP!! Its going to save us alot of hassle

[webman]

Hi eskIT.

 

What errors are you receiving when you try to make the database? How are you trying to do these?

 

When you set up MySQL, you should have set a "root" password at some point. When you log in as root with that password, you should be able to do anything - including creating new databases.

[fiza]

@webman - ive said it before - excellent bit of software!!

 

Any news on those changes? (adding in chargeback ticks)

[eskIT]

I set the Root password and allows me to login. when i try creating the database i get no errors just carriage return to the next line.

[fiza]

@eskIT - use apache friends - xampp for windows

 

It made things so easy for me to install Print Master.

[dcorwin822]

@eskIT - use apache friends - xampp for windows

 

It made things so easy for me to install Print Master.

 

A few posts ago I made a zip file with xampp and PM setup available for a "quick setup".

[webman]

@webman - ive said it before - excellent bit of software!!

 

Any news on those changes? (adding in chargeback ticks)

 

Thanks fiza Sadly not - I haven't had any time lately to work on this

 

 

I set the Root password and allows me to login. when i try creating the database i get no errors just carriage return to the next line.

 

Ah! OK. If you add a semicolon after your commands, it should be fine. For example:

 

CREATE DATABASE printmaster;

[dcorwin822]

Anyway we can make better use of screen real estate? There's a lot of useless space to the left and right of the Install consumable Consumable stock columns.