Using A Database/text Field To Denote A Printer? Follow

0
Avatar
Legacy Poster

Hi,

 

Does anybody know if its possible to use Commander or BarTender to pass a 'Printer to use' field from one of the Fields supplied in a Text input file through to BarTender?

 

We have the following scenario:

 

1 - We use an event in our ERP System to automatically output a label file in the format:  00002928¦LOT456¦4¦Xerox2

 

(Where the final field output is the printer that we would like any label printed too)

 

2 - We use commander currently to pick up the generated text file and then use BarTender to populate a label based on its contents.

 

We would like to automate the printing of this generated label to a defined printer, the name of which is supplied in the input text file...

 

Is this possible? Has anyone done anything like this already?

 

Many Thanks

 

Darren

4 comments

0
Avatar
Ian Cummings
Moderator
Comment actions Permalink

Have you considered having your ERP produce Commander Script or XML instead of just a single record of delimited data?  In that way you can specify additional print parameters for the print job, such as the printer to use, in addition to the transactional data.  See the below white papers and the BarTender Help System for more details.

 

http://www.bartenderbarcodesoftware.com/label-software/whitepapers/Codeless-Integration-of-Barcode-and-Label-Printing-with-other-Software(English).pdf

 

http://www.bartenderbarcodesoftware.com/label-software/whitepapers/Commander-Examples(English).pdf

 

Alternatively you could use a transform command to massage the trigger file into Commander Script or XML Script, transposing the printer name into a print parameter command option, saving the transformed trigger to file and then producing a BarTender print job with the resulting script.  Note that this would require the Enterprise Automation edition. 

0
Avatar
Legacy Poster
Comment actions Permalink

Thank you Ian, we are going to look at building the ERP generated Variables into a Commander Script file, which we can then then use to print an 'ini' file denoted label to an input data defined printer.  :blink:

0
Avatar
Legacy Poster
Comment actions Permalink

Hi,

 

I am also investigating BTXML. I have an inbound XML file as the trigger which has within it a tag <PrinterID>3005</PrinterID>. When I run this in Commander what script or BTXML to I use to get this value set in the <Printer>Value</Printer> tag in the BTXML please?

 

Thanks,

 

Simon

0
Avatar
Ian Cummings
Moderator
Comment actions Permalink

You need to run an XSLT (XSL transform) to transform the original XML into BarTender XML Script.  Therefore you have two commands in the task, the first to do the transform, the second to run the XML script.  There are examples of this in the sample files of your BarTender installation for SAP AII and Oracle.

 

The following websites are a good introduction on how XSLTs work: http://www.learn-xslt-tutorial.com and http://www.w3schools.com/xml/xml_xsl.asp

Please sign in to leave a comment.