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