+ Post New Thread
Page 1 of 20 1234511 ... LastLast
Results 1 to 15 of 287
How do you do....it? Thread, Toner inventory Database in Technical; I was just about to knock up a stock control MS Access database for our toner supplies.. But figured someone ...
  1. #1

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,531
    Thank Post
    1,341
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    200

    Toner inventory Database

    I was just about to knock up a stock control MS Access database for our toner supplies.. But figured someone must have done this already...

    Has anyone got one they would be willing to share please?
    Last edited by RabbieBurns; 26th August 2010 at 06:24 AM.

  2. #2

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,413
    Thank Post
    642
    Thanked 964 Times in 664 Posts
    Blog Entries
    2
    Rep Power
    327
    I'm currently working on something like that for my degree project, using PHP/MySQL. Will let you know once it's finished.

  3. 6 Thanks to webman:

    IWDave (20th February 2014), lionsl2005 (19th January 2011), mac_shinobi (26th August 2010), RabbieBurns (14th January 2011), talksr (9th March 2011), zag (18th October 2013)

  4. #3
    Flakes's Avatar
    Join Date
    Nov 2009
    Location
    Newcastle
    Posts
    476
    Thank Post
    38
    Thanked 74 Times in 48 Posts
    Rep Power
    27
    GLPI Helpdesk and inventory has one built in, put your toners into the Cartridges Inventory, and list your printers in the Printer Inventory, you then can say which toners are compatible with each printer then add and remove stock and, "install" cartridges into printers. its a really nice system, think ive made it sound more complicated than it actually is. GLPI - Gestionnaire libre de parc informatique

  5. #4


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    database is a bit overkill?
    We use a google docs spreadsheet/form.

  6. #5
    dgsmith's Avatar
    Join Date
    Nov 2007
    Location
    Merseyside, England
    Posts
    1,108
    Thank Post
    119
    Thanked 90 Times in 78 Posts
    Rep Power
    37
    I just have a printed list in the office with amount of each in stock, and when I use a cartridge reduce the number by 1. When I get to 0 I know there aren't any left. Keep it simple =)

  7. #6
    Flakes's Avatar
    Join Date
    Nov 2009
    Location
    Newcastle
    Posts
    476
    Thank Post
    38
    Thanked 74 Times in 48 Posts
    Rep Power
    27
    Quote Originally Posted by CyberNerd View Post
    database is a bit overkill?
    We use a google docs spreadsheet/form.
    Think it depends on the size of the business/school, on a small scale it is overkill in a school with lots of printers it makes sense.

    ours is set up to email a warning when stock of any toner gets to 2, then a new order is put in place. very useful.

  8. #7

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,531
    Thank Post
    1,341
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    200
    We have a spreadsheet just now but its becoming unmanageable. Have 2 campuses to look after too.

    Will have a look at your suggestion tomorrow, cheers flakes.

  9. #8
    Cache's Avatar
    Join Date
    Apr 2008
    Location
    Cumbria
    Posts
    1,258
    Thank Post
    471
    Thanked 181 Times in 178 Posts
    Blog Entries
    3
    Rep Power
    66
    I started using GLPI since I needed to get a new asset management system anyway. If you go into all the details of it, handy for linking to suppliers and pricing to keep an extra track of things, but I'm only just starting with that.

  10. #9

    Join Date
    Jan 2009
    Location
    Essex / Macclesfield
    Posts
    272
    Thank Post
    28
    Thanked 8 Times in 6 Posts
    Rep Power
    13
    Quote Originally Posted by webman View Post
    I'm currently working on something like that for my degree project, using PHP/MySQL. Will let you know once it's finished.
    I would be very interested to take a look at this when you have finished it, or even test it if you want feedback.

  11. #10

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,142
    Thank Post
    522
    Thanked 2,550 Times in 1,979 Posts
    Blog Entries
    24
    Rep Power
    877
    Quote Originally Posted by dgsmith View Post
    I just have a printed list in the office with amount of each in stock, and when I use a cartridge reduce the number by 1. When I get to 0 I know there aren't any left. Keep it simple =)
    How do you keep track of individual printer costs, to know if a model is costing a huge amount more than others?

  12. #11

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,897
    Thank Post
    3,420
    Thanked 1,081 Times in 997 Posts
    Rep Power
    369
    Quote Originally Posted by webman View Post
    I'm currently working on something like that for my degree project, using PHP/MySQL. Will let you know once it's finished.
    Let me know as well - would be good

  13. #12

    maniac's Avatar
    Join Date
    Feb 2007
    Location
    Kent
    Posts
    3,070
    Thank Post
    210
    Thanked 430 Times in 310 Posts
    Rep Power
    144
    I have an in house solution that latches into our assets management which was also written by me in house, all PHP and SQL based. Anything on the assets database marked as a printer automatically appears in the toner management system, and then you can tell it what consumables each type of printer needs - you only have to do this once for each model.

    Whenever you change a toner in a printer, get the asset number off the back, look it up on the list, click change toner - if it's a colour one there's an additional step to select which one, job done! It knocks one of the stock file and logs a toner change against that printer. It's dead handy for seeing how much toner a particular printer gets through.

    On the front screen it alerts us to low stock scinarios, which it does by looking at the history of toner changes for that cartridge type, ad the number of printers requiring that cartridge and estimating how many we need in stock to cover us for the next 4 weeks - if there's less than 4 weeks worth in stock it alerts us. It's not 100% accurate yet, I'm still tweeking the algorithm for this. There's also a simple booking in system for when we get deliveries and a stock checking system as well.

    Does the job for us!

    Mike.

  14. #13


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    Quote Originally Posted by Flakes View Post

    ours is set up to email a warning when stock of any toner gets to 2, then a new order is put in place. very useful.
    Good Idea! I might write a script so our Google spreadsheet sends an email...

    we do have 50 odd printers, but I didn't really notice it being difficult to manage. Would be interested in the php/mysql as well.

  15. #14


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    Quote Originally Posted by CyberNerd View Post

    Good Idea! I might write a script so our Google spreadsheet sends an email....
    Thinking aloud, I could probably get the spreadsheet to automatically generate an order requisition, and email it to our finance team as soon as the toner stock gets low.
    Theres loads of info about these scripts here:
    Spreadsheet Services - Google Apps Script - Google Code

    /enthusiasm

  16. #15

    maniac's Avatar
    Join Date
    Feb 2007
    Location
    Kent
    Posts
    3,070
    Thank Post
    210
    Thanked 430 Times in 310 Posts
    Rep Power
    144
    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:
+ Post New Thread
Page 1 of 20 1234511 ... LastLast

Similar Threads

  1. OCS Inventory
    By Geoff in forum Downloads
    Replies: 5
    Last Post: 3rd June 2011, 08:40 AM
  2. Inventory
    By school in forum Scripts
    Replies: 2
    Last Post: 3rd June 2010, 02:18 PM
  3. Inventory
    By mmoseley in forum Network and Classroom Management
    Replies: 15
    Last Post: 20th June 2007, 12:31 PM
  4. Replies: 4
    Last Post: 28th February 2007, 09:37 AM
  5. inventory system
    By bjg5858 in forum General Chat
    Replies: 2
    Last Post: 11th July 2006, 09:10 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •