CSV file and multiple labels per page

J. R. Marker

• February 24, 2024 22:16

We have a wholesale nursery and have been using the Automation version of BarTender for about 8 or 10 years connecting to an on-site SQL server.  We are in the process of moving to a cloud-based ERP.  Label printing will be done from the new program and a CSV file will be dropped to a directory on our server that I can have an Integration monitoring.

For our thermal printing needs, this seems to work well.  I'm having an issue with printing to our laser printer.  We provide 1 color sign per plant purchased to our customers.  The signs are 5"x7" and 2 per sheet of letter size paper.  In our old system, the print job would use the top and bottom sign on each sheet, but the new system is only printing on the top sign of each sheet.  I'm guessing because the integration is treating each line of the CSV as a separate print job instead of one batch.  Is there any way to have it use both signs on the paper so we are not wasting so much material?  Thank you!

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • February 27, 2024 12:34

  Hopefully this should work:

  • create your label with the page settings set to print two rows and configure your template linking the fields to a dummy database that matches the layout of your trigger/output file. Give this data file a different name to your trigger file.
  • In Integration builder, create a File Integration that is waiting for a trigger file and add two actions to this. Set the integration to delete the file when triggered.
  • The first is a Write File action that should create a text file that matches the name you gave to your dummy database above and that saves the file in the same location where the dummy database is stored. Set this to replace any existing files and make sure you adjust the Variable (via the Insert Variable button) to Event Data

  

  • The Print Action should be set to print your label and no extra config should be required.

  At print time, when a file is produced, the Integration will read the contents of the file then delete the trigger. It will then write those contents to a new file with a name that matches the database name and location that is linked to the label format and then print the label.

  0

Please sign in to leave a comment.