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