[Freeswitch-users] XML CDRs

[Tim Panton]

On 29 Jan 2008, at 21:34, David Knell wrote:

> Hi -
>
> Having installed mod_limit, my XML CDRs now sometimes - if the limit's
> exceeded -
> have two <callflow> sections, and I guess there can be an arbitrary
> number of them if
> a call's transferred from extension to extension, or whatever.
>
> My problem is knowing how to chain them together in the right order.
> The <times>
> section in each contains a <transfer_time> which I can use with the
> <profile_created_time>
> to chain them together - at least in the examples I've got - but  
> this is
> a bit fiddly.
>
> Am I missing something obvious?

Assuming you aren't missing a freeswitch thing, have you thought of  
using XSL to
do the extract and chain ? For moderate sized XML chunks this should  
be a good way to go.

For larger files, we have been inserting the XML CDR into an oracle  
XMLTYPE field, then
we can run mixed Xpath and SQL queries against them. I'm not sure I  
like the
results (yet), but it's early days.



Tim.