Parse multiple data sources from a single bar code 追蹤

Robert Taylor

Can someone instruct me on how to create a single QR code that has multiple data sources and how to set it up to parse the data into different fields when it scans into a form from another program?

I'm working with a form in Epicor (MES). The BT template will be linked to an Excel sheet with all of the data for each field. I just need a way to incorporate all of the data for each field into a single bar code. This way the user only has to scan one code to populate the whole form.

 I've tried making a vb script and using control characters for tab & return and also adding multiple data sources to the bar code itself while also using control characters. But it either doesn't populate all of the data or it puts all of the data from all data sources into one field (including the tabs that resulted from the character control).

2 意見

Ralph Haney
評論操作 永久連結

Robert, did you ever find a way to do this? I'm tackling something similar:
1) Using a data input form, the Production team prints a label with one Data Matrix barcode that contains multiple field values (date,SKU,lot,qty. etc.) but only the SKU value is human readable on the label.
2) Label becomes pallet "license plate" upon pallet completion
3) Label is scanned into warehouse when pallet arrives at that location
4) Field values populate from scan into spreadsheet, preferably separated out into proper fields

I found this, which allows a single one of those values to be human readable on the label, but I can't find how to pull them all into one barcode (using a data input form) and then pull them back out separately via scan event:

- Ralph, northern CA