Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2011
    Posts
    2

    Inventory Database With Pictures

    Hello,

    I've got an Inventory of 1,000 parts and I would like to have this list available online via a web page. I need to include Part Number, Manufacturer, Description, and Notes. I also plan to take up to 10 photos of each part to include with the description.

    The idea is to make this available to the Technicians in the field so that they have a control part to reference while on site trying to assess damages.

    Over course I can't make 1 long page of parts, so I'm going to have to build a database.

    I'm open to suggestions and direction. I'm assuming either an SQL DB or something using ASP, but I'm drawing a blank as to where to begin.

    Thanks for your help,

    Mike

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    What kind of parts, how are they categorized, and how do your technicians think about them? Once you determine a taxonomy and what information you need to keep, you'll be most of the way to solving your problem.

    Explain what you are trying to do (what problems you are trying to solve for management, the technicians, etc), and we can probably help you!

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Jan 2011
    Posts
    2
    I need a page that they can go to:
    Part # _________
    Manufacturer ________
    Description _______
    [Search]

    Then I just need it to list all matches and when they select a match it opens to a "Details" page with the full description and extra Notes. Pics would also be on this page.

    Under normal circumstances they would know either the part number or the manufacturer. The parts usually reside in a unit has the manufacturer on it somewhere. The part number is normally on the part if we installed it, but sometimes it comes off or is damaged. (Bar Coded sticky label)

    Since you asked about it, most techs think about them by Manufacturer and by part number. Being able to search description might be moot point since the descriptions on the in house Inventory List are not all coded the same way.

    I think we're pretty much talking about some kind of PHP based web site using MySQL. I'm fine when it comes to hacking up someone else's PHP site, but I'm kind lost when building one from scratch.

  4. #4
    Join Date
    Sep 2006
    Posts
    265
    Have a look at this although this site is ASP with an Access 2003 Database admittedly with only one image:

    Trevor Sutton

    Simon

Posting Permissions

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