>Pls help me to find a reliable solution in the following situation:
>We have several locations spread arround the country and we need to transfer data automatically to the server during night.
>Our application is written in FoxPro 2.6 and, for now, transfer is done by email. How can I use XML or web services or something else to transfer data?
We do it with a Web Service. You can build a Web Service on the server to accept that data from a method such as SendData(). I assume you would probably want to have authentication on that one as you are uploading data on the server. This is easy to do in Web Service. The SendData() method could receive your XML string as tcXML as String.
From the client side, you could CursorToXML() and send that to the method. On the server, once received, you would then do the reverse process to have everything back as a VFP cursor.
As this is FoxPro 2.6, you would probably want to build your XML manually as CursorToXML() is not supported. But, the process can remain the same.