BarTender integration with Infor SyteLine: common setups

Build a label integration

1. 1List the label types and their data: shipping, item, lot, serial, pallet, with the fields each needs.
2. 2Design the label templates in BarTender with named data sources for each field.
3. 3Choose the trigger method: database trigger, file trigger, web service, or an HTTP request.
4. 4For a database trigger, create a staging table that SyteLine writes to (through a custom event, stored procedure or IDO extension) with one row per label request.
5. 5Configure BarTender Integration Builder to watch that table, read the row, print to the named printer and mark the row processed.
6. 6Test with a few records, including edge cases like long descriptions and special characters.
7. 7Add error handling: failed print status, retry, and a way to reprint.
8. 8Secure the credentials used by BarTender to read the database, with read access limited to the staging objects.

Getting data out of SyteLine

-- Staging table sketch (illustrative)
CREATE TABLE label_request (
  id INT IDENTITY PRIMARY KEY,
  label_type VARCHAR(30),
  item VARCHAR(30),
  lot VARCHAR(30),
  qty DECIMAL(18,4),
  printer VARCHAR(60),
  status VARCHAR(10) DEFAULT 'NEW',
  created DATETIME DEFAULT GETDATE()
);

Common pitfalls

• !Reading live transaction tables directly, which break on upgrades.
• !No status column, so rows reprint or are lost after a restart.
• !Field length mismatches truncating barcodes.
• !Using an admin database login for BarTender.
• !No reprint path for operators.