Vb Script Or Commander
For give the newbie. I programmed, but before most of you were born. I am a sales person, not a techie, but I understand the logic process. Need help.
I have a customer with a database, my label is working great, but he has 5 different label designs for 5 different customers. Depending on the customer, the label format I need to print is different.
Am I better off using an If...Then...Else some where in the label format or is Commander a better choice.
If the VB is the way to go, I don't know the syntax for it, and where would I put it in the format.
I know one of you could do this in less than a minute.
Any help would be GREATLY appreciated.
Labelguy
I have a customer with a database, my label is working great, but he has 5 different label designs for 5 different customers. Depending on the customer, the label format I need to print is different.
Am I better off using an If...Then...Else some where in the label format or is Commander a better choice.
If the VB is the way to go, I don't know the syntax for it, and where would I put it in the format.
I know one of you could do this in less than a minute.
Any help would be GREATLY appreciated.
Labelguy
0
-
Shotaro Ito
★ BarTender Hero ★
Hi Labelguy,
As of BarTender 9.4, BarTender format's VB Script is not able to select which format to print - as VB Script is inside of label format.
What you can do is modify existing objects on current format.
See some ability of BarTender Automation Edition's Object Automation by VB script.
[url="http://seagullscientific.invisionzone.com/index.php?/topic/213-how-to-change-object-properties/"]How To Change Object Properties?[/url]
To dynamically select label format from application, you can use Commander.
Unfortunately Commander / BarTender cannot decide which format to print in CSV data, so what you can do is..
a. Use multiple tasks with BarTender command.
Task A detects "FMTA*.csv" file and print "formatA.btw"
Task B detects "FMTB*.csv" file and print "formatB.btw"
...etc
See [url="http://s3.amazonaws.com/SeagullBarTender/ftp/WhitePapers/WhitePaper_CommanderExamples_English.pdf"]White paper: Commander Examples[/url] #2.
b. Use commander script.
at the top of CSV file, you need to add commander script like below.
[code]%BTW% /AF="C:\bt\formatA.btw" /PRN="MY Printer" /D="%Trigger File Name%" /R=3 /P /DD
%END%
"PRODUCTID","PRODUCTNAME","QTY"
"PD-001","Blood Diamond","750"
"PD-017","Shutter Island","2140"
[/code]
Task Command type is just "Commander Script".
See [url="http://s3.amazonaws.com/SeagullBarTender/ftp/WhitePapers/WhitePaper_CommanderExamples_English.pdf"]White paper: Commander Examples[/url] #3.
When you use trigger file as CSV data for BarTender, don't delete trigger file at detection - select rename.
delete file after print by /DD command.
[b]I would take Commander[/b] as that would need less coding and more flexible.
or ask the customer to select formats manually
0 -
[quote name='Shotaro I -Seagull Support' timestamp='1327643752' post='1590']
Hi Labelguy,
As of BarTender 9.4, BarTender format's VB Script is not able to select which format to print - as VB Script is inside of label format.
What you can do is modify existing objects on current format.
See some ability of BarTender Automation Edition's Object Automation by VB script.
[url="http://seagullscientific.invisionzone.com/index.php?/topic/213-how-to-change-object-properties/"]How To Change Object Properties?[/url]
To dynamically select label format from application, you can use Commander.
Unfortunately Commander / BarTender cannot decide which format to print in CSV data, so what you can do is..
a. Use multiple tasks with BarTender command.
Task A detects "FMTA*.csv" file and print "formatA.btw"
Task B detects "FMTB*.csv" file and print "formatB.btw"
...etc
See [url="http://s3.amazonaws.com/SeagullBarTender/ftp/WhitePapers/WhitePaper_CommanderExamples_English.pdf"]White paper: Commander Examples[/url] #2.
b. Use commander script.
at the top of CSV file, you need to add commander script like below.
[code]%BTW% /AF="C:\bt\formatA.btw" /PRN="MY Printer" /D="%Trigger File Name%" /R=3 /P /DD
%END%
"PRODUCTID","PRODUCTNAME","QTY"
"PD-001","Blood Diamond","750"
"PD-017","Shutter Island","2140"
[/code]
Task Command type is just "Commander Script".
See [url="http://s3.amazonaws.com/SeagullBarTender/ftp/WhitePapers/WhitePaper_CommanderExamples_English.pdf"]White paper: Commander Examples[/url] #3.
When you use trigger file as CSV data for BarTender, don't delete trigger file at detection - select rename.
delete file after print by /DD command.
[b]I would take Commander[/b] as that would need less coding and more flexible.
or ask the customer to select formats manually
[/quote]0 -
[quote name='Shotaro I -Seagull Support' timestamp='1327643752' post='1590']
Hi Labelguy,
As of BarTender 9.4, BarTender format's VB Script is not able to select which format to print - as VB Script is inside of label format.
What you can do is modify existing objects on current format.
See some ability of BarTender Automation Edition's Object Automation by VB script.
[url="http://seagullscientific.invisionzone.com/index.php?/topic/213-how-to-change-object-properties/"]How To Change Object Properties?[/url]
To dynamically select label format from application, you can use Commander.
Unfortunately Commander / BarTender cannot decide which format to print in CSV data, so what you can do is..
a. Use multiple tasks with BarTender command.
Task A detects "FMTA*.csv" file and print "formatA.btw"
Task B detects "FMTB*.csv" file and print "formatB.btw"
...etc
See [url="http://s3.amazonaws.com/SeagullBarTender/ftp/WhitePapers/WhitePaper_CommanderExamples_English.pdf"]White paper: Commander Examples[/url] #2.
b. Use commander script.
at the top of CSV file, you need to add commander script like below.
[code]%BTW% /AF="C:\bt\formatA.btw" /PRN="MY Printer" /D="%Trigger File Name%" /R=3 /P /DD
%END%
"PRODUCTID","PRODUCTNAME","QTY"
"PD-001","Blood Diamond","750"
"PD-017","Shutter Island","2140"
[/code]
Task Command type is just "Commander Script".
See [url="http://s3.amazonaws.com/SeagullBarTender/ftp/WhitePapers/WhitePaper_CommanderExamples_English.pdf"]White paper: Commander Examples[/url] #3.
When you use trigger file as CSV data for BarTender, don't delete trigger file at detection - select rename.
delete file after print by /DD command.
[b]I would take Commander[/b] as that would need less coding and more flexible.
or ask the customer to select formats manually
[/quote]
Thank you Shotaro. I think I messed up on the reply. I started looking into Batchmaker. Maybe that might be the better choice?
Labelguy0 -
The really simple solution is using Print Station: It will display all label formats in a specific folder, and the customer can simply click one of the five to select it.
As far as using VB, the formats would have to be similar enough that they can be modified all within one .btw to give the appropriate output. It's not impossible, as I have programmed "Alternating labels" all from within one .btw file. But it really depends on the specifics.0
Vous devez vous connecter pour laisser un commentaire.
Commentaires
4 commentaires