Can anyone help a newbie?
I am not a prgrammer. Just a networking guy stuck with managing a new database that manages our maintenance program and inventory.
The work order section is easy. But the inventory section is a nightmare in that the inventory arrives at my warehouse, then gets checked out for initial testing and configuration, then checked back into warehouse inventory, then gets issued to contractors who install it in the field (becomes part of field inventory by location), and then my technicians maintain it in the field often swapping out parts that also must be tracked.
What I want to do is create a bar code upon initial entry into the database and use that to track the item through its lifecycle at different locations. I understand that barcode readers are simply I/O devices like a keyboard. What I need is a means to interface a barcode reader with my database so that I can track the movement of this inventory.
Database setup is SQl 2005 server with a web interface using Apache and JBoss.
Any suggestions on compatible readers and 3rd party interfaces that may be a good starting point for this solution?