+ Post New Thread
Page 2 of 20 FirstFirst 12345612 ... LastLast
Results 16 to 30 of 291
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,491
    Thank Post
    37
    Thanked 175 Times in 151 Posts
    Blog Entries
    2
    Rep Power
    52
    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
    6,069
    Thank Post
    902
    Thanked 1,013 Times in 825 Posts
    Blog Entries
    9
    Rep Power
    350
    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,532
    Thank Post
    1,341
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    200
    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,422
    Thank Post
    645
    Thanked 967 Times in 667 Posts
    Blog Entries
    2
    Rep Power
    328

  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
    14
    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
    18,529
    Thank Post
    527
    Thanked 2,648 Times in 2,049 Posts
    Blog Entries
    24
    Rep Power
    925
    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,422
    Thank Post
    645
    Thanked 967 Times in 667 Posts
    Blog Entries
    2
    Rep Power
    328
    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,111
    Thank Post
    119
    Thanked 90 Times in 78 Posts
    Rep Power
    37
    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,447
    Thank Post
    1,537
    Thanked 1,069 Times in 934 Posts
    Rep Power
    305
    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,111
    Thank Post
    119
    Thanked 90 Times in 78 Posts
    Rep Power
    37
    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,459
    Thank Post
    409
    Thanked 672 Times in 614 Posts
    Rep Power
    192
    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,111
    Thank Post
    119
    Thanked 90 Times in 78 Posts
    Rep Power
    37
    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,422
    Thank Post
    645
    Thanked 967 Times in 667 Posts
    Blog Entries
    2
    Rep Power
    328
    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 04:21 PM.

  17. #29
    dgsmith's Avatar
    Join Date
    Nov 2007
    Location
    Merseyside, England
    Posts
    1,111
    Thank Post
    119
    Thanked 90 Times in 78 Posts
    Rep Power
    37
    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,422
    Thank Post
    645
    Thanked 967 Times in 667 Posts
    Blog Entries
    2
    Rep Power
    328
    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, 09:40 AM
  2. Inventory
    By school in forum Scripts
    Replies: 2
    Last Post: 3rd June 2010, 03:18 PM
  3. Inventory
    By mmoseley in forum Network and Classroom Management
    Replies: 15
    Last Post: 20th June 2007, 01:31 PM
  4. Replies: 4
    Last Post: 28th February 2007, 10:37 AM
  5. inventory system
    By bjg5858 in forum General Chat
    Replies: 2
    Last Post: 11th July 2006, 10: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
  •