Messages

61

QueueMetrics installation / Re: Customizing some of the reports - Where are all the data in the database?

« on: November 30, 2010, 16:46:36 »

Thanks but what does 1000 mean in data2?

Can you explain what data1, data2 and other field are in that queue_log table?

62

General Asterisk configuration / What is data1 in Sql table?

« on: November 30, 2010, 00:20:09 »

Hi Everyone,

Can someone please explain what the different fields in the table queue_log table mean?

I want to know specifically what data1 is and other fields are.

E.g:

Code: [Select]

"partition";"time_id";"call_id";"queue";"agent";"verb";"data1";"data2";"data3";"data4";"serverid";"unique_row_count"
"P001";"1285623533";"1285621944.3109";"500";"Local/338@from-internal/n";"RINGNOANSWER";"15000";"";"";"";"";"1"

Thanks

63

QueueMetrics installation / Customizing some of the reports - Where are all the data in the database?

« on: November 29, 2010, 17:41:40 »

Hello,

I am looking to make a customized graph from the data. I am looking at QM database and all I see is the queue_log table that holds some Asterisk related data.

1- I want to know what each row means and where can I get information like the duration of the call, caller number, how long it rang until it was picked up, who was the slowest to pick up, etc....(I know these reports are available on QM but we have an internal system that take advantage of the data)

2- Was the call for extension 334 waiting for so long to be answered? What do below signify? what is 0 and 1000 in data1? What is heartbeat?

Code: [Select]

"partition";"time_id";"call_id";"queue";"agent";"verb";"data1";"data2";"data3";"data4";"serverid";"unique_row_count"
"P001";"1285843585";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843567";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843566";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843565";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843564";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843563";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843562";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843561";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843560";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843559";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843557";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843556";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843555";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843568";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843569";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843570";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843584";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"1000";"";"";"";"";"1"
"P001";"1285843582";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843581";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843580";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843579";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843578";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843577";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843576";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843575";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843574";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843573";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843572";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843554";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843553";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843516";"NONE";"NONE";"NONE";"HEARTBEAT";NULL;"";"";"";"";"1"
"P001";"1285829100";"NONE";"NONE";"NONE";"HEARTBEAT";NULL;"";"";"";"";"1"
"P001";"1285828199";"NONE";"NONE";"NONE";"HEARTBEAT";NULL;"";"";"";"";"1"
"P001";"1285827298";"NONE";"NONE";"NONE";"HEARTBEAT";NULL;"";"";"";"";"1"
"P001";"1285826397";"NONE";"NONE";"NONE";"HEARTBEAT";NULL;"";"";"";"";"1"
"P001";"1285825496";"NONE";"NONE";"NONE";"HEARTBEAT";NULL;"";"";"";"";"1"
"P001";"1285824595";"NONE";"NONE";"NONE";"HEARTBEAT";NULL;"";"";"";"";"1"
"P001";"1285823694";"NONE";"NONE";"NONE";"HEARTBEAT";NULL;"";"";"";"";"1"
"P001";"1285822793";"NONE";"NONE";"NONE";"HEARTBEAT";NULL;"";"";"";"";"1"
"P001";"1285821892";"NONE";"NONE";"NONE";"HEARTBEAT";NULL;"";"";"";"";"1"
"P001";"1285820991";"NONE";"NONE";"NONE";"HEARTBEAT";NULL;"";"";"";"";"1"

Thanks

64

QueueMetrics installation / Re: Bug in Disconnection Cause code

« on: November 23, 2010, 17:07:28 »

When do you expect this and #1216 to be complete or your next release?

Regards,

65

QueueMetrics installation / Bug in Disconnection Cause code

« on: November 22, 2010, 20:38:57 »

Hello,

We are running the latest version of Queuemetrics. If a call is abondoned, on the report we can see it as saying Abondoned but when I press Call Details I see that it says Agent Disconnected. This is contridicting info. If agent disconnected then why is the duration ZERO? If Agent Disconnected is right then there is a bug in duration recording.

How can I know if the agent picked up and disconnected RIGHT AWAY. Can you confirm this as a bug?



-Bruce

66

General Asterisk configuration / Re: Agent portal shows Queue NUMBER instead of Queue Alias. How to fix this?

« on: November 08, 2010, 15:31:58 »

"I did" ?

Do you mean it's fixed? should we update?

Thanks

67

General Asterisk configuration / Re: PAUSE code includes an amigous reason code know as: "-" - Is this a bug?

« on: November 08, 2010, 15:31:09 »

Why without a reason?

The purpose of reasons are to make sure a strict policy is followed.

Please provide the option for us (the users) to chose this as it's a very subjective idea.

In fact, agents can log out without a reason and say they mis-clicked it and there is no way to properly tally their hours spent.

At the very least, the "-" should be option to add or not in the list of the options. Don't you agree?

Thanks

68

General Asterisk configuration / PAUSE code includes an amigous reason code know as: "-" - Is this a bug?

« on: November 06, 2010, 00:47:48 »

Hello,

By default for aesthetic reasons and to avoid confusion a scroll down should include the top value as the default displayed and selected value. However, this doesn't happen for the scroll down of the reason code when an agent wants to go on PAUSE. In fact an agent can chose "-" as the reason code and it shows in the reports.

Please don't tell me it's a bug and has to wait for few months to get solved.

Is there a way to remove this and to only allow the proper reason codes to be picked up?

Thanks

69

General Asterisk configuration / Re: Agent portal shows Queue NUMBER instead of Queue Alias. How to fix this?

« on: November 05, 2010, 15:53:58 »

The same thing happen in Live Monitor as well. Maybe you should add a note in the bug # 1194 to fix this as well.

70

General Asterisk configuration / Re: Agent portal shows Queue NUMBER instead of Queue Alias. How to fix this?

« on: November 04, 2010, 18:58:38 »

:-( Maybe you should open up the code a bit so interested parties can contribute :-)

*** Would definitely be faster time around.

71

General Asterisk configuration / Re: Agent portal shows Queue NUMBER instead of Queue Alias. How to fix this?

« on: November 03, 2010, 16:16:56 »

Maybe we can help with submitting a patch. Can you guide me to the file responsible?

Thanks

72

General Asterisk configuration / Re: Agent portal shows Queue NUMBER instead of Queue Alias. How to fix this?

« on: November 02, 2010, 17:21:50 »

Since the Alias exists in the QM database then it should be a really easy fix to match the number to the Alias and display the Alias instead.

Wondering if you can prioritize this as in a multilingual center it becomes very hard to train reps to numbers and they can't understand why it should be a number rather than the name; hence, laziness kicks in and they don't do a good job of logging in and out since they blame the software.

Thanks

73

General Asterisk configuration / Re: Agent portal shows Queue NUMBER instead of Queue Alias. How to fix this?

« on: November 02, 2010, 03:16:57 »

Anything on this?

74

General Asterisk configuration / Re: Agent portal shows Queue NUMBER instead of Queue Alias. How to fix this?

« on: October 29, 2010, 16:59:50 »

Two pictures below to demonstrate. Agent shows logged in to 500 and 499 instead of English and French.






********************************************

75

General Asterisk configuration / Re: Agent RELOAD BAR is really lazy. Is there a reason for that?

« on: October 29, 2010, 16:56:56 »

Where is it coded to be that lazy? Can the timer be changed?

Thanks