Next How to create an IVR menu system by using a database

[williamwalker]

Hi all,

I'd like to create an interactive voice response menu system on my own. I'd like to use my MySQL database. I have a found an interesting idea (https://ivrhttpozml.codeplex.com/), but it's based on using a webserver. In short, the previously copied guide presents a simple XML code (more exactly an OzML code) and it should be hosted through a webserver.

Does anybody have a similar solution using a database server?

Thanks in advance

[Dormilich]

Does anybody have a similar solution using a database server?

personally, I doubt it.

although, the IVR part is only on the client side, so anything on the server could be easily modified to your needs.

[robertanderson]

by using sql ozml you can host your script through your database.

what you should do:

1. configure your database (that is: creat new database, create the ozmlin, ozmlout and ozmlscripts tables)

for creating the needed tables:

-- -----------------------------------------------------
-- Table `OzekiPBX`.`ozmlin`
-- -----------------------------------------------------
CREATE TABLE ozmlin
(
  id int identity(1,1) PRIMARY KEY,
  callerid varchar(40) NOT NULL,
  scriptid int NOT NULL,
  duration int DEFAULT NULL,
  status varchar(40) DEFAULT NULL,
  recordurl varchar(150) DEFAULT NULL,
  starttime datetime DEFAULT NULL
);
 
-- ----------------------------------------------------- 
-- Table `ozekipbx`.`ozmlout`
-- -----------------------------------------------------
CREATE TABLE ozmlout
(
  id int identity(1,1) PRIMARY KEY,
  dialednumber varchar(40) NOT NULL,
  status varchar(40) DEFAULT NULL,
  duration int DEFAULT NULL,
  scriptid int DEFAULT NULL,
  recordurl varchar(150) DEFAULT NULL,
  starttime datetime DEFAULT NULL
);
 
-- -----------------------------------------------------
-- Table `ozekipbx`.`ozmlscripts`
-- -----------------------------------------------------
CREATE TABLE ozmlscripts
(
  scriptid int identity(1,1) PRIMARY KEY,
  ozml varchar(8000) NOT NULL
);
 

2. install an sql ozml api
3. add ozml scripts to ozmlscripts table
4. sql queries and dial plan configurations