dbTalk Databases Forums  

Printing Custom Labels in Worldship

comp.databases.pick comp.databases.pick


Discuss Printing Custom Labels in Worldship in the comp.databases.pick forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Wenthe
 
Posts: n/a

Default Printing Custom Labels in Worldship - 08-16-2005 , 11:44 AM






Currently, we use UPS Worldship and a middlewear piece called Shipgear
to tie into our ERP system and print our shipping labels.

Recently, one of our customers started requiring our shipping labels to
be printed in a specific format that is significantly different from
the UPS canned standard. Basically this is a 4 by 6 label with nine
mandatory sections laid out in a specific format with four barcodes
included. We are using a Zebra barcode printer for labels.

I've approached UPS and VTechnologies (they own Shipgear) about the
problem and basically got "Sorry, we can't help you".

My next approach is to code something in VB that can pull the
information from our ERP system, generate the barcodes, and print them
(possibly using a Crystal Report) to the Zebra printer.

I had an application that I thought would do the job by displaying the
information in a VB form and then printing it using the Printform
method, but there is an issue in VB6 that won't let you print the
contents of Pictureboxes using the Printform method.

I'd appreciate any input I can get.


Reply With Quote
  #2  
Old   
DaveG
 
Posts: n/a

Default Re: Printing Custom Labels in Worldship - 08-16-2005 , 11:59 AM






We print labels directly to the Zebra printers from D3 using ZPL. We
print about 30 different formats meeting different customers
requirements.

I've manually designed the labels in ZPL - not that difficult. I've
also designed the labels using the BAR-ONE software, printing to a file
instead of the printer (change the printer port to File: in Windows). I
then imported the text file into D3 and replace the data fields with
real data.

We print thousands of labels a day.. We have 12 Zebra's in use.


Reply With Quote
  #3  
Old   
Ron
 
Posts: n/a

Default Re: Printing Custom Labels in Worldship - 08-16-2005 , 01:38 PM



DaveG wrote:
Quote:
We print labels directly to the Zebra printers from D3 using ZPL. We
print about 30 different formats meeting different customers
requirements.

I've manually designed the labels in ZPL - not that difficult. I've
also designed the labels using the BAR-ONE software, printing to a file
instead of the printer (change the printer port to File: in Windows). I
then imported the text file into D3 and replace the data fields with
real data.

We print thousands of labels a day.. We have 12 Zebra's in use.

I have had the same problem as the OP. Designing and printing
the labels from basic is quite easy but if you need to print a
graphic image thing get in a wad. I have yet to get it to work
properly. Any pointers to the path of graphic bliss? :-)

Ron White


http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----


Reply With Quote
  #4  
Old   
Jeffrey Kaufman
 
Posts: n/a

Default Re: Printing Custom Labels in Worldship - 08-16-2005 , 01:39 PM



You can use the UPS printer for your labels as well. The Eltron
Create-A-Label software is free. If comes with the Eltron printers and can
be downloaded off their web site.

1) Set the UPS printer up as a network printer.
2) create the label format in the Eltron software using hard coded data.
3) run the create EPL code program.
4) open the text file it created and cut and paste the EPL code into your
basic program.
5) change the hard coded data into variables.
6) sp-assign to the printer and run your program.

Very simple.

The Eltron TLP2844 printer is about $400 if you need to buy another one.

Jeff


"Wenthe" <wenthe (AT) aol (DOT) com> wrote

Quote:
Currently, we use UPS Worldship and a middlewear piece called Shipgear
to tie into our ERP system and print our shipping labels.

Recently, one of our customers started requiring our shipping labels to
be printed in a specific format that is significantly different from
the UPS canned standard. Basically this is a 4 by 6 label with nine
mandatory sections laid out in a specific format with four barcodes
included. We are using a Zebra barcode printer for labels.

I've approached UPS and VTechnologies (they own Shipgear) about the
problem and basically got "Sorry, we can't help you".

My next approach is to code something in VB that can pull the
information from our ERP system, generate the barcodes, and print them
(possibly using a Crystal Report) to the Zebra printer.

I had an application that I thought would do the job by displaying the
information in a VB form and then printing it using the Printform
method, but there is an issue in VB6 that won't let you print the
contents of Pictureboxes using the Printform method.

I'd appreciate any input I can get.




Reply With Quote
  #5  
Old   
Tom deL
 
Posts: n/a

Default Re: Printing Custom Labels in Worldship - 08-16-2005 , 02:00 PM



Hi Ron,
<SNIP>
Quote:
I have had the same problem as the OP. Designing and printing
the labels from basic is quite easy but if you need to print a
graphic image thing get in a wad. I have yet to get it to work
properly. Any pointers to the path of graphic bliss? :-)

Ron White
Are you using the (depenging upon host OS) '-o raw' or '-og'
arguments to lpr so that the system knows to pass binary data?

HTH,
-Tom



Reply With Quote
  #6  
Old   
Ron
 
Posts: n/a

Default Re: Printing Custom Labels in Worldship - 08-16-2005 , 04:10 PM



Tom deL wrote:
Quote:
Hi Ron,
SNIP

I have had the same problem as the OP. Designing and printing
the labels from basic is quite easy but if you need to print a
graphic image thing get in a wad. I have yet to get it to work
properly. Any pointers to the path of graphic bliss? :-)

Ron White


Are you using the (depenging upon host OS) '-o raw' or '-og'
arguments to lpr so that the system knows to pass binary data?

HTH,
-Tom

Host OS is windoze 2000 server and the print driver is
set to raw mode.

Ron White


http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----


Reply With Quote
  #7  
Old   
Frans
 
Posts: n/a

Default Printing Custom Labels in Worldship - 08-16-2005 , 05:35 PM



Ron,

I loaded the images in the printer memory and then call them from
basic.
Only limitation is the mem. in the printer. I had to load them from
DOS and it works just fine. Let me know if you need more info!
I can then dig up the scripts I;m using to upload the images.

Frans

On Tue, 16 Aug 2005 13:38:42 -0500, Ron <ron (AT) eckel (DOT) com> wrote:

Quote:
DaveG wrote:
We print labels directly to the Zebra printers from D3 using ZPL. We
print about 30 different formats meeting different customers
requirements.

I've manually designed the labels in ZPL - not that difficult. I've
also designed the labels using the BAR-ONE software, printing to a file
instead of the printer (change the printer port to File: in Windows). I
then imported the text file into D3 and replace the data fields with
real data.

We print thousands of labels a day.. We have 12 Zebra's in use.

I have had the same problem as the OP. Designing and printing
the labels from basic is quite easy but if you need to print a
graphic image thing get in a wad. I have yet to get it to work
properly. Any pointers to the path of graphic bliss? :-)

Ron White


http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----


Reply With Quote
  #8  
Old   
Ron
 
Posts: n/a

Default Re: Printing Custom Labels in Worldship - 08-17-2005 , 08:34 AM



Frans wrote:
Quote:
Ron,

I loaded the images in the printer memory and then call them from
basic.
Only limitation is the mem. in the printer. I had to load them from
DOS and it works just fine. Let me know if you need more info!
I can then dig up the scripts I;m using to upload the images.

Frans

On Tue, 16 Aug 2005 13:38:42 -0500, Ron <ron (AT) eckel (DOT) com> wrote:


DaveG wrote:

We print labels directly to the Zebra printers from D3 using ZPL. We
print about 30 different formats meeting different customers
requirements.

I've manually designed the labels in ZPL - not that difficult. I've
also designed the labels using the BAR-ONE software, printing to a file
instead of the printer (change the printer port to File: in Windows). I
then imported the text file into D3 and replace the data fields with
real data.

We print thousands of labels a day.. We have 12 Zebra's in use.


I have had the same problem as the OP. Designing and printing
the labels from basic is quite easy but if you need to print a
graphic image thing get in a wad. I have yet to get it to work
properly. Any pointers to the path of graphic bliss? :-)

Ron White


http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----


Thanks Frans. I have not tried the DOS route. When I
get some time I will try that.

Ron


http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----


Reply With Quote
  #9  
Old   
Tom deL
 
Posts: n/a

Default Re: Printing Custom Labels in Worldship - 08-17-2005 , 08:46 AM



Hi Ron,

<SNIP>

Quote:
Host OS is windoze 2000 server and the print driver is
set to raw mode.

Ron White
Oops I missed that, sorry. There _is_ a cure then:
http://www.noworms.com/treatment.cfm <G>

-Tom



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.