Saltar al contenido principal

Búsqueda

Búsqueda

Data Matrix: multiple values in, multiple values out

Comentarios

7 comentarios

  • Avatar
    Peter Thane

    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

    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

    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
    Peter Thane

    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

    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

    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
    Peter Thane

    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. 

     

     

     

     

    0

Iniciar sesión para dejar un comentario.