Vantage to UPS Worldship ODBC


(system) #1
UPS Worldship provides a mechanism for data import. You can link to any flat
file structure to provide the information to the UPS system. The problem
occurs in the best choice for creating the flat file. Gary Grenier appears
to use a mechanism where he creates a flat file in CSV format for the UPS
system to use. I use a stand-alone Microsoft Access routine to perform the
queries and create a .DBF file for UPS to use. In my case, my product is
serial numbered and often packaged one serial numbered product to a box. I
had to use Access to run five different queries to create a final flat file
for UPS.

One caution, regardless of method, UPS Worldship does not yet allow more
than a single package per shipment. This means that you will create every
package as 1 of 1 in the UPS system regardless of how many you are actually
sending.

Dale Puls
Pacesetter Electronics Inc.

-----Original Message-----
From: Darren Mann [mailto:dmann@...]
Sent: Friday, July 21, 2000 1:28 PM
To: vantage@egroups.com
Subject: RE: [Vantage] Re: Vantage to UPS Worldship ODBC


What are you transferring to UPS's database? Does it allow you to import
the entire packing slip information for shipments destine for UPS shipping?
What new ability is built into UPS Worldship for data transfer? It sounds
good....

Darren Mann
Miller Products Co.

(system) #2
What are you transferring to UPS's database? Does it allow you to import
the entire packing slip information for shipments destine for UPS shipping?
What new ability is built into UPS Worldship for data transfer? It sounds
good....

Darren Mann
Miller Products Co.

> -----Original Message-----
> From: Gary Grenier [mailto:ggrenier@...]
> Sent: Friday, July 21, 2000 12:50 PM
> To: vantage@egroups.com
> Subject: [Vantage] Re: Vantage to UPS Worldship ODBC
>
>
> We tried to get UPS Worldship to reach into the Vantage
> database "live" to
> pull relevant information. Every once in a while it would
> seem to work.
> Most of the time, it would time out. I have set up an export
> in the Vantage
> Export Utility that automatically deposits the information we
> need in a
> comma-delimited text file that Worldship searches by packing
> slip number.
> The person creating the packing slips will run the export
> several times a
> day.
>
> Gary Grenier
> Bell Manufacturing Co.
> ggrenier@...
>
> > From: dposkevich@...
> > Subject: > 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.
>
>
>
>
> --------------------------------------------------------------
> ----------
> Respond.com - Technology Solutions for your Business!
> http://click.egroups.com/1/6828/13/_/411782/_/964201774/
> --------------------------------------------------------------
> ----------
>
> We no longer allow attachments to files. To access/share
> Report Files, please go to the 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.)