VoicemailPro and Database integration 3

[vladcbv]

Hi Guys,

I am using IPO 9.1 and VoiceMail Pro 9.1..
I created a database in Microsoft Access based on some examples I found online.
What I want to do for now is:
- get the DTMF and compare it with a valuea in DB.
- if they are equal then transfer to ext A else transfer to ext B .. I have also recorded voice at every step of the callflow to see exactly what happens.

It seems I simply can't find a way to do that. For you to better understand what I am saying, this is what I have:

In the Specific Tab of DataBase Execute I have
"
SELECT ISBN
FROM OrderBooks
WHERE (ISBN = "$KEY") ;
"

The table looks like this :

And the condition is set to Value A $DBD[0] Is Equal To Value B 1001.

So when I dial the IVR I get to the point where I type in the DTMF keys and then it follows the callflow and instead of transfering me to an extension it simply closes the call.

Any help I can get please?
Thank you !

 

[Gunnaro]

Two pointers:

- Don't use DBD[x] directly, convert to a $CPxx before you do anything further.
- Are you sure you're picking the right column in the DB? DBD0 is the lowest alphabetically of those columns you have tagged in your execute box.

Kind regards

Gunnar
_______
B.U.B.F

 

[vladcbv]

I have converted ti $CO with a Generic and placed it after the menui Capture ISBN.
I have changed the condition to compare it with DB3.
I hgave also crated an entry point for the Test Condition. I don't get it played.. it transfers me directly to 207..

 

[Gunnaro]

Well, then I would put in a Text to Speak box right in front of the test condition:
"DB0 is $DBD[0], DB1 is $DBD[1], DB2 is $DBD[2], DB3 is $DBD[3], DB4 is $DBD[4], DB5 is $DBD[5]"
Call in and hear what DBD[x] has the desired value.

Kind regards

Gunnar
_______
B.U.B.F

 

[vladcbv]

That is a great ideea!

I have simpliefied things though.
This is the callflow:

The Generic Fail has a recording saing FAIL... and that's what it's doing.. it seems like I simply cannot successfully execute the command

SELECT Author, Cost, ISBN, Title
FROM OrderBooks
WHERE (ISBN = "$KEY") ;

Why is it not taking values from the table ?

 

[Gunnaro]

Ehrm...your config won't ever work unless you add the necessary final DB action, (brainfreez, can't remember the name, but it's the 3rd down in the dropdown, huge box, Sucess, empty, end, fail)

That's the one who sets the DBD's.

Kind regards

Gunnar
_______
B.U.B.F

 

[vladcbv]

I created a Database Get Data.. the problem is that it's not even getting there. it seems like it's going with the Failure Acction for the Database Execute...

Maybe there is something wrong with my DB ?? I have just simply created a new MS Access file, created the Table and saved it as .accdb ...

 

[Gunnaro]

Try making a access DB in the old style. (.mdb)

If you're not in a hurry, I'll drop you a working example once I reach my destination 300 km up the road.

Kind regards

Gunnar
_______
B.U.B.F

 

[vladcbv]

I'll try to do that. create an MDB file.. I have to say, I haven't opened Access for 6 years or so...

I am not in a hurry, I am just testing and learning this feature of IPO..

Anyway, Have a safe drive!

 

[Gunnaro]

Safe? I should have walked here then As Ricky Bobby says; I just wanna go fast

So, here's an example for you, pretty much the same thing going on as in your module.
If a Key match, caller is transferred to the extn number for that Key.
If no match, the call goes to 200 Main. (you don't need the condition for this, the last DB box sorts it out for you.

Download and import this ZIP FILE
Extract to C:\VMPRO_DB\ (Important)
Import the .MOD with VMPro client.
New module "Incoming" should now be listed in you left lower pane.

And here are a few other setups you can poke around in:

Auto-dialer
Reporting tool
Callback Pro
Routing by Area codes (US)
Protector - don't remember what it does, maybe it's porn?

(Some of these are not R9.1 proof, since they broke many things since R8.1.85)

There's absolutely no good doc's on this, but once you get it, you really get it.
A new world of opportunities opens up and you can make callflows Enterprise-style

Enjoy!

Gin & Tonic, please!


Kind regards

Gunnar
_______
B.U.B.F

 

[vladcbv]

Hehe, Thank you so much! For the file and tips and also for reminding me to see that movie!

I will continue from where I left off since I am not in the office now..

Thank you again,
Have a great one!

 

[vladcbv]

Hey Gunnaro..
Your example with the calls is working. I will play with it and make some tests, see and understand how this work and come back with other queries.

Thank you again!!

 

[Gunnaro]

Of course it works, I made it

You're welcome.

Kind regards

Gunnar
_______
B.U.B.F

 

[vladcbv]

So I think my problem is with my .accdb file . I replaced it in you example and it fails to execute.. Is there a specific way to create/save a DB ?? :|

 

[Gunnaro]

Take a look in the DB open box, compare the strings with mine.
VMPro adds some Persist-blah-blah-BS at the end.
Remove all text after .accdb and test.

If no joy, you can always build on my module, it's like Lego.
I had my fair share of trouble the first time too, so just poke around.

Use the speak text boxes, they tell you where things go wrong, much quicker than to make traces.


Kind regards

Gunnar
_______
B.U.B.F

 

[vladcbv]

Still playing with the setup. Sometimes it's working with different DBs, other times it's not..
I will try to lego on your example.

I want to get to the point where a customer calls, dials in his UniqueID and enters a 5 digits number. That 5digits nr should be stored in another (or the same) Database.

I can feel I'm almost there, but I am very annoyed by the fact that it only works on your DB and another one downloaded from web..

Btw, the speak text boxes are a very good ideea ! :>

 

[vladcbv]

Uhm.. There is a way to write into the Database right? I mean, the keys entered, to replace the value in a a given table field..

 

[Gunnaro]

Yes amd no. New entries will not replace existing values, but is added to a whole new line at the bottom.


Kind regards

Gunnar
_______
B.U.B.F

 

[vladcbv]

I see..
So I guess this setup requires additional work by 3rd party apps on the DB itself.. I thought VmPro would have more optinos than simply SELECT and INSERT.

Thanks so much again!

I'll go ahead and play with it a little more!

 

[Gunnaro]

Well, I just pull all data, then replace the required fields, then select on last entry.

Remember that you can only read 6 values at the time, but write at least 16 back in one go

Kind regards

Gunnar
_______
B.U.B.F