That is very interesting. So both Vantage and Worldship read and write to
the Access DB. How about using a User Defined Table to do this instead of
Access.
Scott Litzau, MCP
Olympus Flag & Banner
Information Systems Manager
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
David Gartner
Sent: Friday, February 09, 2007 4:34 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Worldship Integration
UPS was very helpful in setting up the similar scenario. We have an Access
ODBC query based on the Ship head table. The best thing is when a shipment
goes from Ground to Next Day AM during the day, we missed a couple in the
past. But now its updated as soon as Sales makes the change on the SO. A
very high ROI.
Currently, we paste in the tracking number manually. I should look into a
barcode scanner.
David
_____
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jim Frice
Sent: Friday, February 09, 2007 3:41 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Worldship Integration
Talk to your UPS account manager and tell them that you need someone to use
crossware to import information from your database. We use the packing slip
number from the ship head table to pass the information through. They can
use that to get to the ship detail so you have the order information. We
worked with a Robert Dzierwa but they have others a UPS that do this as
well. It actually works pretty slick and it didn't cost us a dime. You will
have to provide them with some information but they can install and get you
up and running all remotely.
Jim
_____
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Scott Litzau
Sent: Friday, February 09, 2007 2:55 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Worldship Integration
Last year there was a series of posts dealing with integrating
Worldship and Vantage. I just completed a meeting with UPS and it
sounds like pulling data from Vantage to Worldship is not an issue by
using the Keyed Import feature of Worldship. Problem is, is that the
Keyed Import keys on one field to pull data from Vantage to Worldship.
Release from Vantage to Worldship. And then the challenge is that the
Order Release doesn't hold the Ship To Address just a Ship To Number
so I need to link back to Customer \ Ship to to pull that information
in.
In my inital look at it, it does not look all that straight forward
as far as mapping Vantage fields to Worldship fields. Creating the
map through Worldship Connection Wizard is easy enough, I am seeing
the Vantage Tables and Fields.
Jim Smith of Lovejoy Chaplet Corp. last year you started a post about
this. Was wondering how you are doing and how you made it work.
Is anyone else doing this and what was your solution.
I am on 8.00.809g with Progress. Planning on patching up to 8.00.810c
this weekend. Does 8.03 with Pack Out and Manifest Information at the
Order Level work better?
Thanks,
Scott Litzau
Olympus Flag & Banner
IS Manager
Recent Activity
*
5
New
<http://groups.yahoo.com/group/vantage/members;_ylc=X3oDMTJkdmp1bnFlBF9TAzk3
MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MwRzZWMDdnRsBHNsawN2bWJycwRz
dGltZQMxMTcxMDU2Njkz> Members
*
3
New
<http://groups.yahoo.com/group/vantage/files;_ylc=X3oDMTJlcWU5ZDQ1BF9TAzk3Mz
U5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MwRzZWMDdnRsBHNsawN2ZmlsZXMEc3
RpbWUDMTE3MTA1NjY5Mw--> Files
Visit
<http://groups.yahoo.com/group/vantage;_ylc=X3oDMTJjdGJtcDM1BF9TAzk3MzU5NzE0
BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MwRzZWMDdnRsBHNsawN2Z2hwBHN0aW1lAzEx
NzEwNTY2OTM-> Your Group
Give Back
Yahoo!
<http://us.lrd.yahoo.com/_ylc=X3oDMTJrYnZkaWd1BF9TAzk3MzU5NzE0BF9wAzEEZ3JwSW
QDMjAzNjkEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwNuY21vZARzbGsDYnJhbmQEc3RpbWUDMTE3MT
A1NjY5Mw--;_ylg=1/SIG=11314uv3k/**http%3A//brand.yahoo.com/forgood> for Good
Get inspired
by a good cause.
Y! Toolbar
Get
<http://us.lrd.yahoo.com/_ylc=X3oDMTJtNW1oZDBzBF9TAzk3MzU5NzE0BF9wAzIEZ3JwSW
QDMjAzNjkEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwNuY21vZARzbGsDdG9vbGJhcgRzdGltZQMxMT
cxMDU2Njkz;_ylg=1/SIG=11c6dvmk9/**http%3A//toolbar.yahoo.com/%3F.cpdl=ygrps>
it Free!
easy 1-click access
to your groups.
Yahoo! Groups
Start
<http://groups.yahoo.com/start;_ylc=X3oDMTJtM3E0Y2JpBF9TAzk3MzU5NzE0BF9wAzME
Z3JwSWQDMjAzNjkEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwNuY21vZARzbGsDZ3JvdXBzMgRzdGlt
ZQMxMTcxMDU2Njkz> a group
in 3 easy steps.
Connect with others.
.
<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msgId=5
4716/stime=1171056693/nc1=1/nc2=2/nc3=3>
[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
the Access DB. How about using a User Defined Table to do this instead of
Access.
Scott Litzau, MCP
Olympus Flag & Banner
Information Systems Manager
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
David Gartner
Sent: Friday, February 09, 2007 4:34 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Worldship Integration
UPS was very helpful in setting up the similar scenario. We have an Access
ODBC query based on the Ship head table. The best thing is when a shipment
goes from Ground to Next Day AM during the day, we missed a couple in the
past. But now its updated as soon as Sales makes the change on the SO. A
very high ROI.
Currently, we paste in the tracking number manually. I should look into a
barcode scanner.
David
_____
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jim Frice
Sent: Friday, February 09, 2007 3:41 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Worldship Integration
Talk to your UPS account manager and tell them that you need someone to use
crossware to import information from your database. We use the packing slip
number from the ship head table to pass the information through. They can
use that to get to the ship detail so you have the order information. We
worked with a Robert Dzierwa but they have others a UPS that do this as
well. It actually works pretty slick and it didn't cost us a dime. You will
have to provide them with some information but they can install and get you
up and running all remotely.
Jim
_____
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Scott Litzau
Sent: Friday, February 09, 2007 2:55 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Worldship Integration
Last year there was a series of posts dealing with integrating
Worldship and Vantage. I just completed a meeting with UPS and it
sounds like pulling data from Vantage to Worldship is not an issue by
using the Keyed Import feature of Worldship. Problem is, is that the
Keyed Import keys on one field to pull data from Vantage to Worldship.
>From what I can see I really need to pull Order Number \ Order Line \Order Release in order to get the proper Shipping infomation for a
Release from Vantage to Worldship. And then the challenge is that the
Order Release doesn't hold the Ship To Address just a Ship To Number
so I need to link back to Customer \ Ship to to pull that information
in.
In my inital look at it, it does not look all that straight forward
as far as mapping Vantage fields to Worldship fields. Creating the
map through Worldship Connection Wizard is easy enough, I am seeing
the Vantage Tables and Fields.
Jim Smith of Lovejoy Chaplet Corp. last year you started a post about
this. Was wondering how you are doing and how you made it work.
Is anyone else doing this and what was your solution.
I am on 8.00.809g with Progress. Planning on patching up to 8.00.810c
this weekend. Does 8.03 with Pack Out and Manifest Information at the
Order Level work better?
Thanks,
Scott Litzau
Olympus Flag & Banner
IS Manager
Recent Activity
*
5
New
<http://groups.yahoo.com/group/vantage/members;_ylc=X3oDMTJkdmp1bnFlBF9TAzk3
MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MwRzZWMDdnRsBHNsawN2bWJycwRz
dGltZQMxMTcxMDU2Njkz> Members
*
3
New
<http://groups.yahoo.com/group/vantage/files;_ylc=X3oDMTJlcWU5ZDQ1BF9TAzk3Mz
U5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MwRzZWMDdnRsBHNsawN2ZmlsZXMEc3
RpbWUDMTE3MTA1NjY5Mw--> Files
Visit
<http://groups.yahoo.com/group/vantage;_ylc=X3oDMTJjdGJtcDM1BF9TAzk3MzU5NzE0
BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MwRzZWMDdnRsBHNsawN2Z2hwBHN0aW1lAzEx
NzEwNTY2OTM-> Your Group
Give Back
Yahoo!
<http://us.lrd.yahoo.com/_ylc=X3oDMTJrYnZkaWd1BF9TAzk3MzU5NzE0BF9wAzEEZ3JwSW
QDMjAzNjkEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwNuY21vZARzbGsDYnJhbmQEc3RpbWUDMTE3MT
A1NjY5Mw--;_ylg=1/SIG=11314uv3k/**http%3A//brand.yahoo.com/forgood> for Good
Get inspired
by a good cause.
Y! Toolbar
Get
<http://us.lrd.yahoo.com/_ylc=X3oDMTJtNW1oZDBzBF9TAzk3MzU5NzE0BF9wAzIEZ3JwSW
QDMjAzNjkEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwNuY21vZARzbGsDdG9vbGJhcgRzdGltZQMxMT
cxMDU2Njkz;_ylg=1/SIG=11c6dvmk9/**http%3A//toolbar.yahoo.com/%3F.cpdl=ygrps>
it Free!
easy 1-click access
to your groups.
Yahoo! Groups
Start
<http://groups.yahoo.com/start;_ylc=X3oDMTJtM3E0Y2JpBF9TAzk3MzU5NzE0BF9wAzME
Z3JwSWQDMjAzNjkEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwNuY21vZARzbGsDZ3JvdXBzMgRzdGlt
ZQMxMTcxMDU2Njkz> a group
in 3 easy steps.
Connect with others.
.
<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msgId=5
4716/stime=1171056693/nc1=1/nc2=2/nc3=3>
[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