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 !

 

[vladcbv]

Hy guys,

I was out of the office for 2 weeks, and now that I am back, I want to continue with this.

I opened a Database from SQL server installed on the same machine as VMPro. It goes through Success, and then I create a menu to input digits. After I do a DataBaseExecute - Select * FROM CALLS where (nrab=$KEY). After this point it goes to Success - which is great. Theproblem now is that when I want th check the #DBD0123456 variables, they are all empty.. aand that confuses me..

Any clues ?

 

[Gunnaro]

Then you're not fetching any data. There are 4 options in the Database collecting process, try one of the other options, like Get last or first, etc.


Kind regards

Gunnar
_______
B.U.B.F

 

[vladcbv]

I was just about to post that I wasn't fetching any data.. that was it..

Rookie mistake.. Now it works.. FINALLY!!

Thank you Gunnaro!

 

[Gunnaro]

There you go

Kind regards

Gunnar
_______
B.U.B.F

 

[vladcbv]

Now it won't INSERT data at the end of the table :-?

I have used 3 Generics to store info in CP1,2,3 and then I want to add that info into the CALLS table.
Execute 2 looks like this:

INSERT INTO CALLS
(IndexVechi,NAME,nrab)
VALUES ("$CP1","$CP2","$CP3");

If I want to use the wizzard The Field and Vaules columns are empty..so I need to type the querry manually..

After the command executes it goes to Failure..

 

[Gunnaro]

If it doesn't show up in the wizard, there's no point in entering anything manually.
You're not connected to the DB properly, plain and simple.

See anything in the dropdown, to select the appropriate sheet?

Kind regards

Gunnar
_______
B.U.B.F

 

[vladcbv]

Hey

The thing is it didn't show up in the wizzard when I wanted to SELECT values, and it did work when I manually typed the querry in.. si I thought it should work for INSERT aswell..

To be clear, for the DB I am usign Microsoft OLE DB Provider for SQL Server.. I also tried with SQL Server Native Client 11 .. same problem..

So When I want to execute - SELECT this is what I have in the Database Path: Provider=SQLNCLI11.1;Password=123qweasd;Persist Security Info=True;User ID=sa;Initial Catalog="";Data Source=127.0.0.1;Initial File Name="";Server SPN=""

I think I am missing something here

 

[vladcbv]

And this is log capture from DBGView :


27/08 16:50:06.143 vmprov5s (17,2) b30,1494: Database Error: TmodClrObjects:vtExecute[721]: Failed to "execute the query "INSERT INTO CALLS

(IndexVechi, NAME, nrab )

VALUES ("1349", "Georgescu George", "50000");"", error -2147217900 [0x80040e14] - Invalid column name '1349'. [source=Microsoft OLE DB Provider for SQL Server] [[0]: Error number -2147217900 [80040e14] - Invalid column name '1349'., native number 207 - 42S22, [1]: Error number -2147217900 [80040e14] - Invalid column name 'Georgescu George'., native number 207 - 42S22, [2]: Error number -2147217900 [80040e14] - Invalid column name '50000'., native number 207 - 42S22].


27/08 16:50:06.143 vmprov5s (09,2) b30,1494: Session: 00000092 - Database execute failed: TmodClrObjects:vtExecute[721]: Failed to "execute the query "INSERT INTO CALLS

(IndexVechi, NAME, nrab )

VALUES ("1349", "Georgescu George", "50000");"", error -2147217900 [0x80040e14] - Invalid column name '1349'. [source=Microsoft OLE DB Provider for SQL Server] [[0]: Error number -2147217900 [80040e14] - Invalid column name '1349'., native number 207 - 42S22, [1]: Error number -2147217900 [80040e14] - Invalid column name 'Georgescu George'., native number 207 - 42S22, [2]: Error number -2147217900 [80040e14] - Invalid column name '50000'., native number 207 - 42S22].

 

[derfloh]

Are you sure that values have to be in " " and not in ' '?

 

[vladcbv]

Good point there!

I did change them to '' and now I get a different error.. It sais it cannot add the NULL Value in the ID column. That seems fair to me, but I don't understand why doesn't it increment it like it did before, when I was using Access Database.. No I think I have to store the last ID in the table and increment it when I want to add the new value.. Is there an alternative to this ?

Another thing.. I created modules to simplify my workflow.. for any reason what so ever, VMPro won't let me connect them togheter.. Sometimes it does, somtimes it dosen't.. I have rebooted servies / pc and still have same problem.. I won't even lent me connect anything to Start Point anymore...

 

[derfloh]

Then you have to change the settings of the ID column so that it gets auto populated.

Look here:

http://stackoverflow.com/questions/...mary-key-in-sql-server-management-studio-2012

 

[vladcbv]

Hey So I have decided to start over with a new Database .. I made sure the ID gets incremented by 1 .. Now my callflow is working like it should
This callflow may be installed in a service providers deployment, if that will happen, I will come back with some beers :>

Thank you guys for your help ! I have learned a lot about VoiceMailPro and looking forward to learn even more.

I wish you good day!

Vlad C.
Ro.

 

[engabduqaid]

Thank you so much Gunnaro for attached file