ReleaseNotes9:Linux Reporting: Difference between revisions

From innovaphone wiki
Jump to navigation Jump to search
← Older editNewer edit →
VisualWikitext
m regular roadmap update
m regular roadmap update
Line 8: Line 8:
      
      
= V1 Hotfix 1 (10181) =
= V1 Hotfix 1 (10181) =
These are the fixes included in Reporting V1 hotfix 1.
These are the fixes included in Reporting V1 hotfix 1.<!---->
[http://mantis.innovaphone.com/view.php?id=64095 Definition]
[http://mantis.innovaphone.com/view.php?id=64095 Definition]


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) =
These are the fixes included in Reporting V1 hotfix 2.
These are the fixes included in Reporting V1 hotfix 2.<!---->
[http://mantis.innovaphone.com/view.php?id=66705 Definition]
[http://mantis.innovaphone.com/view.php?id=66705 Definition]


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) =
These are the fixes included in Reporting V1 hotfix 3.
These are the fixes included in Reporting V1 hotfix 3.<!---->
[http://mantis.innovaphone.com/view.php?id=67577 Definition]
[http://mantis.innovaphone.com/view.php?id=67577 Definition]


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) =
These are the fixes included in Reporting V1 hotfix 4.
These are the fixes included in Reporting V1 hotfix 4.<!---->
[http://mantis.innovaphone.com/view.php?id=71206 Definition]
[http://mantis.innovaphone.com/view.php?id=71206 Definition]


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) =
These are the fixes included in Reporting V1 hotfix 5.
These are the fixes included in Reporting V1 hotfix 5.<!---->
[http://mantis.innovaphone.com/view.php?id=72213 Definition]
[http://mantis.innovaphone.com/view.php?id=72213 Definition]


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) =
These are the fixes included in Reporting V1 hotfix 6.
These are the fixes included in Reporting V1 hotfix 6.<!---->
[http://mantis.innovaphone.com/view.php?id=74057 Definition]
[http://mantis.innovaphone.com/view.php?id=74057 Definition]


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 7 (10285) =
= V1 Hotfix 7 (10285) =
These are the fixes included in Reporting V1 hotfix 7.
These are the fixes included in Reporting V1 hotfix 7.<!---->
[http://mantis.innovaphone.com/view.php?id=91997 Definition]
[http://mantis.innovaphone.com/view.php?id=91997 Definition]


Line 690: Line 690:
|[http://mantis.innovaphone.com/view.php?id=76779 76779]
|[http://mantis.innovaphone.com/view.php?id=76779 76779]
|}
|}
Call list shall contain localised date and time. Also today's and yesterday's date should be replaced by words.<br/><!---->
Call list shall contain localised date and time. Also today's and yesterday's date should be replaced by words.<br/>
      
      
=== reporting: make LDAP queries for Trunk Line Objects ===
=== reporting: make LDAP queries for Trunk Line Objects ===
Line 701: Line 701:
|[http://mantis.innovaphone.com/view.php?id=76906 76906]
|[http://mantis.innovaphone.com/view.php?id=76906 76906]
|}
|}
we now see in reports in the "Left" column "external number Amt" for the Amt object but this external number may appear in LDAP. If this number is found in LDAP, we replace previous value with the LDAP result.<!---->
we now see in reports in the "Left" column "external number Amt" for the Amt object but this external number may appear in LDAP. If this number is found in LDAP, we replace previous value with the LDAP result.
      
      
=== moved/changed some shared code for future innovaphone applications ===
=== moved/changed some shared code for future innovaphone applications ===
Line 712: Line 712:
|[http://mantis.innovaphone.com/view.php?id=77381 77381]
|[http://mantis.innovaphone.com/view.php?id=77381 77381]
|}
|}
Some shared code has been moved for future innovaphone applications for the linux application platform.<!---->
Some shared code has been moved for future innovaphone applications for the linux application platform.
      
      
== Bug Fixes ==
== Bug Fixes ==
Line 727: Line 727:
|[http://mantis.innovaphone.com/view.php?id=77334 77334]
|[http://mantis.innovaphone.com/view.php?id=77334 77334]
|}
|}
only remove certain lines from default pg_hba.conf file if postgresql hasn't been installed yet.<!---->
only remove certain lines from default pg_hba.conf file if postgresql hasn't been installed yet.
      
      
= V1 Hotfix 8 (10288) =
= V1 Hotfix 8 (10288) =
These are the fixes included in Reporting V1 hotfix 8.
These are the fixes included in Reporting V1 hotfix 8.<!---->
[http://mantis.innovaphone.com/view.php?id=76643 Definition]
[http://mantis.innovaphone.com/view.php?id=76643 Definition]


Line 746: Line 746:
|[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 757: Line 757:
|[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 772: Line 772:
|[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 783: Line 783:
|[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 794: Line 794:
|[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) =
These are the fixes included in Reporting V1 hotfix 9.
These are the fixes included in Reporting V1 hotfix 9.<!---->
[http://mantis.innovaphone.com/view.php?id=79707 Definition]
[http://mantis.innovaphone.com/view.php?id=79707 Definition]


Line 817: Line 817:
|[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 828: Line 828:
|[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 839: Line 839:
|[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 851: Line 851:
      
      
= V1 Hotfix 10 (10303) =
= V1 Hotfix 10 (10303) =
These are the fixes included in Reporting V1 hotfix 10.
These are the fixes included in Reporting V1 hotfix 10.<!---->
[http://mantis.innovaphone.com/view.php?id=81059 Definition]
[http://mantis.innovaphone.com/view.php?id=81059 Definition]


Line 867: Line 867:
|[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 878: Line 878:
|[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 893: Line 893:
|[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 904: Line 904:
|[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) =
These are the fixes included in Reporting V1 hotfix 11.
These are the fixes included in Reporting V1 hotfix 11.<!---->
[http://mantis.innovaphone.com/view.php?id=83653 Definition]
[http://mantis.innovaphone.com/view.php?id=83653 Definition]


Line 923: Line 923:
|[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 934: Line 934:
|[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 945: Line 945:
|[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 956: Line 956:
|[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 971: Line 971:
|[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 982: Line 982:
|[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) =
These are the fixes included in Reporting V1 hotfix 12.
These are the fixes included in Reporting V1 hotfix 12.<!---->
[http://mantis.innovaphone.com/view.php?id=85437 Definition]
[http://mantis.innovaphone.com/view.php?id=85437 Definition]


Line 1,001: Line 1,001:
|[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 1,012: Line 1,012:
|[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 1,023: Line 1,023:
|[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 1,036: Line 1,036:
|[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 1,051: Line 1,051:
|[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,062: Line 1,062:
|[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,073: Line 1,073:
|[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,084: Line 1,084:
|[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,095: Line 1,095:
|[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,106: Line 1,106:
|[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,117: Line 1,117:
|[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) =
These are the fixes included in Reporting V1 hotfix 13.
These are the fixes included in Reporting V1 hotfix 13.<!---->
[http://mantis.innovaphone.com/view.php?id=87141 Definition]
[http://mantis.innovaphone.com/view.php?id=87141 Definition]


Line 1,136: Line 1,136:
|[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,147: Line 1,147:
|[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,158: Line 1,158:
|[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,171: Line 1,171:
|[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,182: Line 1,182:
|[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,197: Line 1,197:
|[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,208: Line 1,208:
|[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,219: Line 1,219:
|[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,230: Line 1,230:
|[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,243: Line 1,243:
|[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,254: Line 1,254:
|[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) =
These are the fixes included in Reporting V1 hotfix 14.
These are the fixes included in Reporting V1 hotfix 14.<!---->
[http://mantis.innovaphone.com/view.php?id=91970 Definition]
[http://mantis.innovaphone.com/view.php?id=91970 Definition]


Line 1,273: Line 1,273:
|[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,284: Line 1,284:
|[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,295: Line 1,295:
|[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,310: Line 1,310:
|[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) =
These are the fixes included in Reporting V1 hotfix 15.
These are the fixes included in Reporting V1 hotfix 15.<!---->
[http://mantis.innovaphone.com/view.php?id=91972 Definition]
[http://mantis.innovaphone.com/view.php?id=91972 Definition]


Line 1,333: Line 1,333:
|[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,344: Line 1,344:
|[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,355: Line 1,355:
|[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,366: Line 1,366:
|[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,377: Line 1,377:
|[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 (10358) =
= V1 Hotfix 16 (10358) =
These are the fixes included in Reporting V1 hotfix 16.
These are the fixes included in Reporting V1 hotfix 16.<!---->
[http://mantis.innovaphone.com/view.php?id=91973 Definition]
[http://mantis.innovaphone.com/view.php?id=91973 Definition]


Line 1,400: Line 1,400:
|[http://mantis.innovaphone.com/view.php?id=92762 92762]
|[http://mantis.innovaphone.com/view.php?id=92762 92762]
|}
|}
A filter with too many conditions caused a buffer overrun.<br/><br/><!--<br/>pg_report.c<br/>--><!---->
A filter with too many conditions caused a buffer overrun.<br/><br/><!--<br/>pg_report.c<br/>-->
      
      
= V1 Hotfix 17 (10369) =
= V1 Hotfix 17 (10369) =
These are the fixes included in Reporting V1 hotfix 17.
These are the fixes included in Reporting V1 hotfix 17.<!---->
[http://mantis.innovaphone.com/view.php?id=93156 Definition]
[http://mantis.innovaphone.com/view.php?id=93156 Definition]


Line 1,419: Line 1,419:
|[http://mantis.innovaphone.com/view.php?id=94771 94771]
|[http://mantis.innovaphone.com/view.php?id=94771 94771]
|}
|}
With a change of the restore process, the restore time could be reduced.<br/><br/><!--<br/>config.sh<br/>Makefile<br/>make.sh<br/>onerror_template.sh<br/>install_reporting/faxserver/exchange.sh<br/>get_add_constraint_statement.psql<br/>get_add_index_statement.psql<br/>get_drop_statements.psql<br/>--><!---->
With a change of the restore process, the restore time could be reduced.<br/><br/><!--<br/>config.sh<br/>Makefile<br/>make.sh<br/>onerror_template.sh<br/>install_reporting/faxserver/exchange.sh<br/>get_add_constraint_statement.psql<br/>get_add_index_statement.psql<br/>get_drop_statements.psql<br/>-->
      
      
=== Direct report download on web interface ===
=== Direct report download on web interface ===
Line 1,430: Line 1,430:
|[http://mantis.innovaphone.com/view.php?id=94935 94935]
|[http://mantis.innovaphone.com/view.php?id=94935 94935]
|}
|}
For huge reports it might be usefull to directly download the report instead of viewing it in the browser first before downloading it.<br/><br/><!--<br/>java.js<br/>report.php<br/>report.xsl<br/>pg_report.c<br/>pg_report.h<br/>include.php<br/>--><!---->
For huge reports it might be usefull to directly download the report instead of viewing it in the browser first before downloading it.<br/><br/><!--<br/>java.js<br/>report.php<br/>report.xsl<br/>pg_report.c<br/>pg_report.h<br/>include.php<br/>-->
      
      
=== Added Italian translation ===
=== Added Italian translation ===
Line 1,441: Line 1,441:
|[http://mantis.innovaphone.com/view.php?id=95366 95366]
|[http://mantis.innovaphone.com/view.php?id=95366 95366]
|}
|}
Italian translation is now available for the Linux Application Platform and its applications.<br/><br/><!--<br/>all it language files<br/>--><!---->
Italian translation is now available for the Linux Application Platform and its applications.<br/><br/><!--<br/>all it language files<br/>-->
      
      
== Bug Fixes ==
== Bug Fixes ==
Line 1,456: Line 1,456:
|[http://mantis.innovaphone.com/view.php?id=93309 93309]
|[http://mantis.innovaphone.com/view.php?id=93309 93309]
|}
|}
The page was wrongly aligned.<br/><br/><!--<br/>login.php<br/>--><!---->
The page was wrongly aligned.<br/><br/><!--<br/>login.php<br/>-->
      
      
=== Deletion of a large amount of CDRs didn't work ===
=== Deletion of a large amount of CDRs didn't work ===
Line 1,467: Line 1,467:
|[http://mantis.innovaphone.com/view.php?id=94803 94803]
|[http://mantis.innovaphone.com/view.php?id=94803 94803]
|}
|}
If one tried to delete a large amount of CDRs (e.g. > 100000), the process failed without an error message.<br/>This is fixed now, although the process lasts longer now.<br/><br/><!--<br/>config_reporting.php<br/>--><!---->
If one tried to delete a large amount of CDRs (e.g. > 100000), the process failed without an error message.<br/>This is fixed now, although the process lasts longer now.<br/><br/><!--<br/>config_reporting.php<br/>-->
      
      
=== PDF report creation might have failed with selected grouping ===
=== PDF report creation might have failed with selected grouping ===
Line 1,478: Line 1,478:
|[http://mantis.innovaphone.com/view.php?id=94972 94972]
|[http://mantis.innovaphone.com/view.php?id=94972 94972]
|}
|}
The page count has been wrongly calculated, if the report has been grouped.<br/><br/><!--<br/>pg_report.c<br/>--><!---->
The page count has been wrongly calculated, if the report has been grouped.<br/><br/><!--<br/>pg_report.c<br/>-->
      
      
=== Limit web reports to prevent browser crashes ===
=== Limit web reports to prevent browser crashes ===
Line 1,489: Line 1,489:
|[http://mantis.innovaphone.com/view.php?id=95003 95003]
|[http://mantis.innovaphone.com/view.php?id=95003 95003]
|}
|}
If the shown web report is too large, some browsers are crashing.<br/>This is now prevented by a limit to the shown calls. The report itself can still be directly downloaded without this limit.<br/><br/><!--<br/>report.css<br/>report.xsl<br/>report.php<br/>include.php<br/>language files<br/>pg_report.c<br/>inno_lib.h<br/>--><!---->
If the shown web report is too large, some browsers are crashing.<br/>This is now prevented by a limit to the shown calls. The report itself can still be directly downloaded without this limit.<br/><br/><!--<br/>report.css<br/>report.xsl<br/>report.php<br/>include.php<br/>language files<br/>pg_report.c<br/>inno_lib.h<br/>-->
      
      
=== External calls mistakenly recognised as pickup calls ===
=== External calls mistakenly recognised as pickup calls ===
Line 1,500: Line 1,500:
|[http://mantis.innovaphone.com/view.php?id=95663 95663]
|[http://mantis.innovaphone.com/view.php?id=95663 95663]
|}
|}
If an external connected number differs from the called number, the call has been recognized as a pickup call.<br/><br/><!--<br/>pg_report.c<br/>--><!---->
If an external connected number differs from the called number, the call has been recognized as a pickup call.<br/><br/><!--<br/>pg_report.c<br/>-->
      
      
=== LDAP: add number resolution without percentage character ===
=== LDAP: add number resolution without percentage character ===
Line 1,511: Line 1,511:
|[http://mantis.innovaphone.com/view.php?id=95749 95749]
|[http://mantis.innovaphone.com/view.php?id=95749 95749]
|}
|}
a customer has problems with LDAP resolution and we guess the problem resides on the % character. Now the filter contains both cases, number with and without percentages.<!---->
a customer has problems with LDAP resolution and we guess the problem resides on the % character. Now the filter contains both cases, number with and without percentages.
      
      
= V1 Hotfix 18 (10371) =
= V1 Hotfix 18 (10371) =
These are the fixes included in Reporting V1 hotfix 18.
These are the fixes included in Reporting V1 hotfix 18.<!---->
[http://mantis.innovaphone.com/view.php?id=95927 Definition]
[http://mantis.innovaphone.com/view.php?id=95927 Definition]


Line 1,534: Line 1,534:
|[http://mantis.innovaphone.com/view.php?id=96062 96062]
|[http://mantis.innovaphone.com/view.php?id=96062 96062]
|}
|}
Mail tool was wrongly configured if user was given without password.<br/><br/><!--<br/>report.php<br/>config.sh<br/>--><!---->
Mail tool was wrongly configured if user was given without password.<br/><br/><!--<br/>report.php<br/>config.sh<br/>-->
      
      
=== myPBX call list authentication works with Reporting access credentials now ===
=== myPBX call list authentication works with Reporting access credentials now ===
Line 1,545: Line 1,545:
|[http://mantis.innovaphone.com/view.php?id=96094 96094]
|[http://mantis.innovaphone.com/view.php?id=96094 96094]
|}
|}
The myPBX call list authentication only worked with the Linux Web Server credentials, although it is possible to configure separate Reporting access credentials.<br/>Now both credentials will work.<br/><br/><!--<br/>mypbx.c<br/>--><!---->
The myPBX call list authentication only worked with the Linux Web Server credentials, although it is possible to configure separate Reporting access credentials.<br/>Now both credentials will work.<br/><br/><!--<br/>mypbx.c<br/>-->
      
      
= V1 Hotfix 19 (10372) =
= V1 Hotfix 19 (10372) =
These are the fixes included in Reporting V1 hotfix 19.
These are the fixes included in Reporting V1 hotfix 19.<!---->
[http://mantis.innovaphone.com/view.php?id=96850 Definition]
[http://mantis.innovaphone.com/view.php?id=96850 Definition]


Line 1,568: Line 1,568:
|[http://mantis.innovaphone.com/view.php?id=97621 97621]
|[http://mantis.innovaphone.com/view.php?id=97621 97621]
|}
|}
The "Stay logged in" checkmark didn't work.<br/><br/><!--<br/>login.php<br/>--><!---->
The "Stay logged in" checkmark didn't work.<br/><br/><!--<br/>login.php<br/>-->
      
      
=== Report number filtering only checks first number now ===
=== Report number filtering only checks first number now ===
Line 1,579: Line 1,579:
|[http://mantis.innovaphone.com/view.php?id=97703 97703]
|[http://mantis.innovaphone.com/view.php?id=97703 97703]
|}
|}
Instead of checking all numbers, just the first relevant number is checked now.<br/><br/><!--<br/>report.php<br/>cdr.c<br/>pg_report.c/.h<br/>--><!---->
Instead of checking all numbers, just the first relevant number is checked now.<br/><br/><!--<br/>report.php<br/>cdr.c<br/>pg_report.c/.h<br/>-->
      
      
=== User defined filter can be deleted now ===
=== User defined filter can be deleted now ===
Line 1,590: Line 1,590:
|[http://mantis.innovaphone.com/view.php?id=97721 97721]
|[http://mantis.innovaphone.com/view.php?id=97721 97721]
|}
|}
The check if the filter can be deleted has been fixed and a user defined filter can be deleted now.<br/><br/><!--<br/>config_reporting.php<br/>--><!---->
The check if the filter can be deleted has been fixed and a user defined filter can be deleted now.<br/><br/><!--<br/>config_reporting.php<br/>-->
      
      
= V1 Hotfix 20 (10375) =
= V1 Hotfix 20 (10375) =
These are the fixes included in Reporting V1 hotfix 20.
These are the fixes included in Reporting V1 hotfix 20.<!---->
[http://mantis.innovaphone.com/view.php?id=98559 Definition]
[http://mantis.innovaphone.com/view.php?id=98559 Definition]


Line 1,613: Line 1,613:
|[http://mantis.innovaphone.com/view.php?id=99330 99330]
|[http://mantis.innovaphone.com/view.php?id=99330 99330]
|}
|}
Creation of web reports in IE10 wasn't working.<br/><br/><!--<br/>java.js<br/>--><!---->
Creation of web reports in IE10 wasn't working.<br/><br/><!--<br/>java.js<br/>-->
      
      
=== Force PostgreSQL to free disk space after deletion of CDRs ===
=== Force PostgreSQL to free disk space after deletion of CDRs ===
Line 1,624: Line 1,624:
|[http://mantis.innovaphone.com/view.php?id=99967 99967]
|[http://mantis.innovaphone.com/view.php?id=99967 99967]
|}
|}
PostgreSQL does not free disk space after deletion of table data to keep the space for further usage.<br/>Now this space is really freed after deleting CDRs.<br/><br/><!--<br/>config.sh<br/>config_reporting.php<br/>--><!---->
PostgreSQL does not free disk space after deletion of table data to keep the space for further usage.<br/>Now this space is really freed after deleting CDRs.<br/><br/><!--<br/>config.sh<br/>config_reporting.php<br/>-->
      
      
= V1 Hotfix 21 (10376) =
= V1 Hotfix 21 (10376) =
These are the fixes included in Reporting V1 hotfix 21.
These are the fixes included in Reporting V1 hotfix 21.<!---->
[http://mantis.innovaphone.com/view.php?id=99996 Definition]
[http://mantis.innovaphone.com/view.php?id=99996 Definition]


Line 1,643: Line 1,643:
|[http://mantis.innovaphone.com/view.php?id=100942 100942]
|[http://mantis.innovaphone.com/view.php?id=100942 100942]
|}
|}
Currently only latin1 languages were possible within the web interface. Now also UTF8 only languages are possible.<br/><br/><!--<br/>translator.class.php<br/>include_main.php<br/>all language files in UTF-8 now<br/>--><!---->
Currently only latin1 languages were possible within the web interface. Now also UTF8 only languages are possible.<br/><br/><!--<br/>translator.class.php<br/>include_main.php<br/>all language files in UTF-8 now<br/>-->
      
      
== Bug Fixes ==
== Bug Fixes ==
Line 1,650: Line 1,650:
      
      
= V1 Hotfix 22 (10377) =
= V1 Hotfix 22 (10377) =
These are the fixes included in Reporting V1 hotfix 22.
These are the fixes included in Reporting V1 hotfix 22.<!---->
[http://mantis.innovaphone.com/view.php?id=101086 Definition]
[http://mantis.innovaphone.com/view.php?id=101086 Definition]


Line 1,670: Line 1,670:
|[http://mantis.innovaphone.com/view.php?id=101846 101846]
|[http://mantis.innovaphone.com/view.php?id=101846 101846]
|}
|}
<!--<br/>cdr.c<br/>reporting_config.c<br/>config_reporting.php<br/>--><!---->
<!--<br/>cdr.c<br/>reporting_config.c<br/>config_reporting.php<br/>-->
      
      
=== Wrong http error strings returned on failing CDR ===
=== Wrong http error strings returned on failing CDR ===
Line 1,681: Line 1,681:
|[http://mantis.innovaphone.com/view.php?id=101969 101969]
|[http://mantis.innovaphone.com/view.php?id=101969 101969]
|}
|}
There was a mismatch of error code and error string.<br/><br/><!--<br/>inno-lib.c<br/>--><!---->
There was a mismatch of error code and error string.<br/><br/><!--<br/>inno-lib.c<br/>-->
      
      
=== Retry CDR insert after broken postgresql connection ===
=== Retry CDR insert after broken postgresql connection ===
Line 1,692: Line 1,692:
|[http://mantis.innovaphone.com/view.php?id=102304 102304]
|[http://mantis.innovaphone.com/view.php?id=102304 102304]
|}
|}
Instead of directly returning an error, the insert is now retried one time.<br/><br/><!--<br/>process.c<br/>--><!---->
Instead of directly returning an error, the insert is now retried one time.<br/><br/><!--<br/>process.c<br/>-->
      
      
= V1 Hotfix 23 (10380) =
= V1 Hotfix 23 (10380) =
These are the fixes included in Reporting V1 hotfix 23.
These are the fixes included in Reporting V1 hotfix 23.<!---->
[http://mantis.innovaphone.com/view.php?id=102533 Definition]
[http://mantis.innovaphone.com/view.php?id=102533 Definition]


Line 1,707: Line 1,707:
      
      
= V1 Hotfix 24 (10383) =
= V1 Hotfix 24 (10383) =
These are the fixes included in Reporting V1 hotfix 24.
These are the fixes included in Reporting V1 hotfix 24.<!---->
[http://mantis.innovaphone.com/view.php?id=107998 Definition]
[http://mantis.innovaphone.com/view.php?id=107998 Definition]


Line 1,727: Line 1,727:
|[http://mantis.innovaphone.com/view.php?id=107134 107134]
|[http://mantis.innovaphone.com/view.php?id=107134 107134]
|}
|}
From 60 to 1024 chars.<br/><br/><!--<br/>config_reporting.php<br/>--><!---->
From 60 to 1024 chars.<br/><br/><!--<br/>config_reporting.php<br/>-->
      
      
=== Correctly escape long name and pbx/system name ===
=== Correctly escape long name and pbx/system name ===
Line 1,738: Line 1,738:
|[http://mantis.innovaphone.com/view.php?id=107723 107723]
|[http://mantis.innovaphone.com/view.php?id=107723 107723]
|}
|}
Otherwise the report generation failed.<br/><br/><!--<br/>report.php<br/>include.php<br/>pg_report.c<br/>mypbx.c<br/>inputpage.class.php<br/>--><!---->
Otherwise the report generation failed.<br/><br/><!--<br/>report.php<br/>include.php<br/>pg_report.c<br/>mypbx.c<br/>inputpage.class.php<br/>-->
      
      
=== Fix wrongly released version number in cumulative hotfix ===
=== Fix wrongly released version number in cumulative hotfix ===
Line 1,749: Line 1,749:
|[http://mantis.innovaphone.com/view.php?id=107872 107872]
|[http://mantis.innovaphone.com/view.php?id=107872 107872]
|}
|}
The cumulative hotfix 23 contained a hotfix 22 with a wrong build number 10378.<br/>The cumulative hotfix 24 will now replace this number with 10377 and further hotfixes will be installed correctly.<br/><br/><!--<br/>install_hotfixes.sh<br/>--><!---->
The cumulative hotfix 23 contained a hotfix 22 with a wrong build number 10378.<br/>The cumulative hotfix 24 will now replace this number with 10377 and further hotfixes will be installed correctly.<br/><br/><!--<br/>install_hotfixes.sh<br/>-->
      
      
= V1 Hotfix 25 (10386) =
= V1 Hotfix 25 (10386) =
These are the fixes included in Reporting V1 hotfix 25.
These are the fixes included in Reporting V1 hotfix 25.<!---->
[http://mantis.innovaphone.com/view.php?id=108002 Definition]
[http://mantis.innovaphone.com/view.php?id=108002 Definition]


Line 1,772: Line 1,772:
|[http://mantis.innovaphone.com/view.php?id=108667 108667]
|[http://mantis.innovaphone.com/view.php?id=108667 108667]
|}
|}
The connected number was shown as "N/A". Now the correct connected number is shown.<br/><br/><!--<br/>pg_report.c<br/>--><!---->
The connected number was shown as "N/A". Now the correct connected number is shown.<br/><br/><!--<br/>pg_report.c<br/>-->
      
      
=== Report compatibility with IE 11 ===
=== Report compatibility with IE 11 ===
Line 1,783: Line 1,783:
|[http://mantis.innovaphone.com/view.php?id=109496 109496]
|[http://mantis.innovaphone.com/view.php?id=109496 109496]
|}
|}
Microsoft changed their navigator.appName to "Netscape" (obviously) so we needed another check to test for Internet Explorer...<br/><br/><!--<br/>java.js<br/>--><!---->
Microsoft changed their navigator.appName to "Netscape" (obviously) so we needed another check to test for Internet Explorer...<br/><br/><!--<br/>java.js<br/>-->
      
      
= V1 Hotfix 26 (10387) =
= V1 Hotfix 26 (10387) =
These are the fixes included in Reporting V1 hotfix 26.
These are the fixes included in Reporting V1 hotfix 26.<!---->
[http://mantis.innovaphone.com/view.php?id=109658 Definition]
[http://mantis.innovaphone.com/view.php?id=109658 Definition]


Line 1,806: Line 1,806:
|[http://mantis.innovaphone.com/view.php?id=110893 110893]
|[http://mantis.innovaphone.com/view.php?id=110893 110893]
|}
|}
LDAP filter was not built correctly, add exact number dialed<br/><br/><!--<br/>cdr.c<br/>--><!---->
LDAP filter was not built correctly, add exact number dialed<br/><br/><!--<br/>cdr.c<br/>-->
      
      
=== LDAP: name resolution for an internal number in special case ===
=== LDAP: name resolution for an internal number in special case ===
Line 1,817: Line 1,817:
|[http://mantis.innovaphone.com/view.php?id=111136 111136]
|[http://mantis.innovaphone.com/view.php?id=111136 111136]
|}
|}
setup-from before an unconditional diversion contains no name information.<br/><br/><!--<br/>cdr.c<br/>--><!---->
setup-from before an unconditional diversion contains no name information.<br/><br/><!--<br/>cdr.c<br/>-->
      
      
= V1 Hotfix 27 =
= V1 Hotfix 27 =
These are the fixes included in Reporting V1 hotfix 27.
These are the fixes included in Reporting V1 hotfix 27.<!---->
[http://mantis.innovaphone.com/view.php?id=111548 Definition]
[http://mantis.innovaphone.com/view.php?id=111548 Definition]


Line 1,840: Line 1,840:
|[http://mantis.innovaphone.com/view.php?id=112320 112320]
|[http://mantis.innovaphone.com/view.php?id=112320 112320]
|}
|}
The customer did not entry the phone number im LDAP Server including area code for local numbers.<br/><br/><!--<br/>cdr.c<br/>--><!---->
The customer did not entry the phone number im LDAP Server including area code for local numbers.<br/><br/><!--<br/>cdr.c<br/>-->
      
      
=== Fixed wrong reporting data for certain call forwards ===
=== Fixed wrong reporting data for certain call forwards ===
Line 1,851: Line 1,851:
|[http://mantis.innovaphone.com/view.php?id=112365 112365]
|[http://mantis.innovaphone.com/view.php?id=112365 112365]
|}
|}
Certain call forward scenarios produced wrong caller information reports.<br/>Old CDRs will be still wrongly shown. Just new CDRs are fixed.<br/><br/><!--<br/>cdr.c<br/>--><!---->
Certain call forward scenarios produced wrong caller information reports.<br/>Old CDRs will be still wrongly shown. Just new CDRs are fixed.<br/><br/><!--<br/>cdr.c<br/>-->

Revision as of 17:40, 2 January 2014

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.

reporting: logo and footer for pdf reports

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 7 (10285)

These are the fixes included in Reporting V1 hotfix 7. Definition

New Features

Reporting: Localised date and time format in myPBX call list

Status Closed
Id 76779

Call list shall contain localised date and time. Also today's and yesterday's date should be replaced by words.

reporting: make LDAP queries for Trunk Line Objects

Status Closed
Id 76906

we now see in reports in the "Left" column "external number Amt" for the Amt object but this external number may appear in LDAP. If this number is found in LDAP, we replace previous value with the LDAP result.

moved/changed some shared code for future innovaphone applications

Status Closed
Id 77381

Some shared code has been moved for future innovaphone applications for the linux application platform.

Bug Fixes

check for postgresql installation before editing postgresql conf file

Status Closed
Id 77334

only remove certain lines from default pg_hba.conf file if postgresql hasn't been installed yet.

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 (10358)

These are the fixes included in Reporting V1 hotfix 16. Definition

New Features

Bug Fixes

Filter with too many conditions failed

Status Closed
Id 92762

A filter with too many conditions caused a buffer overrun.

V1 Hotfix 17 (10369)

These are the fixes included in Reporting V1 hotfix 17. Definition

New Features

Increased performance of database restore

Status Closed
Id 94771

With a change of the restore process, the restore time could be reduced.

Direct report download on web interface

Status Closed
Id 94935

For huge reports it might be usefull to directly download the report instead of viewing it in the browser first before downloading it.

Added Italian translation

Status Closed
Id 95366

Italian translation is now available for the Linux Application Platform and its applications.

Bug Fixes

Fixed user login page alignment

Status Closed
Id 93309

The page was wrongly aligned.

Deletion of a large amount of CDRs didn't work

Status Closed
Id 94803

If one tried to delete a large amount of CDRs (e.g. > 100000), the process failed without an error message.
This is fixed now, although the process lasts longer now.

PDF report creation might have failed with selected grouping

Status Closed
Id 94972

The page count has been wrongly calculated, if the report has been grouped.

Limit web reports to prevent browser crashes

Status Closed
Id 95003

If the shown web report is too large, some browsers are crashing.
This is now prevented by a limit to the shown calls. The report itself can still be directly downloaded without this limit.

External calls mistakenly recognised as pickup calls

Status Closed
Id 95663

If an external connected number differs from the called number, the call has been recognized as a pickup call.

LDAP: add number resolution without percentage character

Status Closed
Id 95749

a customer has problems with LDAP resolution and we guess the problem resides on the % character. Now the filter contains both cases, number with and without percentages.

V1 Hotfix 18 (10371)

These are the fixes included in Reporting V1 hotfix 18. Definition

New Features

Bug Fixes

Mails: allow SMTP Relay without Authentication

Status Closed
Id 96062

Mail tool was wrongly configured if user was given without password.

myPBX call list authentication works with Reporting access credentials now

Status Closed
Id 96094

The myPBX call list authentication only worked with the Linux Web Server credentials, although it is possible to configure separate Reporting access credentials.
Now both credentials will work.

V1 Hotfix 19 (10372)

These are the fixes included in Reporting V1 hotfix 19. Definition

New Features

Bug Fixes

Save Reporting user login in browser

Status Closed
Id 97621

The "Stay logged in" checkmark didn't work.

Report number filtering only checks first number now

Status Closed
Id 97703

Instead of checking all numbers, just the first relevant number is checked now.

User defined filter can be deleted now

Status Closed
Id 97721

The check if the filter can be deleted has been fixed and a user defined filter can be deleted now.

V1 Hotfix 20 (10375)

These are the fixes included in Reporting V1 hotfix 20. Definition

New Features

Bug Fixes

IE10 compatibility for web reports

Status Closed
Id 99330

Creation of web reports in IE10 wasn't working.

Force PostgreSQL to free disk space after deletion of CDRs

Status Closed
Id 99967

PostgreSQL does not free disk space after deletion of table data to keep the space for further usage.
Now this space is really freed after deleting CDRs.

V1 Hotfix 21 (10376)

These are the fixes included in Reporting V1 hotfix 21. Definition

New Features

Support of UTF-8 only languages like Russian

Status Closed
Id 100942

Currently only latin1 languages were possible within the web interface. Now also UTF8 only languages are possible.

Bug Fixes

V1 Hotfix 22 (10377)

These are the fixes included in Reporting V1 hotfix 22. Definition

New Features

Bug Fixes

LDAP: traces for unset parameters

Status Closed
Id 101846

Wrong http error strings returned on failing CDR

Status Closed
Id 101969

There was a mismatch of error code and error string.

Retry CDR insert after broken postgresql connection

Status Closed
Id 102304

Instead of directly returning an error, the insert is now retried one time.

V1 Hotfix 23 (10380)

These are the fixes included in Reporting V1 hotfix 23. Definition

New Features

Bug Fixes

V1 Hotfix 24 (10383)

These are the fixes included in Reporting V1 hotfix 24. Definition

New Features

Bug Fixes

Increased max length of report mails field

Status Closed
Id 107134

From 60 to 1024 chars.

Correctly escape long name and pbx/system name

Status Closed
Id 107723

Otherwise the report generation failed.

Fix wrongly released version number in cumulative hotfix

Status Closed
Id 107872

The cumulative hotfix 23 contained a hotfix 22 with a wrong build number 10378.
The cumulative hotfix 24 will now replace this number with 10377 and further hotfixes will be installed correctly.

V1 Hotfix 25 (10386)

These are the fixes included in Reporting V1 hotfix 25. Definition

New Features

Bug Fixes

Correctly show connected number in report if no alert is present and setup is empty

Status Closed
Id 108667

The connected number was shown as "N/A". Now the correct connected number is shown.

Report compatibility with IE 11

Status Closed
Id 109496

Microsoft changed their navigator.appName to "Netscape" (obviously) so we needed another check to test for Internet Explorer...

V1 Hotfix 26 (10387)

These are the fixes included in Reporting V1 hotfix 26. Definition

New Features

Bug Fixes

LDAP: search filter was not correct

Status Closed
Id 110893

LDAP filter was not built correctly, add exact number dialed

LDAP: name resolution for an internal number in special case

Status Closed
Id 111136

setup-from before an unconditional diversion contains no name information.

V1 Hotfix 27

These are the fixes included in Reporting V1 hotfix 27. Definition

New Features

Bug Fixes

LDAP: Name resolution did not work for local numbers

Status To-decide
Id 112320

The customer did not entry the phone number im LDAP Server including area code for local numbers.

Fixed wrong reporting data for certain call forwards

Status To-decide
Id 112365

Certain call forward scenarios produced wrong caller information reports.
Old CDRs will be still wrongly shown. Just new CDRs are fixed.

Retrieved from "https://wiki.innovaphone.com/index.php?title=ReleaseNotes9:Linux_Reporting&oldid=32097"