IP Office Database Functions 1

[tdaugirdas]

Has anyone out there been able to get the database functions in VM Pro to work - or is this just more Avaya hype - backed up with no credibility?

Tom Daugirdas,
President
STCG, Inc.
stcg.com

 

[hairlessupportmonkey]

you need the appropriate licence.

VM Pro is a very good product, and its one of the IPOffices best assets.

you wont get many if any other VM products with as much functionality for the price.

So, your answer is yes.


ACSS - SME

 

[tdaugirdas]

Well - I have been working with Jenne and Catalyst tech support to do a very simple database lookup - and no one has figured out how to make it work.

The customer is a tech support provider. Priority customers have an ID number.

When they call-in and the AA answers - they want an option to have priority customers key-in their ID number - and go to a priority queue.

I have a very simple one table, one column Access database with the ID numbers keyed in.

I can get to the point of opening the database (successfully)- and I programmed the simple "select" option to lookup the number against $KEY - but all numbers entered - lead to the "failure" result. So - basically nothing works.

I am pulling my hair out - as this seems so simple.

Tom Daugirdas,
President
STCG, Inc.
stcg.com

 

[tlpeter]

It looks simple but it can be hard.
What kind of database is it?



When you pay peanuts, you get monkeys!

honey, i fried the IP Office !!!

Sarcasm, it's only one of the services I offer.

 

[hairlessupportmonkey]

peter - an access DB.

What version of Access was it created in?

ACSS - SME

 

[tlpeter]

Oeps, i was still sleeping.
There is an example on the knowledgebase which uses an access database too.


When you pay peanuts, you get monkeys!

honey, i fried the IP Office !!!

Sarcasm, it's only one of the services I offer.

 

[kwing112000]

I have done it with access and what we had was you called in and entered your ZIP code. the VM matched that against the database and transfered you to the right ext. I can get you copied of the Module and the database if needed. shoot me an email at kwing at carouselindustries dot com

Kevin Wing
ACSS Small and Medium Enterprise (SME) Communications
ACS- Implement IP Office
ACA- Implement IP Office
Carousel Industries

 

[intrigrant]

It is sooooo easy but you must know what you are doing.
I have made examples with all kinds of ODBC connections:
plain text file, excel file, access database, ms sql data base and more without any problem at all.
This is a very fine Avaya product where competitors can only dream of for that kind of money.

 

[tdaugirdas]

I am not sure which "type" of Microsoft Access database it is. I thought they are all pretty much the same. I am using Office 2007.

The Database Execute has these three SQL commands (which were generated by the SQL Wizard):
SELECT StoreID
FROM PSAVaild
WHERE (StoreID = "$KEY") ;

When $KEY finds a match in the StoreID column - the caller should be routed to a priority queue. If there is no match - they hear an "incorrect ID" announcement and are routed back to the main menu.

Seems simple - and I followed the example with ISDN number lookup in the VM Pro Manual - however I cannot get it to work.

I tried an Excel alternative. Again I can get past the database open command - but if i try a VLOOKUP command for $KEY - it fails.

Tom Daugirdas,
President
STCG, Inc.
stcg.com

 

[intrigrant]

Use the SQL query in excel then you can see what you get returned and if it works then copy paste the sql query form excel to VM Pro SQL Wizard.

 

[tdaugirdas]

I never tried using SQL commands within a spreadsheet before - but I'll try anything at this point.

Tom Daugirdas,
President
STCG, Inc.
stcg.com

 

[mattKnight]

SELECT StoreID FROM PSAVaild WHERE (StoreID = "$KEY") ;

what happens when you run this query from the access query analyser?
No matches?

I suspect that your query is wrong because it is looking for the column StoreID to contain the precise value $KEY (and not the value contained in the VM PRO variable $KEY)

I reckon you need to read the access help for PARAMETERISED QUERY, which will explain it much better than my hazy memory will

Likewise, your query is a bit self defeating: it reads give me the value of the column StoreID where the value of StoreID is <value>...



Take Care

Matt
I have always wished that my computer would be as easy to use as my telephone.
My wish has come true. I no longer know how to use my telephone.

 

[tdaugirdas]

Special thanks to Kevin!! - and everyone else who responded. I found out that my whole issue was in the database table. The entries were formatted as "text". When I changed it to "number" formatting - everything started to work. Without Kevin's module - I never would have thought to check this issue.

Tom Daugirdas,
President
STCG, Inc.
stcg.com