VoIP Mailing List Archives

[lcm at marshap.com]

I would like to process the ${billsec} variable in the conf/autoload_configs/cdr_csv.conf.xml file below, returning a different value for the INSERT command.

I already have written a lua function which takes an integer value from ${billsec} and returns a string. It is stored in freeswitch/scripts as sec2time.lua.

Do I change the sql template below to …, ${lua(billsec)}, …?

<configuration name="cdr_csv.conf" description="CDR CSV Format">
<settings>
<param name="default-template" value="sql"/>
<param name="rotate-on-hup" value="true"/>
<param name="legs" value="a"/>
</settings>
<templates>
<template name="sql">INSERT INTO cdr VALUES ("${caller_id_name}","${caller_id_number}","${destination_number}","${context}"
,"${start_stamp}","${answer_stamp}","${end_stamp}","${duration}","${billsec}",...
</templates>
</configuration>

Thanks, Lars

[brian at freeswitch.org]

Nope those aren't expanded there. Can you not post process this?

/b

On May 31, 2009, at 11:50 AM, Larry Marshall wrote: