Integration Builder 2016 Follow

0
Avatar
Legacy Poster

I am testing the database trigger option to print labels. Using a simple sql database I have configured the Integration builder utility to monitor a primary key field (ID) which is auto-incrementing. When I insert a new record the utility seems to detect the database update and tries to print the label document but errors with a message that the Print Scheduler Service isnt running. When I manually start the  service it complains that it cant find the file. When I look in the bartender directory it seems to be there:

 

"C:\Program Files (x86)\Seagull\BarTender Suite\PrintScheduler.Service.exe"

 

Any help would be appreciated.

7 comments

0
Avatar
Ian Cummings
Moderator
Comment actions Permalink

I would guess at some kind of installation issue.  If you make a simple integration with text file event and predefined print document action do you still get the same error?  I suggest you get in touch with tech-support on how to fix that.

0
Avatar
Legacy Poster
Comment actions Permalink

You are correct, Tech Support recommended not to install Bartender with Anti-Virus software active because sometimes, specifically, services may not work properly.

In this case they were able to re-install the PrintScheduler service via the DOS command line without having to re-install Bartender.

 

Everything works as expected except that when the Integration builder detects and prints the document, it prints ALL the records instead of just the last record that it detected!

0
Avatar
Ian Cummings
Moderator
Comment actions Permalink

How are you specifying the integration to only print a particular record?  What is the event data that is being given to BarTender at the time of the event and in what form is it in?

0
Avatar
Legacy Poster
Comment actions Permalink

I am not sure how to specify it. I tried using the print override
option and checked "Record Range". It only seems to accept a numerical
range. I need the last record only.

 

 

 

Also I did try checking "Record Range" and selected "More Variables"

 

 

It did allow me to insert the %CurrentRecord% variable, as shown

[attachment=1999:IntegrationBuilder.png]

in the attachmen, but this would cause an error "Invalid range" when printed.

0
Avatar
Ian Cummings
Moderator
Comment actions Permalink

The record range would be expecting something like this:

 

1,2,3

1...

4-15

etc

 

When selecting records in BarTender manually, you'll see below the records section the syntax of record range selection that you're making.

0
Avatar
Legacy Poster
Comment actions Permalink

I want the integration builder to override the document setting and automatically print only the last record......

0
Avatar
Legacy Poster
Comment actions Permalink

I manged to get it working but Integration Builder is now only configured to do two things: Detect a new record by monitoring the ID field (a DateStamp field could also be used) and the Action setting is set to Print Label Document.

The Label Document didnt have the print record options that I needed so in the Document's Database Connection Setup I entered the following Sql statement to print only the last record (most recent) in the table:

 

SELECT top 1 [ID], [WEIGHT], [DATESTAMP], [MORE_DATA] FROM [dbo].[Table_2]
ORDER BY [ID] DESC

 

I tried to accomplish all of this in Integration Builder but couldnt get it to work....

Please sign in to leave a comment.