Integration Builder - Print Label Using Label's Datasource

Legacy Poster

• February 04, 2016 19:33

First I think I've searched and looked as best I can before posting this, but I'm trying to set up Bartender as a proof of concept in our company.  

 

For reference, I'm running 2016R1, Enterprise Automation Trial

 

I've created a Bartender label that utilizes a SQL datasource and includes one query prompt.  The label works as expected in BarTender.  If I print the label, I receive a single query prompt for the containerID.  The returned results include a list of the items in the container.  The query prompt name is "ContainerID"

Using Page Templates, and Templates, I've got all the records showing as I'd expect.

 

I'm trying to test setting this up to be used via a webservice.  

In Integration builder I've setup a Web Service Integration. 

I've named the Service, and specified "unstructured" as my input data format

I'm not sure yet how to use the Response section, but I set %response% = %PrintJobMessage% for the response header.

In Variables I've created 2 variables "ContainerID" and "Document"

I have a single Print Action.  "Print Container Label"

 

The properties for the print action are: 

Document - <my documents path>\BarTender Documents\%Document%

Printer - I have this hard coded to the same printer defined in the label itself

I have checked the box for "Prompt for Data Input" below the Job Name field

Query Prompts: ContainerID = %ContainerID%

 

I'm using the Advanced Rest Client Application.  

Url:80

Path: /Integration/ContainerLabel/Execute

Query Parameters are

ContainerID = <number>

Document = CrateLabel_Test.btw

 

Integration builder sees the requests, however every time I try to run it, I receive an error message.  

 

"Print job "CrateLabel_Test.btw' did not complete due to the folowin error: An error occured during BTXML Script processing. Unable to merge BarTender batch database data with document <path to label> because a "btTextFile" database connection was not found"

 

I have no clue what btTextFile database it's referring to.  Any pointers would be greatly appreciated.

 

Thanks

 

Edit: 

In actions, I changed the Database Overrides section to "Use Document Setting"  and it actually printed the label, but it is only printing the first record.  If I 'print' the label directly from bartender, I have multiple records on the page.  Printing it through the integration, I only get the first record.

 

Edit - again. 

Looks like I needed to save the Template for the data, as well as the Page Template.  Once I saved my 'changes' for both the Template that displayed my repeating data and saved the changes for my page template, my print jobs worked successfully. 

0

• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • February 05, 2016 14:35

  The attached PDF should be of help to you.

  0
• 

  Octavio Rodriguez

  ★ BarTender Hero ★

  • May 03, 2018 04:34

  Were is the PDF?  I'm trying to do a proof of concept need to know how to post data in XML format to a Web Service integration.  So far I can make it work in JSON but need XML.

   

  Thanks,

  0
• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • June 01, 2018 07:19

  Octavio: The tutorials and videos at the below links should help you out:

  https://support.seagullscientific.com/hc/en-us/categories/204151647-Integration 

  https://support.seagullscientific.com/hc/en-us/sections/115001058008-Integration 

  0

Please sign in to leave a comment.