lawrence Posted February 9, 2006 Share Posted February 9, 2006 I am trying to use sql link plugin and even though the plugin is returning E_cities which happened to be the name of another ogm called E_cities as yet the Check Pin ogm is not routing to E_cities ogm. Details are being provided hereunder, reference should be given to: 20:36:13 Plugin returned: Rowcount=-1&Result=Okay&nv_ogm=E_cities&from=E_cities©right=NCH Swift Sound The following is a sequence of events: 20:36:07 Play file: C:\Documents and Settings\All Users\Application Data\NCH Swift Sound\IVM\OGMs\Start.wav 20:36:08 Caller pressed key [1] 20:36:09 Caller pressed key [2] 20:36:10 Caller pressed key [3] 20:36:11 Caller pressed key [4] 20:36:11 Caller pressed key [5] 20:36:12 Caller pressed key [6] 20:36:12 Variable account = 123456 20:36:12 Command - Go 20:36:12 Open OGM: Check Pin 20:36:12 Run plugin: "C:\Program Files\NCH Swift Sound\IVM\sqllink.exe" get_ogm "select nv_ogm from accounts where nv_pin= '123456'" 20:36:12 Play file: C:\Documents and Settings\All Users\Application Data\NCH Swift Sound\IVM\OGMs\Check Pin.wav 20:36:13 Plugin returned: Rowcount=-1&Result=Okay&nv_ogm=E_cities&from=E_cities©right=NCH Swift Sound Would someone give me a helping hand, since once I do my testing I would be looking forward to purchase the license. Thanks and regards. Lawrence, Link to comment Share on other sites More sharing options...
lawrence Posted February 10, 2006 Author Share Posted February 10, 2006 Would anyone send me specific details of how to setup an sql plugin (more detailed than that provided in web site) including preferably print screens of select queries. I am looking forward to setup an IVR. Would appreciate any feedback. Thanks. Link to comment Share on other sites More sharing options...
chinoy Posted February 20, 2006 Share Posted February 20, 2006 I can probably help you. If you're expecting the reply to be "E_cities" your ogm has to be named the same. Next you'll need to specify in the GO TO OGM box (on the main properties screen of the ogm). Typical settings: wait: in seconds (this will depend on how long your query takes... you'll need to adjust it up if you get a "time out" or query did not respond by the time OGM finished playing" Repeat : whatever you need Then: GO TO OGM (in the details : %Env_ogm% I think when you are using the select statement " select nv_ogm from accounts where nv_pin= '123456'". If you are expecting the result to be env_ogm, then the above is correct. Let me know if this helps. If you need more help, post your actual sql query or upload your IVR file and I'll be glad to have a look. Link to comment Share on other sites More sharing options...
lawrence Posted February 22, 2006 Author Share Posted February 22, 2006 hi So far I had managed to use sql plugin, many thanks for your suggestion. However, I would like to know whether it is possible to call an sql stored procedure that would return a result. I managed to call a stored procedure but I did not managed to call a stored procedure that returns back a result. Thanks. I can probably help you. If you're expecting the reply to be "E_cities"your ogm has to be named the same. Next you'll need to specify in the GO TO OGM box (on the main properties screen of the ogm). Typical settings: wait: in seconds (this will depend on how long your query takes... you'll need to adjust it up if you get a "time out" or query did not respond by the time OGM finished playing" Repeat : whatever you need Then: GO TO OGM (in the details : %Env_ogm% I think when you are using the select statement " select nv_ogm from accounts where nv_pin= '123456'". If you are expecting the result to be env_ogm, then the above is correct. Let me know if this helps. If you need more help, post your actual sql query or upload your IVR file and I'll be glad to have a look. <{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
chinoy Posted February 23, 2006 Share Posted February 23, 2006 hi So far I had managed to use sql plugin, many thanks for your suggestion. However, I would like to know whether it is possible to call an sql stored procedure that would return a result. I managed to call a stored procedure but I did not managed to call a stored procedure that returns back a result. Thanks. <{POST_SNAPBACK}> Hi, I personally have not used stored procedures, but I don't see why it would not work. I would think that any odbc driver that supports stored procedures should work with the sql plugin. In my experience I have noticed that quite often I miss obvious things that are revealed upon closer examination. Some of my future projects may require me to use stored procedures, so if I have success, I'll let you know. Link to comment Share on other sites More sharing options...
lawrence Posted February 24, 2006 Author Share Posted February 24, 2006 Hi, I thank you for your interest if you need any help on stored procedure using sql 2000 I would try to help you. I managed to use stored procedure but as I told you not able to return back values. As a matter of fact I had finished the basis of the callplan and now I am moving to test the callplan using a TAPI. In fact I am finding difficulties in setting a voice modem to be 100% TAPI compliant. I am using a Zdx MultiTech modem and installed the driver but as yet the nch swift is refusing to set it as a Tapi device. Could you help? Any circumstance, is that I would like to know how I would be able to grep the cli, start of call and end of call so that I will upload details into a database and be used as a call data record. Would appreciate your feedback. Thanks Hi,I personally have not used stored procedures, but I don't see why it would not work. I would think that any odbc driver that supports stored procedures should work with the sql plugin. In my experience I have noticed that quite often I miss obvious things that are revealed upon closer examination. Some of my future projects may require me to use stored procedures, so if I have success, I'll let you know. <{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
lawrence Posted February 25, 2006 Author Share Posted February 25, 2006 Hi,I thank you for your interest if you need any help on stored procedure using sql 2000 I would try to help you. I managed to use stored procedure but as I told you not able to return back values. As a matter of fact I had finished the basis of the callplan and now I am moving to test the callplan using a TAPI. In fact I am finding difficulties in setting a voice modem to be 100% TAPI compliant. I am using a Zdx MultiTech modem and installed the driver but as yet the nch swift is refusing to set it as a Tapi device. Could you help? Any circumstance, is that I would like to know how I would be able to grep the cli, start of call and end of call so that I will upload details into a database and be used as a call data record. Would appreciate your feedback. Thanks <{POST_SNAPBACK}> Hi, Would anyone provide details of any site where to download TAPI driver? I would like to download a TAPI driver for Zdx MultiTech modem. Would anyone provide details of how to log call data record details i.e. The calling and called number, start time and duration of call. Thanks. Link to comment Share on other sites More sharing options...
chinoy Posted April 28, 2006 Share Posted April 28, 2006 Hi,Would anyone provide details of any site where to download TAPI driver? I would like to download a TAPI driver for Zdx MultiTech modem. Would anyone provide details of how to log call data record details i.e. The calling and called number, start time and duration of call. Thanks. <{POST_SNAPBACK}> Regarding the stored procedures. I think I'll take up on your offer. Although I use Fox Pro database, I think using stored procedures will help me. Any assistance you can give me is appreciated Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now