Author Topic: Generating customised reports using XML RPC  (Read 8000 times)

tank30

  • Newbie
  • *
  • Posts: 46
  • Karma: 0
    • View Profile
Generating customised reports using XML RPC
« on: July 15, 2008, 16:14:59 »
I would like to make my own reports using XML RPC but I am a bit lost on what exactly i need to do  (what data to read , etc).
for example i would like to have a report for each agent that would tell me how much of the time that is logged in was idle and how much  time was used for talking to customers. This should be done on a daily, weekly , monthly basis, etc. So basically for Agent 361 i would like to know if for today he spent 40 minutes  (80%) idle and 10 minutes (20%) talking to customers, out of 50 minutes logged in time in total for the day.
also i would like to have this report for all agents as a team ,  per queue or queueset.
Anyone care to help?   ;)

thanks
KM

tank30

  • Newbie
  • *
  • Posts: 46
  • Karma: 0
    • View Profile
Re: Generating customised reports using XML RPC
« Reply #1 on: July 22, 2008, 09:27:24 »
Help  anyone please?
 ::)


KM

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Generating customised reports using XML RPC
« Reply #2 on: July 22, 2008, 09:29:53 »
I would start by querying QM interactivekly to find the dataset sources, and then would add the general logic. I know there are a lot of data sources, but Qm does compute a lot of information.... :)

tank30

  • Newbie
  • *
  • Posts: 46
  • Karma: 0
    • View Profile
Re: Generating customised reports using XML RPC
« Reply #3 on: August 08, 2008, 08:25:48 »
So basically we have no documentation on the queuemetrics datasets and the only way is by exploration?

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Generating customised reports using XML RPC
« Reply #4 on: August 09, 2008, 16:39:47 »
No it's all documented here: http://queuemetrics.com/download/QueueMetrics_XmlRpc_v13.pdf

The exact data is the same as for the result table with the same name, so you firdt look un in QM which datasets you need, then look for their name in the docs, and then you query them.

zpcanada

  • Newbie
  • *
  • Posts: 7
  • Karma: 0
    • View Profile
    • Email
Re: Generating customised reports using XML RPC
« Reply #5 on: November 09, 2009, 06:23:37 »
the above link to the document is invalid. Would you provide the valid link? thanks,

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Generating customised reports using XML RPC
« Reply #6 on: November 09, 2009, 09:57:11 »
Yes it has changed - you can access the HTML version here:
http://queuemetrics.com/manuals/QM_XML-RPC_manual-chunked

You can download a PDF copy from our manual page: http://queuemetrics.com/manual_list.jsp


zpcanada

  • Newbie
  • *
  • Posts: 7
  • Karma: 0
    • View Profile
    • Email
Re: Generating customised reports using XML RPC
« Reply #7 on: November 17, 2009, 07:26:20 »
What is datasets in QM? Can you give me an example that shows matching a dataitem in QM to a XML.RPC call?
Thanks in advance.
No it's all documented here: http://queuemetrics.com/download/QueueMetrics_XmlRpc_v13.pdf

The exact data is the same as for the result table with the same name, so you firdt look un in QM which datasets you need, then look for their name in the docs, and then you query them.

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Generating customised reports using XML RPC
« Reply #8 on: November 17, 2009, 17:02:37 »
All the tables in the reports and the RT page are datasets - you just need to find the proper names.

zpcanada

  • Newbie
  • *
  • Posts: 7
  • Karma: 0
    • View Profile
    • Email
Re: Generating customised reports using XML RPC
« Reply #9 on: November 17, 2009, 17:34:50 »
All the tables in the reports and the RT page are datasets - you just need to find the proper names.

Thanks, but how to find the proper names?


QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Generating customised reports using XML RPC
« Reply #10 on: November 24, 2009, 10:54:55 »
The "correct" answer is: look here:

http://queuemetrics.com/manuals/QM_XML-RPC_manual-chunked/apa.html


...but if you want to know a trick (ssht! don't tell anyone!)  ;)  what I usually do is: I run a  report in Qm and find the block I care for. If you look at the link that is created e.g. to export to Excel, it will be something like:

http ://server:8080/queuemetrics/qm/qm_export_table.do?S.OkDO.StintsOk.828815582

in this case, the name of the block is OkDO.StintsOK.