>This is a general question... or more precisely a request for thoughts and ideas on how to handle a request being presented to me by a client. There are tons of details involved, but for this posting I will try to summarize the current environment and request briefly, as I am just curious as to how some of you would handle this.
>
>[Existing environment] We're talking about an existing application running under Visual FoxPro 9.0 SP2, on a Windows network. The data is stored in VFP tables belonging to a DBC, and accessed (usually) via views found in other DBCs. The application was developed using the Visual FoxExpress framework. All users are centrally located, and there is (ahhhh... was) no need for access to the application nor its data from outside the confines of the central location.
>
>The application performs many different functions, but the one germane to this discussion is order entry. Customers call staff members at the location and provide information over the phone that is used by the staff to construct and enter orders via the application.
>
>[New request] One of the larger customers has voiced a desire to have their system--which contains the required order information--linked to my client's system to eliminate the need for the phone call. The thought would be the customer's staff would enter the order into their system, and via the magic of technology my client's system would be updated to reflect the order. It should be noted that the information transmitted contains sensitive data and therefore proper steps must be taken to ensure confidentiality.
>
>Although this customer is very important to my client, the volume of transactions is quite small (perhaps five to ten per day at most), and my client is certainly not looking to build a huge process around this as the company is a relatively small business. In fact, my client has very good arguments why the phone conversations are important to ensure proper ordering, and would actually prefer to continue taking order over the phone. That said, they do want to make their biggest customer happy and therefore want to provide some mechanism for this (again, keeping the complexity and cost DOWN).
>
>
>Web services some to mind, and as my client does have a website, perhaps using a relatively "low tech" secured FTP upload/download solution would make everyone happy. I'm wondering what some of you might be thinking as possibilities. Feel free to ask for additional information, as I have intentionally tried not to bore everyone to death (too late, right?).
>
>TIA

One idea I would suggest to consider is to have one system drop an order file in a form of an XML file into a folder and the other system have a program with a timer that continuously looks for a file. If found the file can be then imported into the VFP system. I have done a couple of projects bases on this approach.

HTH.