Vantage to UPS Worldship ODBC


(system) #1
Hi Dave,

You will need a copy of the Merant ODBC software (available from Epicor) to
allow connection to the Progress database. I have written a Microsoft
Access routine that extracts the shipment information from the Vantage
"OrderHed, OrderDtl, SerialNo, ShipTo, ShipHead, and ShipDtl tables (I also
hold a translation table that takes the Vantage ShipViaCode and
table-look-up converts it to a valid UPS Service Type) and creates a single
flat file that is directly linked into the UPS Worldship program. The UPS
Worldship program does not handle batch processing as well as it should so
your shipping personnel will still need to process each shipment. The good
news is that all of your package and address information can reside within
Vantage. The flat file will preload all the address and package details
into UPS Worldship so your shipping personnel just move the shipment from
"Pending" to "Ready for Pickup".

Let me know if you would like a copy.

Dale

-----Original Message-----
From: dposkevich@...
[mailto:dposkevich@...]
Sent: Friday, July 21, 2000 7:10 AM
To: vantage@egroups.com
Subject: Re: [Vantage] Vantage to UPS Worldship ODBC



How were you able to get Vantage to be able to pass data into UPS's
Worldship? I would be very interested in finding out more on this.


I already have one application that passes shipment information from
Vantage
into UPS's Worldship product. The application uses Access to extract the
shipment information from Vantage and then put the information in a form
compatible to UPS. The loss of ODBC connectivity to the shipment tables
could cause us to not be able to ship.


_________________
Dave Poskevich
Systems Analyst
PRECISION MACHINE AND MANUFACTURING COMPANY

following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)

(system) #2
How were you able to get Vantage to be able to pass data into UPS's
Worldship? I would be very interested in finding out more on this.


I already have one application that passes shipment information from
Vantage
into UPS's Worldship product. The application uses Access to extract the
shipment information from Vantage and then put the information in a form
compatible to UPS. The loss of ODBC connectivity to the shipment tables
could cause us to not be able to ship.


_________________
Dave Poskevich
Systems Analyst
PRECISION MACHINE AND MANUFACTURING COMPANY







______________________________________________________________________


This document should only be read by those persons to whom it is
addressed and is not intended to be relied upon by any person without
subsequent written confirmation of its contents. Accordingly, PRECISION
MACHINE AND MANUFACTURING COMPANY disclaims all responsibility and accepts
no liability (including in negligence) for the consequences for any person
acting, or refraining from acting, on such information prior to the receipt
by those persons of subsequent written confirmation.

If you have received this E-mail message in error, please notify us
immediately by telephone. Please also destroy and delete the message from
your computer.

Contact:
By Phone: Systems Administrator at (515)-733-5181
By Email: sysadmin@...

Any form of reproduction, dissemination, copying, disclosure,
modification, distribution and/or publication of this E-mail message is
strictly prohibited.