[6.1] Code 128 Bar Coding from Vantage

Yahoo Archive
1
The reason for the add-in is to calculate and create the additional characters. Code 128 has internal check digits to assure a proper scan. I can't recall the actual formula but is is something like adding up the ASCII decimal code number for each character times the position in the string and dividing the total by 13 (or something) and taking the remainder...then printing this with appropriate start/stop codes (like * in Code 39) in the Code 128 font. This could be done in RB or Crystal I suppose but for anything but fixed length strings it would be brutal because of the position thing. A canned subroutine macro with recursive coding to take any string (or any length) and return a string would make life a lot easier.

Soap box time: My understanding is that Code 128 was developed for automated warehousing to assure parts getting to the right place and allowing badly scanned items to be recognized and segregated for human intervention. Unfortunately the automation consultants hired by many of our customers only know the fully automated Code 128 route even though our customers will never use this capability. Every time I have run into a Code 128 requirement it has been where a consultant was running the show and making things far more complicated (good for revenue) than it needs to be. Who says the emperor ain't naked?

-Todd C.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of lonwiksell@...
Sent: Friday, April 13, 2007 8:22 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [6.1] Code 128 Bar Coding from Vantage



I'm not sure why you would need an add-in to print a bar code. If you
can get the correct bar code font as a true type font then it is just a
matter of loading that into your windows font directory. We have
several bar code fonts that came with our bar code scanners. Once they
are loaded you can use them in Access, Word, Excel, etc. We print these
bar codes on our travelers and shipping label with Access. We use the
SATO printer to print 4x5 labels and Access to select what to print and
how many to print. We've been doing this for about two years now.

________________________________

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com [mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On Behalf
Of Todd Caughey
Sent: Thursday, April 12, 2007 3:10 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] [6.1] Code 128 Bar Coding from Vantage

Followup to my own question....has anyone used the MSAccess shareware
add-in called ABarCode ? It will generate Code 128 barcodes. If it works
the way I think it might I could then run an ODBC driven Access report
from the Vantage Favorites bar.
Thanks,
-Todd C.

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com <mailto:vantage%40yahoogroups.com>
[mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com <mailto:vantage%40yahoogroups.com> ]On
Behalf Of Todd Caughey
Sent: Thursday, April 12, 2007 2:28 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] [6.1] Code 128 Bar Coding from Vantage

For 5 years now I've dodged the Code 128 bullet but now have a customer
that will not back down and accept Code 30 (Dataworks bar 39 font). I've
had (but not had to try) a routine for Crystal Reports that will
generate the correct data (with check digits) to put into a Code 128
font - sent by someone from this list a year or two ago. Because of the
number of customers who would really rather we used Code 128 I've been
given the go ahead to buy something. Perferably something that directly
integrates or can access via ODBC the typical data for a shipping label.
Each customer wants their own format and layout so ease of creation
would be good too. If I have to export to a CSV file and pick that up
that might be acceptable if it is easy enough for the shipping personnel
to deal with

Does anyone here have something that does Code 128 bar coding and
integrates pretty tightly with Vantage (6.1)?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
2
For 5 years now I've dodged the Code 128 bullet but now have a customer that will not back down and accept Code 30 (Dataworks bar 39 font). I've had (but not had to try) a routine for Crystal Reports that will generate the correct data (with check digits) to put into a Code 128 font - sent by someone from this list a year or two ago. Because of the number of customers who would really rather we used Code 128 I've been given the go ahead to buy something. Perferably something that directly integrates or can access via ODBC the typical data for a shipping label. Each customer wants their own format and layout so ease of creation would be good too. If I have to export to a CSV file and pick that up that might be acceptable if it is easy enough for the shipping personnel to deal with

Does anyone here have something that does Code 128 bar coding and integrates pretty tightly with Vantage (6.1)?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.




[Non-text portions of this message have been removed]
3
Todd,
I have been using Wasp Labeler software for some time now. I can use a BAM
in 6.1 to export to a .csv, then launch the label and preset the number of
copies. I don't use it for shipping labels, but I expect I could easily
based on a shipment being marked shipped or some other trigger. It will
generate Code 128 based on the csv files or tie in via ODBC if you prefer.
I pick the csv route for safety, speed reliability (that is if it didn't
print well, I can just launch the label from a shortcut and have it re-run
based on the same data again).
I am sure there are many products that tie in better, but I can give a bunch
of code samples if you choose to go a route similar to this.
Good luck,
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Todd Caughey
Sent: Thursday, April 12, 2007 3:28 PM
To: vantage@yahoogroups.com
Subject: [Vantage] [6.1] Code 128 Bar Coding from Vantage


For 5 years now I've dodged the Code 128 bullet but now have a customer
that will not back down and accept Code 30 (Dataworks bar 39 font). I've had
(but not had to try) a routine for Crystal Reports that will generate the
correct data (with check digits) to put into a Code 128 font - sent by
someone from this list a year or two ago. Because of the number of customers
who would really rather we used Code 128 I've been given the go ahead to buy
something. Perferably something that directly integrates or can access via
ODBC the typical data for a shipping label. Each customer wants their own
format and layout so ease of creation would be good too. If I have to export
to a CSV file and pick that up that might be acceptable if it is easy enough
for the shipping personnel to deal with

Does anyone here have something that does Code 128 bar coding and
integrates pretty tightly with Vantage (6.1)?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.



[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
4
Followup to my own question....has anyone used the MSAccess shareware add-in called ABarCode ? It will generate Code 128 barcodes. If it works the way I think it might I could then run an ODBC driven Access report from the Vantage Favorites bar.
Thanks,
-Todd C.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Todd Caughey
Sent: Thursday, April 12, 2007 2:28 PM
To: vantage@yahoogroups.com
Subject: [Vantage] [6.1] Code 128 Bar Coding from Vantage



For 5 years now I've dodged the Code 128 bullet but now have a customer that will not back down and accept Code 30 (Dataworks bar 39 font). I've had (but not had to try) a routine for Crystal Reports that will generate the correct data (with check digits) to put into a Code 128 font - sent by someone from this list a year or two ago. Because of the number of customers who would really rather we used Code 128 I've been given the go ahead to buy something. Perferably something that directly integrates or can access via ODBC the typical data for a shipping label. Each customer wants their own format and layout so ease of creation would be good too. If I have to export to a CSV file and pick that up that might be acceptable if it is easy enough for the shipping personnel to deal with

Does anyone here have something that does Code 128 bar coding and integrates pretty tightly with Vantage (6.1)?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.



[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
5
I'm not sure why you would need an add-in to print a bar code. If you
can get the correct bar code font as a true type font then it is just a
matter of loading that into your windows font directory. We have
several bar code fonts that came with our bar code scanners. Once they
are loaded you can use them in Access, Word, Excel, etc. We print these
bar codes on our travelers and shipping label with Access. We use the
SATO printer to print 4x5 labels and Access to select what to print and
how many to print. We've been doing this for about two years now.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Caughey
Sent: Thursday, April 12, 2007 3:10 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [6.1] Code 128 Bar Coding from Vantage



Followup to my own question....has anyone used the MSAccess shareware
add-in called ABarCode ? It will generate Code 128 barcodes. If it works
the way I think it might I could then run an ODBC driven Access report
from the Vantage Favorites bar.
Thanks,
-Todd C.


-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On
Behalf Of Todd Caughey
Sent: Thursday, April 12, 2007 2:28 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] [6.1] Code 128 Bar Coding from Vantage

For 5 years now I've dodged the Code 128 bullet but now have a customer
that will not back down and accept Code 30 (Dataworks bar 39 font). I've
had (but not had to try) a routine for Crystal Reports that will
generate the correct data (with check digits) to put into a Code 128
font - sent by someone from this list a year or two ago. Because of the
number of customers who would really rather we used Code 128 I've been
given the go ahead to buy something. Perferably something that directly
integrates or can access via ODBC the typical data for a shipping label.
Each customer wants their own format and layout so ease of creation
would be good too. If I have to export to a CSV file and pick that up
that might be acceptable if it is easy enough for the shipping personnel
to deal with

Does anyone here have something that does Code 128 bar coding and
integrates pretty tightly with Vantage (6.1)?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
6
Todd,

You can try out www.elfring.com for creating your different bar code
types. They have a free trial and it is very easy to install and use you
can then copy the necessary fonts to the workstations once you buy the
copy.

Jason

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of lonwiksell@...
Sent: Friday, April 13, 2007 8:22 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [6.1] Code 128 Bar Coding from Vantage



I'm not sure why you would need an add-in to print a bar code. If you
can get the correct bar code font as a true type font then it is just a
matter of loading that into your windows font directory. We have
several bar code fonts that came with our bar code scanners. Once they
are loaded you can use them in Access, Word, Excel, etc. We print these
bar codes on our travelers and shipping label with Access. We use the
SATO printer to print 4x5 labels and Access to select what to print and
how many to print. We've been doing this for about two years now.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Todd Caughey
Sent: Thursday, April 12, 2007 3:10 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] [6.1] Code 128 Bar Coding from Vantage

Followup to my own question....has anyone used the MSAccess shareware
add-in called ABarCode ? It will generate Code 128 barcodes. If it works
the way I think it might I could then run an ODBC driven Access report
from the Vantage Favorites bar.
Thanks,
-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ]On
Behalf Of Todd Caughey
Sent: Thursday, April 12, 2007 2:28 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] [6.1] Code 128 Bar Coding from Vantage

For 5 years now I've dodged the Code 128 bullet but now have a customer
that will not back down and accept Code 30 (Dataworks bar 39 font). I've
had (but not had to try) a routine for Crystal Reports that will
generate the correct data (with check digits) to put into a Code 128
font - sent by someone from this list a year or two ago. Because of the
number of customers who would really rather we used Code 128 I've been
given the go ahead to buy something. Perferably something that directly
integrates or can access via ODBC the typical data for a shipping label.
Each customer wants their own format and layout so ease of creation
would be good too. If I have to export to a CSV file and pick that up
that might be acceptable if it is easy enough for the shipping personnel
to deal with

Does anyone here have something that does Code 128 bar coding and
integrates pretty tightly with Vantage (6.1)?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]