United Parcel Service - Worldship Integration

We often have several (as many as 20) boxes for a shipment. We scan the first one and assume they will all, more or less, travel together. If UPS splits them up we still have the individual tracking numbers available to use, just not in Vantage. Actually, they might have the same tracking number because Worldship does have a multiple box feature. But I know we just scan the first box that gets a UPS label into the packing slip screen.
-Todd C.

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


Todd,

Just curious: what do you do when you have more than one tracking number
for the same Customer shipment?

Lydia

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Friday, December 02, 2005 12:38 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] United Parcel Service - Worldship Integration







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




SPONSORED LINKS
Manufacturing <http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
Pda <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software Database <http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* 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]
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.
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.



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



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* 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]
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.



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



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* 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/.
(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







[Non-text portions of this message have been removed]
You can use an ODBC link in Access, your UPS tech should know how to do
this, you may also want to link to the "OrderHed" and "OrderDtl" tables
to get customer names and ship to addresses. However, I am having
trouble displaying the OrderHed info because the data sizes appear to
be to big for access to handle, most of the columns in that table are
string data types with a character limit of 65534 or 2 to the 16th.

When you create your ODBC DSN connection, you can check the box that
says "Read Only Mode" in which case you should not have to worry about
deleting any data.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of James Smith
Sent: Friday, December 02, 2005 8: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.



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/>
<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



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* 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







[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




SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>

Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>



________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* 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]
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.



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



* Visit your group "vantage
< http://groups.yahoo.com/group/vantage> " on the web.

* 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/.
(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







[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




SPONSORED LINKS
Manufacturing <http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
Pda <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software Database <http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* 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]
I run a perl script that access Vantage through the ODBC and export the
address from the ShipTo via the ShipHead and MscShpHd tables to a csv
file that is read by Worldship and is keyed from the Packing Slip number
that is barcoded on the Packing Slip. The problem I have writing the
tracking number back from Worldship is that Worldship cannot distinguish
between a Customer Packing Slip or a Misc Packing Slip and those need to
be written to separate tables. What I have done is wrote a perl script
that imports the tracking numbers to Vantage at the end of the day, we
have been doing this for over two years without any issues.



I would love to hear back if you have any luck with you UPS tech.



Thanks,



Rich



_____

From: Todd Caughey [mailto:caugheyt@...]
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.



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/>
< 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



* Visit your group "vantage
< http://groups.yahoo.com/group/vantage> " on the web.

* 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







[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




SPONSORED LINKS
Manufacturing
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software
Membership
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
database software Database
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage
software
Pda
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database
software Database
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
management software Database
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>
marketing software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage
<http://groups.yahoo.com/group/vantage> " on the web.


* 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




SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>

Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>



_____

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* 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]
> 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.

Good advice from Todd. I would NEVER circumvent business logic by using an
ODBC connection to modify data in ANY application.

In addition to Todd's barcode suggestion, if you pass Worldship an email
address, it will email the tracking number to the customer at ship time. It
lacks some of the pretty branding that one might want to do, but for the
price (free) it may be worth doing.

Also, when linking addressing, make sure that if there are multiple ship-to
locations/releases that you're getting the correct address. Don't mess with
the address book, just have UPS create a shipment record.

BTW, if the web services get better, I think the interface with UPS will be
much tighter. The business logic would be enforced in the interface when one
finally exists. You can get more details about the UPS web services
available at:
http://www.ups.com/content/us/en/bussol/offering/technology/automated_shippi
ng/online_tools.html, but be warned, this is for the programmer type.

Also for the Geeky types, here's an article show a real live example of a
web site getting UPS rates into their page using the UPS web services:
http://www.4guysfromrolla.com/webtech/112200-1.shtml

Finally, there's always the Advance Ship module used by Tanya Jernigan at
Water Jets which she says is starting to mature.

Mark W.
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.



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



* Visit your group "vantage
< http://groups.yahoo.com/group/vantage> " on the web.

* 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/.
(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







[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




SPONSORED LINKS
Manufacturing
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing
+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=P
da+database+software&w5=Database+management+software&w6=Database+marketing+s
oftware&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+softwar
e&w4=Pda+database+software&w5=Database+management+software&w6=Database+marke
ting+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software
Database
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+software&
w4=Pda+database+software&w5=Database+management+software&w6=Database+marketi
ng+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
Pda
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+
software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pd
a+database+software&w5=Database+management+software&w6=Database+marketing+so
ftware&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software
Database
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+softwar
e&w4=Pda+database+software&w5=Database+management+software&w6=Database+marke
ting+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software
Database
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufact
uring+software&w2=Membership+database+software&w3=Database+mortgage+software
&w4=Pda+database+software&w5=Database+management+software&w6=Database+market
ing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage>
" on the web.


* 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/.
(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







[Non-text portions of this message have been removed]
Is the "simple bar code scanner" a simple solution? Does it involve more
than simply having the cursor in the tracking number field on the packing
slip and scanning the label?

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.



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



* Visit your group "vantage
< http://groups.yahoo.com/group/vantage> " on the web.

* 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/.
(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







[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




SPONSORED LINKS
Manufacturing
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing
+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=P
da+database+software&w5=Database+management+software&w6=Database+marketing+s
oftware&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+softwar
e&w4=Pda+database+software&w5=Database+management+software&w6=Database+marke
ting+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software
Database
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+software&
w4=Pda+database+software&w5=Database+management+software&w6=Database+marketi
ng+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
Pda
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+
software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pd
a+database+software&w5=Database+management+software&w6=Database+marketing+so
ftware&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software
Database
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+softwar
e&w4=Pda+database+software&w5=Database+management+software&w6=Database+marke
ting+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software
Database
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufact
uring+software&w2=Membership+database+software&w3=Database+mortgage+software
&w4=Pda+database+software&w5=Database+management+software&w6=Database+market
ing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage>
" on the web.


* 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/.
(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







[Non-text portions of this message have been removed]
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&sort_by=status&tracknums_displayed=5&TypeOfInquiryNumber=T&button_index=201&loc=en_US&InquiryNumber1=> &InquiryNumber2=&InquiryNumber3=&InquiryNumber4=&InquiryNumber5=&AgreeToTermsAndConditions=yes&track.x=36&track.y=12">http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0&sort_by=status&tracknums_displayed=5&TypeOfInquiryNumber=T&button_index=201&loc=en_US&InquiryNumber1=<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.



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



* Visit your group "vantage
< http://groups.yahoo.com/group/vantage> " on the web.

* 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/.
(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







[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




SPONSORED LINKS
Manufacturing
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing> &k=Manufacturing+software&w1=Manufacturing
+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=P
da+database+software&w5=Database+management+software&w6=Database+marketing+s
oftware&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufac> &k=Membership+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+softwar
e&w4=Pda+database+software&w5=Database+management+software&w6=Database+marke
ting+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software
Database
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufactu> &k=Database+mortgage+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+software&
w4=Pda+database+software&w5=Database+management+software&w6=Database+marketi
ng+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
Pda
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+> &k=Pda+database+software&w1=Manufacturing+
software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pd
a+database+software&w5=Database+management+software&w6=Database+marketing+so
ftware&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software
Database
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufac> &k=Database+management+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+softwar
e&w4=Pda+database+software&w5=Database+management+software&w6=Database+marke
ting+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software
Database
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufact> &k=Database+marketing+software&w1=Manufact
uring+software&w2=Membership+database+software&w3=Database+mortgage+software
&w4=Pda+database+software&w5=Database+management+software&w6=Database+market
ing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage < http://groups.yahoo.com/group/vantage>
" on the web.


* 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/.
(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







[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 LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* 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]
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&
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.



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



* Visit your group "vantage
< http://groups.yahoo.com/group/vantage> " on the web.

* 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/.
(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







[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




SPONSORED LINKS
Manufacturing
< http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring> &k=Manufacturing+software&w1=Manufacturing
+software&w2=Membership+database+software&w3=Database+mortgage+software&
w4=P
da+database+software&w5=Database+management+software&w6=Database+marketi
ng+s
oftware&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership
< http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufac> &k=Membership+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
twar
e&w4=Pda+database+software&w5=Database+management+software&w6=Database+m
arke
ting+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software
Database
< http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
actu> &k=Database+mortgage+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&
w4=Pda+database+software&w5=Database+management+software&w6=Database+mar
keti
ng+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software

Pda
< http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+> &k=Pda+database+software&w1=Manufacturing+
software&w2=Membership+database+software&w3=Database+mortgage+software&w
4=Pd
a+database+software&w5=Database+management+software&w6=Database+marketin
g+so
ftware&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software
Database
< http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufac> &k=Database+management+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
twar
e&w4=Pda+database+software&w5=Database+management+software&w6=Database+m
arke
ting+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software
Database
< http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
fact> &k=Database+marketing+software&w1=Manufact
uring+software&w2=Membership+database+software&w3=Database+mortgage+soft
ware
&w4=Pda+database+software&w5=Database+management+software&w6=Database+ma
rket
ing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software


_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <
http://groups.yahoo.com/group/vantage>
" on the web.


* 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/.
(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







[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 LINKS



* Visit your group " vantage
<http://groups.yahoo.com/group/vantage> " on the web.


* 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/.
(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








This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.
Thanks! I'll try that out.


-----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.



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



* Visit your group "vantage
< http://groups.yahoo.com/group/vantage> " on the web.

* 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/.
(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







[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




SPONSORED LINKS
Manufacturing
< http://groups.yahoo.com/gads?t=ms
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu> &k=Manufacturing+software&w1=Manufactu
ring> &k=Manufacturing+software&w1=Manufacturing
+software&w2=Membership+database+software&w3=Database+mortgage+software&
w4=P
da+database+software&w5=Database+management+software&w6=Database+marketi
ng+s
oftware&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership
< http://groups.yahoo.com/gads?t=ms
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man> &k=Membership+database+software&w1=Man
ufac> &k=Membership+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
twar
e&w4=Pda+database+software&w5=Database+management+software&w6=Database+m
arke
ting+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software
Database
< http://groups.yahoo.com/gads?t=ms
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf> &k=Database+mortgage+software&w1=Manuf
actu> &k=Database+mortgage+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&
w4=Pda+database+software&w5=Database+management+software&w6=Database+mar
keti
ng+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software

Pda
< http://groups.yahoo.com/gads?t=ms
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur> &k=Pda+database+software&w1=Manufactur
ing+> &k=Pda+database+software&w1=Manufacturing+
software&w2=Membership+database+software&w3=Database+mortgage+software&w
4=Pd
a+database+software&w5=Database+management+software&w6=Database+marketin
g+so
ftware&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software
Database
< http://groups.yahoo.com/gads?t=ms
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man> &k=Database+management+software&w1=Man
ufac> &k=Database+management+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
twar
e&w4=Pda+database+software&w5=Database+management+software&w6=Database+m
arke
ting+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software
Database
< http://groups.yahoo.com/gads?t=ms
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu> &k=Database+marketing+software&w1=Manu
fact> &k=Database+marketing+software&w1=Manufact
uring+software&w2=Membership+database+software&w3=Database+mortgage+soft
ware
&w4=Pda+database+software&w5=Database+management+software&w6=Database+ma
rket
ing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software


_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <
http://groups.yahoo.com/group/vantage>
" on the web.


* 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/.
(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







[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 LINKS



* Visit your group " vantage
< http://groups.yahoo.com/group/vantage> " on the web.


* 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/.
(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








This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.


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




SPONSORED LINKS
Manufacturing <http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
Pda <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software Database <http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* 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]
Todd,

Just curious: what do you do when you have more than one tracking number
for the same Customer shipment?

Lydia

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Friday, December 02, 2005 12:38 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] United Parcel Service - Worldship Integration