Re: Varsity Shipping Rate Optimizer

Thanks, Matt.

I'm a big fan of wrapping RPG functionality as an external stored procedure.
My issue is product specific at this point since I don't know if Varsity
provides a clean programmatic interface. An ex-employee made a half hearted
attempt to write one some years back but it looks like they just took the
Varsity screen interface program and ripped out screens until it did one
thing poorly and that one thing doesn't translate well to retail customers.

I wanted to give the list a shot because my experiences with their support
haven't been productive and I believe my boss is presently wrastling with
their license renewal fees.

Alfred

On 1/14/08, Haas, Matt (CL Tech Sv) <matt.haas@xxxxxxxxxxx> wrote:

Alfred,

I haven't done this specifically (our rate calculator was written in
house) but when I need to expose this type of functionality to either Java
or systems running off-box, I typically create an external stored procedure
to do it. Depending upon how the parameters are passed in, you may be able
to get by with just defining the SQL procedure but if you pass in data
structures, you'll probably want to write a helper program to make the calls
easier to make.

Matt

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of Alfredo Delgado
Sent: Monday, January 14, 2008 9:40 AM
To: web400@xxxxxxxxxxxx
Subject: [WEB400] Varsity Shipping Rate Optimizer

Good morning,

We're a JDE shop and we utilize a shipping rate optimizer from Varsity
Logistics that suggests the best/cheapest carriers for orders. Order items
can range from small and expensive to large and cheap so whether we use a
freight company vs. ground vs. air is important.

Has anyone on the list had experience interfacing with Varsity when
creating
an e-commerce order process? For established customers it's possible to
have
esoteric shipping data in their record but for a retail customer I'd
really
be looking to just provide an origin zip code, a destination zip code, and
some information about the items being shipped. In either case cleanly
obtaining the output to format for a user would be necessary.

If you know of an add-on product that can meet these requirements I'm open
to those suggestions, too.

Thanks,
Alfred

--
Alfredo Delgado / Web Development
6800 Broken Sound Pkwy; Suite 150
Boca Raton, Florida 33487
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.


--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.