Print multiple records in a single template

Lele Tran

• May 28, 2024 22:20

Hi fellow Bartenders,

Howdy! I'm a complete newbie to Bartenders so I'm hoping I'm just being silly and forgot a setting or two.

The goal is to print multiple records in a single label. I've followed this reference kbase, and 1/10, the label prints, but the other 9/10, Bartender returns "No record found" error. I'm genuinely at a lost and can't seem to rundown what the root cause is.
- Reference kbase: How to display multiple records in a single template – BarTender Support Portal (seagullscientific.com)

Infor CloudSuite Industrial is our current ERP and within the ERP, I've created an integration via VisualBasic to build and output the file to a network drive.

     str_PrinterName = ThisForm.Variables("V_PrinterName").Value

      str_fileName = "\\UNCPATH\Triggers\V_JobMatlPickListLabels_Audit_GPI.csv"

      str_outDataStream = "%BTW%  /AF=\\UNCPATH\Labels\V_JobMatlPickListLabels_Audit_GPI.btw /D=%Trigger File Name% /PRN="

      'str_outDataStream = ""

      str_outDataStream = str_outDataStream & str_PrinterName

      str_outDataStream = str_outDataStream & " /R=3 /P /DD" & vbCrLf & vbCrLf

      str_outDataStream = str_outDataStream & "%END%" & vbCrLf & vbCrLf

      With ThisForm

         For i = 0 To oSubCollCache.GetNumEntries - 1

         str_QtyToPick = Cstr(FormatNumber(oSubCollCache.GetObjectProperty("DerQtyToPick", i),0) )

         str_QtyToPick = replace (str_QtyToPick, "," , "" )

         Const str_Tab As String = Chr(9)

        str_outDataStream = str_outDataStream _

            & Trim(oSubCollCache.GetObjectProperty("Item", i)) & str_Tab _

            & Trim(oSubCollCache.GetObjectProperty("Job", i)) & str_Tab _

            & Trim(str_QtyToPick)

        str_outDataStream = str_outDataStream & vbCrLf

    Next i

End With

 

This is the output file:

In Bartender Designer, I've set "Maximum number of records per printed item" to 7 (I've also tried 2 and 3), and enabled the "Combine multiple records into single field" option:

I applied a filter so it won't print the %BTW and %END command:

Text properties:

When I preview the label, all looks good:

 

Integration in Bartender Integration Builder:

 

Input Data tab:

 

Print Command Script:

When I hit Print in the ERP system, Bartender returns "No records found". 9/10, this fails, but 1 out of 10 tries, it does print... 

Is there a verbose logging option I can enable? "No records found" isn't descriptive. If I updated the Record Per Items back to 1, then the job prints, but it prints one record per label. I've been staring at this and going in circles. Any insight is greatlly apprciated! Thank you!!

Cheers,
Lele

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • May 29, 2024 07:57

  I would suggest splitting the commands and the data into two files. 

  For the command file all you would need would be the printer and label format name without any other commands and they could be configured in a File Integration as variables and connected to the Printer and Label Format settings in the Print Document command in the Integration.

  The data itself (only) can be output in a separate file that always has the same name and that overwrites any existing file of the same name. The label should be linked to a dummy copy of this data file without the need for any filters. 

  0
• 

  Lele Tran

  ★ BarTender Hero ★

  • May 30, 2024 16:52

  Hi Peter,

  Thank you for your response! Awesome, I'll give this a shot and will let you know the result. Thank you!

  0
• 

  Lele Tran

  ★ BarTender Hero ★

  • May 31, 2024 21:45

  Hi Peter,

  Thank you for the suggestion - that worked! I split the command and the data into two separate files and Bartender is no longer complaing about "No record found". I appreciate your time and help. Have a great one! :)

  0

Please sign in to leave a comment.