After we have upgraded from V12.5 to V14 creating the reports is really a challenge. Generally, I can handle CDR Reports if they are in form, that can be easyly handled by Excel.
But the V14 CDR reports are really difficult to read and to aggregate the data:
a)
There are cells (data) that makes the aggregation very difficult. Example: the heading is repeating itself after every 20 rows. In my report (calls from last 2 months) there are about 20K rows, so eliminating such a cells/rows manually is not an option. The same with the page number (that makes really no sense to have it in Excel).
Is there any option the get plain raw CDR data?
b)
The structure of the CDRs is totally different than it was with V12.5. In 12.5 it was one row per call, so the aggregation was simple. Now in V14 there can several rows for one call, so the aggregation is very difficult.
I want a report about the call flow (kind of matrix):
Who got how much calls? How many calls were ansered on the primary target and how many of them were routed to other destination and what happened there (ansered or not answered)? Important is to see the relation between the first and last target. In the V12.5 there was a column with the information about the targets, like 1234 -> 2345 (first target -> last target). This column disappeard now and instead there are additional columns... But they can not be handled in Excel by simply creating a pivot...
We need this to verify our routing and configuration of the groups and queues.
Any idea or tipp how could be solved this?
But the V14 CDR reports are really difficult to read and to aggregate the data:
a)
There are cells (data) that makes the aggregation very difficult. Example: the heading is repeating itself after every 20 rows. In my report (calls from last 2 months) there are about 20K rows, so eliminating such a cells/rows manually is not an option. The same with the page number (that makes really no sense to have it in Excel).
Is there any option the get plain raw CDR data?
b)
The structure of the CDRs is totally different than it was with V12.5. In 12.5 it was one row per call, so the aggregation was simple. Now in V14 there can several rows for one call, so the aggregation is very difficult.
I want a report about the call flow (kind of matrix):
Who got how much calls? How many calls were ansered on the primary target and how many of them were routed to other destination and what happened there (ansered or not answered)? Important is to see the relation between the first and last target. In the V12.5 there was a column with the information about the targets, like 1234 -> 2345 (first target -> last target). This column disappeard now and instead there are additional columns... But they can not be handled in Excel by simply creating a pivot...
We need this to verify our routing and configuration of the groups and queues.
Any idea or tipp how could be solved this?
