This is a multi-part message in MIME format.

------=_NextPart_000_0022_01C62DB5.C58E84E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello,

I'm looking for the simplest solution for sending and receiving data to =
the "same" application, but in separate geographical locations.

A record(s) is created and needs to be sent across the internet to the =
same application running on another machine. What is simplest method =
for sending the record, then appending to a master table at the =
receiving end? =20

Next, an acknowledgement record is created and returned to the original =
sender. It then needs to be appended to the activity table on the =
originating machine.

Suggestions please...

John





------=_NextPart_000_0022_01C62DB5.C58E84E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2802" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>Hello,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I'm looking for the=20
<STRONG><U>simplest</U></STRONG> solution for sending and receiving data =
to the=20
"same" application, but in separate geographical locations.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>A record(s) is created and needs to be =
sent across=20
the internet to the same application running on another machine.&nbsp; =
What is=20
simplest method for sending the record, then appending&nbsp;to a master =
table at=20
the receiving end?&nbsp;&nbsp;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Next, an acknowledgement record is =
created and=20
returned to the original sender.&nbsp; It then needs to be appended =
to&nbsp;the=20
activity table on the originating machine.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Suggestions please...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>John</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_0022_01C62DB5.C58E84E0--

Re: Sending / receivig across the internet (transaction handling) by Edhy

Edhy
Thu Feb 09 21:50:21 CST 2006

This is a multi-part message in MIME format.

------=_NextPart_000_0010_01C62DCB.3507EA40
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi John,

I have done this using an FTP site as the mailbox, where the source pc =
converts the VFP data to XML <CURSORTOXML()> and zip it, then it sends =
the information to the ftp site, then the main server downloads it and =
update the master data file. I use GUID as Primary Keys fields to avoid =
duplications and validate the integrity of the records before adding =
them.

--=20
Edhy Rijo
www.progytech.com
Bronx NY


"John Dandy" <jdandy@micronet.org> wrote in message =
news:0OSdndQJmIc6mHHenZ2dnUVZ_t-dnZ2d@giganews.com...
Hello,

I'm looking for the simplest solution for sending and receiving data =
to the "same" application, but in separate geographical locations.

A record(s) is created and needs to be sent across the internet to the =
same application running on another machine. What is simplest method =
for sending the record, then appending to a master table at the =
receiving end? =20

Next, an acknowledgement record is created and returned to the =
original sender. It then needs to be appended to the activity table on =
the originating machine.

Suggestions please...

John





------=_NextPart_000_0010_01C62DCB.3507EA40
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2802" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi John,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I have done this using an FTP site as =
the mailbox,=20
where the source pc converts the VFP data to XML =
&lt;CURSORTOXML()&gt;&nbsp;and=20
zip it, then it sends the information to the ftp site, then =
the&nbsp;main server=20
downloads it and update the master data file.&nbsp; I use GUID as =
Primary Keys=20
fields to avoid duplications and validate the integrity of the records =
before=20
adding them.</FONT></DIV>
<DIV><BR>-- <BR>Edhy Rijo<BR><A=20
href=3D"http://www.progytech.com">www.progytech.com</A><BR>Bronx =
NY</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"John Dandy" &lt;<A=20
href=3D"mailto:jdandy@micronet.org">jdandy@micronet.org</A>&gt; wrote =
in message=20
<A=20
=
href=3D"news:0OSdndQJmIc6mHHenZ2dnUVZ_t-dnZ2d@giganews.com">news:0OSdndQJ=
mIc6mHHenZ2dnUVZ_t-dnZ2d@giganews.com</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Hello,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I'm looking for the=20
<STRONG><U>simplest</U></STRONG> solution for sending and receiving =
data to=20
the "same" application, but in separate geographical =
locations.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>A record(s) is created and needs to =
be sent=20
across the internet to the same application running on another =
machine.&nbsp;=20
What is simplest method for sending the record, then appending&nbsp;to =
a=20
master table at the receiving end?&nbsp;&nbsp;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Next, an acknowledgement record is =
created and=20
returned to the original sender.&nbsp; It then needs to be appended=20
to&nbsp;the activity table on the originating machine.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Suggestions please...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>John</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial =
size=3D2></FONT>&nbsp;</DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0010_01C62DCB.3507EA40--


Re: Sending / receivig across the internet (transaction handling) by Hans

Hans
Fri Feb 10 04:55:32 CST 2006

This is a multi-part message in MIME format.

------=_NextPart_000_000F_01C62E38.E67BD800
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

1) Maybe you can connect the two applications over a VPN connection.

2) You can send the data (in XML or other format) over HTTP to an =
ASP/PHP web page with script code in it that puts the data in the =
database on the other side and returns the confirmation.
Look at Rick Strahl's 'West Wind Client Tools' (www.west-wind.com) to =
handle the VFP part of it.


Bye, Hans
"John Dandy" <jdandy@micronet.org> schreef in bericht =
news:0OSdndQJmIc6mHHenZ2dnUVZ_t-dnZ2d@giganews.com...
Hello,

I'm looking for the simplest solution for sending and receiving data =
to the "same" application, but in separate geographical locations.

A record(s) is created and needs to be sent across the internet to the =
same application running on another machine. What is simplest method =
for sending the record, then appending to a master table at the =
receiving end? =20

Next, an acknowledgement record is created and returned to the =
original sender. It then needs to be appended to the activity table on =
the originating machine.

Suggestions please...

John





------=_NextPart_000_000F_01C62E38.E67BD800
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.5296.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>1) Maybe you can connect the two =
applications over=20
a VPN connection.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>2) </FONT><FONT face=3DArial =
size=3D2>You can send the=20
data (in XML or other format) over HTTP to an ASP/PHP web page with =
script code=20
in it&nbsp;that puts the data in the database on </FONT><FONT =
face=3DArial=20
size=3D2>the other side and returns the confirmation.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Look at Rick Strahl's 'West Wind Client =
Tools' (<A=20
href=3D"http://www.west-wind.com">www.west-wind.com</A>) to handle the =
VFP part of=20
it.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Bye, </FONT><FONT face=3DArial=20
size=3D2>Hans</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"John Dandy" &lt;<A=20
href=3D"mailto:jdandy@micronet.org">jdandy@micronet.org</A>&gt; =
schreef in=20
bericht <A=20
=
href=3D"news:0OSdndQJmIc6mHHenZ2dnUVZ_t-dnZ2d@giganews.com">news:0OSdndQJ=
mIc6mHHenZ2dnUVZ_t-dnZ2d@giganews.com</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Hello,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I'm looking for the=20
<STRONG><U>simplest</U></STRONG> solution for sending and receiving =
data to=20
the "same" application, but in separate geographical =
locations.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>A record(s) is created and needs to =
be sent=20
across the internet to the same application running on another =
machine.&nbsp;=20
What is simplest method for sending the record, then appending&nbsp;to =
a=20
master table at the receiving end?&nbsp;&nbsp;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Next, an acknowledgement record is =
created and=20
returned to the original sender.&nbsp; It then needs to be appended=20
to&nbsp;the activity table on the originating machine.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Suggestions please...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>John</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial =
size=3D2></FONT>&nbsp;</DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_000F_01C62E38.E67BD800--


Re: Sending / receivig across the internet (transaction handling) by Hans

Hans
Fri Feb 10 05:13:16 CST 2006

This is a multi-part message in MIME format.

------=_NextPart_000_0008_01C62E3B.6001B2B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi again,

I found a little code sample from doing a test a while ago with the West =
Wind Client Tools, sending an XML file over to the server and returning =
it as a tab delimited file:

SET PROCEDURE TO wwUtils ADDIT
SET PROCEDURE TO wwHTTP ADDIT
loHTTP =3D CREATEOBJECT("wwHTTP")

*** Posting XML
loHTTP.nHttpPostMode =3D 1 && 4=3Dxml
lcXML =3D ALLTRIM(FILETOSTR("C:\mydata.xml"))
loHTTP.AddPostKey() && Clear POST buffer
loHTTP.AddPostKey("xml_data",lcXML)
lcXML =3D =
loHTTP.HttpGet("http://www.mydomain.com/posttest/httppost.php5")

IF LEN(lcXML) > 0
USE TEST
ZAP
STRTOFILE(lcXML,"c:\output.txt")
APPEND FROM c:\output.txt TYPE DELIMITED WITH TAB
BROWSE NORMAL NOWAIT
ENDIF



"Hans" <hans.degrootATplanet.nl> schreef in bericht =
news:u7Rl3BjLGHA.668@TK2MSFTNGP11.phx.gbl...
1) Maybe you can connect the two applications over a VPN connection.

2) You can send the data (in XML or other format) over HTTP to an =
ASP/PHP web page with script code in it that puts the data in the =
database on the other side and returns the confirmation.
Look at Rick Strahl's 'West Wind Client Tools' (www.west-wind.com) to =
handle the VFP part of it.


Bye, Hans

------=_NextPart_000_0008_01C62E3B.6001B2B0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.5296.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi again,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I found a little code sample&nbsp;from =
doing a=20
test&nbsp;a while ago with the West Wind Client Tools, sending an XML =
file over=20
to the server and returning it as a tab delimited file:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT><FONT face=3DArial =
size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3D"Courier New" size=3D2>SET PROCEDURE TO wwUtils =
ADDIT<BR>SET=20
PROCEDURE TO wwHTTP ADDIT</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2>loHTTP =3D=20
CREATEOBJECT("wwHTTP")</FONT></DIV>
<DIV><FONT size=3D2><FONT face=3D"Courier =
New"></FONT></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2><FONT face=3D"Courier New">*** Posting=20
XML<BR>loHTTP.nHttpPostMode =3D 1&nbsp; &amp;&amp; 4=3Dxml<BR>lcXML =3D=20
ALLTRIM(FILETOSTR("C:\mydata.xml"))<BR>loHTTP.AddPostKey()&nbsp; =
&amp;&amp;=20
Clear POST buffer<BR>loHTTP.AddPostKey("xml_data",lcXML)<BR>lcXML =3D=20
loHTTP.HttpGet("</FONT><A=20
href=3D"http://www.mydomain.com/posttest/httppost.php5"><FONT=20
face=3D"Courier =
New">http://www.mydomain.com/posttest/httppost.php5</FONT></A><FONT=20
face=3D"Courier New">")<BR><BR>IF LEN(lcXML) &gt; 0</FONT></FONT></DIV>
<DIV><FONT size=3D2><FONT face=3D"Courier New">&nbsp;&nbsp;&nbsp; USE=20
TEST<BR>&nbsp;&nbsp;&nbsp; ZAP<BR>&nbsp;&nbsp;&nbsp;=20
STRTOFILE(lcXML,"c:\output.txt")<BR>&nbsp;&nbsp;&nbsp; APPEND FROM =
c:\output.txt=20
TYPE DELIMITED WITH TAB<BR>&nbsp;&nbsp;&nbsp; BROWSE NORMAL=20
NOWAIT</FONT></FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2>ENDIF</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Hans" &lt;hans.degrootATplanet.nl&gt; schreef in bericht <A=20
=
href=3D"news:u7Rl3BjLGHA.668@TK2MSFTNGP11.phx.gbl">news:u7Rl3BjLGHA.668@T=
K2MSFTNGP11.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>1) Maybe you can connect the two =
applications=20
over a VPN connection.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>2) </FONT><FONT face=3DArial =
size=3D2>You can send=20
the data (in XML or other format) over HTTP to an ASP/PHP web page =
with script=20
code in it&nbsp;that puts the data in the database on </FONT><FONT =
face=3DArial=20
size=3D2>the other side and returns the confirmation.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Look at Rick Strahl's 'West Wind =
Client Tools'=20
(<A href=3D"http://www.west-wind.com">www.west-wind.com</A>) to handle =
the VFP=20
part of it.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Bye, </FONT><FONT face=3DArial=20
size=3D2>Hans</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV><FONT face=3DArial=20
size=3D2></FONT>&nbsp;</DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0008_01C62E3B.6001B2B0--


RE: VFP9: Sending / receivig across the internet (transaction handling) by Leemi

Leemi
Fri Feb 10 09:17:37 CST 2006

Hi John:

Take a look at this white paper on West-Wind.com:
http://www.west-wind.com/presentations/internetenabling/InternetEnabling.htm


I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/

*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003

>Hello,
>I'm looking for the simplest solution for sending and receiving data to
the "same" application, but
>in separate geographical locations.
>A record(s) is created and needs to be sent across the internet to the
same application running
>on another machine. What is simplest method for sending the record, then
appending to a >master table at the receiving end?
>Next, an acknowledgement record is created and returned to the original
sender. It then needs
>to be appended to the activity table on the originating machine.
>Suggestions please...
>John



Re: Sending / receivig across the internet (transaction handling) by swdev2

swdev2
Fri Feb 10 21:56:55 CST 2006

Hiya John -
I think this is a good solution - not saying 'simplest' ...
http://www.gnsinfotech.com/Articles/a_simple_way_to_make_your_vfp_de.htm

You'll need to add in a refresh for your new record back at the server
level - but a 'push record' method is straightforward.

If you don't want to rely on any server whatsoever - suggest you roll yer
own for peer to peer low level 'message' passing (the concept, not the
application). There's some codebase floating around somewhere...
hth - regards [Bill]
--
===================
William Sanders / EFG VFP / mySql / MS-SQL
www.efgroup.net/vfpwebhosting
www.terrafox.net www.viasqlserver.net

"John Dandy" <jdandy@micronet.org> wrote in message
news:0OSdndQJmIc6mHHenZ2dnUVZ_t-dnZ2d@giganews.com...
Hello,

I'm looking for the simplest solution for sending and receiving data to the
"same" application, but in separate geographical locations.

A record(s) is created and needs to be sent across the internet to the same
application running on another machine. What is simplest method for sending
the record, then appending to a master table at the receiving end?

Next, an acknowledgement record is created and returned to the original
sender. It then needs to be appended to the activity table on the
originating machine.

Suggestions please...

John