[ic] Handling inventory

[Steve Graham]

Hello,

I have a similar setup. I have set up interchange server to use mysql 
database.
My company database software resides on a NT box. I can access my windows 
database with MS Active Server Pages (.asp) and also access the mysql server 
simultaneoulsy with the odbc connector set up on the Windows box (Mysql 
offers this odbc connector). I access my windows database via Windows 
activer server pages, and update the database on the mysql server on the 
fly. I am familiar with accessing databases via .asp and am sure there might 
be other ways to do this, but it works, and this way I can adjust stock 1, 
or 2 times a day.

Of course, all my machines are setting next to each other behind the 
firewall, which makes communication easy.

Good Luck,
Steve


>From: "Dan Browning" <danpb@mail.com>
>Reply-To: interchange-users@interchange.redhat.com
>To: <interchange-users@interchange.redhat.com>
>Subject: RE: [ic] Handling inventory
>Date: Wed, 28 Nov 2001 13:39:41 -0800
>
> > The client is a motorcycle dealership who needs an online
> > store. The trick with these guys is that a lot of the stuff
> > must be ordered but, there are some things that they stock
> > and will stock more based on demand.
> >
> > They use Lightspeed as their management suite. It's
> > client/server running on windows.
> >
> > Is that enough info?
> >
> > George Loch
>
>Assuming you mean:
>	http://www.bhpower.com/support/lspeed.htm
>
>They don't really have a lot of technical information on their website,
>so I assume one of the first steps is to get more information (directly
>from them perhaps) about how their systems allows integration with other
>software / data sources.  For example, if they have a hourly CSV import
>setup, then you would customize IC to fit to that.  If they prefer a
>direct ODBC (being Windows and all) insert, then you can customize IC to
>do that.
>
>Do you already know a lot about the system and how it integrates with
>other software?  If so, then it only becomes a question of how to do you
>make IC do what they want.  If not, then it means you get out the
>disassembler and start hacking.  ;-)
>
>Dan Browning
>Kavod Technologies
>
>PS.  It is preferred that you quote within the context that you are
>referring to, like I am now.
>
>
>
> > ----- Original Message -----
> > > It depends entirely on what you have already.
> > >
> > > It depends on your network architecture, how important it is to be
> > > exact, how time critical, etc....  For most online stores it is
> > > irrelevant, for some that deal in "one ofs" it is critical.
> > >
> > > What are the details?
> > >
> > > --
> > >
> > > Christopher F. Miller, Publisher
> > cfm@maine.com
> > > MaineStreet Communications, Inc           208 Portland
> > Road, Gray, ME
> > 04039
> > > 1.207.657.5078
> > http://www.maine.com/
> > > Content/site management, online commerce, internet
> > integration, Debian
> > linux
> > > _______________________________________________
> > > interchange-users mailing list
> > > interchange-users@interchange.redhat.com
> > > http://interchange.redhat.com/mailman/listinfo/interchange-users
> > >
> >
> >
> > _______________________________________________
> > interchange-users mailing list
> > interchange-users@interchange.redhat.com
> > http://interchange.redhat.com/mailman/listinfo/interchange-users
> >
>
>
>_______________________________________________
>interchange-users mailing list
>interchange-users@interchange.redhat.com
>http://interchange.redhat.com/mailman/listinfo/interchange-users


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp