Skip to main content

Search

Search

Integration Builder 2016

Comments

8 comments

  • Avatar
    Ian Cummings
    Moderator

    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

    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

    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

    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

    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

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

    0
  • Avatar
    Legacy Poster

    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....

    0
  • Avatar
    Mark Gilmour

    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.