Queue report functions not returning attributes consistently

Talk with others about developing applications for Switchvox

Moderators: bmdhacks, dpodolsky, tristand, jwitt, joshuas

Queue report functions not returning attributes consistently

Postby c012294 » Fri Jan 13, 2012 4:41 pm

Hi all,

We're having an issue with using switchvox.callQueueReports.search and switchvox.callQueues.getCurrentStatus not consistently returning all expected attributes. For example, the request:

<?xml version="1.0"?>
<request method="switchvox.callQueueReports.search">
<parameters>
<start_date>2012-01-13 00:00:00</start_date>
<end_date>2012-01-13 23:59:59</end_date>
<ignore_weekends>1</ignore_weekends>
<queue_account_ids>
<queue_account_id>1162</queue_account_id>
</queue_account_ids>
<breakdown>by_queue</breakdown>
<report_fields>
<report_field>total_calls</report_field>
<report_field>completed_calls</report_field>
<report_field>abandoned_calls</report_field>
<report_field>redirected_calls</report_field>
<report_field>longest_queue_length</report_field>
<report_field>avg_entry_position</report_field>
<report_field>max_wait_time_all_calls</report_field>
<report_field>avg_wait_time_all_calls</report_field>
<report_field>max_wait_time_completed_calls</report_field>
<report_field>avg_wait_time_completed_calls</report_field>
<report_field>max_wait_time_abandoned_calls</report_field>
<report_field>avg_wait_time_abandoned_calls</report_field>
<report_field>max_talk_time</report_field>
<report_field>avg_talk_time</report_field>
</report_fields>
<format>xml</format>
<sort_field>account_id</sort_field>
<sort_order>asc</sort_order>
<items_per_page>50</items_per_page>
<page_number>1</page_number>
</parameters>
</request>


often does not return the total calls attribute. This is an example of one of those responses:

<?xml version="1.0" encoding="UTF-8"?>
<response method="switchvox.callQueueReports.search">
<result>
<queues items_per_page="50" page_number="1" total_items="1" total_pages="1">
<queue abandoned_calls="4" account_id="1162" avg_talk_time="203.06" completed_calls="44" display_name="CS" longest_queue_length="2" max_talk_time="990" max_wait_time_abandoned_calls="140" max_wait_time_all_calls="166" max_wait_time_completed_calls="166" redirected_calls="0"/>
</queues>
</result>
</response>

As you can see, the server did not return the "total_calls" attribute, even though it was specified under <report_fields> above. This is wreaking havoc on our ability to create queue reporting dashboards for our supervisors that display the queue numbers along with each agent's call handling information.

Has anyone experienced the same? Is there anything I should be doing differently to ensure that these results are always included? The other one that's killing us is that switchvox.callQueues.getCurrentStatus does not include all attributes for all queue members consistently..."missed_calls" is one that seems to really be hit or miss, and again, we need that data for our dashboard.
c012294
Newsterisk
 
Posts: 9
Joined: Fri Jan 13, 2012 4:33 pm

Re: Queue report functions not returning attributes consistently

Postby dpodolsky » Fri Jan 13, 2012 4:51 pm

What exactly do you mean by when you say you don't get consistent results? Some queues give total_calls some don't? Or that some API requests give total_calls and the SAME api request 5 minutes later doesn't give the attribute? Is it that the same attribute (total_calls) is the only inconsistent one or are others missing?

Alternately, as a work around now. If you are consistently getting abandoned_calls, completed_calls, and redirect_calls. You can just add these totals together to get the total_call value.
dpodolsky
Oldsterisk
 
Posts: 325
Joined: Thu Apr 23, 2009 2:35 pm

Re: Queue report functions not returning attributes consistently

Postby c012294 » Fri Jan 13, 2012 4:56 pm

That's exactly it...if I send the request, I might or might not get all of the attributes. There seems to be no pattern to it. Same API request, crap shoot every time.

There are others missing that I've noticed...the one that's especially bothersome is the "missed_calls" attribute when sending a switchvox.callQueues.getCurrentStatus request.
c012294
Newsterisk
 
Posts: 9
Joined: Fri Jan 13, 2012 4:33 pm

Re: Queue report functions not returning attributes consistently

Postby c012294 » Fri Jan 13, 2012 5:03 pm

Here's an example of that. Notice that some have "missed_calls" and some do not.

Thanks for your quick response to my first post, btw. I really appreciate it.


<response method="switchvox.callQueues.getCurrentStatus">
<result>
<call_queue account_id="1162" extension="110" call_queue_name="CS" strategy="-1">
<queue_members>
<queue_member account_id="1117" extension="267" fullname="Jane Simpson" order="1" logged_in_status="logged_in" login_type="login" talking_to_name="" talking_to_number="" time_of_last_call="" paused_since="" paused="0" completed_calls="3" missed_calls="6" avg_talk_time="274.67" max_talk_time="531" login_time="21830" paused_time="4991" />
<queue_member account_id="1121" extension="314" fullname="Frank Finney" order="2" logged_in_status="logged_off" login_type="login" talking_to_name="" talking_to_number="" time_of_last_call="" paused_since="" paused="0" completed_calls="0" missed_calls="0" avg_talk_time="0" max_talk_time="0" login_time="0" paused_time="0" />
<queue_member account_id="1126" extension="455" fullname="John Reece" order="3" logged_in_status="logged_off" login_type="login" talking_to_name="" talking_to_number="" time_of_last_call="" paused_since="" paused="0" completed_calls="0" avg_talk_time="0" max_talk_time="0" />
<queue_member account_id="1130" extension="470" fullname="Leslie Johannson" order="4" logged_in_status="logged_off" login_type="login" talking_to_name="" talking_to_number="" time_of_last_call="" paused_since="" paused="0" completed_calls="11" missed_calls="4" avg_talk_time="187.27" max_talk_time="508" login_time="27067" paused_time="0" />
<queue_member account_id="1131" extension="472" fullname="Paul Star" order="5" logged_in_status="logged_off" login_type="login" talking_to_name="" talking_to_number="" time_of_last_call="" paused_since="" paused="0" completed_calls="8" missed_calls="9" avg_talk_time="213" max_talk_time="734" login_time="24628" paused_time="0" />
<queue_member account_id="1168" extension="406" fullname="Brian Banter" order="6" logged_in_status="logged_off" login_type="login" talking_to_name="" talking_to_number="" time_of_last_call="" paused_since="" paused="0" completed_calls="0" missed_calls="0" avg_talk_time="0" max_talk_time="0" login_time="0" paused_time="0" />
<queue_member account_id="1170" extension="408" fullname="Susan Wobler" order="7" logged_in_status="logged_off" login_type="login" talking_to_name="" talking_to_number="" time_of_last_call="" paused_since="" paused="0" completed_calls="9" missed_calls="3" avg_talk_time="251.33" max_talk_time="525" login_time="27230" paused_time="0" />
<queue_member account_id="1171" extension="441" fullname="Francis Alexander" order="8" logged_in_status="logged_off" login_type="login" talking_to_name="" talking_to_number="" time_of_last_call="" paused_since="" paused="0" completed_calls="3" missed_calls="8" avg_talk_time="352.33" max_talk_time="661" login_time="21613" paused_time="1782" />
<queue_member account_id="1107" extension="214" fullname="Michelle Mark" order="9" logged_in_status="logged_off" login_type="login" talking_to_name="" talking_to_number="" time_of_last_call="2011-12-29 16:20:10" paused_since="" paused="0" completed_calls="10" missed_calls="7" avg_talk_time="184" max_talk_time="990" login_time="34095" paused_time="0" />
<queue_member account_id="1132" extension="500" fullname="Gigi Klure" order="10" logged_in_status="logged_off" login_type="login" talking_to_name="" talking_to_number="" time_of_last_call="2012-01-11 16:28:29" paused_since="" paused="0" completed_calls="0" missed_calls="0" avg_talk_time="0" max_talk_time="0" login_time="0" paused_time="0" />
</queue_members>
<waiting_callers>
</waiting_callers>
</call_queue>
</result>
</response>
c012294
Newsterisk
 
Posts: 9
Joined: Fri Jan 13, 2012 4:33 pm

Re: Queue report functions not returning attributes consistently

Postby c012294 » Sat Jan 14, 2012 5:13 pm

Just as an added note...I have ruled out my client as the culprit by testing using the online request generator on the Digium site. Same thing...if I hit send several times in a row, sometimes I get the attributes and sometimes I don't. Very frustrating.

Edit: Aha! I used my old demo account on demo3.switchvox.com to test and it does not seem to be displaying this behavior! Our system is running 5.1.2 (40062) and demo3.switchvox.com is running 5.0.1 (34916). Could something have been broken in the newer releases?
c012294
Newsterisk
 
Posts: 9
Joined: Fri Jan 13, 2012 4:33 pm

Re: Queue report functions not returning attributes consistently

Postby c012294 » Wed Jan 18, 2012 9:18 am

<cricket...cricket>

I opened a support ticket for this issue with Digium, will post the results.
c012294
Newsterisk
 
Posts: 9
Joined: Fri Jan 13, 2012 4:33 pm

Re: Queue report functions not returning attributes consistently

Postby c012294 » Tue Jan 24, 2012 7:15 pm

Less than stellar response from Digium support. The last response from them was on the 18th, nothing since.
c012294
Newsterisk
 
Posts: 9
Joined: Fri Jan 13, 2012 4:33 pm

Re: Queue report functions not returning attributes consistently

Postby c012294 » Thu Jan 26, 2012 2:52 pm

Ok, received a response from Digium support today. Not quite what I was expecting.


"We do not support API's at this support office. Your best option for support on this API issue will be to use our developers forums found here:

viewforum.php?f=29

Our developers of the Switchvox software respond to questions on the above site. This is going to be your best source of information for your API issue.

Thanks,"



So we're back at square one. Are there Switchvox developers reading this forum? Can someone verify the issue and help?
c012294
Newsterisk
 
Posts: 9
Joined: Fri Jan 13, 2012 4:33 pm

Re: Queue report functions not returning attributes consistently

Postby lorsungcu » Thu Jan 26, 2012 9:57 pm

Podolsky is a developer, he'd be the guy to answer your questions. My guess is that he will be quite busy the next few weeks.

I'll try to reproduce the issue, and if I can, I'll open a ticket.
lorsungcu
Oldsterisk
 
Posts: 116
Joined: Wed Mar 09, 2011 9:30 am

Re: Queue report functions not returning attributes consistently

Postby c012294 » Fri Jan 27, 2012 1:31 pm

Thanks for the reply. If you need any more information from me to open a ticket, I'll provide anything you need to know. If you need access to my box, that can also be arranged.
c012294
Newsterisk
 
Posts: 9
Joined: Fri Jan 13, 2012 4:33 pm

Re: Queue report functions not returning attributes consistently

Postby dpodolsky » Thu Feb 02, 2012 6:50 pm

I have filed the bug report and got an update that at we can reproduce it here. We are seeing the behavior you mentioned in the forum post where randomly some attributes are missing. So far we have only reproduced it on one of the API calls not both. When I have more information I will give this thread and your ticket an update. Thanks for working with us to get this figured out.
dpodolsky
Oldsterisk
 
Posts: 325
Joined: Thu Apr 23, 2009 2:35 pm


Return to Switchvox Developers

Who is online

Users browsing this forum: No registered users and 1 guest