Clicky

I have created successful inventory solutions in the recent past using Windows Mobile Devices with WiFi, an application named, PTS Tracer Plus, PTS ODBC link, and a MySQL database.

Has anyone done any implementation with just a simple wireless barcode scanner with a host PC and automatically inserting the scans into a MySQL table or multiple tables that can be specified at runtime?

For example: John wants to scan in a new order received today.  John goes to the host PC and does something to choose where he wants his scans to go to, a particular operation like "RECEIVE PRODUCTS INTO INVENTORY", and then whatever he scans will be transmitted through the wireless barcode scanner to the host PC via the wireless scanner interface cradle (likely USB based plugged into the host PC).

At that point a host application detects the scans from that particular scanner and does something with them, etc...

I thought it could be as easy as "John" logging into a web page, choosing a task and then going to town scanning away.  Yes, I already know I can do that with a web page and setting the scanner to add a CRLF after every successful scan causing a FORM POST action that would inevitably do an insert into a chosen MySQL table.  But I want something a little more full-proof then that.  There are too many possibilities for error.

Anyone have any ideas or possible solutions?

asked 05/13/2010 02:49

wfninpa's gravatar image

wfninpa ♦♦


7 Answers:
Hi

I am currently working on an application that uses the NordicID unit (http://www.nordicid.com/en/products/nordic-id-rf-series/nordic-id-rf601.html)

The main benefit of this device is that you get an API with it that you can then create an application in C++,C# or even VB that then does the processing of the data, writing to SQL etc. It also has a screen on the device that allows you to send screen info back to the device based on the scans (It also has a keypad that can be used for input)  

I am finding that this really is a very good and stable system and very easy to interface to and build fool proof applications.

Wayne


link
WayneATaylor's gravatar image

WayneATaylor

Their website leaves much to be desired.  No pricing online?  Seems like a good concept.  But I'm looking more to use PHP and MySQL, not to say I couldn't do so with a host application written in another language like VB.  I would rather a host application that is windows-based provided by the manufacturer of the scanner or otherwise that I can simply configure to my needs.

I'm not that fond of ActiveX controls.
link
wfninpa's gravatar image

wfninpa

Ah ok. Most of these systems come with an SDK, this one comes with a DLL, you then simply call the functions within that. Should be able to do that from PHP.

You can actually download the SDK and an emulator from the site to develop without buying a device, so you could test it fully with your app.

I don't think they sell direct, we buy from a Distributor in the UK...

link
WayneATaylor's gravatar image

WayneATaylor

Thanks.  That deserves some credit.  I will award once I get the exact solution I am looking for.
link
wfninpa's gravatar image

wfninpa

We use Symbol scanners (now motorolla) and have programmed applications into them.  Our app was very simple, scan barcode A and the scanner is configured to drop check digit and do CR.  Scan barcode B and it is configured with check digit and Tab suffix.  
The programming can get very complex and use intelligence embedded in the barcode to change the function of the scanner.  
link
steveoskh's gravatar image

steveoskh

I just re-read your question and realize you were well aware of the answer I suggested.   I suspect you need a solution that works when the user can not see the PC screen to verify that the entry applied correctly and did not result in an error?  
Symbol had a wireless hand scanner that provided the basic keyboard type input but also had a small display that could show results from the application.  It was not what we needed for our specific application so we did not do any work with it.  I beleive it used the serial port for sending data from the application back to the scanner.   Not sure if serial was also used for the input interface.  
If this is of interest I will do the research to see if the model still exists.
link
steveoskh's gravatar image

steveoskh

Thank you for rereading my question.  I decided to use a solution by PTS which works great.  Rather than having to develop one on my own they had a ODBC wireless server and a customizable application developer for Windows Mobile devices so I went that route.

All it does is handle the scans as they are made and insert them into a DB table which I later get more sophisticated with on the WEB end.

It all worked out well.

Thanks.
link
wfninpa's gravatar image

wfninpa

Your answer
[hide preview]

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Tags:

×2
×1
×2
×81
×8
×1
×1
×1
×11
×6
×1
×50

Asked: 05/13/2010 02:49

Seen: 644 times

Last updated: 10/09/2010 09:16