routerguy's blog

More on build 42

I've also upgraded, or, more accurately, backed up my voice files, uninstalled, and reinstalled. Everything went flawlessly. I've enabled mysql access in php.ini (note that the .dll filename is slightly changed from the online documentation), and have created some simple prophecy>php>mysql applications. Next up, auto-updating an rss feed to the mysql database and using tts to read it over the phone. Goal of the application is to get semi-realtime traffic information for a voice-selected freeway in los angeles. I'd really be interested in hearing any other interesting applications for some extremely powerful technology.

downloadable grammars

Voxeo has a selection of pre-made grammars available for download here that include commonly used functionality such as states, zip codes, area codes, days of the week, months, etc. These can save you significant time over developing your own!

best practices - what to use when

I'm a neophyte to the ASR-TTS arena, and I'm a bit confused over the benefits and drawbacks associated with the VXML vs. CCXML decision. I'm not going to consider the proprietary calxml unless and until there is something that requires functionality unavailable in the standards.

Prophecy and Database Support

So the next logical step is to add some database interaction. Here's what I've tried so far.

Installed mysql 4.1 and created a test database.
Tried to run a small php file:

$db = mysql_connect("localhost", "root");
mysql_select_db("Test",$db);
$result = mysql_query("SELECT * FROM Books",$db);
printf( "TITLE: %s\n", mysql_result($result,0,"Title"));
printf( "CODE: %s\n", mysql_result($result,0,"Price"));

Results in php error: Fatal error: Call to undefined function mysql_connect() in c:\program files\Voxeo\www\data.php on line 4

It appears that PHP is installed without MySQL support. Note that the default in php 5.1 is to have MySQL support disabled, and since it's compiled into voxeo.exe, it appears that there's not much I can do about it.

VXML call transfer working with asterisk

First off, there's now an acknowleded bug in the call-transfer module that requires a new license key from voxeo to fix. In order to get this to work correctly with asterisk, you also need to make sure that "provider requires bridged connection" is checked in the prophecy admin section, and that there is NO "bridge=" statement either true or false, in your xml. With this configuration, I am now able to do an interactive voice recognition application that can transfer calls successfully. Next up, Php=>MySQL integration for account balance lookups, or appointment availability, or whatever. S

Syndicate content