Tracking shipments from within customer shipment tracker

No

Big or small ?

Grey or Tan ?

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of James Smith
Sent: Thursday, August 24, 2006 10:43 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Tracking shipments from within customer shipment tracker



Does anyone have a DHL URL they would be willing to share?

Thank You,
Jim
Lovejoy Chaplet Corp.

Todd,

Thanks to your prior assistance, I was able to integrate the track button
for tracking our UPS shipments from within Vantage. What do you do if there
are multiple tracking numbers for a single packing slip? We currently enter
them with a comma separator, but when we try to track the shipments, UPS
recognizes it as a single (invalid) tracking number. Is there a format that
you need to use to separate the different tracking numbers so UPS will
recognize the multiple tracking numbers?

Thanks Again,
Jim

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On Behalf Of
Todd Hofert
Sent: Friday, December 02, 2005 2:29 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] United Parcel Service - Worldship Integration

Todd,

I use this for FedEx:

http://www.fedex.com/cgi-bin/tracking?tracknumbers= <http://www.fedex.com/cgi-bin/tracking?tracknumbers=> <VantageTrackingNumbe
r>&action=track

Todd

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf
Of Todd Caughey
Sent: Friday, December 02, 2005 3:04 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] United Parcel Service - Worldship Integration

Glad you like it. Aside from saving time it means the tracking number
is far more accurate than typing it. If you have not taken the next
step already make an entry in the ShipVia maintenance for the tracking
URL.
For UPS I use:

< http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0 <http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0>
<http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0& <http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0&> > &
sort_by=status&tracknums_displayed=5&TypeOfInquiryNumber=T&button_index=
201&loc=en_US&InquiryNumber1=>
&InquiryNumber2=&InquiryNumber3=&InquiryNumber4=&InquiryNumber5=&AgreeTo
TermsAndConditions=yes&track.x=36&track.y=12"> http://wwwapps.ups.com/Web <http://wwwapps.ups.com/Web>
Tracking/processInputRequest?HTMLVersion=5.0&sort_by=status&tracknums_di
splayed=5&TypeOfInquiryNumber=T&button_index=201&loc=en_US&InquiryNumber
1=<VantageTrackingNumber>&InquiryNumber2=&InquiryNumber3=&InquiryNumber4
=&InquiryNumber5=&AgreeToTermsAndConditions=yes&track.x=36&track.y=12

and in Placeholder: <VantageTrackingNumber> (that URL probably wrapped
badly in email - sorry).

Then in Customer Shipment Tracker people can click on the track button
and the tracking number is filled in and the UPS tracking web site is
displayed. Vantage has its own little browser that does not allow users
to enter URLs and go surfing if they are otherwise restricted from web
usage. All the customer service people need is the PO number from the
customer to navigate the Sales Order screens to shipments and then to
the shipment tracker. They can usually answer a call about shipment
status within a few seconds.

The scanning works with other shippers as well - we scan Fed Ex but I
have not setup the URL for it yet since our Fed Ex volume is very low.
If someone has a Fed Ex URL to share it would really save me some time.

-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On Behalf
Of James Smith
Sent: Friday, December 02, 2005 1:34 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] United Parcel Service - Worldship Integration

Todd,

Thanks a bunch for your advice on the bar scanner. It was a very simple
solution. I just wish I had done this a year ago. I did not realize that
the tracking number field was even available when the packing slip was
generated. We had a bar scanner available that was sitting around
collecting dust. It was as simple as plugging it in and scanning the bar
code on the shipping label with the cursor residing in the tracking
field in customer shipment entry. That five minutes spent hooking up the
bar scanner will save us a bunch of time.

Thanks Again,
Jim

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On Behalf
Of Todd Caughey
Sent: Friday, December 02, 2005 8:49 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] United Parcel Service - Worldship Integration

You can access the Vantage tables with ODBC and it is safe to "read".
Writing to Vantage might very well NOT be safe and is not worth the
risk.
But using something like Access to prompt and read from Vantage would be
fairly easy - importing to Worldship though might require expert
knowledge of that system.

One alternative for the tracking number that we use....a simple bar code
scanner to zap and "enter" the tracking number in the appropriate field
on the Packing Slip screen. This then becomes available from one of the
tracker screens with a button you can set up to start a browser link to
the UPS tracking site. So customer service people can answer shipment
status questions. By scanning the UPS label (the Code 39 bar code not
the 2D
matrix) entry is accurate, fairly fast and not too expensive with a
low-end keyboard line scanner.

-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On Behalf
Of James Smith
Sent: Friday, December 02, 2005 7:34 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] United Parcel Service - Worldship Integration

How do you access those tables from outside of vantage and is it safe
to?

Thanks,
Jim

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On Behalf
Of Gerard Wadman
Sent: Friday, December 02, 2005 8:21 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] United Parcel Service - Worldship Integration

In Version 8, the tables are "shipdtl" and "shiphead".

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf
Of James Smith
Sent: Friday, December 02, 2005 7:24 AM
To: Vantage (E-mail)
Subject: [Vantage] United Parcel Service - Worldship Integration

I have an individual from UPS coming in today from their Customer
Technology Sales Support staff to attempt to integrate worldship with
Vantage. He is hoping to give me a tool that will give me UPS tracking
numbers that are tied to the sales order and either have the tracking
information available from within Vantage or have a script run from the
desktop that can be exported to excel and have the tracking information
available from there. He is also going to attempt to link the two so
that if the order number is entered in Worldship the details from
vantage will come over automatically.

Has anyone been successful with integrating Worldship with Vantage? I
went to the archives on Yahoogroups to review previous posts concerning
this matter and did not read a lot of encouraging results. What do I
need to be aware of?

Where does the table/path reside that would have the relevant ship to
information when a packing slip is created?

Thanks in advance for your help. Please keep in mind when replying that
you are dealing with a Bean Counter and not an IT person. In other words
please keep it simple.

Thanks,
Jim Smith
Lovejoy Chaplet Corp.






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

Thanks to your prior assistance, I was able to integrate the track button
for tracking our UPS shipments from within Vantage. What do you do if there
are multiple tracking numbers for a single packing slip? We currently enter
them with a comma separator, but when we try to track the shipments, UPS
recognizes it as a single (invalid) tracking number. Is there a format that
you need to use to separate the different tracking numbers so UPS will
recognize the multiple tracking numbers?

Thanks Again,
Jim

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Todd Hofert
Sent: Friday, December 02, 2005 2:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] United Parcel Service - Worldship Integration


Todd,

I use this for FedEx:

http://www.fedex.com/cgi-bin/tracking?tracknumbers=<VantageTrackingNumbe
r>&action=track

Todd

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Caughey
Sent: Friday, December 02, 2005 3:04 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] United Parcel Service - Worldship Integration

Glad you like it. Aside from saving time it means the tracking number
is far more accurate than typing it. If you have not taken the next
step already make an entry in the ShipVia maintenance for the tracking
URL.
For UPS I use:

< http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0
<http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0&> &
sort_by=status&tracknums_displayed=5&TypeOfInquiryNumber=T&button_index=
201&loc=en_US&InquiryNumber1=>
&InquiryNumber2=&InquiryNumber3=&InquiryNumber4=&InquiryNumber5=&AgreeTo
TermsAndConditions=yes&track.x=36&track.y=12"> http://wwwapps.ups.com/Web
Tracking/processInputRequest?HTMLVersion=5.0&sort_by=status&tracknums_di
splayed=5&TypeOfInquiryNumber=T&button_index=201&loc=en_US&InquiryNumber
1=<VantageTrackingNumber>&InquiryNumber2=&InquiryNumber3=&InquiryNumber4
=&InquiryNumber5=&AgreeToTermsAndConditions=yes&track.x=36&track.y=12

and in Placeholder: <VantageTrackingNumber> (that URL probably wrapped
badly in email - sorry).

Then in Customer Shipment Tracker people can click on the track button
and the tracking number is filled in and the UPS tracking web site is
displayed. Vantage has its own little browser that does not allow users
to enter URLs and go surfing if they are otherwise restricted from web
usage. All the customer service people need is the PO number from the
customer to navigate the Sales Order screens to shipments and then to
the shipment tracker. They can usually answer a call about shipment
status within a few seconds.

The scanning works with other shippers as well - we scan Fed Ex but I
have not setup the URL for it yet since our Fed Ex volume is very low.
If someone has a Fed Ex URL to share it would really save me some time.

-Todd C.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of James Smith
Sent: Friday, December 02, 2005 1:34 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] United Parcel Service - Worldship Integration


Todd,

Thanks a bunch for your advice on the bar scanner. It was a very simple
solution. I just wish I had done this a year ago. I did not realize that
the tracking number field was even available when the packing slip was
generated. We had a bar scanner available that was sitting around
collecting dust. It was as simple as plugging it in and scanning the bar
code on the shipping label with the cursor residing in the tracking
field in customer shipment entry. That five minutes spent hooking up the
bar scanner will save us a bunch of time.

Thanks Again,
Jim

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Todd Caughey
Sent: Friday, December 02, 2005 8:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] United Parcel Service - Worldship Integration


You can access the Vantage tables with ODBC and it is safe to "read".
Writing to Vantage might very well NOT be safe and is not worth the
risk.
But using something like Access to prompt and read from Vantage would be
fairly easy - importing to Worldship though might require expert
knowledge of that system.

One alternative for the tracking number that we use....a simple bar code
scanner to zap and "enter" the tracking number in the appropriate field
on the Packing Slip screen. This then becomes available from one of the
tracker screens with a button you can set up to start a browser link to
the UPS tracking site. So customer service people can answer shipment
status questions. By scanning the UPS label (the Code 39 bar code not
the 2D
matrix) entry is accurate, fairly fast and not too expensive with a
low-end keyboard line scanner.

-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of James Smith
Sent: Friday, December 02, 2005 7:34 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] United Parcel Service - Worldship Integration


How do you access those tables from outside of vantage and is it safe
to?

Thanks,
Jim

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Gerard Wadman
Sent: Friday, December 02, 2005 8:21 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] United Parcel Service - Worldship Integration


In Version 8, the tables are "shipdtl" and "shiphead".



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of James Smith
Sent: Friday, December 02, 2005 7:24 AM
To: Vantage (E-mail)
Subject: [Vantage] United Parcel Service - Worldship Integration



I have an individual from UPS coming in today from their Customer
Technology Sales Support staff to attempt to integrate worldship with
Vantage. He is hoping to give me a tool that will give me UPS tracking
numbers that are tied to the sales order and either have the tracking
information available from within Vantage or have a script run from the
desktop that can be exported to excel and have the tracking information
available from there. He is also going to attempt to link the two so
that if the order number is entered in Worldship the details from
vantage will come over automatically.

Has anyone been successful with integrating Worldship with Vantage? I
went to the archives on Yahoogroups to review previous posts concerning
this matter and did not read a lot of encouraging results. What do I
need to be aware of?

Where does the table/path reside that would have the relevant ship to
information when a packing slip is created?

Thanks in advance for your help. Please keep in mind when replying that
you are dealing with a Bean Counter and not an IT person. In other words
please keep it simple.

Thanks,
Jim Smith
Lovejoy Chaplet Corp.
Does anyone have a DHL URL they would be willing to share?

Thank You,
Jim
Lovejoy Chaplet Corp.


Todd,

Thanks to your prior assistance, I was able to integrate the track button
for tracking our UPS shipments from within Vantage. What do you do if there
are multiple tracking numbers for a single packing slip? We currently enter
them with a comma separator, but when we try to track the shipments, UPS
recognizes it as a single (invalid) tracking number. Is there a format that
you need to use to separate the different tracking numbers so UPS will
recognize the multiple tracking numbers?

Thanks Again,
Jim

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Todd Hofert
Sent: Friday, December 02, 2005 2:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] United Parcel Service - Worldship Integration


Todd,

I use this for FedEx:

http://www.fedex.com/cgi-bin/tracking?tracknumbers=<VantageTrackingNumbe
r>&action=track

Todd

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Caughey
Sent: Friday, December 02, 2005 3:04 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] United Parcel Service - Worldship Integration

Glad you like it. Aside from saving time it means the tracking number
is far more accurate than typing it. If you have not taken the next
step already make an entry in the ShipVia maintenance for the tracking
URL.
For UPS I use:

< http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0
<http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0&> &
sort_by=status&tracknums_displayed=5&TypeOfInquiryNumber=T&button_index=
201&loc=en_US&InquiryNumber1=>
&InquiryNumber2=&InquiryNumber3=&InquiryNumber4=&InquiryNumber5=&AgreeTo
TermsAndConditions=yes&track.x=36&track.y=12"> http://wwwapps.ups.com/Web
Tracking/processInputRequest?HTMLVersion=5.0&sort_by=status&tracknums_di
splayed=5&TypeOfInquiryNumber=T&button_index=201&loc=en_US&InquiryNumber
1=<VantageTrackingNumber>&InquiryNumber2=&InquiryNumber3=&InquiryNumber4
=&InquiryNumber5=&AgreeToTermsAndConditions=yes&track.x=36&track.y=12

and in Placeholder: <VantageTrackingNumber> (that URL probably wrapped
badly in email - sorry).

Then in Customer Shipment Tracker people can click on the track button
and the tracking number is filled in and the UPS tracking web site is
displayed. Vantage has its own little browser that does not allow users
to enter URLs and go surfing if they are otherwise restricted from web
usage. All the customer service people need is the PO number from the
customer to navigate the Sales Order screens to shipments and then to
the shipment tracker. They can usually answer a call about shipment
status within a few seconds.

The scanning works with other shippers as well - we scan Fed Ex but I
have not setup the URL for it yet since our Fed Ex volume is very low.
If someone has a Fed Ex URL to share it would really save me some time.

-Todd C.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of James Smith
Sent: Friday, December 02, 2005 1:34 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] United Parcel Service - Worldship Integration


Todd,

Thanks a bunch for your advice on the bar scanner. It was a very simple
solution. I just wish I had done this a year ago. I did not realize that
the tracking number field was even available when the packing slip was
generated. We had a bar scanner available that was sitting around
collecting dust. It was as simple as plugging it in and scanning the bar
code on the shipping label with the cursor residing in the tracking
field in customer shipment entry. That five minutes spent hooking up the
bar scanner will save us a bunch of time.

Thanks Again,
Jim

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Todd Caughey
Sent: Friday, December 02, 2005 8:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] United Parcel Service - Worldship Integration


You can access the Vantage tables with ODBC and it is safe to "read".
Writing to Vantage might very well NOT be safe and is not worth the
risk.
But using something like Access to prompt and read from Vantage would be
fairly easy - importing to Worldship though might require expert
knowledge of that system.

One alternative for the tracking number that we use....a simple bar code
scanner to zap and "enter" the tracking number in the appropriate field
on the Packing Slip screen. This then becomes available from one of the
tracker screens with a button you can set up to start a browser link to
the UPS tracking site. So customer service people can answer shipment
status questions. By scanning the UPS label (the Code 39 bar code not
the 2D
matrix) entry is accurate, fairly fast and not too expensive with a
low-end keyboard line scanner.

-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of James Smith
Sent: Friday, December 02, 2005 7:34 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] United Parcel Service - Worldship Integration


How do you access those tables from outside of vantage and is it safe
to?

Thanks,
Jim

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Gerard Wadman
Sent: Friday, December 02, 2005 8:21 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] United Parcel Service - Worldship Integration


In Version 8, the tables are "shipdtl" and "shiphead".



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of James Smith
Sent: Friday, December 02, 2005 7:24 AM
To: Vantage (E-mail)
Subject: [Vantage] United Parcel Service - Worldship Integration



I have an individual from UPS coming in today from their Customer
Technology Sales Support staff to attempt to integrate worldship with
Vantage. He is hoping to give me a tool that will give me UPS tracking
numbers that are tied to the sales order and either have the tracking
information available from within Vantage or have a script run from the
desktop that can be exported to excel and have the tracking information
available from there. He is also going to attempt to link the two so
that if the order number is entered in Worldship the details from
vantage will come over automatically.

Has anyone been successful with integrating Worldship with Vantage? I
went to the archives on Yahoogroups to review previous posts concerning
this matter and did not read a lot of encouraging results. What do I
need to be aware of?

Where does the table/path reside that would have the relevant ship to
information when a packing slip is created?

Thanks in advance for your help. Please keep in mind when replying that
you are dealing with a Bean Counter and not an IT person. In other words
please keep it simple.

Thanks,
Jim Smith
Lovejoy Chaplet Corp.
http://track.dhl-usa.com/TrackByNbr.asp?ShipmentNumber=

Butch


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of James Smith
Sent: Thursday, August 24, 2006 7:43 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Tracking shipments from within customer shipment tracker



Does anyone have a DHL URL they would be willing to share?

Thank You,
Jim
Lovejoy Chaplet Corp.

Todd,

Thanks to your prior assistance, I was able to integrate the track button
for tracking our UPS shipments from within Vantage. What do you do if there
are multiple tracking numbers for a single packing slip? We currently enter
them with a comma separator, but when we try to track the shipments, UPS
recognizes it as a single (invalid) tracking number. Is there a format that
you need to use to separate the different tracking numbers so UPS will
recognize the multiple tracking numbers?

Thanks Again,
Jim

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On Behalf Of
Todd Hofert
Sent: Friday, December 02, 2005 2:29 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] United Parcel Service - Worldship Integration

Todd,

I use this for FedEx:

http://www.fedex.com/cgi-bin/tracking?tracknumbers= <http://www.fedex.com/cgi-bin/tracking?tracknumbers=> <VantageTrackingNumbe
r>&action=track

Todd

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf
Of Todd Caughey
Sent: Friday, December 02, 2005 3:04 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] United Parcel Service - Worldship Integration

Glad you like it. Aside from saving time it means the tracking number
is far more accurate than typing it. If you have not taken the next
step already make an entry in the ShipVia maintenance for the tracking
URL.
For UPS I use:

< http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0 <http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0>
<http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0& <http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0&> > &
sort_by=status&tracknums_displayed=5&TypeOfInquiryNumber=T&button_index=
201&loc=en_US&InquiryNumber1=>
&InquiryNumber2=&InquiryNumber3=&InquiryNumber4=&InquiryNumber5=&AgreeTo
TermsAndConditions=yes&track.x=36&track.y=12"> http://wwwapps.ups.com/Web <http://wwwapps.ups.com/Web>
Tracking/processInputRequest?HTMLVersion=5.0&sort_by=status&tracknums_di
splayed=5&TypeOfInquiryNumber=T&button_index=201&loc=en_US&InquiryNumber
1=<VantageTrackingNumber>&InquiryNumber2=&InquiryNumber3=&InquiryNumber4
=&InquiryNumber5=&AgreeToTermsAndConditions=yes&track.x=36&track.y=12

and in Placeholder: <VantageTrackingNumber> (that URL probably wrapped
badly in email - sorry).

Then in Customer Shipment Tracker people can click on the track button
and the tracking number is filled in and the UPS tracking web site is
displayed. Vantage has its own little browser that does not allow users
to enter URLs and go surfing if they are otherwise restricted from web
usage. All the customer service people need is the PO number from the
customer to navigate the Sales Order screens to shipments and then to
the shipment tracker. They can usually answer a call about shipment
status within a few seconds.

The scanning works with other shippers as well - we scan Fed Ex but I
have not setup the URL for it yet since our Fed Ex volume is very low.
If someone has a Fed Ex URL to share it would really save me some time.

-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On Behalf
Of James Smith
Sent: Friday, December 02, 2005 1:34 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] United Parcel Service - Worldship Integration

Todd,

Thanks a bunch for your advice on the bar scanner. It was a very simple
solution. I just wish I had done this a year ago. I did not realize that
the tracking number field was even available when the packing slip was
generated. We had a bar scanner available that was sitting around
collecting dust. It was as simple as plugging it in and scanning the bar
code on the shipping label with the cursor residing in the tracking
field in customer shipment entry. That five minutes spent hooking up the
bar scanner will save us a bunch of time.

Thanks Again,
Jim

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On Behalf
Of Todd Caughey
Sent: Friday, December 02, 2005 8:49 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] United Parcel Service - Worldship Integration

You can access the Vantage tables with ODBC and it is safe to "read".
Writing to Vantage might very well NOT be safe and is not worth the
risk.
But using something like Access to prompt and read from Vantage would be
fairly easy - importing to Worldship though might require expert
knowledge of that system.

One alternative for the tracking number that we use....a simple bar code
scanner to zap and "enter" the tracking number in the appropriate field
on the Packing Slip screen. This then becomes available from one of the
tracker screens with a button you can set up to start a browser link to
the UPS tracking site. So customer service people can answer shipment
status questions. By scanning the UPS label (the Code 39 bar code not
the 2D
matrix) entry is accurate, fairly fast and not too expensive with a
low-end keyboard line scanner.

-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On Behalf
Of James Smith
Sent: Friday, December 02, 2005 7:34 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] United Parcel Service - Worldship Integration

How do you access those tables from outside of vantage and is it safe
to?

Thanks,
Jim

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On Behalf
Of Gerard Wadman
Sent: Friday, December 02, 2005 8:21 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] United Parcel Service - Worldship Integration

In Version 8, the tables are "shipdtl" and "shiphead".

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf
Of James Smith
Sent: Friday, December 02, 2005 7:24 AM
To: Vantage (E-mail)
Subject: [Vantage] United Parcel Service - Worldship Integration

I have an individual from UPS coming in today from their Customer
Technology Sales Support staff to attempt to integrate worldship with
Vantage. He is hoping to give me a tool that will give me UPS tracking
numbers that are tied to the sales order and either have the tracking
information available from within Vantage or have a script run from the
desktop that can be exported to excel and have the tracking information
available from there. He is also going to attempt to link the two so
that if the order number is entered in Worldship the details from
vantage will come over automatically.

Has anyone been successful with integrating Worldship with Vantage? I
went to the archives on Yahoogroups to review previous posts concerning
this matter and did not read a lot of encouraging results. What do I
need to be aware of?

Where does the table/path reside that would have the relevant ship to
information when a packing slip is created?

Thanks in advance for your help. Please keep in mind when replying that
you are dealing with a Bean Counter and not an IT person. In other words
please keep it simple.

Thanks,
Jim Smith
Lovejoy Chaplet Corp.






[Non-text portions of this message have been removed]
This is the URL we have set up: http://www.dhl.com/cgi-bin/tracking.pl?TID=CP_ENG&FIRST_DB=US&AWB=<VantageTrackingNumber>



Randall Lunsford
Excel Machinery, Ltd.
e-mail: rlunsf@...
Phone: (806) 335-4565 ext. 531
Fax: (806) 335-9017

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of James Smith
Sent: Thursday, August 24, 2006 9:43 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Tracking shipments from within customer shipment tracker



Does anyone have a DHL URL they would be willing to share?

Thank You,
Jim
Lovejoy Chaplet Corp.

Todd,

Thanks to your prior assistance, I was able to integrate the track button
for tracking our UPS shipments from within Vantage. What do you do if there
are multiple tracking numbers for a single packing slip? We currently enter
them with a comma separator, but when we try to track the shipments, UPS
recognizes it as a single (invalid) tracking number. Is there a format that
you need to use to separate the different tracking numbers so UPS will
recognize the multiple tracking numbers?

Thanks Again,
Jim

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On Behalf Of
Todd Hofert
Sent: Friday, December 02, 2005 2:29 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] United Parcel Service - Worldship Integration

Todd,

I use this for FedEx:

http://www.fedex.com/cgi-bin/tracking?tracknumbers= <http://www.fedex.com/cgi-bin/tracking?tracknumbers=> <VantageTrackingNumbe
r>&action=track

Todd

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf
Of Todd Caughey
Sent: Friday, December 02, 2005 3:04 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] United Parcel Service - Worldship Integration

Glad you like it. Aside from saving time it means the tracking number
is far more accurate than typing it. If you have not taken the next
step already make an entry in the ShipVia maintenance for the tracking
URL.
For UPS I use:

< http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0 <http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0>
<http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0& <http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0&> > &
sort_by=status&tracknums_displayed=5&TypeOfInquiryNumber=T&button_index=
201&loc=en_US&InquiryNumber1=>
&InquiryNumber2=&InquiryNumber3=&InquiryNumber4=&InquiryNumber5=&AgreeTo
TermsAndConditions=yes&track.x=36&track.y=12"> http://wwwapps.ups.com/Web <http://wwwapps.ups.com/Web>
Tracking/processInputRequest?HTMLVersion=5.0&sort_by=status&tracknums_di
splayed=5&TypeOfInquiryNumber=T&button_index=201&loc=en_US&InquiryNumber
1=<VantageTrackingNumber>&InquiryNumber2=&InquiryNumber3=&InquiryNumber4
=&InquiryNumber5=&AgreeToTermsAndConditions=yes&track.x=36&track.y=12

and in Placeholder: <VantageTrackingNumber> (that URL probably wrapped
badly in email - sorry).

Then in Customer Shipment Tracker people can click on the track button
and the tracking number is filled in and the UPS tracking web site is
displayed. Vantage has its own little browser that does not allow users
to enter URLs and go surfing if they are otherwise restricted from web
usage. All the customer service people need is the PO number from the
customer to navigate the Sales Order screens to shipments and then to
the shipment tracker. They can usually answer a call about shipment
status within a few seconds.

The scanning works with other shippers as well - we scan Fed Ex but I
have not setup the URL for it yet since our Fed Ex volume is very low.
If someone has a Fed Ex URL to share it would really save me some time.

-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On Behalf
Of James Smith
Sent: Friday, December 02, 2005 1:34 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] United Parcel Service - Worldship Integration

Todd,

Thanks a bunch for your advice on the bar scanner. It was a very simple
solution. I just wish I had done this a year ago. I did not realize that
the tracking number field was even available when the packing slip was
generated. We had a bar scanner available that was sitting around
collecting dust. It was as simple as plugging it in and scanning the bar
code on the shipping label with the cursor residing in the tracking
field in customer shipment entry. That five minutes spent hooking up the
bar scanner will save us a bunch of time.

Thanks Again,
Jim

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On Behalf
Of Todd Caughey
Sent: Friday, December 02, 2005 8:49 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] United Parcel Service - Worldship Integration

You can access the Vantage tables with ODBC and it is safe to "read".
Writing to Vantage might very well NOT be safe and is not worth the
risk.
But using something like Access to prompt and read from Vantage would be
fairly easy - importing to Worldship though might require expert
knowledge of that system.

One alternative for the tracking number that we use....a simple bar code
scanner to zap and "enter" the tracking number in the appropriate field
on the Packing Slip screen. This then becomes available from one of the
tracker screens with a button you can set up to start a browser link to
the UPS tracking site. So customer service people can answer shipment
status questions. By scanning the UPS label (the Code 39 bar code not
the 2D
matrix) entry is accurate, fairly fast and not too expensive with a
low-end keyboard line scanner.

-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On Behalf
Of James Smith
Sent: Friday, December 02, 2005 7:34 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] United Parcel Service - Worldship Integration

How do you access those tables from outside of vantage and is it safe
to?

Thanks,
Jim

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On Behalf
Of Gerard Wadman
Sent: Friday, December 02, 2005 8:21 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] United Parcel Service - Worldship Integration

In Version 8, the tables are "shipdtl" and "shiphead".

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf
Of James Smith
Sent: Friday, December 02, 2005 7:24 AM
To: Vantage (E-mail)
Subject: [Vantage] United Parcel Service - Worldship Integration

I have an individual from UPS coming in today from their Customer
Technology Sales Support staff to attempt to integrate worldship with
Vantage. He is hoping to give me a tool that will give me UPS tracking
numbers that are tied to the sales order and either have the tracking
information available from within Vantage or have a script run from the
desktop that can be exported to excel and have the tracking information
available from there. He is also going to attempt to link the two so
that if the order number is entered in Worldship the details from
vantage will come over automatically.

Has anyone been successful with integrating Worldship with Vantage? I
went to the archives on Yahoogroups to review previous posts concerning
this matter and did not read a lot of encouraging results. What do I
need to be aware of?

Where does the table/path reside that would have the relevant ship to
information when a packing slip is created?

Thanks in advance for your help. Please keep in mind when replying that
you are dealing with a Bean Counter and not an IT person. In other words
please keep it simple.

Thanks,
Jim Smith
Lovejoy Chaplet Corp.





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