We've Moved! Please visit our new and improved forum over at our new portal: https://portal.plumvoice.com/hc/en-us/community/topics
Comparing a DTMF entry to a variable
-
- Posts: 69
- Joined: Wed Feb 24, 2010 5:59 pm
- Location: Chagrin Falls, OH
- Contact:
Comparing a DTMF entry to a variable
I want to enter a transaction number that has to a agree with a variable we passed from our main database application into the Plum database and the stack. Our variable identifies the record being verified. I assumed that I can do a Digits Input then compare it to our variable using an Inputs Properties "Input mode". Then, if the two agree, we move on. If not, we go through some counters to decide. Is that a correct approach? What name would I give the Digit Input as it is not the variable I am comparing it to?
DMIVS
Comparing IVR input to database variable
Hi,
About your post, would you please verify a few things for us:
1) The variable that is passed from your database. Would this variable be a series of digits? If so, you shouldn't have any problems comparing this variable to any digits the user inputs via the digit input module.
2) Why do you need to check to see if the digit input was DTMF? The module can be limited to only accept DTMF inputs.
Thanks for clarifying!
Regards,
Plum Support
About your post, would you please verify a few things for us:
1) The variable that is passed from your database. Would this variable be a series of digits? If so, you shouldn't have any problems comparing this variable to any digits the user inputs via the digit input module.
2) Why do you need to check to see if the digit input was DTMF? The module can be limited to only accept DTMF inputs.
Thanks for clarifying!
Regards,
Plum Support
Plum Support
http://www.plumvoice.com
http://www.plumvoice.com
-
- Posts: 69
- Joined: Wed Feb 24, 2010 5:59 pm
- Location: Chagrin Falls, OH
- Contact:
Variable string
Actually it is a character string, though I can modify it to be all numbers and, consequently, input by the caller. In certain cases the caller has to enter the character string to get started on the questions. Consequently, I thought about using numbers only. So, back to my question. Am I approaching it correctly?
DMIVS
Comparing IVR input to database variable
Hi,
You should be able to compare the string of numbers you retrieve from the database with a set of digits from the digits input module. From what we can understand your application should look like this:
Start> Query Database> Get Row from Stack> Digits Input> Branch on Number> Rest of Application
The branch on number should be set up to compare the variable for the Digits Input with the variable you name in the Get Row from Stack module.
Note that by default the Get Row from Stack module expects you to name your variable the same as the column name in the table you just queried. If you want to fetch the value into a differently named variable, you need to use the Reassign Names option in the module menu.
You can name your digits input anything memorable, as long as it is different from the variable you are comparing it with in the Branch on Number module.
Hope this helps.
Regards,
Plum Support
You should be able to compare the string of numbers you retrieve from the database with a set of digits from the digits input module. From what we can understand your application should look like this:
Start> Query Database> Get Row from Stack> Digits Input> Branch on Number> Rest of Application
The branch on number should be set up to compare the variable for the Digits Input with the variable you name in the Get Row from Stack module.
Note that by default the Get Row from Stack module expects you to name your variable the same as the column name in the table you just queried. If you want to fetch the value into a differently named variable, you need to use the Reassign Names option in the module menu.
You can name your digits input anything memorable, as long as it is different from the variable you are comparing it with in the Branch on Number module.
Hope this helps.
Regards,
Plum Support
Last edited by support on Mon Mar 01, 2010 3:15 pm, edited 1 time in total.
Plum Support
http://www.plumvoice.com
http://www.plumvoice.com
-
- Posts: 69
- Joined: Wed Feb 24, 2010 5:59 pm
- Location: Chagrin Falls, OH
- Contact:
Getting row
If I have a unique identifier for a row, how do I address the Query Database function to fetch the matching row. I would think my caller could enter the Digits Input and could trigger the function. This is important when my callers are randomly calling back to complete a questionnaire or to leave a fax number for us to forward a form. In the outbounds, we will trigger the questionnaires one at a time so the variables are used and completed without issue as to row. They are clearly the "next" row.
DMIVS
Use the filter function of Query Database to only return the row that matches your unique identifier. If your caller is entering the unique identifier in the Digits input, you use that as the variable value for your filter. It would look something like the following:
and then the first and only row that you would get with a Get Row from Stack module would be the one matching your unique identifier.
If you don't get a row, then no rows in the table matched what the user entered, and you can branch off to an error message.
Code: Select all
select from <table>
filter matching all of the following:
<column> = <variable from digits input>
If you don't get a row, then no rows in the table matched what the user entered, and you can branch off to an error message.
Plum Support
http://www.plumvoice.com
http://www.plumvoice.com