Select Printer and Template based on field values
Hi,
I'm struggling to get the below concept to work.
We use different colour labels upon goods receipt based upon two conditions,
if receipted to our Warehouse "TAN" and its a QC controlled product , then it needs to print from the Quarantine product label from the "Orange Printer".
If its not QC Controlled , or receipted into our DIS Warehouse then print the Released as Available from the "Green Printer"
Both templates are in the one file.
I can get the correct template called up, based on the conditional printing values in each template
However the Printer selection doesn't seem to work no matter what I try
I assume I need some sort of VB script here, which will pass the value to a named data source ?
-
I have written the SQL to pull the data via ODBC , and have the SQL query providing the Printer name as part of the process.
A named data source then links to that which defines the printer, and is selected as the Printer source in the dialogue box.
However it steadfastly refuses to use the Printer name to point to the correct printer.......
0 -
Hey Matt,
Have you tried the "Get printer name from database field" or "Get printer name from data source" options yet?
If you set it to a data source, you could probably use the VBScript transform to do something like this:
If you're using SQL to get the data, you could also make the printer logic part of your query.
- Ian
Professional Label Software Implementation | IPSi Scan
0 -
I am not sure there is a way to reference the Printer Name setting via VB and so I dont think that is a valid option.
Are you using either Automation or Enterprise edition as there is an alternate way you can achieve this?
0 -
We are running the Automation version.
I have a SQL query pulling the data for the query, and also providing a database field called "Printr" which is populated using the Printer Name in the Server
UT01_REL_LBL or UT01_QUAR_LBL
I have tried every combination of naming the printers, including Domain (eg \\DOMAIN\Printer) , IPofPrinter:9100 etc , and it just will not route to different printers
I even added the field to the label, and confirmed the data being sent is correctly calling out the Printer name....
0 -
I was able to get this to work using the "Get printer name from database field" option- it appears, however, that you can only use one printer per print job, so if you are trying to print multiple records to different printers as part of the same job, you will need to leverage something like form actions or integration builder.
0
Vous devez vous connecter pour laisser un commentaire.
Commentaires
5 commentaires