Solved

VIN Scanning and voice data entry

Posted on 2011-02-21
4
647 Views
Last Modified: 2012-05-11
We would like to scan Vehicle Identification Numbers (VIN#) off of vehicles in the field (typically auto dealer parking lots).  We would like that data to be automatically entered into an Excel spreadsheet (preferably).  We would also like to use voice recognition software to add other vehicle information (e.g. year, make, model, etc....) into the same spreadsheet. Ultimately, we're trying to minimize the amount of keyed data entry in the field (conditions in the field can be very challenging: cold, heat, snow, rain, wind, etc...).

Do you have any recommendations for scanners to scan the VIN# and maybe voice recognition software to enter the additional information?  Any other general suggestions?  We're currently writing down all of the information by hand and then transcribing the information into Excel; very tedious, error prone and time consuming.

Any help would be greatly appreciated!
0
Comment
Question by:DarinOBrien
  • 2
4 Comments
 
LVL 45

Accepted Solution

by:
patrickab earned 250 total points
ID: 34947438
DarinOBrien,

Aren't most VIN recognition software really only photo data extraction routines?

If there is some central licensing system perhaps you can get permission to interrogate the database and extract the make, model, colour etc from that. That is done in the UK by many different companies/organisations who access the DVLA's database.

Ref for DVLA: http://www.direct.gov.uk/en/Dl1/Directories/UsefulContactsByCategory/MotoringContacts/DG_10012974

Patrick
0
 
LVL 38

Assisted Solution

by:Aaron Tomosky
Aaron Tomosky earned 250 total points
ID: 34947819
Vins have a barcode right? There are wireless and wired barcode scanners that work with everything. I have a Bluetooth wireless one that works with an iPhone.
0
 

Author Closing Comment

by:DarinOBrien
ID: 34978708
Found VIN scanners that could also provide car-specific information.  There's a broad range of capabilities with the VIN scanners and a broad range of prices.  I'm trying one of the cheapest ones.  

Also found Dragon Naturally Speaking for voice recognition software.
0
 
LVL 45

Expert Comment

by:patrickab
ID: 34978775
DarinOBrien - Thanks for the grade - Patrick
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

If you are having problems installing printer drivers, or if documents repeatedly get stuck in the print queue even after re-installing the printer drivers, then follow these steps to solve the problems. Please note that the steps are shown both for…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now