I have defined the following template in autoload_config/cdr_csv.conf.xml:

 

<template name="sql">"${caller_id_name}","${caller_id_number}","${destination_number}","${context}","${start_stamp}","${answer_stamp}",

"${end_stamp}","${duration}","${billsec}","${hangup_cause}","${uuid}","${bleg_uuid}","${accountcode}","${read_codec}","${write_codec}",

"${channel_name}","${bridge_channel}","${direction}"</template>

 

 

The resultant Master.csv in logs/1000.csv:

 

"+19495551212","+19495551212","1000","default","2009-06-18 09:59:59","2009-06-18 10:00:06","2009-06-18 10:01:16","77","70","NORMAL_CLEARING","7551138e-5c29-11de-80e6-1b59605a543b","75574754-5c29-11de-80e6-1b59605a543b","","PCMU","PCMU","sofia/external/+19495551212@66.53.188.187","sofia/internal/sip:1001@192.168.10.101",""

 

Both ${direction} and ${accountcode} do not have any data in the cdr file. Am I using the wrong variable names? I do see Caller-Direction with a valid value ([inbound]) in freeswitch.log, but nothing like accountcode. The wiki at http://wiki.freeswitch.org/wiki/Channel_Variables#variable_xxxx says that both these variables exist.

 

Thanks for any help, Lars