Solved

Fox 9 to phone/email/text system

Posted on 2013-07-01
3
346 Views
Last Modified: 2013-07-18
I have to come up with a solution for a medical office who contacts patients once a month to notify them to come in for an office visit.  The patient list is stored in Fox Pro. It currently prints post cards which has become too costly.  Can have up to 300 patients to notify per month.

Any one know of a way to access a fox table and make outgoing phone calls--play a wave file-or send an email or a text message.  Method of contact based on patients preferences.

There must be some interface available that fox can talk to that will make this possible. Can export out of Fox to another application or format if need be.

I know there are companies out there that do this but they are somewhat limited. They also can charge per contact which can get excessive.

Any one have any experience with this ?

Thank You
Dan
0
Comment
Question by:Malibucompany
  • 2
3 Comments
 
LVL 41

Assisted Solution

by:pcelba
pcelba earned 167 total points
ID: 39290390
1) E-mail from FoxPro.
Many ways exist, see http://fox.wikis.com/wc.dll?Wiki~AutomatedEmail
I would recommend CDO which is easy and reliable

2) SMS from FoxPro.
Many ways exist... See, e.g. http://www.youtube.com/watch?v=8rvVqAMkl3I
SMS is possible to send as an e-mail: http://www.example-code.com/foxpro/sms_send.asp
SMS is also possible to send via web page (http://fox.wikis.com/wc.dll?Wiki~SmartSMS) or web service or via phone connected to the PC. So depends what service do you use and what API the cell provider offers to you. You should start with the provider possibilities given to you.

3) Voice call
Many...  This depends on hardware or software used. It should be possible to use e.g. VoIP software API and text to speech (TTS) software which will call any number and read the message prepared as a text. You may also record the message as WAW or MP3 file etc.
Look e.g. here: http://www.cisco.com/en/US/products/sw/voicesw/ps1860/products_data_sheet09186a0080092436.html
Or ask your VoIP service provider for the recommendation.

You may also use a standard PSTN phone line and appropriate dialer hardware or software etc. Notebook modems allow voice calls obviously but the software isn't so easy to find... Some phone companies can also deliver SMS to a standard PSTN phone using TTS software.

VoIP is better probably because providers are open to new technologies and they can offer more than PSTN dinosaurs obviously.

I cannot give you specific code and/or specific recommendation for SMS and Voice calls because I don't know your local conditions and possibilities.
0
 
LVL 12

Assisted Solution

by:jrbbldr
jrbbldr earned 333 total points
ID: 39290708
VoIP is better probably because providers are open to new technologies

I may amend Pavel's comment above to say:  SOME providers are open to new technologies.

I have worked with Avaya on their "Open Office" in-house SIP phone system and their only support was to tell me that the interface can be done via TAPI.  
But how to use the TAPI interface and what needed to be done with it was left totally un-answered.

As such my client's Click-to-Dial functionality within their VFP application never got off the ground - let alone any other additional automation with the phone.

Can it be done?  Absolutely !!!
Who can advise you?   I am Not Sure.

Actually one thing you might consider would be to use a 'cloud' based dialer vendor.  They have generally have interface-able 'gateways' and support for IVR/Voice Messaging/etc.

Good Luck
0
 
LVL 12

Accepted Solution

by:
jrbbldr earned 333 total points
ID: 39290719
Just an short addendum if you were to consider this approach....
   Another name for 'cloud' based dialer vendors might be:
      Hosted contact center solutions
           or
      Cloud based contact center

Good Luck
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

In this article we will discuss some EI Capitan Mail app issues and provide some manual process to resolve them.
Ransomware continues to be a growing problem for both personal and business users alike and Antivirus companies are still struggling to find a reliable way to protect you from this dangerous threat.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now