# BarTender with Infor SyteLine: how label printing is wired up > Source: https://netray.co/stack/bartender-label-printing-infor-syteline > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: ERP Stack ## Short answer SyteLine sites commonly print labels with BarTender by having BarTender watch a SQL table that SyteLine populates, which works well on-prem. In multi-tenant cloud there is no direct database access, so the community describes patterns using Mongoose web services or file server folders, IDO extensions, or file drops. Those cloud patterns are community practice, not vendor certified. ## Erp Infor CloudSuite Industrial (SyteLine) ## Erp Key syteline ## On Prem true ## Product BarTender ## Vendor Seagull Scientific (BarTender) ## Category Label printing ## Integration **Method:** SQL trigger table (traditional, on-prem) **Detail:** A custom or standard process writes a row per label into a table, and BarTender's database trigger watches that table, merges the row into a template and prints. Using a status column on the row lets you mark labels printed and retry failures. **Method:** IDO extension class calling a web service (cloud, community pattern) **Detail:** Where you cannot reach the database, a SyteLine IDO extension class can call a BarTender-side web service with the label data. This is custom development, so it is only as supportable as the code you write and test. **Method:** Mongoose file server folder or object-store drop (cloud, community pattern) **Detail:** SyteLine writes a text or XML file to a folder or storage location, and BarTender picks it up and prints. The community thread on cloud label printing describes these options. None is vendor certified, so test upgrades. ## Data Flows **From:** SyteLine receiving, shipping or job transactions **To:** BarTender trigger table or file **Data:** Item, lot, quantity, location, PO or order reference **Trigger:** Operator posts receipt, pick, ship or job completion **From:** BarTender **To:** Label printer **Data:** Rendered label from template **Trigger:** New row or file detected **From:** BarTender **To:** Trigger table status **Data:** Printed or failed flag **Trigger:** After the print job completes or errors **From:** SyteLine item and customer master **To:** BarTender template data **Data:** Descriptions, customer part numbers, compliance text **Trigger:** At label request time ## Setup ### Inventory your labels **Detail:** List every label (receiving, container, pallet, shipping, work order, serial) with its size, printer and required fields before building anything. ### Choose the trigger pattern **Detail:** On-prem with database access: a trigger table. Cloud without database access: a web service, IDO extension or file drop. Pick one and keep it consistent. ### Design the label data table or file layout **Detail:** One row or file per label, with columns for every template field, a template name, a printer name, quantity of copies and a status flag. ### Build templates in BarTender **Detail:** Bind template fields to the trigger columns. Keep template names stable because the printing process refers to them by name. ### Hook the SyteLine side **Detail:** Add the event that writes the label row, from a custom form, event handler, IDO method or scheduled job, depending on where the label must be requested. ### Configure the BarTender service **Detail:** Run Integration Builder or the print server as a service on a machine with access to the table or folder and the printers, with its own service account. ### Test with real transactions **Detail:** Print each label type from live-style transactions, including lot and serial items, reprints and multi-copy runs, and verify scanner readability. ### Plan the upgrade check **Detail:** Add label printing to your SyteLine upgrade regression list, since customisations and schema changes can silently break it. ## Pitfalls - Cloud tenants cannot host a database trigger, so a design copied from an on-prem site will not work without a different transport. - Duplicate prints when a retry job resends rows that BarTender already printed and nobody updated the status flag. - Template field names drift from column names after someone edits one side, producing blank labels. - Unit of measure and lot or serial formats on the label differ from what the scanner or customer expects. - The print service runs under a personal account whose password expires, silently stopping all labels. - Community patterns are not vendor certified, so a SyteLine upgrade or schema change can break them without notice. ## Ai Layer ### Missing and failed label triage **Description:** An assistant reading both the SyteLine transaction and the label trigger table can show 'receipts posted today with no label row' or 'rows stuck in failed', and draft a reprint list for a supervisor to approve. ### Label content check **Description:** Compare the data printed on a label against the item, lot and customer records to catch wrong revisions or missing compliance text before shipment, as a review aid. ### Template impact lookup **Description:** Ask in plain language which templates use a given field or customer, so changes to a customer's labelling requirements can be scoped quickly. ## Alternatives - For simple needs, native SyteLine reports printed to a label-capable printer may be enough without a separate label product. - A WMS or RF suite with built-in labelling may be a better fit if you also need directed putaway and scanning. - Other label products such as NiceLabel or Loftware follow the same trigger-file pattern, so choose by what your IT team already runs. ## Faq ### Is BarTender a certified SyteLine integration? **Answer:** The patterns documented by the Infor community, such as SQL trigger tables, IDO extensions and Mongoose file server folders, are community practice rather than a vendor certified connector. That is workable, but you own the testing and upgrade risk. ### How do I print labels from multi-tenant cloud SyteLine? **Answer:** You cannot rely on a database table the printer watches. The community describes calling a web service from an IDO extension, writing files through the Mongoose file server, or dropping files to cloud storage that BarTender collects. ### Why do labels print twice? **Answer:** Usually because the process that retries failed rows does not update a printed flag, or because the same transaction fires the label event twice. Add a unique key per label and a status column, and make the retry job check it. ### Can AI help manage labels? **Answer:** It can find receipts or shipments without a matching label row and draft reprint lists for approval. It should not change label templates or write to SyteLine without a human reviewing the change. ## Source https://community.infor.com/infor-os-mongoose/f/infor-os-mongoose/35125/bartender---how-to-do-label-printing-from-the-cloud ## Search terms bartender syteline cloud label printing, bartender syteline, syteline label printing, syteline barcode labels bartender, bartender sql trigger syteline, mongoose label printing --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json