?
Solved

VIN Scanning and voice data entry

Posted on 2011-02-21
4
Medium Priority
?
687 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 45

Accepted Solution

by:
patrickab earned 1000 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 39

Assisted Solution

by:Aaron Tomosky
Aaron Tomosky earned 1000 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It started not too long ago. It was at first annoying. My keystrokes seemed to be randomly generated, not the ones I typed on the keyboard. For some reason this only happened in certain applications (especially browsers such as IE11, Firefox and Chr…
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

770 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