We have 13 stores, each has its own DID and IVR. The IVRs all play the same options. Is there a way to log the IVR option (button) selected so that it can be easily queried using a MySql query?
Right now, our approach is to direct each button press to an exten that is unique to each store then drop the call into a queue for that store. At this point, we are not routing the calls to different places, we just want to capture the key presses for analysis.
So pressing 1 at store 5 goes to 50001 and pressing 2 at store 12 goes to 12002. This is a pain to parse in SQL.
@cynjut Thanks, that is what I’m doing now (substrings) but is prone to error if another, unrelated exten ends in 1 or 2. I’d prefer to build on something that I can be sure won’t be subject to that type of misinterpretation.