Progress Program question

Todd,

I took your advice (mostly). I created the progress .p to run that does
the editing based on screen values. I then set the program to run as
part of the open for the VBForm. Now with a barcode, I can have them
scan the Tracking number, then scan a barcode to "verify" the tracking
number. That barcode contains an enter to leave the tracking number
field, a "V" to open the VBForm, an "O" to ok the VBForm and an "O" to
ok the header information. I threw in a couple of extra "O"s to be sure
screen lag does not create a problem.

With this process I feel it is automated enough and fast enough to not
cause a problem for shipping.

Thank you for the advice about using the VBForm.

Aaron



-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, January 13, 2004 11:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress Program question



* On a VBform screen you could scan the "large" number in then
have a button to populate the main screen field with the trimmed value.
In 6.0+ I believe the scan field and the button could reside on the main
screen - kind of a kludge but if FEDEX volume is not real high compared
to other methods it might be OK.
-Todd C.

-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Tuesday, January 13, 2004 9:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Progress Program question


Ok, trying to use progress to write to the DB.

I want to take a tracking number scanned from a FEDEX label into the
tracking number field and cut it down to the actual tracking number.

Apparently FedEx adds some "extra" data into their tracking number
barcode. UPS and DHL are direct scans, but FedEx seems to have 16
characters (of junk to me) and then the tracking number, and then 4 more
characters (of junk to me).

I was going to use code similar to below, but this can't be done at the
screen level because I can't find a way to customize the ship header
screen. I am left with triggering this with a global alert, therefore
forcing me to change the data contained in the field, not the screen.

Any suggestions?



inittraknum = getStringValue("Shiphead.TrackingNumber.SCRVALUE":U).



IF LENGTH(inittraknum) > 29

THEN DO:

newtraknum = SUBSTRING(inittraknum, 17, 12).

setStringValue("Shiphead.TrackingNumber.SCRVALUE":U, newtraknum).

END.

ELSE DO:

END.



Thanks for any help.



Aaron Hoyt

Vantage System Admin

Hittite Microwave Corporation








[Non-text portions of this message have been removed]
Ok, trying to use progress to write to the DB.

I want to take a tracking number scanned from a FEDEX label into the
tracking number field and cut it down to the actual tracking number.

Apparently FedEx adds some "extra" data into their tracking number
barcode. UPS and DHL are direct scans, but FedEx seems to have 16
characters (of junk to me) and then the tracking number, and then 4 more
characters (of junk to me).

I was going to use code similar to below, but this can't be done at the
screen level because I can't find a way to customize the ship header
screen. I am left with triggering this with a global alert, therefore
forcing me to change the data contained in the field, not the screen.

Any suggestions?



inittraknum = getStringValue("Shiphead.TrackingNumber.SCRVALUE":U).



IF LENGTH(inittraknum) > 29

THEN DO:

newtraknum = SUBSTRING(inittraknum, 17, 12).

setStringValue("Shiphead.TrackingNumber.SCRVALUE":U, newtraknum).

END.

ELSE DO:

END.



Thanks for any help.



Aaron Hoyt

Vantage System Admin

Hittite Microwave Corporation





[Non-text portions of this message have been removed]
On a VBform screen you could scan the "large" number in then have a button to populate the main screen field with the trimmed value. In 6.0+ I believe the scan field and the button could reside on the main screen - kind of a kludge but if FEDEX volume is not real high compared to other methods it might be OK.
-Todd C.

-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Tuesday, January 13, 2004 9:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Progress Program question


Ok, trying to use progress to write to the DB.

I want to take a tracking number scanned from a FEDEX label into the
tracking number field and cut it down to the actual tracking number.

Apparently FedEx adds some "extra" data into their tracking number
barcode. UPS and DHL are direct scans, but FedEx seems to have 16
characters (of junk to me) and then the tracking number, and then 4 more
characters (of junk to me).

I was going to use code similar to below, but this can't be done at the
screen level because I can't find a way to customize the ship header
screen. I am left with triggering this with a global alert, therefore
forcing me to change the data contained in the field, not the screen.

Any suggestions?



inittraknum = getStringValue("Shiphead.TrackingNumber.SCRVALUE":U).



IF LENGTH(inittraknum) > 29

THEN DO:

newtraknum = SUBSTRING(inittraknum, 17, 12).

setStringValue("Shiphead.TrackingNumber.SCRVALUE":U, newtraknum).

END.

ELSE DO:

END.



Thanks for any help.



Aaron Hoyt

Vantage System Admin

Hittite Microwave Corporation





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



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/SIG=12cdnv5rd/M=267637.4116732.5333197.1261774/D=egroupweb/S=1705007183:HM/EXP=1074095731/A=1853619/R=0/*http://www.netflix.com/Default?mqso=60178356&partid=4116732> click here
<http://us.adserver.yahoo.com/l?M=267637.4116732.5333197.1261774/D=egroupmail/S=:HM/A=1853619/rand=896549892>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
Unfortunately, in 6.0 (where we are) this is not a customizable screen.
I was very excited when Epicor showed those off, but they turn out to be
few and far between. I would love to have a list of the screens that
are customizable, but no luck so far.

As far as the VB form goes, I could, but this would be three extra
clicks, and we ship several hundred shipments per day. As it is I am
asking a lot for the shipper to click into the header and scan the
number in.

I am still investigating just how much progress will let you do in a .p
file. I think I am going to be investigating the Set function.

Wish me luck,

Thanks Todd,



Aaron



-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, January 13, 2004 11:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress Program question



On a VBform screen you could scan the "large" number in then have a
button to populate the main screen field with the trimmed value. In
6.0+ I believe the scan field and the button could reside on the main
screen - kind of a kludge but if FEDEX volume is not real high compared
to other methods it might be OK.
-Todd C.

-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Tuesday, January 13, 2004 9:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Progress Program question


Ok, trying to use progress to write to the DB.

I want to take a tracking number scanned from a FEDEX label into the
tracking number field and cut it down to the actual tracking number.

Apparently FedEx adds some "extra" data into their tracking number
barcode. UPS and DHL are direct scans, but FedEx seems to have 16
characters (of junk to me) and then the tracking number, and then 4 more
characters (of junk to me).

I was going to use code similar to below, but this can't be done at the
screen level because I can't find a way to customize the ship header
screen. I am left with triggering this with a global alert, therefore
forcing me to change the data contained in the field, not the screen.

Any suggestions?



inittraknum = getStringValue("Shiphead.TrackingNumber.SCRVALUE":U).



IF LENGTH(inittraknum) > 29

THEN DO:

newtraknum = SUBSTRING(inittraknum, 17, 12).

setStringValue("Shiphead.TrackingNumber.SCRVALUE":U, newtraknum).

END.

ELSE DO:

END.



Thanks for any help.



Aaron Hoyt

Vantage System Admin

Hittite Microwave Corporation





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



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/SIG=12cdnv5rd/M=267637.4116732.5333197.1261774/D=eg
roupweb/S=1705007183:HM/EXP=1074095731/A=1853619/R=0/*http://www.netflix
.com/Default?mqso=60178356
<http://rd.yahoo.com/SIG=12cdnv5rd/M=267637.4116732.5333197.1261774/D=eg
roupweb/S=1705007183:HM/EXP=1074095731/A=1853619/R=0/*http:/www.netflix.
com/Default?mqso=60178356&partid=4116732> &partid=4116732> click here


<http://us.adserver.yahoo.com/l?M=267637.4116732.5333197.1261774/D=egrou
pmail/S=:HM/A=1853619/rand=896549892>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .




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



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.



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