Do you have any way to ensure that those variables are populated? Can you manually set those in the dialplan? Also, are you doing a leg only or b leg only or both? -MC On Thu, Jun 18, 2009 at 2:54 PM, Lars Zeb <larclap@yahoo.com> wrote:

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<sip%3A1001@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

_______________________________________________ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org