+ 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,512
    Thank Post
    1,320
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    199

    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,401
    Thank Post
    637
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    319
    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,104
    Thank Post
    118
    Thanked 90 Times in 78 Posts
    Rep Power
    36
    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,512
    Thank Post
    1,320
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    199
    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,199
    Thank Post
    447
    Thanked 173 Times in 170 Posts
    Blog Entries
    3
    Rep Power
    63
    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
    17,607
    Thank Post
    514
    Thanked 2,441 Times in 1,889 Posts
    Blog Entries
    24
    Rep Power
    828
    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,703
    Thank Post
    3,235
    Thanked 1,043 Times in 965 Posts
    Rep Power
    363
    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,037
    Thank Post
    209
    Thanked 425 Times in 306 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,037
    Thank Post
    209
    Thanked 425 Times in 306 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
  •