Data Matrix: multiple values in, multiple values out Seguir

0
Avatar
Ralph Haney

Hoping to find a way to do this without coding:

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:
https://support.seagullscientific.com/hc/en-us/community/posts/360039275554-QR-Multiple-Data

- Ralph, northern CA

7 comentarios

0
Avatar
Pete Thane
Acciones de comentarios Permalink

The example you have linked to only shows the serial number for the DataMatrix as the Human Readable option has been set to None and a separate text field was added, linked to the serial number element that had been given a name. 

Are you trying to create the DataMatrix or just work out how to parse the data and populate the spreadsheet? 

Are the data fields all of fixed lengths and if so what are they?

0
Avatar
Ralph Haney
Acciones de comentarios Permalink

Hi, both of the latter, I'm trying create a DataMatrix with multiple fields embedded, then populate a spreadsheet when it's scanned. I've used BT over the years but never with subs-strings. Is there a good video on this topic? Thanks.

Some of the data fields COULD be fixed length, but some may be different number of characters:

Date Product Code Lot # Description Case Quantity Expiration Date Pack Date

  

0
Avatar
Ralph Haney
Acciones de comentarios Permalink

Date
Product Code (SKU)
Lot#
Description
Case Qty
Exp Date
Pack Date

Is that too much info to squeeze into a DataMatrix barcode for a 4x6 label? 

0
Avatar
Pete Thane
Acciones de comentarios Permalink

Is this a GS1-128 DataMatrix with the application identifiers? Or does the code have any delimiters between the data strings <GS> or <HT> etc ? 

Making the code in BarTender should be fairly straightforward, the problem is going to be how you can tell what it what when you scan the code to populate your spreadsheet if the string lengths are not fixed or have no delimitation.

Not sure about a video about sub-strings/muliptle data sources. I did find this after a quick search, it is for an older version of BarTender but does show you how to add them and adjust them.

https://www.youtube.com/watch?v=FRcASc2CnD4 

0
Avatar
Ralph Haney
Acciones de comentarios Permalink

Nailed this! Using multiple data sources, sub-strings, tab and CR suffixes, this provides a clean one DataMatrix code and three human readable values, plus serialization for number of pallet (1 of 3 etc.). Thanks for your earlier post here, Pete:
https://support.seagullscientific.com/hc/en-us/community/posts/360039275554-QR-Multiple-Data

Hope this helps others.

 

0
Avatar
Ralph Haney
Acciones de comentarios Permalink

I'm not sure, I'm new to this but I chose the basic DM option under Barcodes (see below). I did use HT (horizontal tabs) after each data string to push the cursor to the next Excel cell, and then a CR (carriage return) after the last one to push it to the next row, ready for the next label scan. Works great!

I just posted the following on another thread about trying to embed the "x of y" value into the DataMatrix barcode:
This is a real time saver and valuable for the "Pallet License Plate" I'm building. Works great, thanks.
Question: Slim VB scripting experience here; how can I get the current "x of y" value embedded into my DataMatrix barcode? My DM code currently unpacks several values into an Excel row and the manager would love to see the pallet number ( for example, "3 of 5" ) in a column in his spreadsheet.
Scan 1/Row 1 = "1 of 5"
Scan 2/Row 2 = "2 of 5"
Scan 3/Row 3 = "3 of 5" etc.

Each row may have differing lot codes so it would be helpful to know which # of 5 was that row/pallet. Make sense?

0
Avatar
Pete Thane
Acciones de comentarios Permalink

If you use the the Print Job Field option as the data source you can link the X to the Page number and Y to the total printed items to achieve what you need. 

You will need to have a sequential number field somewhere in the template too (the 1 text field in the image below), but it does not need to be on the label itself and so does not need to print. 

 

 

 

 

Iniciar sesión para dejar un comentario.