re SMS with 4D
|
View:
New views
11 Messages
—
Rating Filter:
Alert me
|
 |
re SMS with 4D
by Gareth Home Openworld
::
Rate this Message:
Hello Everyone,
I have written a reception database for a health clinic and I want to incorporate SMS (text) reminders to patients from the database. I'm sure this is possible, and I know other databases that do this...can anyone tell me where I can get info on it...where to get started ? Many Thanks, Gareth ********************************************************************** 4D Basics hosted by 4D, Inc. http://www.4D.com/ An all-new List box. More features, more power. Headers, footers, cell formatting and other goodies. See it here first! <http://www.4d.com/livedemos> To Unsubscribe: mailto:4DBasics-off@... ********************************************************************** |
|
|
Re: re SMS with 4D
by john convey
::
Rate this Message:
There was a guy from Malaysia did a session on this at one of the summits - however, this involved plugging a mobile phone into the server... It worked ok but there are obvious and not so obvious issues with this. let me know what you find out as i am interested in this as well i have auto e-mails - you would think there could be similar calls to an sms gateway? then there is the issue of cost per sms John sci-do communications On 28 Apr 2008, at 11:05, Gareth Home Openworld wrote: > Hello Everyone, > I have written a reception database for a health clinic and I want > to incorporate SMS (text) reminders to patients from the database. > I'm sure this is possible, and I know other databases that do > this...can anyone tell me where I can get info on it...where to get > started ? > Many Thanks, > Gareth > > > ********************************************************************** > 4D Basics hosted by 4D, Inc. http://www.4D.com/ > > An all-new List box. More features, more power. > Headers, footers, cell formatting and other goodies. > See it here first! <http://www.4d.com/livedemos> > > To Unsubscribe: mailto:4DBasics-off@... > ********************************************************************** > > ********************************************************************** 4D Basics hosted by 4D, Inc. http://www.4D.com/ An all-new List box. More features, more power. Headers, footers, cell formatting and other goodies. See it here first! <http://www.4d.com/livedemos> To Unsubscribe: mailto:4DBasics-off@... ********************************************************************** |
|
|
Re: re SMS with 4D
by Pete Seabolt
::
Rate this Message:
Why don't you just send them an email to their mobile phone number. It
will arrive as a simple text message. At least it does on AT&T and nextel/sprint. Just put the 4d plugin in the folder and a few lines of code. The following code uses the quick send found in 4D Internetcommands.bundle plugins folder. $Host:=[Info]IP HOST $GACoor:=[Info]CoordSeraEmail $David:=[Info]OffSERAEmail $vAuthUserName:=[Info]AuthUserName $vAuthPassword:=[Info]AuthPassWord $vAuthMode:=[Info]AuthMode `$vAuthUserName:="pseabolt" `$vAuthPassword:="xxxxxxxx" `$vAuthMode:=1 `$GACoor:="ga-coordination@..." `$David:="w4wdw@..." `$David:="aseabolt@..." $Owner:=[Form05]eMail `$Owner:="pseabolt@..." $FromAddress:=[Info]email $Info:=[Info]Name+", "+[Info]Call+Char(13)+"Southeastern Repeater Association, Inc."+Char(13)+[Info]Title+Char(13)+[Info]street+Char(13)+ [Info]CityStZip+Char(13)+[Info]Phone+Char(13)+[Info]Phone 2+Char(13)+Char(13) $Subject:="Coordination "+[Form05]QKey+" "+[Form05]City+" "+ [Form05]State+" "+String([Form05]Output;"###0.0000") $N1:=[Form05]Email Notes+Char(13) $L1:="NOTICE OF COORDINATION (FORM 05) Please find attachment"+Char(13)+Char(13) $L2:="The attachment is an official notice of coordination."+Char(13)+Char(13) $Message:=$N1+$L1+$L2+$Info C_INTEGER($vError) C_LONGINT($vSmtp_id) C_STRING(15;$vAuthUserName;$vAuthPassword) $vError:=SMTP_New ($vSmtp_id) $vError:=SMTP_Host ($vSmtp_id;$Host) $vError:=SMTP_From ($vSmtp_id;$FromAddress) $vError:=SMTP_Subject ($vSmtp_id;$Subject) $vError:=SMTP_To ($vSmtp_id;$David+","+$Owner+","+$GACoor) $vError:=SMTP_Body ($vSmtp_id;$Message)) $vError:=SMTP_Attachment ($vSmtp_id;"";6) If ($vError#0) ALERT("Error: SMTP_QuickSend"+Char(13)+IT_ErrorText ($vError)) End if $vError:=SMTP_Auth ($vSmtp_id;$vAuthUserName;$vAuthPassword;$vAuthMode) $vError:=SMTP_Send ($vSmtp_id) If ($vError#0) ALERT("Error: SMTP_QuickSend"+Char(13)+IT_ErrorText ($vError)) End if $vError:=SMTP_Clear ($vSmtp_id) BEEP End if J. Allen (Pete) Seabolt LCS Technology 51 Mountain View Drive Dahlonega, GA 30533 Home 706-864-6613 Work 706-864-2169 x1 On Apr 30, 2008, at 6:17 AM, john convey wrote: > > > There was a guy from Malaysia did a session on this > at one of the summits - however, this involved plugging a mobile > phone into the server... > It worked ok but there are obvious and not so obvious issues with > this. > > let me know what you find out as i am interested in this as well > i have auto e-mails - you would think there could be similar calls > to an sms gateway? > > then there is the issue of cost per sms > > > John > sci-do communications > > > > > > > > > On 28 Apr 2008, at 11:05, Gareth Home Openworld wrote: >> Hello Everyone, >> I have written a reception database for a health clinic and I want >> to incorporate SMS (text) reminders to patients from the database. >> I'm sure this is possible, and I know other databases that do >> this...can anyone tell me where I can get info on it...where to get >> started ? >> Many Thanks, >> Gareth >> >> >> ********************************************************************** >> 4D Basics hosted by 4D, Inc. http://www.4D.com/ >> >> An all-new List box. More features, more power. >> Headers, footers, cell formatting and other goodies. >> See it here first! <http://www.4d.com/livedemos> >> >> To Unsubscribe: mailto:4DBasics-off@info. >> 4D.com >> ********************************************************************** >> >> > > > ********************************************************************** > 4D Basics hosted by 4D, Inc. http://www.4D.com/ > > An all-new List box. More features, more power. > Headers, footers, cell formatting and other goodies. > See it here first! <http://www.4d.com/livedemos> > > To Unsubscribe: mailto:4DBasics-off@... > ********************************************************************** > > ********************************************************************** 4D Basics hosted by 4D, Inc. http://www.4D.com/ An all-new List box. More features, more power. Headers, footers, cell formatting and other goodies. See it here first! <http://www.4d.com/livedemos> To Unsubscribe: mailto:4DBasics-off@... ********************************************************************** |
|
|
Re: re SMS with 4D
by Gareth Home Openworld
::
Rate this Message:
There seems to be a missing IF.
Also, apologies if I'm being stupid but how would you call this procedure/Method ? Thanks, Gareth On 28 Apr 2008, at 12:29, Pete Seabolt wrote: > Why don't you just send them an email to their mobile phone number. > It will arrive as a simple text message. At least it does on AT&T > and nextel/sprint. Just put the 4d plugin in the folder and a few > lines of code. The following code uses the quick send found in 4D > Internetcommands.bundle plugins folder. > > > $Host:=[Info]IP HOST > $GACoor:=[Info]CoordSeraEmail > $David:=[Info]OffSERAEmail > $vAuthUserName:=[Info]AuthUserName > $vAuthPassword:=[Info]AuthPassWord > $vAuthMode:=[Info]AuthMode > `$vAuthUserName:="pseabolt" > `$vAuthPassword:="xxxxxxxx" > `$vAuthMode:=1 > `$GACoor:="ga-coordination@..." > `$David:="w4wdw@..." > `$David:="aseabolt@..." > $Owner:=[Form05]eMail > `$Owner:="pseabolt@..." > $FromAddress:=[Info]email > $Info:=[Info]Name+", "+[Info]Call+Char(13)+"Southeastern Repeater > Association, Inc."+Char(13)+[Info]Title+Char(13)+[Info]street > +Char(13)+[Info]CityStZip+Char(13)+[Info]Phone+Char(13)+[Info]Phone > 2+Char(13)+Char(13) > $Subject:="Coordination "+[Form05]QKey+" "+[Form05]City+" "+ > [Form05]State+" "+String([Form05]Output;"###0.0000") > $N1:=[Form05]Email Notes+Char(13) > $L1:="NOTICE OF COORDINATION (FORM 05) Please find > attachment"+Char(13)+Char(13) > $L2:="The attachment is an official notice of > coordination."+Char(13)+Char(13) > $Message:=$N1+$L1+$L2+$Info > C_INTEGER($vError) > C_LONGINT($vSmtp_id) > C_STRING(15;$vAuthUserName;$vAuthPassword) > $vError:=SMTP_New ($vSmtp_id) > $vError:=SMTP_Host ($vSmtp_id;$Host) > $vError:=SMTP_From ($vSmtp_id;$FromAddress) > $vError:=SMTP_Subject ($vSmtp_id;$Subject) > $vError:=SMTP_To ($vSmtp_id;$David+","+$Owner+","+$GACoor) > $vError:=SMTP_Body ($vSmtp_id;$Message)) > $vError:=SMTP_Attachment ($vSmtp_id;"";6) > If ($vError#0) > ALERT("Error: SMTP_QuickSend"+Char(13)+IT_ErrorText ($vError)) > End if > > $vError:=SMTP_Auth ($vSmtp_id;$vAuthUserName;$vAuthPassword; > $vAuthMode) > $vError:=SMTP_Send ($vSmtp_id) > If ($vError#0) > ALERT("Error: SMTP_QuickSend"+Char(13)+IT_ErrorText ($vError)) > End if > $vError:=SMTP_Clear ($vSmtp_id) > BEEP > End if > > > J. Allen (Pete) Seabolt > LCS Technology > 51 Mountain View Drive > Dahlonega, GA 30533 > Home 706-864-6613 > Work 706-864-2169 x1 > > On Apr 30, 2008, at 6:17 AM, john convey wrote: > >> >> >> There was a guy from Malaysia did a session on this >> at one of the summits - however, this involved plugging a mobile >> phone into the server... >> It worked ok but there are obvious and not so obvious issues with >> this. >> >> let me know what you find out as i am interested in this as well >> i have auto e-mails - you would think there could be similar calls >> to an sms gateway? >> >> then there is the issue of cost per sms >> >> >> John >> sci-do communications >> >> >> >> >> >> >> >> >> On 28 Apr 2008, at 11:05, Gareth Home Openworld wrote: >>> Hello Everyone, >>> I have written a reception database for a health clinic and I want >>> to incorporate SMS (text) reminders to patients from the database. >>> I'm sure this is possible, and I know other databases that do >>> this...can anyone tell me where I can get info on it...where to >>> get started ? >>> Many Thanks, >>> Gareth >>> >>> >>> ********************************************************************** >>> 4D Basics hosted by 4D, Inc. http://www. >>> 4D.com/ >>> >>> An all-new List box. More features, more power. >>> Headers, footers, cell formatting and other goodies. >>> See it here first! <http://www.4d.com/livedemos> >>> >>> To Unsubscribe: mailto:4DBasics-off@... >>> ********************************************************************** >>> >>> >> >> >> ********************************************************************** >> 4D Basics hosted by 4D, Inc. http://www.4D.com/ >> >> An all-new List box. More features, more power. >> Headers, footers, cell formatting and other goodies. >> See it here first! <http://www.4d.com/livedemos> >> >> To Unsubscribe: mailto:4DBasics-off@info. >> 4D.com >> ********************************************************************** >> >> > > > ********************************************************************** > 4D Basics hosted by 4D, Inc. http://www.4D.com/ > > An all-new List box. More features, more power. > Headers, footers, cell formatting and other goodies. > See it here first! <http://www.4d.com/livedemos> > > To Unsubscribe: mailto:4DBasics-off@... > ********************************************************************** > > ********************************************************************** 4D Basics hosted by 4D, Inc. http://www.4D.com/ An all-new List box. More features, more power. Headers, footers, cell formatting and other goodies. See it here first! <http://www.4d.com/livedemos> To Unsubscribe: mailto:4DBasics-off@... ********************************************************************** |
|
|
Re: re SMS with 4D
by Pete Seabolt
::
Rate this Message:
All the If statement did was help select the records to email.
The procedure is called by the following statements and for example you get an error code stored in $vError is the $Host does not exist. For example: smtp.windstream.nat would return an error because it should be smtp.windstream.net $vError:=SMTP_New ($vSmtp_id) $vError:=SMTP_Host ($vSmtp_id;$Host) $vError:=SMTP_From ($vSmtp_id;$FromAddress) $vError:=SMTP_Subject ($vSmtp_id;$Subject) $vError:=SMTP_To ($vSmtp_id;$David+","+$Owner+","+$GACoor) $vError:=SMTP_Body ($vSmtp_id;$Message)) $vError:=SMTP_Attachment ($vSmtp_id;"";6) If ($vError#0) ALERT("Error: SMTP_QuickSend"+Char(13)+IT_ErrorText ($vError)) End if $vError:=SMTP_Auth ($vSmtp_id;$vAuthUserName;$vAuthPassword;$vAuthMode) $vError:=SMTP_Send ($vSmtp_id) J. Allen (Pete) Seabolt LCS Technology 51 Mountain View Drive Dahlonega, GA 30533 Home 706-864-6613 Work 706-864-2169 x1 On Apr 28, 2008, at 8:03 AM, Gareth Home Openworld wrote: > There seems to be a missing IF. > Also, apologies if I'm being stupid but how would you call this > procedure/Method ? > Thanks, > Gareth > > On 28 Apr 2008, at 12:29, Pete Seabolt wrote: > >> Why don't you just send them an email to their mobile phone number. >> It will arrive as a simple text message. At least it does on AT&T >> and nextel/sprint. Just put the 4d plugin in the folder and a few >> lines of code. The following code uses the quick send found in 4D >> Internetcommands.bundle plugins folder. >> >> >> $Host:=[Info]IP HOST >> $GACoor:=[Info]CoordSeraEmail >> $David:=[Info]OffSERAEmail >> $vAuthUserName:=[Info]AuthUserName >> $vAuthPassword:=[Info]AuthPassWord >> $vAuthMode:=[Info]AuthMode >> `$vAuthUserName:="pseabolt" >> `$vAuthPassword:="xxxxxxxx" >> `$vAuthMode:=1 >> `$GACoor:="ga-coordination@..." >> `$David:="w4wdw@..." >> `$David:="aseabolt@..." >> $Owner:=[Form05]eMail >> `$Owner:="pseabolt@..." >> $FromAddress:=[Info]email >> $Info:=[Info]Name+", "+[Info]Call+Char(13)+"Southeastern Repeater >> Association, Inc."+Char(13)+[Info]Title+Char(13)+[Info]street >> +Char(13)+[Info]CityStZip+Char(13)+[Info]Phone+Char(13)+[Info]Phone >> 2+Char(13)+Char(13) >> $Subject:="Coordination "+[Form05]QKey+" "+[Form05]City+" "+ >> [Form05]State+" "+String([Form05]Output;"###0.0000") >> $N1:=[Form05]Email Notes+Char(13) >> $L1:="NOTICE OF COORDINATION (FORM 05) Please find >> attachment"+Char(13)+Char(13) >> $L2:="The attachment is an official notice of >> coordination."+Char(13)+Char(13) >> $Message:=$N1+$L1+$L2+$Info >> C_INTEGER($vError) >> C_LONGINT($vSmtp_id) >> C_STRING(15;$vAuthUserName;$vAuthPassword) >> $vError:=SMTP_New ($vSmtp_id) >> $vError:=SMTP_Host ($vSmtp_id;$Host) >> $vError:=SMTP_From ($vSmtp_id;$FromAddress) >> $vError:=SMTP_Subject ($vSmtp_id;$Subject) >> $vError:=SMTP_To ($vSmtp_id;$David+","+$Owner+","+$GACoor) >> $vError:=SMTP_Body ($vSmtp_id;$Message)) >> $vError:=SMTP_Attachment ($vSmtp_id;"";6) >> If ($vError#0) >> ALERT("Error: SMTP_QuickSend"+Char(13)+IT_ErrorText ($vError)) >> End if >> >> $vError:=SMTP_Auth ($vSmtp_id;$vAuthUserName;$vAuthPassword; >> $vAuthMode) >> $vError:=SMTP_Send ($vSmtp_id) >> If ($vError#0) >> ALERT("Error: SMTP_QuickSend"+Char(13)+IT_ErrorText ($vError)) >> End if >> $vError:=SMTP_Clear ($vSmtp_id) >> BEEP >> End if >> >> >> J. Allen (Pete) Seabolt >> LCS Technology >> 51 Mountain View Drive >> Dahlonega, GA 30533 >> Home 706-864-6613 >> Work 706-864-2169 x1 >> >> On Apr 30, 2008, at 6:17 AM, john convey wrote: >> >>> >>> >>> There was a guy from Malaysia did a session on this >>> at one of the summits - however, this involved plugging a mobile >>> phone into the server... >>> It worked ok but there are obvious and not so obvious issues with >>> this. >>> >>> let me know what you find out as i am interested in this as well >>> i have auto e-mails - you would think there could be similar calls >>> to an sms gateway? >>> >>> then there is the issue of cost per sms >>> >>> >>> John >>> sci-do communications >>> >>> >>> >>> >>> >>> >>> >>> >>> On 28 Apr 2008, at 11:05, Gareth Home Openworld wrote: >>>> Hello Everyone, >>>> I have written a reception database for a health clinic and I >>>> want to incorporate SMS (text) reminders to patients from the >>>> database. >>>> I'm sure this is possible, and I know other databases that do >>>> this...can anyone tell me where I can get info on it...where to >>>> get started ? >>>> Many Thanks, >>>> Gareth >>>> >>>> >>>> ********************************************************************** >>>> 4D Basics hosted by 4D, Inc. http://www.4D.com/ >>>> >>>> An all-new List box. More features, more power. >>>> Headers, footers, cell formatting and other goodies. >>>> See it here first! <http://www.4d.com/livedemos> >>>> >>>> To Unsubscribe: mailto:4DBasics-off@... >>>> ********************************************************************** >>>> >>>> >>> >>> >>> ********************************************************************** >>> 4D Basics hosted by 4D, Inc. http://www. >>> 4D.com/ >>> >>> An all-new List box. More features, more power. >>> Headers, footers, cell formatting and other goodies. >>> See it here first! <http://www.4d.com/livedemos> >>> >>> To Unsubscribe: mailto:4DBasics-off@... >>> ********************************************************************** >>> >>> >> >> >> ********************************************************************** >> 4D Basics hosted by 4D, Inc. http://www.4D.com/ >> >> An all-new List box. More features, more power. >> Headers, footers, cell formatting and other goodies. >> See it here first! <http://www.4d.com/livedemos> >> >> To Unsubscribe: mailto:4DBasics-off@info. >> 4D.com >> ********************************************************************** >> >> > > > ********************************************************************** > 4D Basics hosted by 4D, Inc. http://www.4D.com/ > > An all-new List box. More features, more power. > Headers, footers, cell formatting and other goodies. > See it here first! <http://www.4d.com/livedemos> > > To Unsubscribe: mailto:4DBasics-off@... > ********************************************************************** > > ********************************************************************** 4D Basics hosted by 4D, Inc. http://www.4D.com/ An all-new List box. More features, more power. Headers, footers, cell formatting and other goodies. See it here first! <http://www.4d.com/livedemos> To Unsubscribe: mailto:4DBasics-off@... ********************************************************************** |
|
|
Re: re SMS with 4D
by Pete Seabolt
::
Rate this Message:
I should have looked before sending the last email. The IF state
follows confirm CONFIRM("Send Coordination email for "+[Form05]Trustee Call) If (OK=1) J. Allen (Pete) Seabolt LCS Technology 51 Mountain View Drive Dahlonega, GA 30533 Home 706-864-6613 Work 706-864-2169 x1 On Apr 28, 2008, at 8:03 AM, Gareth Home Openworld wrote: > There seems to be a missing IF. > Also, apologies if I'm being stupid but how would you call this > procedure/Method ? > Thanks, > Gareth > > On 28 Apr 2008, at 12:29, Pete Seabolt wrote: > >> Why don't you just send them an email to their mobile phone number. >> It will arrive as a simple text message. At least it does on AT&T >> and nextel/sprint. Just put the 4d plugin in the folder and a few >> lines of code. The following code uses the quick send found in 4D >> Internetcommands.bundle plugins folder. >> >> >> $Host:=[Info]IP HOST >> $GACoor:=[Info]CoordSeraEmail >> $David:=[Info]OffSERAEmail >> $vAuthUserName:=[Info]AuthUserName >> $vAuthPassword:=[Info]AuthPassWord >> $vAuthMode:=[Info]AuthMode >> `$vAuthUserName:="pseabolt" >> `$vAuthPassword:="xxxxxxxx" >> `$vAuthMode:=1 >> `$GACoor:="ga-coordination@..." >> `$David:="w4wdw@..." >> `$David:="aseabolt@..." >> $Owner:=[Form05]eMail >> `$Owner:="pseabolt@..." >> $FromAddress:=[Info]email >> $Info:=[Info]Name+", "+[Info]Call+Char(13)+"Southeastern Repeater >> Association, Inc."+Char(13)+[Info]Title+Char(13)+[Info]street >> +Char(13)+[Info]CityStZip+Char(13)+[Info]Phone+Char(13)+[Info]Phone >> 2+Char(13)+Char(13) >> $Subject:="Coordination "+[Form05]QKey+" "+[Form05]City+" "+ >> [Form05]State+" "+String([Form05]Output;"###0.0000") >> $N1:=[Form05]Email Notes+Char(13) >> $L1:="NOTICE OF COORDINATION (FORM 05) Please find >> attachment"+Char(13)+Char(13) >> $L2:="The attachment is an official notice of >> coordination."+Char(13)+Char(13) >> $Message:=$N1+$L1+$L2+$Info >> C_INTEGER($vError) >> C_LONGINT($vSmtp_id) >> C_STRING(15;$vAuthUserName;$vAuthPassword) >> $vError:=SMTP_New ($vSmtp_id) >> $vError:=SMTP_Host ($vSmtp_id;$Host) >> $vError:=SMTP_From ($vSmtp_id;$FromAddress) >> $vError:=SMTP_Subject ($vSmtp_id;$Subject) >> $vError:=SMTP_To ($vSmtp_id;$David+","+$Owner+","+$GACoor) >> $vError:=SMTP_Body ($vSmtp_id;$Message)) >> $vError:=SMTP_Attachment ($vSmtp_id;"";6) >> If ($vError#0) >> ALERT("Error: SMTP_QuickSend"+Char(13)+IT_ErrorText ($vError)) >> End if >> >> $vError:=SMTP_Auth ($vSmtp_id;$vAuthUserName;$vAuthPassword; >> $vAuthMode) >> $vError:=SMTP_Send ($vSmtp_id) >> If ($vError#0) >> ALERT("Error: SMTP_QuickSend"+Char(13)+IT_ErrorText ($vError)) >> End if >> $vError:=SMTP_Clear ($vSmtp_id) >> BEEP >> End if >> >> >> J. Allen (Pete) Seabolt >> LCS Technology >> 51 Mountain View Drive >> Dahlonega, GA 30533 >> Home 706-864-6613 >> Work 706-864-2169 x1 >> >> On Apr 30, 2008, at 6:17 AM, john convey wrote: >> >>> >>> >>> There was a guy from Malaysia did a session on this >>> at one of the summits - however, this involved plugging a mobile >>> phone into the server... >>> It worked ok but there are obvious and not so obvious issues with >>> this. >>> >>> let me know what you find out as i am interested in this as well >>> i have auto e-mails - you would think there could be similar calls >>> to an sms gateway? >>> >>> then there is the issue of cost per sms >>> >>> >>> John >>> sci-do communications >>> >>> >>> >>> >>> >>> >>> >>> >>> On 28 Apr 2008, at 11:05, Gareth Home Openworld wrote: >>>> Hello Everyone, >>>> I have written a reception database for a health clinic and I >>>> want to incorporate SMS (text) reminders to patients from the >>>> database. >>>> I'm sure this is possible, and I know other databases that do >>>> this...can anyone tell me where I can get info on it...where to >>>> get started ? >>>> Many Thanks, >>>> Gareth >>>> >>>> >>>> ********************************************************************** >>>> 4D Basics hosted by 4D, Inc. http://www.4D.com/ >>>> >>>> An all-new List box. More features, more power. >>>> Headers, footers, cell formatting and other goodies. >>>> See it here first! <http://www.4d.com/livedemos> >>>> >>>> To Unsubscribe: mailto:4DBasics-off@... >>>> ********************************************************************** >>>> >>>> >>> >>> >>> ********************************************************************** >>> 4D Basics hosted by 4D, Inc. http://www. >>> 4D.com/ >>> >>> An all-new List box. More features, more power. >>> Headers, footers, cell formatting and other goodies. >>> See it here first! <http://www.4d.com/livedemos> >>> >>> To Unsubscribe: mailto:4DBasics-off@... >>> ********************************************************************** >>> >>> >> >> >> ********************************************************************** >> 4D Basics hosted by 4D, Inc. http://www.4D.com/ >> >> An all-new List box. More features, more power. >> Headers, footers, cell formatting and other goodies. >> See it here first! <http://www.4d.com/livedemos> >> >> To Unsubscribe: mailto:4DBasics-off@info. >> 4D.com >> ********************************************************************** >> >> > > > ********************************************************************** > 4D Basics hosted by 4D, Inc. http://www.4D.com/ > > An all-new List box. More features, more power. > Headers, footers, cell formatting and other goodies. > See it here first! <http://www.4d.com/livedemos> > > To Unsubscribe: mailto:4DBasics-off@... > ********************************************************************** > > ********************************************************************** 4D Basics hosted by 4D, Inc. http://www.4D.com/ An all-new List box. More features, more power. Headers, footers, cell formatting and other goodies. See it here first! <http://www.4d.com/livedemos> To Unsubscribe: mailto:4DBasics-off@... ********************************************************************** |
|
|
Re: re SMS with 4D
by Gareth Home Openworld
::
Rate this Message:
Thank you very much.
Gareth On 28 Apr 2008, at 13:38, Pete Seabolt wrote: > I should have looked before sending the last email. The IF state > follows confirm > > CONFIRM("Send Coordination email for "+[Form05]Trustee Call) > If (OK=1) > > > J. Allen (Pete) Seabolt > LCS Technology > 51 Mountain View Drive > Dahlonega, GA 30533 > Home 706-864-6613 > Work 706-864-2169 x1 > > On Apr 28, 2008, at 8:03 AM, Gareth Home Openworld wrote: > >> There seems to be a missing IF. >> Also, apologies if I'm being stupid but how would you call this >> procedure/Method ? >> Thanks, >> Gareth >> >> On 28 Apr 2008, at 12:29, Pete Seabolt wrote: >> >>> Why don't you just send them an email to their mobile phone >>> number. It will arrive as a simple text message. At least it does >>> on AT&T and nextel/sprint. Just put the 4d plugin in the folder >>> and a few lines of code. The following code uses the quick send >>> found in 4D Internetcommands.bundle plugins folder. >>> >>> >>> $Host:=[Info]IP HOST >>> $GACoor:=[Info]CoordSeraEmail >>> $David:=[Info]OffSERAEmail >>> $vAuthUserName:=[Info]AuthUserName >>> $vAuthPassword:=[Info]AuthPassWord >>> $vAuthMode:=[Info]AuthMode >>> `$vAuthUserName:="pseabolt" >>> `$vAuthPassword:="xxxxxxxx" >>> `$vAuthMode:=1 >>> `$GACoor:="ga-coordination@..." >>> `$David:="w4wdw@..." >>> `$David:="aseabolt@..." >>> $Owner:=[Form05]eMail >>> `$Owner:="pseabolt@..." >>> $FromAddress:=[Info]email >>> $Info:=[Info]Name+", "+[Info]Call+Char(13)+"Southeastern Repeater >>> Association, Inc."+Char(13)+[Info]Title+Char(13)+[Info]street >>> +Char(13)+[Info]CityStZip+Char(13)+[Info]Phone+Char(13)+ >>> [Info]Phone 2+Char(13)+Char(13) >>> $Subject:="Coordination "+[Form05]QKey+" "+[Form05]City+" "+ >>> [Form05]State+" "+String([Form05]Output;"###0.0000") >>> $N1:=[Form05]Email Notes+Char(13) >>> $L1:="NOTICE OF COORDINATION (FORM 05) Please find >>> attachment"+Char(13)+Char(13) >>> $L2:="The attachment is an official notice of >>> coordination."+Char(13)+Char(13) >>> $Message:=$N1+$L1+$L2+$Info >>> C_INTEGER($vError) >>> C_LONGINT($vSmtp_id) >>> C_STRING(15;$vAuthUserName;$vAuthPassword) >>> $vError:=SMTP_New ($vSmtp_id) >>> $vError:=SMTP_Host ($vSmtp_id;$Host) >>> $vError:=SMTP_From ($vSmtp_id;$FromAddress) >>> $vError:=SMTP_Subject ($vSmtp_id;$Subject) >>> $vError:=SMTP_To ($vSmtp_id;$David+","+$Owner+","+$GACoor) >>> $vError:=SMTP_Body ($vSmtp_id;$Message)) >>> $vError:=SMTP_Attachment ($vSmtp_id;"";6) >>> If ($vError#0) >>> ALERT("Error: SMTP_QuickSend"+Char(13)+IT_ErrorText ($vError)) >>> End if >>> >>> $vError:=SMTP_Auth ($vSmtp_id;$vAuthUserName;$vAuthPassword; >>> $vAuthMode) >>> $vError:=SMTP_Send ($vSmtp_id) >>> If ($vError#0) >>> ALERT("Error: SMTP_QuickSend"+Char(13)+IT_ErrorText ($vError)) >>> End if >>> $vError:=SMTP_Clear ($vSmtp_id) >>> BEEP >>> End if >>> >>> >>> J. Allen (Pete) Seabolt >>> LCS Technology >>> 51 Mountain View Drive >>> Dahlonega, GA 30533 >>> Home 706-864-6613 >>> Work 706-864-2169 x1 >>> >>> On Apr 30, 2008, at 6:17 AM, john convey wrote: >>> >>>> >>>> >>>> There was a guy from Malaysia did a session on this >>>> at one of the summits - however, this involved plugging a mobile >>>> phone into the server... >>>> It worked ok but there are obvious and not so obvious issues with >>>> this. >>>> >>>> let me know what you find out as i am interested in this as well >>>> i have auto e-mails - you would think there could be similar >>>> calls to an sms gateway? >>>> >>>> then there is the issue of cost per sms >>>> >>>> >>>> John >>>> sci-do communications >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> On 28 Apr 2008, at 11:05, Gareth Home Openworld wrote: >>>>> Hello Everyone, >>>>> I have written a reception database for a health clinic and I >>>>> want to incorporate SMS (text) reminders to patients from the >>>>> database. >>>>> I'm sure this is possible, and I know other databases that do >>>>> this...can anyone tell me where I can get info on it...where to >>>>> get started ? >>>>> Many Thanks, >>>>> Gareth >>>>> >>>>> >>>>> ********************************************************************** >>>>> 4D Basics hosted by 4D, Inc. http://www.4D.com/ >>>>> >>>>> An all-new List box. More features, more power. >>>>> Headers, footers, cell formatting and other goodies. >>>>> See it here first! <http://www.4d.com/livedemos> >>>>> >>>>> To Unsubscribe: mailto:4DBasics-off@... >>>>> ********************************************************************** >>>>> >>>>> >>>> >>>> >>>> ********************************************************************** >>>> 4D Basics hosted by 4D, Inc. http://www.4D.com/ >>>> >>>> An all-new List box. More features, more power. >>>> Headers, footers, cell formatting and other goodies. >>>> See it here first! <http://www.4d.com/livedemos> >>>> >>>> To Unsubscribe: mailto:4DBasics-off@... >>>> ********************************************************************** >>>> >>>> >>> >>> >>> ********************************************************************** >>> 4D Basics hosted by 4D, Inc. http://www. >>> 4D.com/ >>> >>> An all-new List box. More features, more power. >>> Headers, footers, cell formatting and other goodies. >>> See it here first! <http://www.4d.com/livedemos> >>> >>> To Unsubscribe: mailto:4DBasics-off@... >>> ********************************************************************** >>> >>> >> >> >> ********************************************************************** >> 4D Basics hosted by 4D, Inc. http://www.4D.com/ >> >> An all-new List box. More features, more power. >> Headers, footers, cell formatting and other goodies. >> See it here first! <http://www.4d.com/livedemos> >> >> To Unsubscribe: mailto:4DBasics-off@info. >> 4D.com >> ********************************************************************** >> >> > > > ********************************************************************** > 4D Basics hosted by 4D, Inc. http://www.4D.com/ > > An all-new List box. More features, more power. > Headers, footers, cell formatting and other goodies. > See it here first! <http://www.4d.com/livedemos> > > To Unsubscribe: mailto:4DBasics-off@... > ********************************************************************** > > ********************************************************************** 4D Basics hosted by 4D, Inc. http://www.4D.com/ An all-new List box. More features, more power. Headers, footers, cell formatting and other goodies. See it here first! <http://www.4d.com/livedemos> To Unsubscribe: mailto:4DBasics-off@... ********************************************************************** |
|
|
Re: re SMS with 4D
by Gareth Home Openworld
::
Rate this Message:
Dear Pete,
Great Info...just one question (so far) ....where would you put a mobile phone number rather than email address to send text to a mobile phone ? Thanks, Gareth On 28 Apr 2008, at 13:38, Pete Seabolt wrote: > I should have looked before sending the last email. The IF state > follows confirm > > CONFIRM("Send Coordination email for "+[Form05]Trustee Call) > If (OK=1) > > > J. Allen (Pete) Seabolt > LCS Technology > 51 Mountain View Drive > Dahlonega, GA 30533 > Home 706-864-6613 > Work 706-864-2169 x1 > > On Apr 28, 2008, at 8:03 AM, Gareth Home Openworld wrote: > >> There seems to be a missing IF. >> Also, apologies if I'm being stupid but how would you call this >> procedure/Method ? >> Thanks, >> Gareth >> >> On 28 Apr 2008, at 12:29, Pete Seabolt wrote: >> >>> Why don't you just send them an email to their mobile phone >>> number. It will arrive as a simple text message. At least it does >>> on AT&T and nextel/sprint. Just put the 4d plugin in the folder >>> and a few lines of code. The following code uses the quick send >>> found in 4D Internetcommands.bundle plugins folder. >>> >>> >>> $Host:=[Info]IP HOST >>> $GACoor:=[Info]CoordSeraEmail >>> $David:=[Info]OffSERAEmail >>> $vAuthUserName:=[Info]AuthUserName >>> $vAuthPassword:=[Info]AuthPassWord >>> $vAuthMode:=[Info]AuthMode >>> `$vAuthUserName:="pseabolt" >>> `$vAuthPassword:="xxxxxxxx" >>> `$vAuthMode:=1 >>> `$GACoor:="ga-coordination@..." >>> `$David:="w4wdw@..." >>> `$David:="aseabolt@..." >>> $Owner:=[Form05]eMail >>> `$Owner:="pseabolt@..." >>> $FromAddress:=[Info]email >>> $Info:=[Info]Name+", "+[Info]Call+Char(13)+"Southeastern Repeater >>> Association, Inc."+Char(13)+[Info]Title+Char(13)+[Info]street >>> +Char(13)+[Info]CityStZip+Char(13)+[Info]Phone+Char(13)+ >>> [Info]Phone 2+Char(13)+Char(13) >>> $Subject:="Coordination "+[Form05]QKey+" "+[Form05]City+" "+ >>> [Form05]State+" "+String([Form05]Output;"###0.0000") >>> $N1:=[Form05]Email Notes+Char(13) >>> $L1:="NOTICE OF COORDINATION (FORM 05) Please find >>> attachment"+Char(13)+Char(13) >>> $L2:="The attachment is an official notice of >>> coordination."+Char(13)+Char(13) >>> $Message:=$N1+$L1+$L2+$Info >>> C_INTEGER($vError) >>> C_LONGINT($vSmtp_id) >>> C_STRING(15;$vAuthUserName;$vAuthPassword) >>> $vError:=SMTP_New ($vSmtp_id) >>> $vError:=SMTP_Host ($vSmtp_id;$Host) >>> $vError:=SMTP_From ($vSmtp_id;$FromAddress) >>> $vError:=SMTP_Subject ($vSmtp_id;$Subject) >>> $vError:=SMTP_To ($vSmtp_id;$David+","+$Owner+","+$GACoor) >>> $vError:=SMTP_Body ($vSmtp_id;$Message)) >>> $vError:=SMTP_Attachment ($vSmtp_id;"";6) >>> If ($vError#0) >>> ALERT("Error: SMTP_QuickSend"+Char(13)+IT_ErrorText ($vError)) >>> End if >>> >>> $vError:=SMTP_Auth ($vSmtp_id;$vAuthUserName;$vAuthPassword; >>> $vAuthMode) >>> $vError:=SMTP_Send ($vSmtp_id) >>> If ($vError#0) >>> ALERT("Error: SMTP_QuickSend"+Char(13)+IT_ErrorText ($vError)) >>> End if >>> $vError:=SMTP_Clear ($vSmtp_id) >>> BEEP >>> End if >>> >>> >>> J. Allen (Pete) Seabolt >>> LCS Technology >>> 51 Mountain View Drive >>> Dahlonega, GA 30533 >>> Home 706-864-6613 >>> Work 706-864-2169 x1 >>> >>> On Apr 30, 2008, at 6:17 AM, john convey wrote: >>> >>>> >>>> >>>> There was a guy from Malaysia did a session on this >>>> at one of the summits - however, this involved plugging a mobile >>>> phone into the server... >>>> It worked ok but there are obvious and not so obvious issues with >>>> this. >>>> >>>> let me know what you find out as i am interested in this as well >>>> i have auto e-mails - you would think there could be similar >>>> calls to an sms gateway? >>>> >>>> then there is the issue of cost per sms >>>> >>>> >>>> John >>>> sci-do communications >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> On 28 Apr 2008, at 11:05, Gareth Home Openworld wrote: >>>>> Hello Everyone, >>>>> I have written a reception database for a health clinic and I >>>>> want to incorporate SMS (text) reminders to patients from the >>>>> database. >>>>> I'm sure this is possible, and I know other databases that do >>>>> this...can anyone tell me where I can get info on it...where to >>>>> get started ? >>>>> Many Thanks, >>>>> Gareth >>>>> >>>>> >>>>> ********************************************************************** >>>>> 4D Basics hosted by 4D, Inc. http://www.4D.com/ >>>>> >>>>> An all-new List box. More features, more power. >>>>> Headers, footers, cell formatting and other goodies. >>>>> See it here first! <http://www.4d.com/livedemos> >>>>> >>>>> To Unsubscribe: mailto:4DBasics-off@... >>>>> ********************************************************************** >>>>> >>>>> >>>> >>>> >>>> ********************************************************************** >>>> 4D Basics hosted by 4D, Inc. http://www.4D.com/ >>>> >>>> An all-new List box. More features, more power. >>>> Headers, footers, cell formatting and other goodies. >>>> See it here first! <http://www.4d.com/livedemos> >>>> >>>> To Unsubscribe: mailto:4DBasics-off@... >>>> ********************************************************************** >>>> >>>> >>> >>> >>> ********************************************************************** >>> 4D Basics hosted by 4D, Inc. http://www. >>> 4D.com/ >>> >>> An all-new List box. More features, more power. >>> Headers, footers, cell formatting and other goodies. >>> See it here first! <http://www.4d.com/livedemos> >>> >>> To Unsubscribe: mailto:4DBasics-off@... >>> ********************************************************************** >>> >>> >> >> >> ********************************************************************** >> 4D Basics hosted by 4D, Inc. http://www.4D.com/ >> >> An all-new List box. More features, more power. >> Headers, footers, cell formatting and other goodies. >> See it here first! <http://www.4d.com/livedemos> >> >> To Unsubscribe: mailto:4DBasics-off@info. >> 4D.com >> ********************************************************************** >> >> > > > ********************************************************************** > 4D Basics hosted by 4D, Inc. http://www.4D.com/ > > An all-new List box. More features, more power. > Headers, footers, cell formatting and other goodies. > See it here first! <http://www.4d.com/livedemos> > > To Unsubscribe: mailto:4DBasics-off@... > ********************************************************************** > > ********************************************************************** 4D Basics hosted by 4D, Inc. http://www.4D.com/ An all-new List box. More features, more power. Headers, footers, cell formatting and other goodies. See it here first! <http://www.4d.com/livedemos> To Unsubscribe: mailto:4DBasics-off@... ********************************************************************** |
|
|
Re: re SMS with 4D
by Pete Seabolt
::
Rate this Message:
The service is provided by the Phone carrier. For example AT&T uses
the following were 7062456556 is the phone number of the mobile device. text.att.net only works for AT&T. Sprint uses a different address. 7062456556@... Not sure if I understand the question. Let me know if I answered the wrong question. J. Allen (Pete) Seabolt LCS Technology 51 Mountain View Drive Dahlonega, GA 30533 Home 706-864-6613 Work 706-864-2169 x1 On Apr 29, 2008, at 8:52 AM, Gareth Home Openworld wrote: > Dear Pete, > Great Info...just one question (so far) ....where would you put a > mobile phone number rather than email address to send text to a > mobile phone ? > Thanks, > Gareth > > On 28 Apr 2008, at 13:38, Pete Seabolt wrote: > >> I should have looked before sending the last email. The IF state >> follows confirm >> >> CONFIRM("Send Coordination email for "+[Form05]Trustee Call) >> If (OK=1) >> >> >> J. Allen (Pete) Seabolt >> LCS Technology >> 51 Mountain View Drive >> Dahlonega, GA 30533 >> Home 706-864-6613 >> Work 706-864-2169 x1 >> >> On Apr 28, 2008, at 8:03 AM, Gareth Home Openworld wrote: >> >>> There seems to be a missing IF. >>> Also, apologies if I'm being stupid but how would you call this >>> procedure/Method ? >>> Thanks, >>> Gareth >>> >>> On 28 Apr 2008, at 12:29, Pete Seabolt wrote: >>> >>>> Why don't you just send them an email to their mobile phone >>>> number. It will arrive as a simple text message. At least it does >>>> on AT&T and nextel/sprint. Just put the 4d plugin in the folder >>>> and a few lines of code. The following code uses the quick send >>>> found in 4D Internetcommands.bundle plugins folder. >>>> >>>> >>>> $Host:=[Info]IP HOST >>>> $GACoor:=[Info]CoordSeraEmail >>>> $David:=[Info]OffSERAEmail >>>> $vAuthUserName:=[Info]AuthUserName >>>> $vAuthPassword:=[Info]AuthPassWord >>>> $vAuthMode:=[Info]AuthMode >>>> `$vAuthUserName:="pseabolt" >>>> `$vAuthPassword:="xxxxxxxx" >>>> `$vAuthMode:=1 >>>> `$GACoor:="ga-coordination@..." >>>> `$David:="w4wdw@..." >>>> `$David:="aseabolt@..." >>>> $Owner:=[Form05]eMail >>>> `$Owner:="pseabolt@..." >>>> $FromAddress:=[Info]email >>>> $Info:=[Info]Name+", "+[Info]Call+Char(13)+"Southeastern >>>> Repeater Association, Inc."+Char(13)+[Info]Title+Char(13)+ >>>> [Info]street+Char(13)+[Info]CityStZip+Char(13)+[Info]Phone >>>> +Char(13)+[Info]Phone 2+Char(13)+Char(13) >>>> $Subject:="Coordination "+[Form05]QKey+" "+[Form05]City+" "+ >>>> [Form05]State+" "+String([Form05]Output;"###0.0000") >>>> $N1:=[Form05]Email Notes+Char(13) >>>> $L1:="NOTICE OF COORDINATION (FORM 05) Please find >>>> attachment"+Char(13)+Char(13) >>>> $L2:="The attachment is an official notice of >>>> coordination."+Char(13)+Char(13) >>>> $Message:=$N1+$L1+$L2+$Info >>>> C_INTEGER($vError) >>>> C_LONGINT($vSmtp_id) >>>> C_STRING(15;$vAuthUserName;$vAuthPassword) >>>> $vError:=SMTP_New ($vSmtp_id) >>>> $vError:=SMTP_Host ($vSmtp_id;$Host) >>>> $vError:=SMTP_From ($vSmtp_id;$FromAddress) >>>> $vError:=SMTP_Subject ($vSmtp_id;$Subject) >>>> $vError:=SMTP_To ($vSmtp_id;$David+","+$Owner+","+$GACoor) >>>> $vError:=SMTP_Body ($vSmtp_id;$Message)) >>>> $vError:=SMTP_Attachment ($vSmtp_id;"";6) >>>> If ($vError#0) >>>> ALERT("Error: SMTP_QuickSend"+Char(13)+IT_ErrorText ($vError)) >>>> End if >>>> >>>> $vError:=SMTP_Auth ($vSmtp_id;$vAuthUserName;$vAuthPassword; >>>> $vAuthMode) >>>> $vError:=SMTP_Send ($vSmtp_id) >>>> If ($vError#0) >>>> ALERT("Error: SMTP_QuickSend"+Char(13)+IT_ErrorText ($vError)) >>>> End if >>>> $vError:=SMTP_Clear ($vSmtp_id) >>>> BEEP >>>> End if >>>> >>>> >>>> J. Allen (Pete) Seabolt >>>> LCS Technology >>>> 51 Mountain View Drive >>>> Dahlonega, GA 30533 >>>> Home 706-864-6613 >>>> Work 706-864-2169 x1 >>>> >>>> On Apr 30, 2008, at 6:17 AM, john convey wrote: >>>> >>>>> >>>>> >>>>> There was a guy from Malaysia did a session on this >>>>> at one of the summits - however, this involved plugging a mobile >>>>> phone into the server... >>>>> It worked ok but there are obvious and not so obvious issues >>>>> with this. >>>>> >>>>> let me know what you find out as i am interested in this as well >>>>> i have auto e-mails - you would think there could be similar >>>>> calls to an sms gateway? >>>>> >>>>> then there is the issue of cost per sms >>>>> >>>>> >>>>> John >>>>> sci-do communications >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> On 28 Apr 2008, at 11:05, Gareth Home Openworld wrote: >>>>>> Hello Everyone, >>>>>> I have written a reception database for a health clinic and I >>>>>> want to incorporate SMS (text) reminders to patients from the >>>>>> database. >>>>>> I'm sure this is possible, and I know other databases that do >>>>>> this...can anyone tell me where I can get info on it...where to >>>>>> get started ? >>>>>> Many Thanks, >>>>>> Gareth >>>>>> >>>>>> >>>>>> ********************************************************************** >>>>>> 4D Basics hosted by 4D, Inc. http://www.4D.com/ >>>>>> >>>>>> An all-new List box. More features, more power. >>>>>> Headers, footers, cell formatting and other goodies. >>>>>> See it here first! <http://www.4d.com/livedemos> >>>>>> >>>>>> To Unsubscribe: mailto:4DBasics-off@... >>>>>> ********************************************************************** >>>>>> >>>>>> >>>>> >>>>> & |
