getting warehouse dbf to remote pc

[johncook]

I am unsure of the best approach.I guess I am asking for approaches.

All computers involved use Win XP Pro, VFP 7.0. All have modems. Some are connected to internet while others are not.

I have a VFP app to maintain products.dbf for all remote facilities. Runs at a warehouse location. Creates a file products.dbf which will be used at remote sites to update their local copy of products.dbf. Each remote site has different data in their copy of products.dbf so the warehouse app creates custom copies of products.dbf for each remote facility.

Remote facilities run a VFP app. This app has a process that will look for the latest products.dbf deposited somewhere on the HDD from the warehouse and if it exists apply the changes in that file, to the local products.dbf

I would like to somehow have my warehouse app use the Hypertrm.exe (I've never used it but I believe it is a program that might be useful here), to dial each facility and copy the products.dbf that has been generated for that facility, to that facilities HDD.

All computers have PCAnywhere in case I am missing the ability to automate use of it to accomplish this task.

Somebody lead me in the right direction please. I do not mind reading whatever you recommend. FYI: I know how to use shellexecute to start notepad so I guess I could figure out how to use it to execute the dialer except I have tried and have no idea about the parameters required, etc.

Thanks,
John

 

[ramani]

HI John

The remote working can be done in two differnt ways.

One is remote access
Another is remote control.

Remote control is controlling one node computer (dedicated for this purpose) at the Server location and configured as if it is a local network computer. The remote PC starts up using the remotes CPU and then takes over the HO computer. So Hos CPU, the remote locations, monitor+keyboard+mouse becomes one computer. The advantage here is, only the keystrokes and the screen images are passed on to the remote location and so the speed is just like a local networked computer. (this is nice if only a handful of units of remote locations are needed). You need to use a remote control software and can be PC anywhere or such software.

Remote access is just accessing the server or a HO computer terminal using the remote computer. All the required data is passed thru the modem, dial-up, T1 whatever and its speed decides the applications speed. So you have to use remote views instead of local views and reduce the traffic. This can be done using windows PPP.

So you have to plan the need at your place and decide on these issues. It is difficult to suggest.



ramani
(Subramanian.G)

http://winnersoft.coolfreepages.com/