Serialization On Vb Script Follow

0
Avatar
Legacy Poster

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

0
Avatar
Legacy Poster
Comment actions Permalink

Sorry, I'm unable to follow what you're trying to do, versus what is actually happening.

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?
0
Avatar
Legacy Poster
Comment actions Permalink

Thanks for the reply.

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.
0
Avatar
Legacy Poster
Comment actions Permalink

This is what i wrote actually in vb script to combine different field data for displaying human readable text for barcode.I wrote in at onAutoSelectedEvent

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.
0
Avatar
Shotaro Ito
Comment actions Permalink

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.
0
Avatar
Legacy Poster
Comment actions Permalink

[quote name='Shotaro I -Seagull Support' timestamp='1329798209' post='1787']
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.