Sign in with
Sign up | Sign in
Your question
Closed

Software to scan barcode, reference XLS file, extract data, and export into CSV

Last response: in Computer Peripherals
Share
March 22, 2013 12:57:14 PM

Hi, all--
I'm looking for software that is capable of scanning a barcode from a document (maybe by only scanning a certain section?), searching an XLS file for that scanned number, and then exporting the corresponding data from the same row in that XLS file into a CSV file, comprised of all the data taken from the XLS.

Any ideas? I feel as if I only partially know what I'm asking, but any fingers in the right direction or further narrowing questions would greatly help.

Thank you!
March 22, 2013 1:21:41 PM

It could all be done in Excel with some creative programming.
Score
0
March 22, 2013 1:53:03 PM

Arshuah said:
Hi, all--
I'm looking for software that is capable of scanning a barcode from a document (maybe by only scanning a certain section?), searching an XLS file for that scanned number, and then exporting the corresponding data from the same row in that XLS file into a CSV file, comprised of all the data taken from the XLS.



This is either a (mostly) off the shelf Point of Sale system, similar to what you'd see in a checkout line,
or
A full custom coding job. Depending on the rest of your unknown requirements, it could be done relatively easily, even in Excel.
But don't get hung up on 'it has to interface with an XLS'. The right solution may be something else entirely.

When laying down software requirements, generally it is better to start off in very general terms, rather than specifying particular file formats.

What is the workflow?
"I need to scan in a barcode, search for its corresponding info in the database, and output that info, possibly to a CSV file."

How many users, how often, number of locations, budget, timeline...all have an impact on the final solution.
Score
0
June 23, 2013 7:59:58 PM

abby123 said:
Hi
Will this 1D and 2D barcode scanner meet your requirements? There are detailed functions and operation steps.

This tool is not bad.

Score
0
November 19, 2013 11:52:09 PM

My suggestion is to get a hardware barcode scanner which works more accurately and faster.
Score
0
!