Serialization On Vb Script Follow
Hi.I'm currently having problem solving this kind of issue in bartender using vb script.Please give me any suggestion and advice.
Scenario:
I'm printing a label that can get the information from Excel database.
The label has like 17 fields of data that need to get from it.
There are 3 field with particular case
i.) field name = Card quantity
ii.) field name = Card no.
iii.) field name = barcode
The card quantity read from database.If it is 2,it needs to print 2 pieces of labels. The first label,the card no need to print as 1,the second label need to print as 2. (This i have done actually by using print identical using data source& serialization on card no)
The barcode part, i need to join all the field name information to become its human readable text.I am able to do it using vb script except the last part.
Eg barcode: XXXXXXXXXXXXXXXX XXXXXX01
The 01 is depends on the card no,if it is 1 then is 01. If 2,the is 02.
I have tried the serialization on barcode,tried using vb script on the event serialization.But it keeps printing the same no.
I am wondering what is the best way to help me solving this.
Hope that i get the reply here.Thanks for the time reading.
5 comments
Legacy Poster
I understand you are trying to combine a lot of fields into one. Is just one of the fields not behaving the way you want?
Yep.I'm trying to combine a lot of fields become one barcode.The combining will involve number as well as alphabet.
It works ok by using vb script.But i just want to serialize the barcode if it prints identical.Maybe since it is a mixture of alphabet and number barcode,it doesn't get it.That's what i think.
Hope i clear the question up.Thank you.
Value = "K"&Trim (Field("'Kanban Print$'.F2") )&"1000"& Field("'Kanban Print$'.F10")&"000"&Field("'Kanban Print$'.F7")&" "&Field("'Kanban Print$'.F9")&"00000"&Field("'Kanban Print$'.F17")
Eg:XXXXXXXXXXX XXXXXX1
What i want is to print a serialize barcode when it prints identical.
I have tried to write at onIdenticalCopies on event control script,
Value = "K"&Trim (Field("'Kanban Print$'.F2") )&"1000"& Field("'Kanban Print$'.F10")&"000"&Field("'Kanban Print$'.F7")&" "&Field("'Kanban Print$'.F9")&"00000"&Field("'Kanban Print$'.F17")+1
But when it prints,let say i have printed 2 identical label, it returns both with already serializable data.
Output:XXXXXXXXXXX XXXXXX2
I couldn't figure why and any other alternatives that can help me.Any help would be appreciated much.
1st substring:
XXXXXXXXXXXXXXXX XXXXXX (current data source)
2nd substring: Event control script
OnAutoSelectedEvent
Value = 0
OnNewRecord
Value = 0
OnIdenticalCopies
Value = Value + 1
More options > Minimum to 2, fill by "0" from left, disable warning
Serialization disabled
You can create multiple substrings in datasoruce, from advanced datasource dialog shown by [Advanced] button.
I would create 2 (or more) substrings within the barcode's datasource.
1st substring:
XXXXXXXXXXXXXXXX XXXXXX (current data source)
2nd substring: Event control script
OnAutoSelectedEvent
Value = 0
OnNewRecord
Value = 0
OnIdenticalCopies
Value = Value + 1
More options > Minimum to 2, fill by "0" from left, disable warning
Serialization disabled
You can create multiple substrings in datasoruce, from advanced datasource dialog shown by [Advanced] button.
[/quote]
Thanks for the solution.This is what i am looking for.
Thank you so much.
Please sign in to leave a comment.
