Label programs and Vantage via ODBC

Yahoo Archive
1
Wanted to thank all who responded to my Labeling questions!

FYI, I ended up giving up on the label programs since I discovered I
could create a Crystal "Label" report that would satisify my needs.
Writing a report to print on a Zebra printer (sideways) isn't the
easiest thing to do but it can be done. The main 'report' label is
basically a holder for multiple subreports in different sections. I
then created suppression logic into the sections so that only the
appropriate customers label would print.

The benefit of this method was that it allowed the users to use the
standard Label print function from Customer Shipment Entry.

Thanks again everyone!

Mike

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian Stenglein
Sent: Wednesday, August 02, 2006 6:32 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Label programs and Vantage via ODBC



I've also created a couple of different label apps in Access. They
allow the data to be extracted from Vantage and gives the user an
opportunity to fill in some extra fields before printing in an easy
to use interface. Some are simple apps that print out on avery
labels on regular laser printers.

The one that we print out the majority of our shipping labels from is
very complex. When the shipping clerk has all the data ready the
Access app exports a flat file with all of the info to a program
called Jet Form Central that sends the label to be printed on our
Zebra Printers. Virtually every big customer of ours has their own
barcode specifications, so have several dozen specific layouts to
manage. This process was somewhat difficult to get set up, but it
offers far more flexibility than anything we could do with just
Vantage and Crystal alone.

Brian Stenglein
Clow Stamping Co.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Butch Menge" <bmenge@...> wrote:
>
> I use Microsoft Access to do my labels and it works great with the
ODBC.
>
> Butch
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Mike Lowe
> Sent: Friday, July 28, 2006 1:10 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Label programs and Vantage via ODBC
>
>
>
> Greetings All and Happy Friday!
>
> I'm wondering if anyone out there is using either LabelView or
BarTender
> to access Vantage (6.1, 9.1D) data via ODBC?
>
> For whatever reason, I can't seem to make these programs work
against
> the Progress DB using ODBC. Crystal works fine, just not these label
> programs.
>
> As a side note, are there any other programs being used to generate
> labels that connect directly to the Vantage db?
>
> Thanks in advance,
> Mike Lowe
> Connor Manufacturing Services
>
>
>
> [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
Greetings All and Happy Friday!

I'm wondering if anyone out there is using either LabelView or BarTender
to access Vantage (6.1, 9.1D) data via ODBC?

For whatever reason, I can't seem to make these programs work against
the Progress DB using ODBC. Crystal works fine, just not these label
programs.

As a side note, are there any other programs being used to generate
labels that connect directly to the Vantage db?

Thanks in advance,
Mike Lowe
Connor Manufacturing Services




[Non-text portions of this message have been removed]
3
I use Microsoft Access to do my labels and it works great with the ODBC.

Butch

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mike Lowe
Sent: Friday, July 28, 2006 1:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Label programs and Vantage via ODBC



Greetings All and Happy Friday!

I'm wondering if anyone out there is using either LabelView or BarTender
to access Vantage (6.1, 9.1D) data via ODBC?

For whatever reason, I can't seem to make these programs work against
the Progress DB using ODBC. Crystal works fine, just not these label
programs.

As a side note, are there any other programs being used to generate
labels that connect directly to the Vantage db?

Thanks in advance,
Mike Lowe
Connor Manufacturing Services



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






[Non-text portions of this message have been removed]
4
We are using BarTender via ODBC to generate shipping labels. The
biggest issues we ran into when setting this up were twofold...1)
Make sure you setup your ODBC connections from within the BarTender
program itself. 2)You will have to write your own custom SQL
statements. The queries that are generated by BarTender are not
understood by BarTender.

I can send you some sample SQL statements and/or labels offline if
you would like. Also, Seagull Scientific's support is pretty good.

Ryan

--- In vantage@yahoogroups.com, "Mike Lowe" <MLowe@...> wrote:
>
> Greetings All and Happy Friday!
>
> I'm wondering if anyone out there is using either LabelView or
BarTender
> to access Vantage (6.1, 9.1D) data via ODBC?
>
> For whatever reason, I can't seem to make these programs work
against
> the Progress DB using ODBC. Crystal works fine, just not these
label
> programs.
>
> As a side note, are there any other programs being used to generate
> labels that connect directly to the Vantage db?
>
> Thanks in advance,
> Mike Lowe
> Connor Manufacturing Services
>
>
>
>
> [Non-text portions of this message have been removed]
>
5
Mike,
I us the BAM to export the information required into a .csv file and then
connect my label software to that. I used the Epicor model for running
reports (export to DBF and run crystal based on that) for my inspiration.
It's fairly slick, and you don't have to mess with ODBC on the workstation.
I use Wasp Labeler specifically because it could be called from the command
line and therefore from within the BAM .p code. This allowed me to automate
the labels based on activities within the system (rec from prod, report qty,
receive at dock, ship...) causing the labels to print without further input
from the user.
Just something to think about.
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Mike Lowe
Sent: Friday, July 28, 2006 4:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Label programs and Vantage via ODBC


Greetings All and Happy Friday!

I'm wondering if anyone out there is using either LabelView or BarTender
to access Vantage (6.1, 9.1D) data via ODBC?

For whatever reason, I can't seem to make these programs work against
the Progress DB using ODBC. Crystal works fine, just not these label
programs.

As a side note, are there any other programs being used to generate
labels that connect directly to the Vantage db?

Thanks in advance,
Mike Lowe
Connor Manufacturing Services



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






[Non-text portions of this message have been removed]
6
We are a serialized item company and we would like for a label to automatically printed each time a Serial Number (rec. from Manufact) is assigned in the system. Is this possible? Aaron how do you have this triggered for each new item received. We will have around 4 different stations receiving from manufacturing serialized items.

Thanks




-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Aaron Hoyt
Sent: Monday, July 31, 2006 8:38 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Label programs and Vantage via ODBC



Mike,
I us the BAM to export the information required into a .csv file and then
connect my label software to that. I used the Epicor model for running
reports (export to DBF and run crystal based on that) for my inspiration.
It's fairly slick, and you don't have to mess with ODBC on the workstation.
I use Wasp Labeler specifically because it could be called from the command
line and therefore from within the BAM .p code. This allowed me to automate
the labels based on activities within the system (rec from prod, report qty,
receive at dock, ship...) causing the labels to print without further input
from the user.
Just something to think about.
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com [mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com]On Behalf Of
Mike Lowe
Sent: Friday, July 28, 2006 4:10 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Label programs and Vantage via ODBC

Greetings All and Happy Friday!

I'm wondering if anyone out there is using either LabelView or BarTender
to access Vantage (6.1, 9.1D) data via ODBC?

For whatever reason, I can't seem to make these programs work against
the Progress DB using ODBC. Crystal works fine, just not these label
programs.

As a side note, are there any other programs being used to generate
labels that connect directly to the Vantage db?

Thanks in advance,
Mike Lowe
Connor Manufacturing Services

[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]
7
Interesting solution! I had tried to use my label programs against the
P/S exported DBF files but ran into a problem with the Memo part
description field. Then, when trying to link the part description field
via ODBC ran into my ODBC issue.

I'm going to have to take a look at the BAM now. Thanks for the idea!
A thousand heads are definitely better than one!

Mike

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Aaron Hoyt
Sent: Monday, July 31, 2006 6:38 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Label programs and Vantage via ODBC



Mike,
I us the BAM to export the information required into a .csv file and
then
connect my label software to that. I used the Epicor model for running
reports (export to DBF and run crystal based on that) for my
inspiration.
It's fairly slick, and you don't have to mess with ODBC on the
workstation.
I use Wasp Labeler specifically because it could be called from the
command
line and therefore from within the BAM .p code. This allowed me to
automate
the labels based on activities within the system (rec from prod, report
qty,
receive at dock, ship...) causing the labels to print without further
input
from the user.
Just something to think about.
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On
Behalf Of
Mike Lowe
Sent: Friday, July 28, 2006 4:10 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Label programs and Vantage via ODBC

Greetings All and Happy Friday!

I'm wondering if anyone out there is using either LabelView or BarTender
to access Vantage (6.1, 9.1D) data via ODBC?

For whatever reason, I can't seem to make these programs work against
the Progress DB using ODBC. Crystal works fine, just not these label
programs.

As a side note, are there any other programs being used to generate
labels that connect directly to the Vantage db?

Thanks in advance,
Mike Lowe
Connor Manufacturing Services

[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]
8
Brian,
For the Mfg-Inv, I have it trigger off JobHead.ReceivedQty.
I examine for the "OLD" < current. Then I find the "LAST" associated
PartTran record to get additional information.
For Pur-Stk, I trigger off RcvDtl.OurQty.
As for Serial Numbers, we don't use them, but I would expect you should be
able to link to the appropriate information and print based on what you
find.
Hope this Helps,
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Olson, Brian
Sent: Monday, July 31, 2006 10:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Label programs and Vantage via ODBC


We are a serialized item company and we would like for a label to
automatically printed each time a Serial Number (rec. from Manufact) is
assigned in the system. Is this possible? Aaron how do you have this
triggered for each new item received. We will have around 4 different
stations receiving from manufacturing serialized items.

Thanks




-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Aaron Hoyt
Sent: Monday, July 31, 2006 8:38 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Label programs and Vantage via ODBC

Mike,
I us the BAM to export the information required into a .csv file and then
connect my label software to that. I used the Epicor model for running
reports (export to DBF and run crystal based on that) for my inspiration.
It's fairly slick, and you don't have to mess with ODBC on the
workstation.
I use Wasp Labeler specifically because it could be called from the
command
line and therefore from within the BAM .p code. This allowed me to
automate
the labels based on activities within the system (rec from prod, report
qty,
receive at dock, ship...) causing the labels to print without further
input
from the user.
Just something to think about.
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com [mailto:
vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com]On Behalf Of
Mike Lowe
Sent: Friday, July 28, 2006 4:10 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Label programs and Vantage via ODBC

Greetings All and Happy Friday!

I'm wondering if anyone out there is using either LabelView or BarTender
to access Vantage (6.1, 9.1D) data via ODBC?

For whatever reason, I can't seem to make these programs work against
the Progress DB using ODBC. Crystal works fine, just not these label
programs.

As a side note, are there any other programs being used to generate
labels that connect directly to the Vantage db?

Thanks in advance,
Mike Lowe
Connor Manufacturing Services

[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]
9
Mike,

If you can get ODBC to work, but are still having problems with the
memo, try using the SUBSTRING command in your SELECT statement (e.g.,
SELECT SUBSTRING(memofield,1,25) AS newmemo FROM sometable). I have
had some issues as well, and found I can "cheat" by selecting only a
subset of the data.

By the way, the above works in SQL Server. I know Progress OpenEdge
supports SQL commands, but I'm not sure if version 6.x can.

Cheers!


--- In vantage@yahoogroups.com, "Mike Lowe" <MLowe@...> wrote:
>
> Interesting solution! I had tried to use my label programs against
the
> P/S exported DBF files but ran into a problem with the Memo part
> description field. Then, when trying to link the part description
field
> via ODBC ran into my ODBC issue.
>
> I'm going to have to take a look at the BAM now. Thanks for the
idea!
> A thousand heads are definitely better than one!
>
> Mike
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Aaron Hoyt
> Sent: Monday, July 31, 2006 6:38 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Label programs and Vantage via ODBC
>
>
>
> Mike,
> I us the BAM to export the information required into a .csv file and
> then
> connect my label software to that. I used the Epicor model for
running
> reports (export to DBF and run crystal based on that) for my
> inspiration.
> It's fairly slick, and you don't have to mess with ODBC on the
> workstation.
> I use Wasp Labeler specifically because it could be called from the
> command
> line and therefore from within the BAM .p code. This allowed me to
> automate
> the labels based on activities within the system (rec from prod,
report
> qty,
> receive at dock, ship...) causing the labels to print without
further
> input
> from the user.
> Just something to think about.
> Aaron Hoyt
> Vantage Plastics
> -----Original Message-----
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]
On
> Behalf Of
> Mike Lowe
> Sent: Friday, July 28, 2006 4:10 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Label programs and Vantage via ODBC
>
> Greetings All and Happy Friday!
>
> I'm wondering if anyone out there is using either LabelView or
BarTender
> to access Vantage (6.1, 9.1D) data via ODBC?
>
> For whatever reason, I can't seem to make these programs work
against
> the Progress DB using ODBC. Crystal works fine, just not these label
> programs.
>
> As a side note, are there any other programs being used to generate
> labels that connect directly to the Vantage db?
>
> Thanks in advance,
> Mike Lowe
> Connor Manufacturing Services
>
> [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]
>
10
I've also created a couple of different label apps in Access. They
allow the data to be extracted from Vantage and gives the user an
opportunity to fill in some extra fields before printing in an easy
to use interface. Some are simple apps that print out on avery
labels on regular laser printers.

The one that we print out the majority of our shipping labels from is
very complex. When the shipping clerk has all the data ready the
Access app exports a flat file with all of the info to a program
called Jet Form Central that sends the label to be printed on our
Zebra Printers. Virtually every big customer of ours has their own
barcode specifications, so have several dozen specific layouts to
manage. This process was somewhat difficult to get set up, but it
offers far more flexibility than anything we could do with just
Vantage and Crystal alone.

Brian Stenglein
Clow Stamping Co.

--- In vantage@yahoogroups.com, "Butch Menge" <bmenge@...> wrote:
>
> I use Microsoft Access to do my labels and it works great with the
ODBC.
>
> Butch
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Mike Lowe
> Sent: Friday, July 28, 2006 1:10 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Label programs and Vantage via ODBC
>
>
>
> Greetings All and Happy Friday!
>
> I'm wondering if anyone out there is using either LabelView or
BarTender
> to access Vantage (6.1, 9.1D) data via ODBC?
>
> For whatever reason, I can't seem to make these programs work
against
> the Progress DB using ODBC. Crystal works fine, just not these label
> programs.
>
> As a side note, are there any other programs being used to generate
> labels that connect directly to the Vantage db?
>
> Thanks in advance,
> Mike Lowe
> Connor Manufacturing Services
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>