Inventory Tracking Using Handhelds? 19
DJ Decepticon asks: "I've recently been given the task to determine the feasibility of tracking several hundred workstations spread out across North America using a handheld device. Requirements include having a barcode and GPS reading and inputing that information into a spreadsheet. Would a handheld device such as Palm or Handspring be able to take on such a task?" Aparently there are PalmPilot's with integrated barcode readers at Symbol.Com, however I don't know about ones that also include GPS. If anyone has used these units before, how difficult would it be to add GPS functionality? Are there other solutions?
did it w/o GPS (Score:2, Interesting)
GPS and stuff is fine. (Score:1)
they (scanner + GPS) work over the serial port and use fairly simple 7 bit data transfer over well documented protocols so you should be ok.
Why GPS? (Score:2)
The barcode functionality should be fine for actual identification of the asset. Use good old fashioned address/room no. to locate the computer. If you don't want your people to have to manually enter data, use pull down menus or 4 digit alphanumeric codes for sites.
Remember that GPS requires a line of sight to 3 or more satellites and is accurate to 30m. I don't know about your sites, but my computer room is in the windowless 2nd floor of a 20-story building, where gps won't work. Also, a 30m margin of error could place my desk somewhere in the middle of the street.
Re:Why GPS? (Score:2)
No, you can't get a tour. Trust me.
Re:Why GPS? (Score:2)
Re:Why GPS? (Score:2)
Say the first floor of your building houses the HR and accounting staff; third floor houses call center agents. What group does a particular desktop belong to without height information?
I'll restate my original point; GPS is a total waste of time, unless you are inventorying pipeline equipment or something that is fixed and in a remote location.
What good does knowing where a PC is within 5 meters do? Offices reshuffle all the time and pc's change hands as new computers are ordered. All you need to know for a physical inventory is that the machine is present and what group (IT, development, accounting, etc) it belongs to.
I work in the enterprise systems management group for several large state agencies. We use Tivoli Inventory and a couple of asset management tools to inventory and keep track of over 65,000 pc's scattered throughout the state. As our network maps have evolved and become more details, we have been able to locate pc's down to the exact switch/hub port that it is connected to. If the pc is hooked to an unmanaged hub, we have scripts that talk to active directory and figure out who normally logs into the computer.
The scripts needed to accomplish this took two people about two weeks to implement. The result is inventory info that can be updated nearly in real-time, down to whatever level of detail you need.
Compare the cost of that to outfitting IT people with barcode reader equipped handhelds running all over the place scanning stuff.
Re:Why GPS? (Score:2)
I second the notion that a simple barcode based tracking system is best here. While it's possible to spoof it, usually this isn't a concern. I was the programming staff for Management Support Systems, which marketed such a system using NORAND handhelds back in the 1990s... and am considering bringing the code back out of the closet, and putting a nice GUI in front of it for Windows.
--Mike--
this is what i need! (Score:1)
We have to log all of our computer fixes that we do throughout the day.
I need something in which I can type the problem, the fix, and the date. Anyone know of such a beast?
Re:this is what i need! (Score:1)
Seriously, if you have to type in the problem and the fix, it isn't going to kill you to type in an asset code or something. As a hint, if you're not using Dells (with their nifty little ID tags), and you want to avoid the pain of having to type in the full serial number each time, put together a table in your database where you have all the serial numbers of your items (type once), then link it to a short asset number. Get a label maker, put label on item. When item comes through your door, type in the asset number, and be done with it.
The pain and hassle of acquiring (relatively) expensive barcode readers and coding up the necessary software more than likely outweighs the pain and hassle of having to type in a serial number once and an asset number multiple times -- ESPECIALLY if you have to type anyway. The only time that barcoding is really worth it is if it can save you LARGE amounts of typing time. Normally, it can't. You will have to think long and hard about the ability of barcoding to automate work processes.
An example of the above is inventory: you can scan in the barcode of the item you are checking in, scan in the code of the shelf, scan in the bin/box/whatever, and your app will track where you put something. Great, right? Another real world example: a nurse scans the barcode of the patient's wristband, scans the barcode of the drug she has, and the app checks to see that the drug is indeed the one prescribed for this patient, and throws a warning if it isn't or if the dosage is incorrect. If it *is* the correct prescription and patient, the nurse dispenses the drug, then scans her *own* barcode, and the hospital information system records that the drug was dispensed by the nurse to the patient. The first application might be relatively easy to code; the second one is not.
The real question you should be asking yourself is whether you can automate your process so that you can achieve the same level of functionality without typing. When it comes to describing problems and resolutions, I don't think you can. Maybe you can create a list of barcodes for your common problems, and a list of codes for your normal resolutions, and automate that way -- but remember to make sure that the exceptions (when they inevitably happen) are not so hard to use that it's not more work than it is worth.
barcode reader (Score:1)
Why GPS for asset tracking? (Score:1)
I've been looking at these for ages... (Score:1)
As for getting GPS working with them, they are fully functional palm pilots, so any GPS software available for them will work. Palms aren't big on expansion slots, so they will have to plug into the cradle port.
Symbol do have a PocketPC based unit, the SPT2700 [symbol.com] (UKP1200+). These have the same options (802.11(&
Recently I have found This, the Psion Teklogix 7510 [psionteklogix.com]. It is a full PC with a 586 133MHz chip and a hard drive. It has built in scanner and RF options, and 2 internal / 1 external PCMCIA slots. With a 6" screen, it is a perfect little box. You can run whatever operating system you like, and write whatever code you like for them. They are ruggedised and waterproof, and are built for use on forklifts etc, so they should take a bashing and keep working.
The only problem? At $4300 a piece with barcode and 802.11b, they ain't cheap...
Am I missing something? (Score:1)
And if that's the case, why don't you just have them all track themselves? They can run the same sort of tracking programs as the handheld, right? The only thing you miss on is the GPS requirement, and I question the utility of that anyway. I've always had workstations I've been responsible for inventory themselves; saves a lot of trouble.
drop the palm pilot and get a data collector (Score:1)
Return to CENTRAL and download data from data collector.
You could speed things up if the location has a barcode, the floor listings on the elevators have a barcode and the rooms have barcodes... but we dont live in that kind of world
DRACO-
Handheld and Inventory (Score:1)