Integration Builder 2016
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.
-
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 -
Legacy Poster
★ BarTender Hero ★
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 -
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 -
Legacy Poster
★ BarTender Hero ★
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 -
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 -
Legacy Poster
★ BarTender Hero ★
I want the integration builder to override the document setting and automatically print only the last record......
0 -
Legacy Poster
★ BarTender Hero ★
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] DESCI tried to accomplish all of this in Integration Builder but couldnt get it to work....
0 -
Mark Gilmour
★ BarTender Hero ★
The solution I found was to modify the SQL In BarTender design to read "Select Top 1" this limits the number of records getting sent to integration manager to the last First / Last record, when you sort the list by DESC, then it will send and print only the most recent record.
0
Please sign in to leave a comment.
Comments
8 comments