+ Post New Thread
Page 14 of 20 FirstFirst ... 4101112131415161718 ... LastLast
Results 196 to 210 of 287
How do you do....it? Thread, Toner inventory Database in Technical; Originally Posted by webman Hi. Yes! This would be quite an easy change to add. I will look at adding ...
  1. #196

    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    2,123
    Thank Post
    416
    Thanked 313 Times in 264 Posts
    Rep Power
    152
    Quote Originally Posted by webman View Post
    Hi. Yes! This would be quite an easy change to add. I will look at adding this soon.


    No purchase cost for printers this time around ?
    but still a fantastic upgrade.

  2. #197

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,406
    Thank Post
    639
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    324
    Quote Originally Posted by fiza View Post
    No purchase cost for printers this time around ?
    but still a fantastic upgrade.
    D'oh!

    Soon

  3. #198

    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    2,123
    Thank Post
    416
    Thanked 313 Times in 264 Posts
    Rep Power
    152
    Quote Originally Posted by webman View Post
    D'oh!

    Soon
    I look forward to the next upgrade.

  4. #199
    nicholab's Avatar
    Join Date
    Nov 2006
    Location
    Birmingham
    Posts
    1,493
    Thank Post
    4
    Thanked 97 Times in 93 Posts
    Blog Entries
    1
    Rep Power
    50
    Great product could it:
    Show the total value of all stock
    Pick up SMTP from the printers so that low toner could be picked up
    Produce toner order for suppliler
    Send monthly e-mails to finace with departmental charge backs

  5. #200

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,611
    Thank Post
    647
    Thanked 1,616 Times in 1,446 Posts
    Rep Power
    421
    Quote Originally Posted by nicholab View Post
    Great product could it:
    Show the total value of all stock
    Pick up SMTP from the printers so that low toner could be picked up
    Produce toner order for suppliler
    Send monthly e-mails to finace with departmental charge backs
    Install new toners itself and make the tea?

    Only joking.

    Ben

  6. #201

    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    2,123
    Thank Post
    416
    Thanked 313 Times in 264 Posts
    Rep Power
    152
    Quote Originally Posted by webman View Post
    Hello again.

    PrintMaster is now at version 1.2.0, which now includes the discussed cost feature.



    Please read the upgrade instructions, paying attention to the step that involves running /upgrade.php - this is important, and makes the necessary database changes. You will also need to add the currency value mentioned to the inc/config.php file.
    @webman - Can the cost of the consumable be more than £99? I ask as we have some old printers that take cartridges costing more than £100. I dont intend to purchase anymore cartridges for these but we do have some stock on the shelf already. I tried putting in a cost of £104 but it came back as £99 on the consumables screen. Is it as easy to change as going into mysql Db and changing the "Length/Values" attribute for cost from 4,2 to 5,2?

  7. #202

    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    2,123
    Thank Post
    416
    Thanked 313 Times in 264 Posts
    Rep Power
    152
    @webman - I added the costs for the cartridges directly into the db via phpmyadmin. I have already installed some cartridges so I was hoping that the reports screen would now reflect the fact that I had added costs to the cartridges. The report shows nothing under costs for those cartridges I already installed before adding in the costs.

  8. #203

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,406
    Thank Post
    639
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    324
    Quote Originally Posted by fiza View Post
    @webman - Can the cost of the consumable be more than £99?
    It can now, yes.

    Quote Originally Posted by fiza View Post
    No purchase cost for printers this time around ?
    but still a fantastic upgrade.
    Consider it done!


    Download v1.3.0 (includes fix for consumable costs and added purchase date & cost to printers). Don't forget to read upgrade/changes files.


    In response to the costs in the report section. The cost is stored with each log entry at the time, to account for variation in consumable costs over time. E.g. log an install when a consumable is £40, the log entry will be £40. If you then change the consumable cost to £50, previous log entries will remain at £40. This is just to ensure that they always remain accurate, regardless of any changes. If you need to update your logs for that expensive consumable, I would suggest just updating that manually yourself after upgrading to the latest version. The cost columns should now all be float(6,2).

  9. 3 Thanks to webman:

    fiza (24th August 2013), FragglePete (23rd August 2013), zag (25th August 2013)

  10. #204

    Join Date
    Feb 2008
    Location
    Wiltshire
    Posts
    883
    Thank Post
    274
    Thanked 139 Times in 112 Posts
    Blog Entries
    27
    Rep Power
    42
    This is brilliant @webman, thank you! Have set it up for all our printers and have done a stock check and now have it all sitting in this system.

    The only change I would like to ask for, would it be possible to show the Department for the printer on the Report Page? And be able to sort by this as well? Also, it would be nice to be able to show the cost to each department as a total along with the Grand Total.

    Mucho appreciated!

    Pete

  11. #205

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,406
    Thank Post
    639
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    324
    Hi Pete.

    A departments feature has always been on the TODO list, but have never really gotten round to adding it. Might do that very soon as well to keep the momentum up

  12. #206

    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    2,123
    Thank Post
    416
    Thanked 313 Times in 264 Posts
    Rep Power
    152
    @webman - One of the techies has inadvertantly installed a consumable to the wrong printer. Our report now is incorrect. Is there an easy way to amend this mistake?

  13. #207

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,406
    Thank Post
    639
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    324
    Quote Originally Posted by fiza View Post
    @webman - One of the techies has inadvertantly installed a consumable to the wrong printer. Our report now is incorrect. Is there an easy way to amend this mistake?
    For now, I'm afraid you'll have to delve into the database using phpMyAdmin/HeidiSQL to alter or delete the log entry.

  14. #208

    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    2,123
    Thank Post
    416
    Thanked 313 Times in 264 Posts
    Rep Power
    152
    Quote Originally Posted by webman View Post
    For now, I'm afraid you'll have to delve into the database using phpMyAdmin/HeidiSQL to alter or delete the log entry.
    I thought I would have to. Any indicators as to which table the entry would be in?

  15. #209

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,406
    Thank Post
    639
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    324
    It will be in the 'events' table. The date fields should be readable. You can find the ID of the printer in question by going to the Printers page, click the Edit link on the one that it was wrongly installed to, and look at the address bar at the last bit that says "id=X" where X will be the ID number.

  16. Thanks to webman from:

    fiza (6th September 2013)

  17. #210

    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    2,123
    Thank Post
    416
    Thanked 313 Times in 264 Posts
    Rep Power
    152
    Thank you - all is well again!!

SHARE:
+ Post New Thread

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
  •