ReleaseNotes9:Linux Reporting: Difference between revisions
Jump to navigation
Jump to search
m regular roadmap update |
m regular roadmap update |
||
| Line 24: | Line 24: | ||
|[http://mantis.innovaphone.com/view.php?id=63134 63134] | |[http://mantis.innovaphone.com/view.php?id=63134 63134] | ||
|} | |} | ||
If the CDR contains no name on it, make a LDAP query to the PBX before writing the CDR into the database.<br/>Try with OPENLDAP library. | If the CDR contains no name on it, make a LDAP query to the PBX before writing the CDR into the database.<br/>Try with OPENLDAP library.<!----> | ||
=== reporting: replication not running ssl === | === reporting: replication not running ssl === | ||
| Line 35: | Line 35: | ||
|[http://mantis.innovaphone.com/view.php?id=63933 63933] | |[http://mantis.innovaphone.com/view.php?id=63933 63933] | ||
|} | |} | ||
configure postgresql to run ssl during replication. We will use the web server certificate. | configure postgresql to run ssl during replication. We will use the web server certificate.<!----> | ||
=== reporting: added delete tag in application xml file === | === reporting: added delete tag in application xml file === | ||
| Line 46: | Line 46: | ||
|[http://mantis.innovaphone.com/view.php?id=63936 63936] | |[http://mantis.innovaphone.com/view.php?id=63936 63936] | ||
|} | |} | ||
delete tag defines which files/directories must be deleted during uninstall | delete tag defines which files/directories must be deleted during uninstall<!----> | ||
=== Reporting: separate authentication for reporting web access === | === Reporting: separate authentication for reporting web access === | ||
| Line 57: | Line 57: | ||
|[http://mantis.innovaphone.com/view.php?id=64875 64875] | |[http://mantis.innovaphone.com/view.php?id=64875 64875] | ||
|} | |} | ||
It is now possible to configure a separate authentication to the innovaphone reporting web site.<br/> | It is now possible to configure a separate authentication to the innovaphone reporting web site.<br/><!----> | ||
=== reporting: download xml report if it has an invalid format === | === reporting: download xml report if it has an invalid format === | ||
| Line 68: | Line 68: | ||
|[http://mantis.innovaphone.com/view.php?id=64882 64882] | |[http://mantis.innovaphone.com/view.php?id=64882 64882] | ||
|} | |} | ||
we offer now a link to download the xml report if it has an invalid format and therefore cannot be displayed by the browser. | we offer now a link to download the xml report if it has an invalid format and therefore cannot be displayed by the browser.<!----> | ||
=== reporting: LDAP: add Name and Number attributes === | === reporting: LDAP: add Name and Number attributes === | ||
| Line 79: | Line 79: | ||
|[http://mantis.innovaphone.com/view.php?id=64919 64919] | |[http://mantis.innovaphone.com/view.php?id=64919 64919] | ||
|} | |} | ||
we have added two new fields for Name and Number Attributes in the LDAP configuration. <br/>So far we had just used "displayName" as Name attribute and "mobile,telephoneNumber and HomePhone" as Number attributes. | we have added two new fields for Name and Number Attributes in the LDAP configuration. <br/>So far we had just used "displayName" as Name attribute and "mobile,telephoneNumber and HomePhone" as Number attributes.<!----> | ||
=== reporting: improvements on xml/pdf representation === | === reporting: improvements on xml/pdf representation === | ||
| Line 90: | Line 90: | ||
|[http://mantis.innovaphone.com/view.php?id=65151 65151] | |[http://mantis.innovaphone.com/view.php?id=65151 65151] | ||
|} | |} | ||
we usually use information on the alarm event but conn event normally contains more data. Check which one is better.<br/><br/>pdf looks strange if LDAP returns large strings | we usually use information on the alarm event but conn event normally contains more data. Check which one is better.<br/><br/>pdf looks strange if LDAP returns large strings<!----> | ||
=== reporting: suppress last digits of called/calling party for external calls === | === reporting: suppress last digits of called/calling party for external calls === | ||
| Line 101: | Line 101: | ||
|[http://mantis.innovaphone.com/view.php?id=65259 65259] | |[http://mantis.innovaphone.com/view.php?id=65259 65259] | ||
|} | |} | ||
allow to suppress last digits of called/calling party for external calls. It can be configured how many digits must be replaced with a '*'. | allow to suppress last digits of called/calling party for external calls. It can be configured how many digits must be replaced with a '*'.<!----> | ||
=== reporting: diagnostics page available with logs/rpcap === | === reporting: diagnostics page available with logs/rpcap === | ||
| Line 112: | Line 112: | ||
|[http://mantis.innovaphone.com/view.php?id=65365 65365] | |[http://mantis.innovaphone.com/view.php?id=65365 65365] | ||
|} | |} | ||
The diagnostics page with reporting related log files and rpcap functionality is now also available on the reporting web site. | The diagnostics page with reporting related log files and rpcap functionality is now also available on the reporting web site.<!----> | ||
=== Reporting: transfers on a slave PBX will now generate a new event: transfer-remote === | === Reporting: transfers on a slave PBX will now generate a new event: transfer-remote === | ||
| Line 123: | Line 123: | ||
|[http://mantis.innovaphone.com/view.php?id=65475 65475] | |[http://mantis.innovaphone.com/view.php?id=65475 65475] | ||
|} | |} | ||
when a transfer event happens on a slave PBX, it cannot be known the status of the call afterwards. This new event indicates this situation and a connected status will be shown in the report. | when a transfer event happens on a slave PBX, it cannot be known the status of the call afterwards. This new event indicates this situation and a connected status will be shown in the report.<!----> | ||
=== reporting: show only one CDR for transfer/forward calls per user === | === reporting: show only one CDR for transfer/forward calls per user === | ||
| Line 134: | Line 134: | ||
|[http://mantis.innovaphone.com/view.php?id=65820 65820] | |[http://mantis.innovaphone.com/view.php?id=65820 65820] | ||
|} | |} | ||
Currently both generated CDRs for a user of a transfer or forward call are shown. Diversions are now divided in two CDRs, one showing the whole call flow and another containing billing information, which will not be shown in call lists. | Currently both generated CDRs for a user of a transfer or forward call are shown. Diversions are now divided in two CDRs, one showing the whole call flow and another containing billing information, which will not be shown in call lists.<!----> | ||
== Bug Fixes == | == Bug Fixes == | ||
| Line 149: | Line 149: | ||
|[http://mantis.innovaphone.com/view.php?id=63709 63709] | |[http://mantis.innovaphone.com/view.php?id=63709 63709] | ||
|} | |} | ||
If one has never configured replication or ldap for Reporting, a reporting callback request from mypbx won't work (the process crashes).<br/>This is fixed now by checking a config parameter. | If one has never configured replication or ldap for Reporting, a reporting callback request from mypbx won't work (the process crashes).<br/>This is fixed now by checking a config parameter.<!----> | ||
=== reporting: wrong remote party in some transfer and forward events === | === reporting: wrong remote party in some transfer and forward events === | ||
| Line 160: | Line 160: | ||
|[http://mantis.innovaphone.com/view.php?id=63819 63819] | |[http://mantis.innovaphone.com/view.php?id=63819 63819] | ||
|} | |} | ||
We assumed that the remote party does not change after transfer/forward event and that the next event after those contains more information over the remote party but this is wrong since the remote party may change. | We assumed that the remote party does not change after transfer/forward event and that the next event after those contains more information over the remote party but this is wrong since the remote party may change.<!----> | ||
=== reporting: process.fcgi crashes with filters containing a remote number condition === | === reporting: process.fcgi crashes with filters containing a remote number condition === | ||
| Line 171: | Line 171: | ||
|[http://mantis.innovaphone.com/view.php?id=63878 63878] | |[http://mantis.innovaphone.com/view.php?id=63878 63878] | ||
|} | |} | ||
forgot to open parenthesis<br/>conn_length was also forgotten to change to conn_duration | forgot to open parenthesis<br/>conn_length was also forgotten to change to conn_duration<!----> | ||
=== Reporting: better visibility of replication status === | === Reporting: better visibility of replication status === | ||
| Line 182: | Line 182: | ||
|[http://mantis.innovaphone.com/view.php?id=63920 63920] | |[http://mantis.innovaphone.com/view.php?id=63920 63920] | ||
|} | |} | ||
The connection status to the configured replication server is now shown.<br/>The last run is now also shown, even if there was no successful database connection. | The connection status to the configured replication server is now shown.<br/>The last run is now also shown, even if there was no successful database connection.<!----> | ||
=== reporting: if conn to/from event present, conn-duration must be at least one === | === reporting: if conn to/from event present, conn-duration must be at least one === | ||
| Line 193: | Line 193: | ||
|[http://mantis.innovaphone.com/view.php?id=64267 64267] | |[http://mantis.innovaphone.com/view.php?id=64267 64267] | ||
|} | |} | ||
Sometimes conn event and disc/rel event present the same time. Maybe, this should be changed in PBX but we check it anyway.<br/>Connected time must be at least 1. This is also applicable for billing. | Sometimes conn event and disc/rel event present the same time. Maybe, this should be changed in PBX but we check it anyway.<br/>Connected time must be at least 1. This is also applicable for billing.<!----> | ||
=== reporting: mypbx missed calls wrong for multiple registrations === | === reporting: mypbx missed calls wrong for multiple registrations === | ||
| Line 204: | Line 204: | ||
|[http://mantis.innovaphone.com/view.php?id=65103 65103] | |[http://mantis.innovaphone.com/view.php?id=65103 65103] | ||
|} | |} | ||
If one user has multiple registrations, missed calls were recognized, although the calls has been answered.<br/>Calls from other registrations are disregarded now. | If one user has multiple registrations, missed calls were recognized, although the calls has been answered.<br/>Calls from other registrations are disregarded now.<!----> | ||
=== reporting: show call duration time instead of conn duration time in report === | === reporting: show call duration time instead of conn duration time in report === | ||
| Line 215: | Line 215: | ||
|[http://mantis.innovaphone.com/view.php?id=65132 65132] | |[http://mantis.innovaphone.com/view.php?id=65132 65132] | ||
|} | |} | ||
As the whole call flow is shown in the report, showing the call duration makes more sense. | As the whole call flow is shown in the report, showing the call duration makes more sense.<!----> | ||
=== reporting: conn, call and billing time calculation === | === reporting: conn, call and billing time calculation === | ||
| Line 226: | Line 226: | ||
|[http://mantis.innovaphone.com/view.php?id=65146 65146] | |[http://mantis.innovaphone.com/view.php?id=65146 65146] | ||
|} | |} | ||
billing calls are those having "from", "ct" or "cf" as dir attribute in cdrs. So far we have only considered calls with a setup-from as first event but "ct" and "cf" calls can present a setup-to event and they must be charged too.<br/><br/>all times must be ended with the first disc event.<br/><br/>conn time must not be counted after a transfer-from or cf-from event. | billing calls are those having "from", "ct" or "cf" as dir attribute in cdrs. So far we have only considered calls with a setup-from as first event but "ct" and "cf" calls can present a setup-to event and they must be charged too.<br/><br/>all times must be ended with the first disc event.<br/><br/>conn time must not be counted after a transfer-from or cf-from event.<!----> | ||
=== reporting: allow two or more LDAP configurations to have same PBX name === | === reporting: allow two or more LDAP configurations to have same PBX name === | ||
| Line 237: | Line 237: | ||
|[http://mantis.innovaphone.com/view.php?id=65253 65253] | |[http://mantis.innovaphone.com/view.php?id=65253 65253] | ||
|} | |} | ||
it is needed if you have more than one trunk. | it is needed if you have more than one trunk.<!----> | ||
= V1 Hotfix 2 (10197) = | = V1 Hotfix 2 (10197) = | ||
| Line 256: | Line 256: | ||
|[http://mantis.innovaphone.com/view.php?id=66271 66271] | |[http://mantis.innovaphone.com/view.php?id=66271 66271] | ||
|} | |} | ||
debian update for postgresql 8.4. | debian update for postgresql 8.4.<!----> | ||
== Bug Fixes == | == Bug Fixes == | ||
| Line 271: | Line 271: | ||
|[http://mantis.innovaphone.com/view.php?id=66757 66757] | |[http://mantis.innovaphone.com/view.php?id=66757 66757] | ||
|} | |} | ||
avoid writing a CDR to the DB if it is being restored since this could corrupt the DB. <br/>This CDR will be sent by the PBX again since Linux is responding with 500 HTTP Error Code. | avoid writing a CDR to the DB if it is being restored since this could corrupt the DB. <br/>This CDR will be sent by the PBX again since Linux is responding with 500 HTTP Error Code.<!----> | ||
=== Cumulative hotfix installation script didn't apply second hotfix === | === Cumulative hotfix installation script didn't apply second hotfix === | ||
| Line 282: | Line 282: | ||
|[http://mantis.innovaphone.com/view.php?id=66917 66917] | |[http://mantis.innovaphone.com/view.php?id=66917 66917] | ||
|} | |} | ||
As the version of the previously installed hotfix hasn't been set properly. | As the version of the previously installed hotfix hasn't been set properly.<!----> | ||
=== Reporting: current password was not checked before setting a new password === | === Reporting: current password was not checked before setting a new password === | ||
| Line 293: | Line 293: | ||
|[http://mantis.innovaphone.com/view.php?id=67386 67386] | |[http://mantis.innovaphone.com/view.php?id=67386 67386] | ||
|} | |} | ||
we used localhost and given password to make a connection to the db but localhost needs no password. | we used localhost and given password to make a connection to the db but localhost needs no password.<!----> | ||
= V1 Hotfix 3 (10201) = | = V1 Hotfix 3 (10201) = | ||
| Line 316: | Line 316: | ||
|[http://mantis.innovaphone.com/view.php?id=68123 68123] | |[http://mantis.innovaphone.com/view.php?id=68123 68123] | ||
|} | |} | ||
Certain filter options caused duplicated lines in a report.<br/>This has been fixed by changing the query. | Certain filter options caused duplicated lines in a report.<br/>This has been fixed by changing the query.<!----> | ||
=== Reporting: ldap results were not escaped === | === Reporting: ldap results were not escaped === | ||
| Line 327: | Line 327: | ||
|[http://mantis.innovaphone.com/view.php?id=68654 68654] | |[http://mantis.innovaphone.com/view.php?id=68654 68654] | ||
|} | |} | ||
any string must be 'postgresql' escaped before inserting it into the DB. | any string must be 'postgresql' escaped before inserting it into the DB.<!----> | ||
= V1 Hotfix 4 (10237) = | = V1 Hotfix 4 (10237) = | ||
| Line 346: | Line 346: | ||
|[http://mantis.innovaphone.com/view.php?id=71202 71202] | |[http://mantis.innovaphone.com/view.php?id=71202 71202] | ||
|} | |} | ||
A new button is now available in mypbx to clear the call list. | A new button is now available in mypbx to clear the call list.<!----> | ||
=== possibility to clear log files === | === possibility to clear log files === | ||
| Line 357: | Line 357: | ||
|[http://mantis.innovaphone.com/view.php?id=71714 71714] | |[http://mantis.innovaphone.com/view.php?id=71714 71714] | ||
|} | |} | ||
Log files can be cleared now.<br/>Just system specific log files can't be cleared. | Log files can be cleared now.<br/>Just system specific log files can't be cleared.<!----> | ||
=== added trace level option === | === added trace level option === | ||
| Line 368: | Line 368: | ||
|[http://mantis.innovaphone.com/view.php?id=71857 71857] | |[http://mantis.innovaphone.com/view.php?id=71857 71857] | ||
|} | |} | ||
There is now the possibility to enable further tracing levels. | There is now the possibility to enable further tracing levels.<!----> | ||
=== Increased maximum height of filter list === | === Increased maximum height of filter list === | ||
| Line 379: | Line 379: | ||
|[http://mantis.innovaphone.com/view.php?id=71865 71865] | |[http://mantis.innovaphone.com/view.php?id=71865 71865] | ||
|} | |} | ||
Currently only four filter options can be viewed at a time.<br/><br/>With the fix, the lists height increases from 2 until 16 items until the scrollbar of the list is enabled. | Currently only four filter options can be viewed at a time.<br/><br/>With the fix, the lists height increases from 2 until 16 items until the scrollbar of the list is enabled.<!----> | ||
== Bug Fixes == | == Bug Fixes == | ||
| Line 394: | Line 394: | ||
|[http://mantis.innovaphone.com/view.php?id=71277 71277] | |[http://mantis.innovaphone.com/view.php?id=71277 71277] | ||
|} | |} | ||
Invalid log file entries have been written for mypbx requests, if the reporting database was down. | Invalid log file entries have been written for mypbx requests, if the reporting database was down.<!----> | ||
=== Call list sorting by call duration now numerical, not alphanumerical === | === Call list sorting by call duration now numerical, not alphanumerical === | ||
| Line 405: | Line 405: | ||
|[http://mantis.innovaphone.com/view.php?id=71450 71450] | |[http://mantis.innovaphone.com/view.php?id=71450 71450] | ||
|} | |} | ||
The call list sorting by call duration was alphanumerical, not numerical.<br/>This has been fixed. | The call list sorting by call duration was alphanumerical, not numerical.<br/>This has been fixed.<!----> | ||
=== Viewing log files with invalid chars now possible === | === Viewing log files with invalid chars now possible === | ||
| Line 416: | Line 416: | ||
|[http://mantis.innovaphone.com/view.php?id=71716 71716] | |[http://mantis.innovaphone.com/view.php?id=71716 71716] | ||
|} | |} | ||
Viewing log files with invalid chars is now possible over the diagnostics page. | Viewing log files with invalid chars is now possible over the diagnostics page.<!----> | ||
=== linux: added non-blocking option on flock() call for log files === | === linux: added non-blocking option on flock() call for log files === | ||
| Line 427: | Line 427: | ||
|[http://mantis.innovaphone.com/view.php?id=71838 71838] | |[http://mantis.innovaphone.com/view.php?id=71838 71838] | ||
|} | |} | ||
The flock() call was eventually blocking if the lock could not be acquired. If we do not get the lock after ten attempts, the log trace will be lost. | The flock() call was eventually blocking if the lock could not be acquired. If we do not get the lock after ten attempts, the log trace will be lost.<!----> | ||
=== dynamic list row add/remove doesn't trigger page to top any more === | === dynamic list row add/remove doesn't trigger page to top any more === | ||
| Line 438: | Line 438: | ||
|[http://mantis.innovaphone.com/view.php?id=71957 71957] | |[http://mantis.innovaphone.com/view.php?id=71957 71957] | ||
|} | |} | ||
Adding or removing a line of a dynamic list doesn't trigger the jump to the page top any more. | Adding or removing a line of a dynamic list doesn't trigger the jump to the page top any more.<!----> | ||
= V1 Hotfix 5 (10276) = | = V1 Hotfix 5 (10276) = | ||
| Line 457: | Line 457: | ||
|[http://mantis.innovaphone.com/view.php?id=72391 72391] | |[http://mantis.innovaphone.com/view.php?id=72391 72391] | ||
|} | |} | ||
Reports can be now sent per email. | Reports can be now sent per email.<!----> | ||
=== filter option for report times === | === filter option for report times === | ||
| Line 468: | Line 468: | ||
|[http://mantis.innovaphone.com/view.php?id=73006 73006] | |[http://mantis.innovaphone.com/view.php?id=73006 73006] | ||
|} | |} | ||
A filter can now define report times, e.g. all records between 08:00 and 16:00.<br/> | A filter can now define report times, e.g. all records between 08:00 and 16:00.<br/><!----> | ||
=== reporting: logo and footer for pdf reports === | === reporting: logo and footer for pdf reports === | ||
| Line 479: | Line 479: | ||
|[http://mantis.innovaphone.com/view.php?id=73542 73542] | |[http://mantis.innovaphone.com/view.php?id=73542 73542] | ||
|} | |} | ||
It is now possible to add a logo and footer in pdf reports | It is now possible to add a logo and footer in pdf reports<!----> | ||
=== exclude outgoing calls without number/h323 from mypbx call list === | === exclude outgoing calls without number/h323 from mypbx call list === | ||
| Line 490: | Line 490: | ||
|[http://mantis.innovaphone.com/view.php?id=73561 73561] | |[http://mantis.innovaphone.com/view.php?id=73561 73561] | ||
|} | |} | ||
Calls are not shown anymore, if someone just offhooks and onhooks without dialing. | Calls are not shown anymore, if someone just offhooks and onhooks without dialing.<!----> | ||
== Bug Fixes == | == Bug Fixes == | ||
| Line 505: | Line 505: | ||
|[http://mantis.innovaphone.com/view.php?id=73439 73439] | |[http://mantis.innovaphone.com/view.php?id=73439 73439] | ||
|} | |} | ||
LDAP filters have been moved to the DB.<br/>This makes it easier to replicate them to a standby installation. | LDAP filters have been moved to the DB.<br/>This makes it easier to replicate them to a standby installation.<!----> | ||
= V1 Hotfix 6 (10282) = | = V1 Hotfix 6 (10282) = | ||
| Line 524: | Line 524: | ||
|[http://mantis.innovaphone.com/view.php?id=73944 73944] | |[http://mantis.innovaphone.com/view.php?id=73944 73944] | ||
|} | |} | ||
You can now define a time period and/or a pbx object for which CDRs are deleted in the database. | You can now define a time period and/or a pbx object for which CDRs are deleted in the database.<!----> | ||
=== reporting: test email functionality === | === reporting: test email functionality === | ||
| Line 535: | Line 535: | ||
|[http://mantis.innovaphone.com/view.php?id=75760 75760] | |[http://mantis.innovaphone.com/view.php?id=75760 75760] | ||
|} | |} | ||
under diagnostics kann man ein email senden. So überprüft man ob emails verschickt werden. | under diagnostics kann man ein email senden. So überprüft man ob emails verschickt werden.<!----> | ||
=== reporting: call duration and alert duration in filter settings === | === reporting: call duration and alert duration in filter settings === | ||
| Line 546: | Line 546: | ||
|[http://mantis.innovaphone.com/view.php?id=75764 75764] | |[http://mantis.innovaphone.com/view.php?id=75764 75764] | ||
|} | |} | ||
How long a call was connected or how long a "not connected" call was ringing. | How long a call was connected or how long a "not connected" call was ringing.<!----> | ||
=== reporting: send mails via external server (smtp relay) === | === reporting: send mails via external server (smtp relay) === | ||
| Line 557: | Line 557: | ||
|[http://mantis.innovaphone.com/view.php?id=75903 75903] | |[http://mantis.innovaphone.com/view.php?id=75903 75903] | ||
|} | |} | ||
it is now possible to configure the mail client on Linux to send mails via Exchange. | it is now possible to configure the mail client on Linux to send mails via Exchange.<!----> | ||
== Bug Fixes == | == Bug Fixes == | ||
| Line 572: | Line 572: | ||
|[http://mantis.innovaphone.com/view.php?id=75359 75359] | |[http://mantis.innovaphone.com/view.php?id=75359 75359] | ||
|} | |} | ||
The vm installation was creating a local-host-names file with wrong data and this was making DNS problems. | The vm installation was creating a local-host-names file with wrong data and this was making DNS problems.<!----> | ||
=== reporting: possible buffer overrun reading system processes === | === reporting: possible buffer overrun reading system processes === | ||
| Line 583: | Line 583: | ||
|[http://mantis.innovaphone.com/view.php?id=75645 75645] | |[http://mantis.innovaphone.com/view.php?id=75645 75645] | ||
|} | |} | ||
when restoring db from a backup, we do not accept cdrs. We look the running processes searching from "db-restore" in files whose size is null. I allocated a 1024 bytes thinking that was enough, apparently not. | when restoring db from a backup, we do not accept cdrs. We look the running processes searching from "db-restore" in files whose size is null. I allocated a 1024 bytes thinking that was enough, apparently not.<!----> | ||
=== mypbx call list query optimized for speed === | === mypbx call list query optimized for speed === | ||
| Line 594: | Line 594: | ||
|[http://mantis.innovaphone.com/view.php?id=75646 75646] | |[http://mantis.innovaphone.com/view.php?id=75646 75646] | ||
|} | |} | ||
The query execution lasted quite long, if a user had cleared the call list and less than 20 calls in this list. | The query execution lasted quite long, if a user had cleared the call list and less than 20 calls in this list.<!----> | ||
=== reporting: summary of pdf reports was not displayed correctly === | === reporting: summary of pdf reports was not displayed correctly === | ||
| Line 605: | Line 605: | ||
|[http://mantis.innovaphone.com/view.php?id=75655 75655] | |[http://mantis.innovaphone.com/view.php?id=75655 75655] | ||
|} | |} | ||
The summary was not always displayed correctly | The summary was not always displayed correctly<!----> | ||
=== report mails with non latin1 chars in mail name === | === report mails with non latin1 chars in mail name === | ||
| Line 616: | Line 616: | ||
|[http://mantis.innovaphone.com/view.php?id=75667 75667] | |[http://mantis.innovaphone.com/view.php?id=75667 75667] | ||
|} | |} | ||
The mail name has to be correctly encoded to be correctly parsed by cron. | The mail name has to be correctly encoded to be correctly parsed by cron.<!----> | ||
=== LDAP servers now support object filters === | === LDAP servers now support object filters === | ||
| Line 627: | Line 627: | ||
|[http://mantis.innovaphone.com/view.php?id=75697 75697] | |[http://mantis.innovaphone.com/view.php?id=75697 75697] | ||
|} | |} | ||
This is needed, if an innovaphone PBX is used as phone book. | This is needed, if an innovaphone PBX is used as phone book.<!----> | ||
=== check if reporting application already exists on reporting application install === | === check if reporting application already exists on reporting application install === | ||
| Line 638: | Line 638: | ||
|[http://mantis.innovaphone.com/view.php?id=75828 75828] | |[http://mantis.innovaphone.com/view.php?id=75828 75828] | ||
|} | |} | ||
This check hasn't been done yet and caused application issues, if someone installs an already existing reporting application again. | This check hasn't been done yet and caused application issues, if someone installs an already existing reporting application again.<!----> | ||
=== Reporting: pdf reports showing connected duration instead of call duration === | === Reporting: pdf reports showing connected duration instead of call duration === | ||
| Line 649: | Line 649: | ||
|[http://mantis.innovaphone.com/view.php?id=76303 76303] | |[http://mantis.innovaphone.com/view.php?id=76303 76303] | ||
|} | |} | ||
both times are normally equal, that's why we did not see the bug. | both times are normally equal, that's why we did not see the bug.<!----> | ||
=== possible trap after failed DB insert of a CDR === | === possible trap after failed DB insert of a CDR === | ||
| Line 660: | Line 660: | ||
|[http://mantis.innovaphone.com/view.php?id=76625 76625] | |[http://mantis.innovaphone.com/view.php?id=76625 76625] | ||
|} | |} | ||
A possible trap after a failed DB insert of a CDR has been fixed. | A possible trap after a failed DB insert of a CDR has been fixed.<!----> | ||
=== prevent failing CDR insert with replication === | === prevent failing CDR insert with replication === | ||
| Line 671: | Line 671: | ||
|[http://mantis.innovaphone.com/view.php?id=76633 76633] | |[http://mantis.innovaphone.com/view.php?id=76633 76633] | ||
|} | |} | ||
A missing LOCK statement could have caused a failed CDR insert in replication scenarios. | A missing LOCK statement could have caused a failed CDR insert in replication scenarios.<!----> | ||
= V1 Hotfix 8 (10288) = | = V1 Hotfix 8 (10288) = | ||
| Line 690: | Line 690: | ||
|[http://mantis.innovaphone.com/view.php?id=78762 78762] | |[http://mantis.innovaphone.com/view.php?id=78762 78762] | ||
|} | |} | ||
Currently only the PDF of an email report contains the filter information.<br/>Now, also the xml can contain it and manual reports can also contain the information now. | Currently only the PDF of an email report contains the filter information.<br/>Now, also the xml can contain it and manual reports can also contain the information now.<!----> | ||
=== Parse language code from mypbx === | === Parse language code from mypbx === | ||
| Line 701: | Line 701: | ||
|[http://mantis.innovaphone.com/view.php?id=78879 78879] | |[http://mantis.innovaphone.com/view.php?id=78879 78879] | ||
|} | |} | ||
For localization of the call list. | For localization of the call list.<!----> | ||
== Bug Fixes == | == Bug Fixes == | ||
| Line 716: | Line 716: | ||
|[http://mantis.innovaphone.com/view.php?id=78428 78428] | |[http://mantis.innovaphone.com/view.php?id=78428 78428] | ||
|} | |} | ||
Changed some small things for future web interface translations. | Changed some small things for future web interface translations.<!----> | ||
=== filter call direction options transfer/call forward did not work === | === filter call direction options transfer/call forward did not work === | ||
| Line 727: | Line 727: | ||
|[http://mantis.innovaphone.com/view.php?id=78618 78618] | |[http://mantis.innovaphone.com/view.php?id=78618 78618] | ||
|} | |} | ||
Both options did not work and have been fixed. | Both options did not work and have been fixed.<!----> | ||
=== Show pickup party after transfer/cf/alert in call report === | === Show pickup party after transfer/cf/alert in call report === | ||
| Line 738: | Line 738: | ||
|[http://mantis.innovaphone.com/view.php?id=79495 79495] | |[http://mantis.innovaphone.com/view.php?id=79495 79495] | ||
|} | |} | ||
Currently the connect information is wrong for calls which have been pickuped.<br/>Now, a new line will be shown for the pickup party.<br/><br/><!--<br/>pg_report.c<br/>pg_report.h<br/>pickup.jpg<br/>pickup_rev.jpg<br/>pickup_pdf.jpg<br/>pickup_rev_pdf.jpg<br/>call_pickup_left.jpg<br/>call_pickup_right.jpg<br/>call_list.xsl<br/>report.xsl<br/>--> | Currently the connect information is wrong for calls which have been pickuped.<br/>Now, a new line will be shown for the pickup party.<br/><br/><!--<br/>pg_report.c<br/>pg_report.h<br/>pickup.jpg<br/>pickup_rev.jpg<br/>pickup_pdf.jpg<br/>pickup_rev_pdf.jpg<br/>call_pickup_left.jpg<br/>call_pickup_right.jpg<br/>call_list.xsl<br/>report.xsl<br/>--><!----> | ||
= V1 Hotfix 9 (10294) = | = V1 Hotfix 9 (10294) = | ||
| Line 761: | Line 761: | ||
|[http://mantis.innovaphone.com/view.php?id=80459 80459] | |[http://mantis.innovaphone.com/view.php?id=80459 80459] | ||
|} | |} | ||
wrong handling of special characters.<br/><br/><!--<br/>report.php<br/>config_reporting.php<br/>--> | wrong handling of special characters.<br/><br/><!--<br/>report.php<br/>config_reporting.php<br/>--><!----> | ||
=== Enter key submits filter changes now === | === Enter key submits filter changes now === | ||
| Line 772: | Line 772: | ||
|[http://mantis.innovaphone.com/view.php?id=80763 80763] | |[http://mantis.innovaphone.com/view.php?id=80763 80763] | ||
|} | |} | ||
The enter key now submits filter changes when used in a filter editing field. | The enter key now submits filter changes when used in a filter editing field.<!----> | ||
=== Reporting: avoid empty page at end of PDF reports === | === Reporting: avoid empty page at end of PDF reports === | ||
| Line 783: | Line 783: | ||
|[http://mantis.innovaphone.com/view.php?id=80787 80787] | |[http://mantis.innovaphone.com/view.php?id=80787 80787] | ||
|} | |} | ||
sometimes an empty page appeared at the end of pdf reports.<br/><br/><!--<br/>pg_report.c<br/>--> | sometimes an empty page appeared at the end of pdf reports.<br/><br/><!--<br/>pg_report.c<br/>--><!----> | ||
=== Other Bug Fixes === | === Other Bug Fixes === | ||
| Line 811: | Line 811: | ||
|[http://mantis.innovaphone.com/view.php?id=82835 82835] | |[http://mantis.innovaphone.com/view.php?id=82835 82835] | ||
|} | |} | ||
It is now possible to configure different user logins. The admin can assign so called base filters to these users and the users can just use the assigned base filters to create reports or report mails.<br/>They can also create own filters based on one of the assigned base filters.<br/><br/><!--<br/>report.php<br/>config_reporting.php<br/>include.php<br/>java.js<br/>include_main.php<br/>reporting_database.dump<br/>update_seq.psql<br/>config.sh<br/>replication.c<br/>process.c<br/>pg_report.c<br/>innovaphone-reporting.xml<br/>--> | It is now possible to configure different user logins. The admin can assign so called base filters to these users and the users can just use the assigned base filters to create reports or report mails.<br/>They can also create own filters based on one of the assigned base filters.<br/><br/><!--<br/>report.php<br/>config_reporting.php<br/>include.php<br/>java.js<br/>include_main.php<br/>reporting_database.dump<br/>update_seq.psql<br/>config.sh<br/>replication.c<br/>process.c<br/>pg_report.c<br/>innovaphone-reporting.xml<br/>--><!----> | ||
=== German translation for the web interface and reports === | === German translation for the web interface and reports === | ||
| Line 822: | Line 822: | ||
|[http://mantis.innovaphone.com/view.php?id=83047 83047] | |[http://mantis.innovaphone.com/view.php?id=83047 83047] | ||
|} | |} | ||
Added the german translation. | Added the german translation.<!----> | ||
== Bug Fixes == | == Bug Fixes == | ||
| Line 837: | Line 837: | ||
|[http://mantis.innovaphone.com/view.php?id=81184 81184] | |[http://mantis.innovaphone.com/view.php?id=81184 81184] | ||
|} | |} | ||
Instead of canceling changes.<br/><br/><!--<br/>config_reporting.php<br/>--> | Instead of canceling changes.<br/><br/><!--<br/>config_reporting.php<br/>--><!----> | ||
=== do not send an alarm for deadlocks on CDR insert === | === do not send an alarm for deadlocks on CDR insert === | ||
| Line 848: | Line 848: | ||
|[http://mantis.innovaphone.com/view.php?id=83267 83267] | |[http://mantis.innovaphone.com/view.php?id=83267 83267] | ||
|} | |} | ||
as this CDR insert will be retried afterwards again.<br/><br/><!--<br/>cdr.c<br/>--> | as this CDR insert will be retried afterwards again.<br/><br/><!--<br/>cdr.c<br/>--><!----> | ||
= V1 Hotfix 11 (10317) = | = V1 Hotfix 11 (10317) = | ||
| Line 867: | Line 867: | ||
|[http://mantis.innovaphone.com/view.php?id=83834 83834] | |[http://mantis.innovaphone.com/view.php?id=83834 83834] | ||
|} | |} | ||
On entering a PBX object (long name) to create a report for this object, possible values are now selectable from a displayed list.<br/>To keep the response time low, only values from CDRs of the last week are shown.<br/><br/><!--<br/>inputpage.class.php<br/>innoinputpage.class.php<br/>include.php<br/>config_reporting.php<br/>--> | On entering a PBX object (long name) to create a report for this object, possible values are now selectable from a displayed list.<br/>To keep the response time low, only values from CDRs of the last week are shown.<br/><br/><!--<br/>inputpage.class.php<br/>innoinputpage.class.php<br/>include.php<br/>config_reporting.php<br/>--><!----> | ||
=== retry sending of Report Mail on failure and write error to log file === | === retry sending of Report Mail on failure and write error to log file === | ||
| Line 878: | Line 878: | ||
|[http://mantis.innovaphone.com/view.php?id=84591 84591] | |[http://mantis.innovaphone.com/view.php?id=84591 84591] | ||
|} | |} | ||
The sending of a report mail is now retried two times, if the sending fails and the error is written to the innovaphone-reporting log file, if the last try also fails.<br/><br/><!--<br/>config.sh<br/>--> | The sending of a report mail is now retried two times, if the sending fails and the error is written to the innovaphone-reporting log file, if the last try also fails.<br/><br/><!--<br/>config.sh<br/>--><!----> | ||
=== Language for Report Mail configurable === | === Language for Report Mail configurable === | ||
| Line 889: | Line 889: | ||
|[http://mantis.innovaphone.com/view.php?id=84692 84692] | |[http://mantis.innovaphone.com/view.php?id=84692 84692] | ||
|} | |} | ||
The language for a report mail is now configurable.<br/><br/><!--<br/>report.php<br/>include.php<br/>config_reporting.php<br/>reporting_database.dump<br/>--> | The language for a report mail is now configurable.<br/><br/><!--<br/>report.php<br/>include.php<br/>config_reporting.php<br/>reporting_database.dump<br/>--><!----> | ||
=== Alarms are now cleared if condition is cleared === | === Alarms are now cleared if condition is cleared === | ||
| Line 900: | Line 900: | ||
|[http://mantis.innovaphone.com/view.php?id=85085 85085] | |[http://mantis.innovaphone.com/view.php?id=85085 85085] | ||
|} | |} | ||
Alarms of the Linux Application Platform or by applications like Reporting are now cleared, if the alarm condition doesn't exist anymore.<br/><br/><!--<br/>backup.php<br/>config.php<br/>diagnostics.php<br/>include_main.php<br/>cdr.c<br/>--> | Alarms of the Linux Application Platform or by applications like Reporting are now cleared, if the alarm condition doesn't exist anymore.<br/><br/><!--<br/>backup.php<br/>config.php<br/>diagnostics.php<br/>include_main.php<br/>cdr.c<br/>--><!----> | ||
== Bug Fixes == | == Bug Fixes == | ||
| Line 915: | Line 915: | ||
|[http://mantis.innovaphone.com/view.php?id=84256 84256] | |[http://mantis.innovaphone.com/view.php?id=84256 84256] | ||
|} | |} | ||
The callback time was language independet and now it is localised in the report xml, which is used for reports and the mypbx calllist.<br/><br/><!--<br/>report.php<br/>include.php<br/>pg_report.c<br/>mypbx.c<br/>--> | The callback time was language independet and now it is localised in the report xml, which is used for reports and the mypbx calllist.<br/><br/><!--<br/>report.php<br/>include.php<br/>pg_report.c<br/>mypbx.c<br/>--><!----> | ||
=== PDF report creation didn't work with group by and sort by options === | === PDF report creation didn't work with group by and sort by options === | ||
| Line 926: | Line 926: | ||
|[http://mantis.innovaphone.com/view.php?id=84346 84346] | |[http://mantis.innovaphone.com/view.php?id=84346 84346] | ||
|} | |} | ||
e.g. in Report Mails, but also from web ui.<br/><br/><!--<br/>report.php<br/>--> | e.g. in Report Mails, but also from web ui.<br/><br/><!--<br/>report.php<br/>--><!----> | ||
= V1 Hotfix 12 (10323) = | = V1 Hotfix 12 (10323) = | ||
| Line 945: | Line 945: | ||
|[http://mantis.innovaphone.com/view.php?id=85478 85478] | |[http://mantis.innovaphone.com/view.php?id=85478 85478] | ||
|} | |} | ||
Show the alerting time as column in report.<br/><br/><!--<br/>pg_report.c<br/>include.php<br/>report.xsl<br/>language files<br/>--> | Show the alerting time as column in report.<br/><br/><!--<br/>pg_report.c<br/>include.php<br/>report.xsl<br/>language files<br/>--><!----> | ||
=== Option to compress/not compress the report in a report mail === | === Option to compress/not compress the report in a report mail === | ||
| Line 956: | Line 956: | ||
|[http://mantis.innovaphone.com/view.php?id=85580 85580] | |[http://mantis.innovaphone.com/view.php?id=85580 85580] | ||
|} | |} | ||
Added the possibility to define whether a report in a mail will be compressed or not.<br/><br/><!--<br/>config_reporting.php<br/>include.php<br/>report.php<br/>lang files<br/>--> | Added the possibility to define whether a report in a mail will be compressed or not.<br/><br/><!--<br/>config_reporting.php<br/>include.php<br/>report.php<br/>lang files<br/>--><!----> | ||
=== Reporting: reports in CSV format === | === Reporting: reports in CSV format === | ||
| Line 967: | Line 967: | ||
|[http://mantis.innovaphone.com/view.php?id=85823 85823] | |[http://mantis.innovaphone.com/view.php?id=85823 85823] | ||
|} | |} | ||
Reports in CSV format without call history | Reports in CSV format without call history<!----> | ||
''Status:'' | ''Status:'' | ||
<!--<br/>pg_report.c<br/>report.php<br/>report.xsl<br/>inno-lib.h<br/>config_reporting.php<br/>include.php<br/>report.php<br/>--> | <!--<br/>pg_report.c<br/>report.php<br/>report.xsl<br/>inno-lib.h<br/>config_reporting.php<br/>include.php<br/>report.php<br/>--> | ||
| Line 980: | Line 980: | ||
|[http://mantis.innovaphone.com/view.php?id=85972 85972] | |[http://mantis.innovaphone.com/view.php?id=85972 85972] | ||
|} | |} | ||
Each group gets now a new summary line after the last record of the group, which contains the following information:<br/><br/>Number of incoming calls<br/>Number of outgoing calls<br/>Total connected duration<br/>Total alert duration<br/><br/><!--<br/>pg_report.c<br/>report.xsl<br/>report.css<br/>process-text-tables.h<br/>process-strings-utf8.h<br/>--> | Each group gets now a new summary line after the last record of the group, which contains the following information:<br/><br/>Number of incoming calls<br/>Number of outgoing calls<br/>Total connected duration<br/>Total alert duration<br/><br/><!--<br/>pg_report.c<br/>report.xsl<br/>report.css<br/>process-text-tables.h<br/>process-strings-utf8.h<br/>--><!----> | ||
== Bug Fixes == | == Bug Fixes == | ||
| Line 995: | Line 995: | ||
|[http://mantis.innovaphone.com/view.php?id=85476 85476] | |[http://mantis.innovaphone.com/view.php?id=85476 85476] | ||
|} | |} | ||
Users with multiple registrations had multiple calls in their report, if the call had a CFNR and was connected afterwards.<br/><br/><!--<br/>pg_report.c<br/>--> | Users with multiple registrations had multiple calls in their report, if the call had a CFNR and was connected afterwards.<br/><br/><!--<br/>pg_report.c<br/>--><!----> | ||
=== Sent mail reports are not stored in sent file anymore === | === Sent mail reports are not stored in sent file anymore === | ||
| Line 1,006: | Line 1,006: | ||
|[http://mantis.innovaphone.com/view.php?id=85485 85485] | |[http://mantis.innovaphone.com/view.php?id=85485 85485] | ||
|} | |} | ||
Sent mail reports had been stored in a file. This isn't done anymore now.<br/><br/><!--<br/>init_script.sh<br/>install_hotfix.sh<br/>--> | Sent mail reports had been stored in a file. This isn't done anymore now.<br/><br/><!--<br/>init_script.sh<br/>install_hotfix.sh<br/>--><!----> | ||
=== Occasional corrupt report attachments === | === Occasional corrupt report attachments === | ||
| Line 1,017: | Line 1,017: | ||
|[http://mantis.innovaphone.com/view.php?id=85556 85556] | |[http://mantis.innovaphone.com/view.php?id=85556 85556] | ||
|} | |} | ||
Sometimes sent report archives were corrupt, because the sending mail program didn't recognize the mime type of the file and changed the binary file before sending it.<br/>This is fixed now.<br/><br/><!--<br/>mime.types<br/>init_script.sh<br/>make.sh<br/>onerror_template.sh<br/>Makefile<br/>--> | Sometimes sent report archives were corrupt, because the sending mail program didn't recognize the mime type of the file and changed the binary file before sending it.<br/>This is fixed now.<br/><br/><!--<br/>mime.types<br/>init_script.sh<br/>make.sh<br/>onerror_template.sh<br/>Makefile<br/>--><!----> | ||
=== Don't treat CFU calls with connect as "No response" calls === | === Don't treat CFU calls with connect as "No response" calls === | ||
| Line 1,028: | Line 1,028: | ||
|[http://mantis.innovaphone.com/view.php?id=85863 85863] | |[http://mantis.innovaphone.com/view.php?id=85863 85863] | ||
|} | |} | ||
With a filter with the "No response" check, forwarded calls with a connect after the forward shouldn't be shown.<br/><br/><!--<br/>report.php<br/>--> | With a filter with the "No response" check, forwarded calls with a connect after the forward shouldn't be shown.<br/><br/><!--<br/>report.php<br/>--><!----> | ||
=== Enable PosgreSQL Autovauum feature correctly === | === Enable PosgreSQL Autovauum feature correctly === | ||
| Line 1,039: | Line 1,039: | ||
|[http://mantis.innovaphone.com/view.php?id=86504 86504] | |[http://mantis.innovaphone.com/view.php?id=86504 86504] | ||
|} | |} | ||
There was a configuration option missing for this feature to work properly.<br/><br/><!--<br/>postgresql.conf<br/>--> | There was a configuration option missing for this feature to work properly.<br/><br/><!--<br/>postgresql.conf<br/>--><!----> | ||
=== Restrict myPBX call list to calls of the last month === | === Restrict myPBX call list to calls of the last month === | ||
| Line 1,050: | Line 1,050: | ||
|[http://mantis.innovaphone.com/view.php?id=86573 86573] | |[http://mantis.innovaphone.com/view.php?id=86573 86573] | ||
|} | |} | ||
This prevents high response times if a user does not have 20 calls in the last month.<br/><br/><!--<br/>mypbx.c<br/>--> | This prevents high response times if a user does not have 20 calls in the last month.<br/><br/><!--<br/>mypbx.c<br/>--><!----> | ||
=== Do not uninstall already installed packages after failed hotfix installation === | === Do not uninstall already installed packages after failed hotfix installation === | ||
| Line 1,061: | Line 1,061: | ||
|[http://mantis.innovaphone.com/view.php?id=86597 86597] | |[http://mantis.innovaphone.com/view.php?id=86597 86597] | ||
|} | |} | ||
Due to a bug, already installed packages have been uninstalled after a failed hotfix installation. | Due to a bug, already installed packages have been uninstalled after a failed hotfix installation.<!----> | ||
= V1 Hotfix 13 (10329) = | = V1 Hotfix 13 (10329) = | ||
| Line 1,080: | Line 1,080: | ||
|[http://mantis.innovaphone.com/view.php?id=85768 85768] | |[http://mantis.innovaphone.com/view.php?id=85768 85768] | ||
|} | |} | ||
You have now the possibility to select the displayed duration:<br/>Call Duration (Total) <br/>Call Duration (User)<br/>Billing Duration<br/><br/><!--<br/>inno-lib.h<br/>mypbx.c<br/>pg_report.c/h<br/>process_strings-utf8.h<br/>config_reporting.php<br/>include.php<br/>lang-reporting-*.inc<br/>report.php<br/>report.xsl<br/>install_hotfix.sh<br/>psql_commands<br/>reporting_database.dump<br/>--> | You have now the possibility to select the displayed duration:<br/>Call Duration (Total) <br/>Call Duration (User)<br/>Billing Duration<br/><br/><!--<br/>inno-lib.h<br/>mypbx.c<br/>pg_report.c/h<br/>process_strings-utf8.h<br/>config_reporting.php<br/>include.php<br/>lang-reporting-*.inc<br/>report.php<br/>report.xsl<br/>install_hotfix.sh<br/>psql_commands<br/>reporting_database.dump<br/>--><!----> | ||
=== Optimized myPBX call list query === | === Optimized myPBX call list query === | ||
| Line 1,091: | Line 1,091: | ||
|[http://mantis.innovaphone.com/view.php?id=86824 86824] | |[http://mantis.innovaphone.com/view.php?id=86824 86824] | ||
|} | |} | ||
The query has been optimized for a faster response time.<br/><br/><!--<br/>mypbx.c<br/>--> | The query has been optimized for a faster response time.<br/><br/><!--<br/>mypbx.c<br/>--><!----> | ||
=== Reporting: LDAP Einrichtung mit Wildcard für PBX Name === | === Reporting: LDAP Einrichtung mit Wildcard für PBX Name === | ||
| Line 1,102: | Line 1,102: | ||
|[http://mantis.innovaphone.com/view.php?id=88129 88129] | |[http://mantis.innovaphone.com/view.php?id=88129 88129] | ||
|} | |} | ||
Jetzt wird '%' als Wildcard akzeptiert. | Jetzt wird '%' als Wildcard akzeptiert.<!----> | ||
''Status:'' | ''Status:'' | ||
<!--<br/>cdr.c<br/>pg_report.c<br/>--> | <!--<br/>cdr.c<br/>pg_report.c<br/>--> | ||
| Line 1,115: | Line 1,115: | ||
|[http://mantis.innovaphone.com/view.php?id=88339 88339] | |[http://mantis.innovaphone.com/view.php?id=88339 88339] | ||
|} | |} | ||
The check of a running db restore/backup etc. is now available for other applications.<br/>This offers the possibility to prevent database access during certain operations.<br/><br/><!--<br/>cdr.c<br/>administration.php<br/>application.php<br/>include_main.php<br/>backup.php<br/>config.sh<br/>config_reporting.php<br/>postgresql.php<br/>config_faxserver.php<br/>language files<br/>--> | The check of a running db restore/backup etc. is now available for other applications.<br/>This offers the possibility to prevent database access during certain operations.<br/><br/><!--<br/>cdr.c<br/>administration.php<br/>application.php<br/>include_main.php<br/>backup.php<br/>config.sh<br/>config_reporting.php<br/>postgresql.php<br/>config_faxserver.php<br/>language files<br/>--><!----> | ||
=== Anonymize internal names/numbers in a report === | === Anonymize internal names/numbers in a report === | ||
| Line 1,126: | Line 1,126: | ||
|[http://mantis.innovaphone.com/view.php?id=88425 88425] | |[http://mantis.innovaphone.com/view.php?id=88425 88425] | ||
|} | |} | ||
New option added to anonymize internal names/numbers.<br/><br/><!--<br/>reporting_database.dump<br/>inno-lib.h<br/>pg_report.c<br/>process-strings-utf8.h<br/>process-text-tables.h<br/>config_reporting.php<br/>include.php<br/>report.php<br/>report.xsl<br/>lang-reporting-de/en.inc<br/>--> | New option added to anonymize internal names/numbers.<br/><br/><!--<br/>reporting_database.dump<br/>inno-lib.h<br/>pg_report.c<br/>process-strings-utf8.h<br/>process-text-tables.h<br/>config_reporting.php<br/>include.php<br/>report.php<br/>report.xsl<br/>lang-reporting-de/en.inc<br/>--><!----> | ||
== Bug Fixes == | == Bug Fixes == | ||
| Line 1,141: | Line 1,141: | ||
|[http://mantis.innovaphone.com/view.php?id=86970 86970] | |[http://mantis.innovaphone.com/view.php?id=86970 86970] | ||
|} | |} | ||
The filter settings for alert and conn duration didn't work under certain other filter options.<br/><br/><!--<br/>report.php<br/>--> | The filter settings for alert and conn duration didn't work under certain other filter options.<br/><br/><!--<br/>report.php<br/>--><!----> | ||
=== CSV export didn't work with certain group by and sort by settings === | === CSV export didn't work with certain group by and sort by settings === | ||
| Line 1,152: | Line 1,152: | ||
|[http://mantis.innovaphone.com/view.php?id=87492 87492] | |[http://mantis.innovaphone.com/view.php?id=87492 87492] | ||
|} | |} | ||
If group by was set to date and sort by to any value, the CSV export failed.<br/><br/><!--<br/>pg_report.c<br/>--> | If group by was set to date and sort by to any value, the CSV export failed.<br/><br/><!--<br/>pg_report.c<br/>--><!----> | ||
=== Report on the web didn't show correct group summary if sorted differently === | === Report on the web didn't show correct group summary if sorted differently === | ||
| Line 1,163: | Line 1,163: | ||
|[http://mantis.innovaphone.com/view.php?id=87532 87532] | |[http://mantis.innovaphone.com/view.php?id=87532 87532] | ||
|} | |} | ||
A grouped report didn't correctly show the group summary, if one of the sort columns has been used.<br/><br/><!--<br/>report.xsl<br/>--> | A grouped report didn't correctly show the group summary, if one of the sort columns has been used.<br/><br/><!--<br/>report.xsl<br/>--><!----> | ||
=== Reporting: Remote Party Information is empty === | === Reporting: Remote Party Information is empty === | ||
| Line 1,174: | Line 1,174: | ||
|[http://mantis.innovaphone.com/view.php?id=87742 87742] | |[http://mantis.innovaphone.com/view.php?id=87742 87742] | ||
|} | |} | ||
Calls having only Setup and Rel events contain the information of the remote party inside the release event. (we were using setup) | Calls having only Setup and Rel events contain the information of the remote party inside the release event. (we were using setup)<!----> | ||
''Status:'' | ''Status:'' | ||
<!--<br/>pg_report.c<br/>--> | <!--<br/>pg_report.c<br/>--> | ||
| Line 1,187: | Line 1,187: | ||
|[http://mantis.innovaphone.com/view.php?id=87983 87983] | |[http://mantis.innovaphone.com/view.php?id=87983 87983] | ||
|} | |} | ||
The LDAP port is now required and the default port 389 is suggested.<br/><br/><!--<br/>include.php<br/>report.php<br/>--> | The LDAP port is now required and the default port 389 is suggested.<br/><br/><!--<br/>include.php<br/>report.php<br/>--><!----> | ||
=== Check of running processes didn't work sometimes === | === Check of running processes didn't work sometimes === | ||
| Line 1,198: | Line 1,198: | ||
|[http://mantis.innovaphone.com/view.php?id=88553 88553] | |[http://mantis.innovaphone.com/view.php?id=88553 88553] | ||
|} | |} | ||
Due to the output width of the ps command. <br/><br/><!--<br/>config.sh<br/>init_script.sh<br/>install_script.sh<br/>install_exchange/reporting/faxserver.sh<br/>exchange.php<br/>innovaphone-faxserver<br/>innovaphone.fax.config.class.php<br/>--> | Due to the output width of the ps command. <br/><br/><!--<br/>config.sh<br/>init_script.sh<br/>install_script.sh<br/>install_exchange/reporting/faxserver.sh<br/>exchange.php<br/>innovaphone-faxserver<br/>innovaphone.fax.config.class.php<br/>--><!----> | ||
= V1 Hotfix 14 (10336) = | = V1 Hotfix 14 (10336) = | ||
| Line 1,217: | Line 1,217: | ||
|[http://mantis.innovaphone.com/view.php?id=88907 88907] | |[http://mantis.innovaphone.com/view.php?id=88907 88907] | ||
|} | |} | ||
If this flag is set, all reports created with this base filter will be anonym.<br/><br/><!--<br/>report.php<br/>include.php<br/>config_reporting.php<br/>reporting_database.dump<br/>psql_commands.txt<br/>psql_commands_undo.txt<br/>install_hotfix.sh<br/>--> | If this flag is set, all reports created with this base filter will be anonym.<br/><br/><!--<br/>report.php<br/>include.php<br/>config_reporting.php<br/>reporting_database.dump<br/>psql_commands.txt<br/>psql_commands_undo.txt<br/>install_hotfix.sh<br/>--><!----> | ||
=== Show summarized alert duration in summary === | === Show summarized alert duration in summary === | ||
| Line 1,228: | Line 1,228: | ||
|[http://mantis.innovaphone.com/view.php?id=89033 89033] | |[http://mantis.innovaphone.com/view.php?id=89033 89033] | ||
|} | |} | ||
The alert duration of incoming/outgoing calls is now shown in the summary.<br/><br/><!--<br/>pg_report.c<br/>report.xsl<br/>process-strings-utf8.h<br/>process-text-tables.h<br/>--> | The alert duration of incoming/outgoing calls is now shown in the summary.<br/><br/><!--<br/>pg_report.c<br/>report.xsl<br/>process-strings-utf8.h<br/>process-text-tables.h<br/>--><!----> | ||
=== Some optimizations for a better web ui performance === | === Some optimizations for a better web ui performance === | ||
| Line 1,239: | Line 1,239: | ||
|[http://mantis.innovaphone.com/view.php?id=89238 89238] | |[http://mantis.innovaphone.com/view.php?id=89238 89238] | ||
|} | |} | ||
Added some session vars to avoid running slow code multiple times.<br/>Background processes run with a lower priority now.<br/><br/><!--<br/>config_reporting.php<br/>administration.php<br/>install_reporting.sh<br/>install_exchange.sh<br/>config_exchange.php<br/>install_faxserver.sh<br/>innovaphone_check<br/>innovaphone-faxserver<br/>install_hotfix.sh (2x)<br/>include_main.php<br/>--> | Added some session vars to avoid running slow code multiple times.<br/>Background processes run with a lower priority now.<br/><br/><!--<br/>config_reporting.php<br/>administration.php<br/>install_reporting.sh<br/>install_exchange.sh<br/>config_exchange.php<br/>install_faxserver.sh<br/>innovaphone_check<br/>innovaphone-faxserver<br/>install_hotfix.sh (2x)<br/>include_main.php<br/>--><!----> | ||
== Bug Fixes == | == Bug Fixes == | ||
| Line 1,254: | Line 1,254: | ||
|[http://mantis.innovaphone.com/view.php?id=89234 89234] | |[http://mantis.innovaphone.com/view.php?id=89234 89234] | ||
|} | |} | ||
these functions are consuming very much time. We will now implement locks through files and PHP will only call file_exist function.<br/>These change will also be applied to cdr.c<br/><br/><!--<br/>cdr.c<br/>config.sh<br/>config.php<br/>postgresql.php<br/>config_reporting.php<br/>config_faxserver.php<br/>config_exchange.php<br/>include_main.php<br/>diagnostics.php<br/>backup.php<br/>application.php<br/>administration.php<br/>--> | these functions are consuming very much time. We will now implement locks through files and PHP will only call file_exist function.<br/>These change will also be applied to cdr.c<br/><br/><!--<br/>cdr.c<br/>config.sh<br/>config.php<br/>postgresql.php<br/>config_reporting.php<br/>config_faxserver.php<br/>config_exchange.php<br/>include_main.php<br/>diagnostics.php<br/>backup.php<br/>application.php<br/>administration.php<br/>--><!----> | ||
= V1 Hotfix 15 (10353) = | = V1 Hotfix 15 (10353) = | ||
| Line 1,277: | Line 1,277: | ||
|[http://mantis.innovaphone.com/view.php?id=90519 90519] | |[http://mantis.innovaphone.com/view.php?id=90519 90519] | ||
|} | |} | ||
The connection string was slightly wrong, so SSL mode wasn't disabled as intended.<br/>Therefor the connection was slower than expected.<br/><br/><!--<br/>postgresql.php<br/>administration.php<br/>--> | The connection string was slightly wrong, so SSL mode wasn't disabled as intended.<br/>Therefor the connection was slower than expected.<br/><br/><!--<br/>postgresql.php<br/>administration.php<br/>--><!----> | ||
=== Reporting: optimization of the CDR receiving process === | === Reporting: optimization of the CDR receiving process === | ||
| Line 1,288: | Line 1,288: | ||
|[http://mantis.innovaphone.com/view.php?id=90894 90894] | |[http://mantis.innovaphone.com/view.php?id=90894 90894] | ||
|} | |} | ||
postgresql takes too long to open a connection to the db. Now we have an opened DB connection and we queue the incoming CDRs.<br/><!--<br/>cdr.c<br/>cdr.h<br/>pg_report.c<br/>reporting_config.c<br/>reporting_config.h<br/>inno-lib.c<br/>inno-lib.h<br/>--> | postgresql takes too long to open a connection to the db. Now we have an opened DB connection and we queue the incoming CDRs.<br/><!--<br/>cdr.c<br/>cdr.h<br/>pg_report.c<br/>reporting_config.c<br/>reporting_config.h<br/>inno-lib.c<br/>inno-lib.h<br/>--><!----> | ||
=== LDAP: use next configured server if the actual one returns no name or error. === | === LDAP: use next configured server if the actual one returns no name or error. === | ||
| Line 1,299: | Line 1,299: | ||
|[http://mantis.innovaphone.com/view.php?id=91228 91228] | |[http://mantis.innovaphone.com/view.php?id=91228 91228] | ||
|} | |} | ||
if actual LDAP server does not return a name maybe another configured server does. Therefore test all configured LDAP servers.<br/>Right now we only use the first valid one. | if actual LDAP server does not return a name maybe another configured server does. Therefore test all configured LDAP servers.<br/>Right now we only use the first valid one.<!----> | ||
=== Stop database if application is uninstalled === | === Stop database if application is uninstalled === | ||
| Line 1,310: | Line 1,310: | ||
|[http://mantis.innovaphone.com/view.php?id=91293 91293] | |[http://mantis.innovaphone.com/view.php?id=91293 91293] | ||
|} | |} | ||
The database is now stopped, if it gets uninstalled on an application uninstall.<br/>Otherwise it doesn't start again on the correct port after a new install...<br/><br/><!--<br/>uninstall_script.sh<br/>--> | The database is now stopped, if it gets uninstalled on an application uninstall.<br/>Otherwise it doesn't start again on the correct port after a new install...<br/><br/><!--<br/>uninstall_script.sh<br/>--><!----> | ||
=== LDAP: National/Trunk prefix may not exist === | === LDAP: National/Trunk prefix may not exist === | ||
| Line 1,321: | Line 1,321: | ||
|[http://mantis.innovaphone.com/view.php?id=91798 91798] | |[http://mantis.innovaphone.com/view.php?id=91798 91798] | ||
|} | |} | ||
Some countries like Norway or Spain do not present a Trunk Prefix like Germany does. | Some countries like Norway or Spain do not present a Trunk Prefix like Germany does.<!----> | ||
= V1 Hotfix 16 = | = V1 Hotfix 16 = | ||
Revision as of 13:28, 14 December 2012
This roadmap describes the V1 (that is, Reference9:Concept_Reporting based) Reporting based on the linux application platform.
This article is generated automatically. Do not edit! Please see the disclaimer before using the information presented here!
V1 Hotfix 1 (10181)
These are the fixes included in Reporting V1 hotfix 1. Definition
New Features
Linux: LDAP query if no name available in CDR
| Status | Closed |
| Id | 63134 |
If the CDR contains no name on it, make a LDAP query to the PBX before writing the CDR into the database.
Try with OPENLDAP library.
reporting: replication not running ssl
| Status | Closed |
| Id | 63933 |
configure postgresql to run ssl during replication. We will use the web server certificate.
reporting: added delete tag in application xml file
| Status | Closed |
| Id | 63936 |
delete tag defines which files/directories must be deleted during uninstall
Reporting: separate authentication for reporting web access
| Status | Closed |
| Id | 64875 |
It is now possible to configure a separate authentication to the innovaphone reporting web site.
reporting: download xml report if it has an invalid format
| Status | Closed |
| Id | 64882 |
we offer now a link to download the xml report if it has an invalid format and therefore cannot be displayed by the browser.
reporting: LDAP: add Name and Number attributes
| Status | Closed |
| Id | 64919 |
we have added two new fields for Name and Number Attributes in the LDAP configuration.
So far we had just used "displayName" as Name attribute and "mobile,telephoneNumber and HomePhone" as Number attributes.
reporting: improvements on xml/pdf representation
| Status | Closed |
| Id | 65151 |
we usually use information on the alarm event but conn event normally contains more data. Check which one is better.
pdf looks strange if LDAP returns large strings
reporting: suppress last digits of called/calling party for external calls
| Status | Closed |
| Id | 65259 |
allow to suppress last digits of called/calling party for external calls. It can be configured how many digits must be replaced with a '*'.
reporting: diagnostics page available with logs/rpcap
| Status | Closed |
| Id | 65365 |
The diagnostics page with reporting related log files and rpcap functionality is now also available on the reporting web site.
Reporting: transfers on a slave PBX will now generate a new event: transfer-remote
| Status | Closed |
| Id | 65475 |
when a transfer event happens on a slave PBX, it cannot be known the status of the call afterwards. This new event indicates this situation and a connected status will be shown in the report.
reporting: show only one CDR for transfer/forward calls per user
| Status | Closed |
| Id | 65820 |
Currently both generated CDRs for a user of a transfer or forward call are shown. Diversions are now divided in two CDRs, one showing the whole call flow and another containing billing information, which will not be shown in call lists.
Bug Fixes
reporting callback request from mypbx may crash with uninitialized reporting config
| Status | Closed |
| Id | 63709 |
If one has never configured replication or ldap for Reporting, a reporting callback request from mypbx won't work (the process crashes).
This is fixed now by checking a config parameter.
reporting: wrong remote party in some transfer and forward events
| Status | Closed |
| Id | 63819 |
We assumed that the remote party does not change after transfer/forward event and that the next event after those contains more information over the remote party but this is wrong since the remote party may change.
reporting: process.fcgi crashes with filters containing a remote number condition
| Status | Closed |
| Id | 63878 |
forgot to open parenthesis
conn_length was also forgotten to change to conn_duration
Reporting: better visibility of replication status
| Status | Closed |
| Id | 63920 |
The connection status to the configured replication server is now shown.
The last run is now also shown, even if there was no successful database connection.
reporting: if conn to/from event present, conn-duration must be at least one
| Status | Closed |
| Id | 64267 |
Sometimes conn event and disc/rel event present the same time. Maybe, this should be changed in PBX but we check it anyway.
Connected time must be at least 1. This is also applicable for billing.
reporting: mypbx missed calls wrong for multiple registrations
| Status | Closed |
| Id | 65103 |
If one user has multiple registrations, missed calls were recognized, although the calls has been answered.
Calls from other registrations are disregarded now.
reporting: show call duration time instead of conn duration time in report
| Status | Closed |
| Id | 65132 |
As the whole call flow is shown in the report, showing the call duration makes more sense.
reporting: conn, call and billing time calculation
| Status | Closed |
| Id | 65146 |
billing calls are those having "from", "ct" or "cf" as dir attribute in cdrs. So far we have only considered calls with a setup-from as first event but "ct" and "cf" calls can present a setup-to event and they must be charged too.
all times must be ended with the first disc event.
conn time must not be counted after a transfer-from or cf-from event.
reporting: allow two or more LDAP configurations to have same PBX name
| Status | Closed |
| Id | 65253 |
it is needed if you have more than one trunk.
V1 Hotfix 2 (10197)
These are the fixes included in Reporting V1 hotfix 2. Definition
New Features
reporting: postgresql-8.4 debian package update
| Status | Closed |
| Id | 66271 |
debian update for postgresql 8.4.
Bug Fixes
Reporting: check if database is being restored before writing a CDR
| Status | Closed |
| Id | 66757 |
avoid writing a CDR to the DB if it is being restored since this could corrupt the DB.
This CDR will be sent by the PBX again since Linux is responding with 500 HTTP Error Code.
Cumulative hotfix installation script didn't apply second hotfix
| Status | Closed |
| Id | 66917 |
As the version of the previously installed hotfix hasn't been set properly.
Reporting: current password was not checked before setting a new password
| Status | Closed |
| Id | 67386 |
we used localhost and given password to make a connection to the db but localhost needs no password.
V1 Hotfix 3 (10201)
These are the fixes included in Reporting V1 hotfix 3. Definition
New Features
Bug Fixes
Duplicated report lines on certain filter options
| Status | Closed |
| Id | 68123 |
Certain filter options caused duplicated lines in a report.
This has been fixed by changing the query.
Reporting: ldap results were not escaped
| Status | Closed |
| Id | 68654 |
any string must be 'postgresql' escaped before inserting it into the DB.
V1 Hotfix 4 (10237)
These are the fixes included in Reporting V1 hotfix 4. Definition
New Features
Possibility to clear the call list in mypbx
| Status | Closed |
| Id | 71202 |
A new button is now available in mypbx to clear the call list.
possibility to clear log files
| Status | Closed |
| Id | 71714 |
Log files can be cleared now.
Just system specific log files can't be cleared.
added trace level option
| Status | Closed |
| Id | 71857 |
There is now the possibility to enable further tracing levels.
Increased maximum height of filter list
| Status | Closed |
| Id | 71865 |
Currently only four filter options can be viewed at a time.
With the fix, the lists height increases from 2 until 16 items until the scrollbar of the list is enabled.
Bug Fixes
invalid log file entries for mypbx requests if reporting database is not running
| Status | Closed |
| Id | 71277 |
Invalid log file entries have been written for mypbx requests, if the reporting database was down.
Call list sorting by call duration now numerical, not alphanumerical
| Status | Closed |
| Id | 71450 |
The call list sorting by call duration was alphanumerical, not numerical.
This has been fixed.
Viewing log files with invalid chars now possible
| Status | Closed |
| Id | 71716 |
Viewing log files with invalid chars is now possible over the diagnostics page.
linux: added non-blocking option on flock() call for log files
| Status | Closed |
| Id | 71838 |
The flock() call was eventually blocking if the lock could not be acquired. If we do not get the lock after ten attempts, the log trace will be lost.
dynamic list row add/remove doesn't trigger page to top any more
| Status | Closed |
| Id | 71957 |
Adding or removing a line of a dynamic list doesn't trigger the jump to the page top any more.
V1 Hotfix 5 (10276)
These are the fixes included in Reporting V1 hotfix 5. Definition
New Features
reporting: send reports per email
| Status | Closed |
| Id | 72391 |
Reports can be now sent per email.
filter option for report times
| Status | Closed |
| Id | 73006 |
A filter can now define report times, e.g. all records between 08:00 and 16:00.
| Status | Closed |
| Id | 73542 |
It is now possible to add a logo and footer in pdf reports
exclude outgoing calls without number/h323 from mypbx call list
| Status | Closed |
| Id | 73561 |
Calls are not shown anymore, if someone just offhooks and onhooks without dialing.
Bug Fixes
LDAP filters are now stored in the DB instead of XML
| Status | Closed |
| Id | 73439 |
LDAP filters have been moved to the DB.
This makes it easier to replicate them to a standby installation.
V1 Hotfix 6 (10282)
These are the fixes included in Reporting V1 hotfix 6. Definition
New Features
Possiblity to delete CDRs from database since time X and/or pbx object Y
| Status | Closed |
| Id | 73944 |
You can now define a time period and/or a pbx object for which CDRs are deleted in the database.
reporting: test email functionality
| Status | Closed |
| Id | 75760 |
under diagnostics kann man ein email senden. So überprüft man ob emails verschickt werden.
reporting: call duration and alert duration in filter settings
| Status | Closed |
| Id | 75764 |
How long a call was connected or how long a "not connected" call was ringing.
reporting: send mails via external server (smtp relay)
| Status | Closed |
| Id | 75903 |
it is now possible to configure the mail client on Linux to send mails via Exchange.
Bug Fixes
reporting: mails were not sent in vm installations
| Status | Closed |
| Id | 75359 |
The vm installation was creating a local-host-names file with wrong data and this was making DNS problems.
reporting: possible buffer overrun reading system processes
| Status | Closed |
| Id | 75645 |
when restoring db from a backup, we do not accept cdrs. We look the running processes searching from "db-restore" in files whose size is null. I allocated a 1024 bytes thinking that was enough, apparently not.
mypbx call list query optimized for speed
| Status | Closed |
| Id | 75646 |
The query execution lasted quite long, if a user had cleared the call list and less than 20 calls in this list.
reporting: summary of pdf reports was not displayed correctly
| Status | Closed |
| Id | 75655 |
The summary was not always displayed correctly
report mails with non latin1 chars in mail name
| Status | Closed |
| Id | 75667 |
The mail name has to be correctly encoded to be correctly parsed by cron.
LDAP servers now support object filters
| Status | Closed |
| Id | 75697 |
This is needed, if an innovaphone PBX is used as phone book.
check if reporting application already exists on reporting application install
| Status | Closed |
| Id | 75828 |
This check hasn't been done yet and caused application issues, if someone installs an already existing reporting application again.
Reporting: pdf reports showing connected duration instead of call duration
| Status | Closed |
| Id | 76303 |
both times are normally equal, that's why we did not see the bug.
possible trap after failed DB insert of a CDR
| Status | Closed |
| Id | 76625 |
A possible trap after a failed DB insert of a CDR has been fixed.
prevent failing CDR insert with replication
| Status | Closed |
| Id | 76633 |
A missing LOCK statement could have caused a failed CDR insert in replication scenarios.
V1 Hotfix 8 (10288)
These are the fixes included in Reporting V1 hotfix 8. Definition
New Features
option to show filter info in xml/pdf for call report not only in an email report
| Status | Closed |
| Id | 78762 |
Currently only the PDF of an email report contains the filter information.
Now, also the xml can contain it and manual reports can also contain the information now.
Parse language code from mypbx
| Status | Closed |
| Id | 78879 |
For localization of the call list.
Bug Fixes
some preperations for web interface translations
| Status | Closed |
| Id | 78428 |
Changed some small things for future web interface translations.
filter call direction options transfer/call forward did not work
| Status | Closed |
| Id | 78618 |
Both options did not work and have been fixed.
Show pickup party after transfer/cf/alert in call report
| Status | Closed |
| Id | 79495 |
Currently the connect information is wrong for calls which have been pickuped.
Now, a new line will be shown for the pickup party.
V1 Hotfix 9 (10294)
These are the fixes included in Reporting V1 hotfix 9. Definition
New Features
Bug Fixes
Reporting: Mails not sent due to special characters
| Status | Closed |
| Id | 80459 |
wrong handling of special characters.
Enter key submits filter changes now
| Status | Closed |
| Id | 80763 |
The enter key now submits filter changes when used in a filter editing field.
Reporting: avoid empty page at end of PDF reports
| Status | Closed |
| Id | 80787 |
sometimes an empty page appeared at the end of pdf reports.
Other Bug Fixes
| 79702 | dde | show "from"/"to" for date in report filter info on web |
V1 Hotfix 10 (10303)
These are the fixes included in Reporting V1 hotfix 10. Definition
New Features
multi-client capability for reporting
| Status | Closed |
| Id | 82835 |
It is now possible to configure different user logins. The admin can assign so called base filters to these users and the users can just use the assigned base filters to create reports or report mails.
They can also create own filters based on one of the assigned base filters.
German translation for the web interface and reports
| Status | Closed |
| Id | 83047 |
Added the german translation.
Bug Fixes
Enter key submits mail changes now
| Status | Closed |
| Id | 81184 |
Instead of canceling changes.
do not send an alarm for deadlocks on CDR insert
| Status | Closed |
| Id | 83267 |
as this CDR insert will be retried afterwards again.
V1 Hotfix 11 (10317)
These are the fixes included in Reporting V1 hotfix 11. Definition
New Features
Suggest possible PBX object names on creation of a report
| Status | Closed |
| Id | 83834 |
On entering a PBX object (long name) to create a report for this object, possible values are now selectable from a displayed list.
To keep the response time low, only values from CDRs of the last week are shown.
retry sending of Report Mail on failure and write error to log file
| Status | Closed |
| Id | 84591 |
The sending of a report mail is now retried two times, if the sending fails and the error is written to the innovaphone-reporting log file, if the last try also fails.
Language for Report Mail configurable
| Status | Closed |
| Id | 84692 |
The language for a report mail is now configurable.
Alarms are now cleared if condition is cleared
| Status | Closed |
| Id | 85085 |
Alarms of the Linux Application Platform or by applications like Reporting are now cleared, if the alarm condition doesn't exist anymore.
Bug Fixes
Localise time of callbacks in reports and mypbx calllist
| Status | Closed |
| Id | 84256 |
The callback time was language independet and now it is localised in the report xml, which is used for reports and the mypbx calllist.
PDF report creation didn't work with group by and sort by options
| Status | Closed |
| Id | 84346 |
e.g. in Report Mails, but also from web ui.
V1 Hotfix 12 (10323)
These are the fixes included in Reporting V1 hotfix 12. Definition
New Features
Column with "Alerting time" for reports
| Status | Closed |
| Id | 85478 |
Show the alerting time as column in report.
Option to compress/not compress the report in a report mail
| Status | Closed |
| Id | 85580 |
Added the possibility to define whether a report in a mail will be compressed or not.
Reporting: reports in CSV format
| Status | Closed |
| Id | 85823 |
Reports in CSV format without call history Status:
Summary for each group in a grouped report
| Status | Closed |
| Id | 85972 |
Each group gets now a new summary line after the last record of the group, which contains the following information:
Number of incoming calls
Number of outgoing calls
Total connected duration
Total alert duration
Bug Fixes
Remove duplicate connected CFNR calls from report
| Status | Closed |
| Id | 85476 |
Users with multiple registrations had multiple calls in their report, if the call had a CFNR and was connected afterwards.
Sent mail reports are not stored in sent file anymore
| Status | Closed |
| Id | 85485 |
Sent mail reports had been stored in a file. This isn't done anymore now.
Occasional corrupt report attachments
| Status | Closed |
| Id | 85556 |
Sometimes sent report archives were corrupt, because the sending mail program didn't recognize the mime type of the file and changed the binary file before sending it.
This is fixed now.
Don't treat CFU calls with connect as "No response" calls
| Status | Closed |
| Id | 85863 |
With a filter with the "No response" check, forwarded calls with a connect after the forward shouldn't be shown.
Enable PosgreSQL Autovauum feature correctly
| Status | Closed |
| Id | 86504 |
There was a configuration option missing for this feature to work properly.
Restrict myPBX call list to calls of the last month
| Status | Closed |
| Id | 86573 |
This prevents high response times if a user does not have 20 calls in the last month.
Do not uninstall already installed packages after failed hotfix installation
| Status | Closed |
| Id | 86597 |
Due to a bug, already installed packages have been uninstalled after a failed hotfix installation.
V1 Hotfix 13 (10329)
These are the fixes included in Reporting V1 hotfix 13. Definition
New Features
Possibility to configure displayed duration in report
| Status | Closed |
| Id | 85768 |
You have now the possibility to select the displayed duration:
Call Duration (Total)
Call Duration (User)
Billing Duration
Optimized myPBX call list query
| Status | Closed |
| Id | 86824 |
The query has been optimized for a faster response time.
Reporting: LDAP Einrichtung mit Wildcard für PBX Name
| Status | Closed |
| Id | 88129 |
Jetzt wird '%' als Wildcard akzeptiert. Status:
Check of running db restore/backup etc. available for other applications now
| Status | Closed |
| Id | 88339 |
The check of a running db restore/backup etc. is now available for other applications.
This offers the possibility to prevent database access during certain operations.
Anonymize internal names/numbers in a report
| Status | Closed |
| Id | 88425 |
New option added to anonymize internal names/numbers.
Bug Fixes
Alert/conn duration filter didn't always work
| Status | Closed |
| Id | 86970 |
The filter settings for alert and conn duration didn't work under certain other filter options.
CSV export didn't work with certain group by and sort by settings
| Status | Closed |
| Id | 87492 |
If group by was set to date and sort by to any value, the CSV export failed.
Report on the web didn't show correct group summary if sorted differently
| Status | Closed |
| Id | 87532 |
A grouped report didn't correctly show the group summary, if one of the sort columns has been used.
Reporting: Remote Party Information is empty
| Status | Closed |
| Id | 87742 |
Calls having only Setup and Rel events contain the information of the remote party inside the release event. (we were using setup) Status:
LDAP server configuration now requires LDAP port and suggests default 389
| Status | Closed |
| Id | 87983 |
The LDAP port is now required and the default port 389 is suggested.
Check of running processes didn't work sometimes
| Status | Closed |
| Id | 88553 |
Due to the output width of the ps command.
V1 Hotfix 14 (10336)
These are the fixes included in Reporting V1 hotfix 14. Definition
New Features
Anonym flag now available as base filter option
| Status | Closed |
| Id | 88907 |
If this flag is set, all reports created with this base filter will be anonym.
Show summarized alert duration in summary
| Status | Closed |
| Id | 89033 |
The alert duration of incoming/outgoing calls is now shown in the summary.
Some optimizations for a better web ui performance
| Status | Closed |
| Id | 89238 |
Added some session vars to avoid running slow code multiple times.
Background processes run with a lower priority now.
Bug Fixes
Avoid using exec and system in PHP
| Status | Closed |
| Id | 89234 |
these functions are consuming very much time. We will now implement locks through files and PHP will only call file_exist function.
These change will also be applied to cdr.c
V1 Hotfix 15 (10353)
These are the fixes included in Reporting V1 hotfix 15. Definition
New Features
Bug Fixes
Internal database connection was slow due to SSL mode
| Status | Closed |
| Id | 90519 |
The connection string was slightly wrong, so SSL mode wasn't disabled as intended.
Therefor the connection was slower than expected.
Reporting: optimization of the CDR receiving process
| Status | Closed |
| Id | 90894 |
postgresql takes too long to open a connection to the db. Now we have an opened DB connection and we queue the incoming CDRs.
LDAP: use next configured server if the actual one returns no name or error.
| Status | Closed |
| Id | 91228 |
if actual LDAP server does not return a name maybe another configured server does. Therefore test all configured LDAP servers.
Right now we only use the first valid one.
Stop database if application is uninstalled
| Status | Closed |
| Id | 91293 |
The database is now stopped, if it gets uninstalled on an application uninstall.
Otherwise it doesn't start again on the correct port after a new install...
LDAP: National/Trunk prefix may not exist
| Status | Closed |
| Id | 91798 |
Some countries like Norway or Spain do not present a Trunk Prefix like Germany does.
V1 Hotfix 16
These are the fixes included in Reporting V1 hotfix 16. Definition