QueueMetrics > QueueMetrics news

QueueMetrics 12.01 has been released today

(1/1)

QueueMetrics:
A new version of QueueMetrics is now available, which offers a variety of new features that we are sure you will find very useful.

The first point we want to highlight is the new QueueMetrics versioning system. This has changed, in order to reflect and easily identify the release version versus the release period: the new versions will be the year plus the month of the release. So, this latest release will be version 12.01, which indicates that this release took place in the year 2012 (12), during the month of January (01).

The next major addition is within our reporting, whereas the Custom Reports now offer Non-Contiguous Times which means that one can select the days of the week and the time period that  we want to obtain a report on, and we have also introduced the Agent time by Hour feature where we can view a report on an agent's activity, subdivided in hourly time slots.

The new release offers an improved user experience by allowing calls to be listed in a paginated format that is a lot more readable than previous straightforward listings and by offering per-user persistence settings whereas user search configuration is stored and kept even after log off and can be changed and re-stored at any stage. 

We have also improved QueueMetrics' integration with Asterisk via the handling of “friendly names” and support for MySQL live logging, and our Quality Assessment functionalities by including additional features such as the possibility of filling out QA forms directly from the Agent page.

Last but not least QueueMetrics now offers the option to listen to recordings that are stored in an encrypted format and it can adapt to almost any encryption technology.

Please rest assured that this release works with the same activation keys you used for your current version of QueueMetrics.


Major changes:

# 1364      Agent times by hour
# 1369      Call tagging
# 1383      Paginated call display
# 1385      Realtime on Asterisk 1.8
# 1405      Non-contiguous reports
# 1470      Friendly names handling
# 1492      Encrypted files playback
# 1511    Persistent user properties
# 1519      QA from Agent page

Minor changes:

# 1008    Direct link to Licence page
# 1013      Configuration wizard improvement
# 1073      Purging of completed calls
# 1215      Direct logging for Asterisk 1.8
# 1229      DBtester fix for upgrades
# 1287      English syntax amendments
# 1303      Active tags in the Oreka player
# 1334    XML-CSV export fix
# 1336      Fix for Items editing in QA forms
# 1338      Scoring of N/A values in QA forms
# 1348      Pause code in the Payroll report
# 1349      Agent occupancy on pause during calls
# 1361      Digits displayed for floating-point numbers
# 1362      New file types for call attachments
# 1363      Dynamic call list popups
# 1368      XMI-RPC call to tag calls
# 1370      Tags on call details popup
# 1371      Tags on QA page
# 1373      Addition of process field for tasks
# 1375      XML-RPC call for broadcast messages
# 1376      Additional Task status statistics
# 1377      Optional task disputes
# 1378      Additional task types
# 1381      Data export for call popups
# 1390      Hotdesking attributes read fix   
# 1477      Sidebar compatibility with Firefox 7
# 1490    RingTime computed values fix
# 1498      Dbupdater fields presence fix
# 1516      Icons mouse-over text

adz:
Hello,

Looks like "#1348 - Pause code in the Payroll report" has not been fixed.

Still get the following error:


--- Code: ---"Error (tech) in class 'it.loway.app.queuemetrics.payroll.pauseCodeChange'. -- Inner Exception -- - Exception: it.loway.tpf.common.exceptions.TechException - - Stack trace: - Problem updating DB: Database error: - -- Inner Exception -- - Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException - Error: - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 - Stack trace: - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 - at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) - at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) - at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) - at java.lang.reflect.Constructor.newInstance(Constructor.java:513) - at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) - at com.mysql.jdbc.Util.getInstance(Util.java:381) - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) - at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) - at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) - at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) - at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) - at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536) - at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1564) - at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1485) - at it.loway.tpf.SQL.updateSql(SQL.java:164) - at it.loway.app.queuemetrics.payroll.payrollEngineMover.applyChanges(payrollEngineMover.java:222) - at it.loway.app.queuemetrics.payroll.payrollEnginePauseMover.standardizePauseInLog(payrollEnginePauseMover.java:216) - at it.loway.app.queuemetrics.payroll.payrollEnginePCodeChanger.changePauseCode(payrollEnginePCodeChanger.java:53) - at it.loway.app.queuemetrics.payroll.pauseCodeChange.doRun(pauseCodeChange.java:80) - at it.loway.tpf.transaction.servlets.LowayTransactionController.runVerb(LowayTransactionController.java:276) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(LowayTransactionController.java:566) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(LowayTransactionController.java:387) - at it.loway.tpf.transaction.servlets.LowayTransactionController.doPost(LowayTransactionController.java:238) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:647) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) - at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) - at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:873) - at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) - at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) - at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) - at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) - at java.lang.Thread.run(Thread.java:619) - -- End Inner Exception -- - - When running: DELETE FROM `queue_log` WHERE `partition` = 'P000' AND `time_id` = '1327596297' AND `call_id` = '1327596297.170066' AND `queue` = 'NONE' AND `agent` = 'Agent/1002' AND `verb` = 'PAUSEREASON' AND `serverid` = '' AND `unique_row_count` = - at it.loway.tpf.SQL.updateSql(SQL.java:167) - at it.loway.app.queuemetrics.payroll.payrollEngineMover.applyChanges(payrollEngineMover.java:222) - at it.loway.app.queuemetrics.payroll.payrollEnginePauseMover.standardizePauseInLog(payrollEnginePauseMover.java:216) - at it.loway.app.queuemetrics.payroll.payrollEnginePCodeChanger.changePauseCode(payrollEnginePCodeChanger.java:53) - at it.loway.app.queuemetrics.payroll.pauseCodeChange.doRun(pauseCodeChange.java:80) - at it.loway.tpf.transaction.servlets.LowayTransactionController.runVerb(LowayTransactionController.java:276) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(LowayTransactionController.java:566) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(LowayTransactionController.java:387) - at it.loway.tpf.transaction.servlets.LowayTransactionController.doPost(LowayTransactionController.java:238) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:647) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) - at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) - at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:873) - at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) - at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) - at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) - at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) - at java.lang.Thread.run(Thread.java:619) - -- End Inner Exception -- - "
--- End code ---

QueueMetrics:
It seems like the fix we did was not related to the very case you are experiencing.
We added a new bug #1543 - Please contact support [@] loway.ch to arrange for a dump of the DB so we can replicate your case.

coolname:
could show how to use the new feature in user manaual?

Navigation

[0] Message Index