Re: re SMS with 4D

> 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@...
>>> **********************************************************************
>>>
>>>
>>
>>
>> **********************************************************************
>> 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@...
> **********************************************************************
>
>