Jump to content


bsdb3

Member Since 10 Aug 2007
Offline Last Active Apr 01 2008 07:46 AM
-----

Topics I've Started

Integrating MOM with other systems

11 October 2007 - 03:04 AM

Hi I was wondering if anyone can offer me some advice. I'm looking to integrate MOM more tightly with our website and hopefully using some automated batch code so stock levels, order status', product prices etc can be set in MOM and be reflected quickly on the website with minimum human intervention.

At the moment I'm taking a nightly copy of the Momwin directory, and then using OLEDB from EXCEL to convert the dbf files I'm interested in, in to CSV files which I can upload to the website and work on. The only downside to this, is that the website is only updated once daily using the nightly copy of the data.

Obviously I prefer working on the copy of the foxpro database but I need to find a way to safely make a copy of it, whilst it's in use, so I can update the website more frequently. I'm not too hot on Foxpro and searching the web, and sending mail to dynacomp hasn't offered a solution.

I'm guessing that doing a windows filecopy of the MOM directory wouldn't be safe whilst it's open? I'm guessing connecting to the live database using OLEDB isn't safe either? If anyone would have any ideas or advice I'd be all ears, and it would be much apreciated.

best wishes,

David

Choosing a server to run MOM v6 on

10 August 2007 - 04:04 AM

Hi - we're looking to purchase a server to run MOM v6. I was wondering if anyone would be willing to share the specs of the server they're currently using and how well it runs?

I was looking at a server with Dual Intel Xeon 3040 Processor at 1.86GHz with 2 GB ram, but would like to be sure if this will be up to the job. We're only looking at 3 workstations initally but don't want to use peer-to-peer so we can add more workstations in the future,

thanks in advance,

David