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