nchroy

I run SQLLink plugin from command line like this:

 

sqllink mydsn "SELECT Name FROM Friends"

 

and it returns:

Rowcount=-1&Result=Okay&Name=Mike&FROM=Mike&copyright=NCH Swift Sound

 

Table Freinds have 2 records (Mike and William), but plugin returns only one and Rowcount=-1

Please help.

One of our customers supplied the following information :

I have not used the SQLLink plugin to return multiple variables but I would

first check my query to make sure I get the desired results in the database

program that I use. For example I am using Access, I write the query in

access and then execute it to make sure I get the results I need. Then I

view the SQL and copy it and paste it into the OGM plugin setup criteria and

modify the variables to be variables I pass from IVM (i.e. SELECT %Friend%

FROM Friends).

FYI - I have had problems with long SQL queries getting truncated by IVM,

which forced me to make two database queries to get all the information I

wanted from the database. I also had problems with pulling text information

in as values because Access requires double quotes to be used around text

when making calls to the database. When you use quotes in the call executed

in the plugin the query gets truncated and will not work. Therefore the

lesson learned is to try to make calls to the database using numerical

values or single word text values as variables to avoid this from happening.

Hope this helps.

After installing Express scribe and playing around with the footpedals awhile I inadvertently put it to done and now the sound of the welcome txt message doesn't come up at all, so I cannot use my footpedals to practice. I have no way of having someone send me transcription via phone till I take a test with a company, any way to install the Express scribe welcome txt message without uninstalling and reinstalling.....thanks

The easiest way to get the "welcome" file back is to download and install a new copy of Express Scribe over your existing copy. You could also reload the file from the following folder : C:\Program Files\NCH Swift Sound\Scribe\Done Files

Roy

I have worked with a number of these applications over the years, yours is great.

 

I was able to get an entire office of 10 people (7 of them remote locations) built up in little more then a few hours. But I am having 1 problem.... understanding the logistical flow of the Data Entry feature. I have a Data Entry OGM to enable callers to emter a 3 digit extension, and then get to transfered to another OGM (to offer distribution choice) or mailbox depending on the individual's circumstances. It appears to me that I have to establish an association between the extension number for each employee and the OGM or mailbox I want them directed to. I believe this is referred to as a "variable name"? Herein lies my confusion. How and where do I set up this tab delimited file? What is the format? Do you have any samples I could use as a template? I've reviewed the manual and I just don't get it.

 

Thanks.

I am not sure that I understand what your problem is but perhaps the following suggestions will help.

~ The data entered is given a variable name in the OGM - eg "number" . This variable can be used later in the IVM as %number%.

~ For example you might be able to use %number% as the number in the call transfer window.

~ You might be able to use %number% as the name of a mailbox in the leave message .. menu item .

~ Have a look in the example on our website for 0 - 1000 mailboxes.

~ Always test your setup using the call simulator and view the consequence of a change by opening the system log ( in file//view or print logs) after ever change.

Roy

I just registered. This topic is mine. I posted prior to registering.

 

John

John,

It sounds as if one of the modems is mis-interpreting part of the message as a dtmf tone. Have a look in the system logs ( file//view or print logs) to see what is happening.

We generally recommend a telephony board ( eg CallURL) for more than one line.

Roy

We have had good reports about the compatibility of the Multi-Tech MT5656ZDXV voice modem .