Most appropriate mapping between Asterisk CDR and XML CDR
I am trying to work out the most appropriate mapping between the Asterisk CDR and Freeswitch xml_cdr as an app of mine is based on the Asterisk CDR. The xml cdr is quite large and some of the values are repeated in the different sections. This is the nearest I have come to, I have omitted the full paths to the values, but would like to use the right paths if they are the most meaningful. The example displays t a call from extension 1001 to an external number 08451234567 calldate <start_stamp>2010-04-14%2023%3A08%3A10</start_stamp> or <start_epoch>1271282890</start_epoch> or <created_time>1271282890796875</created_time> clid <caller_id_name>Booth1</caller_id_name> + <caller_id_number>1001</caller_id_number> src <ani>1001</ani> or <username>1001</username> dst <destination_number>08451234567</destination_number> dcontext <context>default</context> channel <bridge_channel>sofia/internal/1001%40192.168.1.133</bridge_channel> or<chan_name>sofia/internal/1001@192.168.1.133</chan_name> dstchannel <chan_name>sofia/external/08451234567</chan_name> lastapp <application app_name="bridge" app_data="sofia/gateway/ provider.co.uk/08451234567"></application> lastdata <chan_name>sofia/external/08451234567</chan_name> duration <duration>46</duration> billsec <billsec>18</billsec> disposition <endpoint_disposition>ANSWER</endpoint_disposition>? amaflags bigint, accountcode - <accountcode>1001</accountcode> uniqueid character uuid=ce234b00-157a-456f-97be-62d15a53b0c9 Is there some guide to which values are more appropriate? I checked the templates for cdr_csv but the look rather simple to me, being as ever a sucker for complexity. -- Frank Church ======================= http://devblog.brahmancreations.com
Their already exists a default on cdr.conf.xml that shows you the exact ones that map as close as possible. <template name="asterisk">"${accountcode}","${caller_id_number}","${destination_number}","${context}","${caller_id}","${channel_name}","${bridge_channel}","${last_app}","${last_arg}","${start_stamp}","${answer_stamp}","${end_stamp}","${duration}","${billsec}","${hangup_cause}","${amaflags}","${uuid}","${userfield}"</template> Its already in cdr_csv.conf.xml /b On Apr 14, 2010, at 7:32 PM, Frank Church wrote:
I am trying to work out the most appropriate mapping between the Asterisk CDR and Freeswitch xml_cdr as an app of mine is based on the Asterisk CDR.
The xml cdr is quite large and some of the values are repeated in the different sections. This is the nearest I have come to, I have omitted the full paths to the values, but would like to use the right paths if they are the most meaningful.
The example displays t a call from extension 1001 to an external number 08451234567
calldate <start_stamp>2010-04-14%2023%3A08%3A10</start_stamp> or <start_epoch>1271282890</start_epoch> or <created_time>1271282890796875</created_time> clid <caller_id_name>Booth1</caller_id_name> + <caller_id_number>1001</caller_id_number> src <ani>1001</ani> or <username>1001</username> dst <destination_number>08451234567</destination_number> dcontext <context>default</context> channel <bridge_channel>sofia/internal/1001%40192.168.1.133</bridge_channel> or<chan_name>sofia/internal/1001@192.168.1.133</chan_name> dstchannel <chan_name>sofia/external/08451234567</chan_name> lastapp <application app_name="bridge" app_data="sofia/gateway/provider.co.uk/08451234567"></application> lastdata <chan_name>sofia/external/08451234567</chan_name> duration <duration>46</duration> billsec <billsec>18</billsec> disposition <endpoint_disposition>ANSWER</endpoint_disposition>? amaflags bigint, accountcode - <accountcode>1001</accountcode> uniqueid character uuid=ce234b00-157a-456f-97be-62d15a53b0c9
Is there some guide to which values are more appropriate? I checked the templates for cdr_csv but the look rather simple to me, being as ever a sucker for complexity.
-- Frank Church
======================= http://devblog.brahmancreations.com _______________________________________________ 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
participants (2)
-
Brian West
-
Frank Church