Since 1938, The Kittery Trading Post (KTP) has served New England, and
the rest of the world, for that matter, providing top quality products
and service for camping, fishing, hunting, and skiing needs. In the
spring of 1983, management determined that, in order to continue to be
successful, and to provide the service and additional products that its
customers deserved, it was time to join the throngs of organizations
that had already found the need to automate their business.



Enter PICK, in the form of, first, General Automation Zebra, followed
by Data General and Advanced Pick on DGUX. COMPAQ and D3/NT took over
in 1998, to be replaced by the current HP systems running D3/NT, in
2003. PICK (RainingData) allowed us to service the tremendous growth
in size that KTP experienced, evolving to the current 90,000+ sq. ft of
retail space. As well, a separate store for Bicycle, Surf, and Paint
ball needs is about 1000 ft. south of KTP; an attached 30,000 sq.ft
warehouse, a 37,000 sq.ft facility about 4 miles north, in York, Me.,
and most recently, a 65,000 sq. ft warehouse 3 mile south, in
Portsmouth, N.H., comprise the other facets of KTP.



Until now, that is. On Wednesday, Oct. 25, 2006, The Kittery Trading
Post proudly debuted its newest sales entity - WWW.KTP.COM. This web
page / shopping cart was designed by a firm in Vermont, using MySQL as
its database. Again, PICK (RainingData) was there to assist KTP in
making this transition to world-wide sales possible.



Through the aid of RD's OPENDB, all of the back-office applications
dealing with, not only the updating of current stock and pricing to the
web, but the extraction of SQL tables from the website, into our D3/NT
database, allow us to build orders, pick inventory, and ship to our
customers. The merger to UPS WorldShip software was a simple
"SQL-CREATE-TABLE..." statement, and we were on our way.



With the OPENDB connection to the MySQL database, a PICK programmer
need not learn any additional programming language, which is a major
factor in being able to see this project come to fulfillment in a
relatively short period of time.



I invite you to check out our website, and view the short video at the
bottom of the screen, which gives a brief picture of who KTP is and
what we stand for. I also ask that you spread the word to your friends
and associates, asking them also to try our site.



It has been my pleasure to be the Director of MIS since the
department's inception, way back in 1983. It has also been a
pleasure to have PICK as THE one and only database to server this
company's Information Technology needs. And now, thanks largely to
PICK Systems / RainingData's products, and the efforts of RD
support-staff members Rick Davies and Robert Burke, and to Zumasys,
providers of hardware and support here at KTP, specifically, Joe Cupp,
who directs the support staff at Zumasys, we have entered into a new
era.





Thanks, and happy shopping at KTP.COM



Jim Cronin

Director MIS

Kittery Trading Post

Kittery, Me. 03904






Jim Cronin, Sr. Director Management Information Systems
KITTERY TRADING POST email: JCronin (AT) ktp (DOT) com
207.439.9222 Ext. 277 Fax 207.439.8001
Website: www.kitterytradingpost.com

Thanks for the post. I think it is great to read success stories. This
is the most important thing and the power of MV.

But:

Why do you need MySQL?. I can have in mind half a docen of products
that can do it with D3 (or any other mv database) without problems.

And i suppose your answer will be, the web product company make it with
MySQL and you do not find any company that make it directly from mv.

That's OUR FAULT. RD helps, the user wants D3, and they install another
software with MySQL. Because we do not know to sell.

Again thanks for the post and congratulations. The critic is not for
you is for "us" devolopers in MV market.




JJCSR ha escrito:

JRA:

Sometimes, we MIS folks are required to take on tasks that we don't
have more control over. Note, I didn't say "complete" control, just
"more". Such is the case with this project. MySql was the database of
choice by the developer - I had no input into the choice of the
developer, nor the database. However, the end result was still a
victory for MV.

Thanks for the reply,

Jim Cronin

jra wrote:

<snip>
It sounds fantastic Jim. Thanks for the success story.
Peter McMurray

Jim,

Agreed with you.


Thanks for you story as well.


Rgds,

JJCSR wrote:
[snip]

Jim,

it's always a pleasure to learn of another genuine MV success story,
especially a long-term user. Thanks for telling us about it.
--
Cheers,
SDM -- a 21st century schizoid man
Systems Theory internet music project links:
official site <www.systemstheory.net>
soundclick <www.soundclick.com/systemstheory>
garageband <www.garageband.com/artist/systemstheory>
"Soundtracks For Imaginary Movies" CD released Dec 2004
"Codetalkers" CD coming Nov 2006
NP: nothing