QueueMetrics forum

QueueMetrics => Scripting QueueMetrics => Topic started by: tank30 on July 15, 2008, 16:14:59

Title: Generating customised reports using XML RPC
Post by: tank30 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
Title: Re: Generating customised reports using XML RPC
Post by: tank30 on July 22, 2008, 09:27:24: Help anyone please?
::)

KM
Title: Re: Generating customised reports using XML RPC
Post by: QueueMetrics 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.... :)
Title: Re: Generating customised reports using XML RPC
Post by: tank30 on August 08, 2008, 08:25:48: So basically we have no documentation on the queuemetrics datasets and the only way is by exploration?
Title: Re: Generating customised reports using XML RPC
Post by: QueueMetrics 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.
Title: Re: Generating customised reports using XML RPC
Post by: zpcanada on November 09, 2009, 06:23:37: the above link to the document is invalid. Would you provide the valid link? thanks,
Title: Re: Generating customised reports using XML RPC
Post by: QueueMetrics 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
Title: Re: Generating customised reports using XML RPC
Post by: zpcanada 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.
Quote from: QueueMetrics 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.
Title: Re: Generating customised reports using XML RPC
Post by: QueueMetrics 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.
Title: Re: Generating customised reports using XML RPC
Post by: zpcanada on November 17, 2009, 17:34:50: Quote from: QueueMetrics 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.

Thanks, but how to find the proper names?
Title: Re: Generating customised reports using XML RPC
Post by: QueueMetrics 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.