+ Post New Thread
Page 2 of 20 FirstFirst 12345612 ... LastLast
Results 16 to 30 of 287
How do you do....it? Thread, Toner inventory Database in Technical; Originally Posted by maniac I will share my PHP/MYSQL creation if anyone wants it, but it was never written for ...
  1. #16
    p858snake's Avatar
    Join Date
    Dec 2008
    Location
    Queensland
    Posts
    1,490
    Thank Post
    37
    Thanked 175 Times in 151 Posts
    Blog Entries
    2
    Rep Power
    51
    Quote Originally Posted by maniac View Post
    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).

  2. #17

    tmcd35's Avatar
    Join Date
    Jul 2005
    Location
    Norfolk
    Posts
    5,620
    Thank Post
    845
    Thanked 882 Times in 731 Posts
    Blog Entries
    9
    Rep Power
    326
    Quote Originally Posted by CyberNerd View Post
    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

  3. Thanks to tmcd35 from:

    Ben_Alton (28th April 2011)

  4. #18

    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
    Quote Originally Posted by tmcd35 View Post
    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

  5. #19

    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

  6. 12 Thanks to webman:

    cromertech (3rd November 2010), CyberNerd (19th September 2010), dgsmith (18th September 2010), fiza (30th July 2013), gumbygaz (30th September 2010), IKWeb (18th September 2010), jamiess (19th September 2010), RabbieBurns (3rd November 2010), round2it (10th January 2011), rush_tech (26th August 2011), stariq (20th September 2010), zag (21st October 2010)

  7. #20

    Join Date
    Jan 2009
    Location
    Essex / Macclesfield
    Posts
    272
    Thank Post
    28
    Thanked 8 Times in 6 Posts
    Rep Power
    13
    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.


  8. #21

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,630
    Thank Post
    514
    Thanked 2,442 Times in 1,890 Posts
    Blog Entries
    24
    Rep Power
    831
    Quote Originally Posted by IKWeb View Post
    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.

  9. Thanks to localzuk from:

    webman (18th September 2010)

  10. #22

    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
    Sorry, should have mentioned how to get it as a ZIP file Thanks localzuk.

  11. #23
    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
    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.

  12. #24

    john's Avatar
    Join Date
    Sep 2005
    Location
    London
    Posts
    10,507
    Thank Post
    1,492
    Thanked 1,050 Times in 919 Posts
    Rep Power
    302
    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

  13. #25
    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
    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..

  14. #26

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,114
    Thank Post
    403
    Thanked 619 Times in 566 Posts
    Rep Power
    180
    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!)

  15. #27
    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
    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:

    Code:
    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..

    Code:
    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?

  16. #28

    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
    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.
    Last edited by webman; 20th September 2010 at 03:21 PM.

  17. #29
    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
    Ah yes, jolly good, that sorted it. May I suggest you include some common manufacturers with the installation (like HP, Brother, Oki, Samsung etc)?

  18. #30

    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
    Not a bad idea, will look at that.

SHARE:
+ Post New Thread
Page 2 of 20 FirstFirst 12345612 ... 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
  •