this is a new one to me

i want to detect a scanned barcode then return a translated string to an external program
the barcode scanner is a usb hid, so works like a keyboard wedge
it also has serial mode if i ever figure how to use it

the barcodes are as received and completely out of my control, i am unable as yet to identify what type they are, from several different manufacturers

i can see several options for this, but really looking for best solution, not to cause other issues on the computer

i can see a simple 2 field database table to look up the product id from the scan, with UI to add new
a keyboard hook should detect incoming scans, but how best to read the barcode string, then send the productid to external programs focused control

anyone done any of this or have suggestions please