Shipping address export

Yahoo Archive
1
Calvin,

You're able to get past the Progress triggers and actually perform a import
into Vantage?

Please tell me more,

H. Dale Puls
Pacesetter Electronics


-----Original Message-----
From: calvin [mailto:calvin@...]
Sent: Saturday, June 10, 2000 7:36 AM
To: vantage@egroups.com
Subject: Re: [Vantage] Shipping address export

..... On the flip side we also export data from Worldship for import into
Vantage. We export the Tracking Number and Total Freight Charges
and then import this into the ShipHead table in Vantage. From a simple
report, our AR person knows exactly how much to charge for the freight
of each shipment.
2
I have finally managed to install both UPS WorldShip with a label printer
and FedExShip on the computer in shipping. It was a bit of a challenge
ultimately solved by the suggestion by one of the members to upgrade from
Win95 to 98. Thank you. Now on to the more difficult part. I would like
to export the addresses we use for shipping (customers and vendors) to a
file that I can import into the respective software packages to save us
hours of hand keying all the information in. I know FedEx can take a
delimited file but I am looking more for the way to export to something of a
similar format. I am sure it is something simple, and I think it has been
covered before, but any information offered would be appreciated.
Thanks in advance.

Aaron Hoyt
System Administrator
Design Standards Corp.
PO Box 1620
Charlestown, NH 03603
Tel 603-826-7744
<mailto:Aaron@...>
3
At 03:51 PM 10/9/2000 , you wrote:
>to export the addresses we use for shipping (customers and vendors) to a
>file that I can import into the respective software packages to save us

Have you tried the Export Utility? It can produce a nice clean dump of any
table, in ascii, Excel, or DBase format. ShipTo and VendorPP are the
tables you're looking for. I like to export in Excel format, then use
Excel for any further sorting / selecting. From there, Excel can save it
in an even wider selection of formats.

-Wayne
4
I believe that Calvin Dekker has already done something that will import
information into UPS WorldShip. You can reach him at calvin@....

Ted Kitch
tedkitch@...

On Mon, 9 Oct 2000 15:51:02 -0400, vantage@egroups.com wrote:

> I have finally managed to install both UPS WorldShip with a label printer
> and FedExShip on the computer in shipping. It was a bit of a challenge
> ultimately solved by the suggestion by one of the members to upgrade from
> Win95 to 98. Thank you. Now on to the more difficult part. I would
like
> to export the addresses we use for shipping (customers and vendors) to a
> file that I can import into the respective software packages to save us
> hours of hand keying all the information in. I know FedEx can take a
> delimited file but I am looking more for the way to export to something
of a
> similar format. I am sure it is something simple, and I think it has
been
> covered before, but any information offered would be appreciated.
> Thanks in advance.
>
> Aaron Hoyt
> System Administrator
> Design Standards Corp.
> PO Box 1620
> Charlestown, NH 03603
> Tel 603-826-7744
> <mailto:Aaron@...>
>
>


Ted Kitch
tedkitch@... Kitch
tedkitch@...





_______________________________________________________
Say Bye to Slow Internet!
http://www.home.com/xinbox/signup.html
5
I just spoke to a UPS tech on Monday (10/9) about installing their
system at our location. Here's what's going down:

* UPS will provide a PC, monitor, label printer, 150 lb. digital scale,
modem and software to us for free (it seems we're a preferred customer -
odd since we ship 10-30 packages per day).

* UPS will install the system as needed to make me/us happy. This
includes setting the PC up on the network and mapping to Vantage.

* The software will read from Vantage' customer file and use either the
customer id field (preferred) or the order number to pull in the needed
info.

* The UPS software will not write back to the database - bad because
advanced error-checking and learning features won't work; good because
Vantage doesn't like keyless data entry.

* UPS is going totally computerized within 3 years so you must have a PC
system going in order to have a pickup account.

The system will be installed on 10/25 at 10 am. When I know more I'll
post to the group.

Rick
MIS
Osco




Ted Kitch wrote:
>
> I believe that Calvin Dekker has already done something that will
> import
> information into UPS WorldShip. You can reach him at
> calvin@....
>
> Ted Kitch
> tedkitch@...
>
> On Mon, 9 Oct 2000 15:51:02 -0400, vantage@egroups.com wrote:
>
> > I have finally managed to install both UPS WorldShip with a label
> printer
> > and FedExShip on the computer in shipping. It was a bit of a
> challenge
> > ultimately solved by the suggestion by one of the members to
> upgrade from
> > Win95 to 98. Thank you. Now on to the more difficult part. I
> would
> like
> > to export the addresses we use for shipping (customers and vendors)
> to a
> > file that I can import into the respective software packages to
> save us
> > hours of hand keying all the information in. I know FedEx can take
> a
> > delimited file but I am looking more for the way to export to
> something
> of a
> > similar format. I am sure it is something simple, and I think it
> has
> been
> > covered before, but any information offered would be appreciated.
> > Thanks in advance.
> >
> > Aaron Hoyt
> > System Administrator
> > Design Standards Corp.
> > PO Box 1620
> > Charlestown, NH 03603
> > Tel 603-826-7744
> > <mailto:Aaron@...>
> >
> >
>
> Ted Kitch
> tedkitch@... Kitch
> tedkitch@...
>
> _______________________________________________________
> Say Bye to Slow Internet!
> http://www.home.com/xinbox/signup.html
>
> eGroups Sponsor
>
>
> 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.)
6
Rick -

If you already have internet access, you don't need the modem and phone
line. UPS's WorldShip software can use your internet connection to link
to UPS as well. This was beneficial to us - there was no need to run a
separate phone line to the Shipping Dept.

UPS's attempts to extract Vantage data was, in summary, a joke. If you
experience the same with your installation person, I would advise
reviewing the Export Utility in Vantage to dump the Customer, ShipTo,
and Contact information as well as the Vendor tables. Once you have
text files, let UPS work with these instead of Vantage directly.

During our importing of the data we also learned that UPS's software needs
each contact at a company to be a separate address record. This
expanded our couple of hundred customers into over 2000 address to be
imported. The vendors increased the number of records as well.

In retrospect, we are thinking of dropping the individual contact names and
just exporting the base Ship To records for both vendor and customer and
have the shipping manager type in the contact name at time of shipment.
This would make the number of entries more manageable within the UPS
software.

On the flip side we also export data from Worldship for import into
Vantage. We export the Tracking Number and Total Freight Charges
and then import this into the ShipHead table in Vantage. From a simple
report, our AR person knows exactly how much to charge for the freight
of each shipment.

If you have any questions, just ask.

Good luck,
Calvin
7
Aaron,

I set up an export from Vantage that our shipping department runs several
times a day. It deposits the most current packing slip information in a CSV
file on the Worldship PC. The person running the Worldship software runs an
import from that file. You could create one of these files with all of your
information. You would then need to create a data map for the import. It
hasn't been perfect, but it HAS saved a tremendous amount of keying.
Currently, it drops the first record, and all of the export (packages
leaving the country) records. Fortunately, that doesn't amount to many
records compared to how many import correctly. I have a call in for our UPS
rep to come in and look at it.

Gary Grenier
Bell Manufacturing Co.
ggrenier@...

> From: "Aaron Hoyt" <aaron@...>
>
> ...UPS WorldShip ...I would like
> to export the addresses we use for shipping (customers and vendors) to a
> file that I can import into the respective software packages to save us
> hours of hand keying all the information in.
>
> Aaron Hoyt