Component Manufacturers Barcode

Subscribe to Thread

Like many other circuit assemblers we cross reference an inc... - Oct 12, 2016 by hken

Hi Pro We are using the barcode system for checking MPN... - Nov 07, 2016 by anhsang38

That's fine for Toshiba but what do you do for other Mfg's w... - Nov 07, 2016 by hken

hken

#76453

Component Manufacturers Barcode | 12 October, 2016

Like many other circuit assemblers we cross reference an incoming reel of components Manufacturers PN (MPN) to our company’s Internal Part number (IPN). For years I've been scanning the MPN & Qty on the manufacturers label and using a simple database to equate their number to ours. The manufacturers have been using barcode formats Code 39 or 128. Manufacturers are changing to 2D barcode formats such as PDF417 (Vishay) or Data Matrix ECC200 (Bourns) which have large character capacity and they are embedding all their information fields in a single barcode character string. My problem now is, how do I determine where the PN, Qty, … is in the very large string of data. Yes, I can ask Vishay what their format is to determine where I need to look but what about Texas Instruments, Panasonic, Bourns, … they are all different. The component manufacturers are not coordinating a common data format.

Vishay PDF417 format barcode data string sample: DF02SA-E3/77 HO0000000005/09/16 201620CNHO 1500 501303398 000011620 S0130010 HO0000360101

Bourns Data Matrix ECC200 format barcode data string sample: PSRU8043-470Y+Q1000+9D1602+1TCA164778M

reply »

anhsang38

#76574

Component Manufacturers Barcode | 7 November, 2016

Hi Pro

We are using the barcode system for checking MPN when we change the new component reel. My company have been using Microsoft access for showing this string. For each MPN we can change to IPN by this software. Ex: this is barcode data string of Toshiba: Y36184763T5CX3 (F,J)1600 TFGSHWLX... But "Y36184763T5CX3 (F,J)" is fixed. Therefore "Y36184763T5CX3 (F,J)" is defauted for 0932091-5(IPN). So, When we scan MPN it will be change to IPN.

Barcode system

1.[.............] IPN

2.[.............] MPN

When 2= Y36184763T5CX3 (F,J)1600 TFGSHWLX... then 1= 0932091-5

reply »

hken

#76577

Component Manufacturers Barcode | 7 November, 2016

That's fine for Toshiba but what do you do for other Mfg's with different formats? And how do you resolve the 255 character input limit in Access for Mfg's with more characters in the barcode string like Vishay?

reply »