[Freeswitch-users] How create customize CDR in free-Switch .

Discussion:

Abdullah

2013-06-20 05:40:56 UTC

hi all ,

Please help me for creating CDR in Free-switch SIP Server,
i don't want to use XML-CDR or any other build in Module .

any idea ,

thanks for sharing with me your experience .

--
View this message in context: http://freeswitch-users.2379917.n2.nabble.com/How-create-customize-CDR-in-free-Switch-tp7591980.html
Sent from the freeswitch-users mailing list archive at Nabble.com.

Anthony Minessale

2013-06-20 06:11:47 UTC

Permalink

Write one in C by making a new module and registering a global state
handler and catching the on_reporting state for every channel, then pull
the data off the session and do whatever you want.

Post by Abdullah
hi all ,
Please help me for creating CDR in Free-switch SIP Server,
i don't want to use XML-CDR or any other build in Module .
any idea ,
thanks for sharing with me your experience .
--
http://freeswitch-users.2379917.n2.nabble.com/How-create-customize-CDR-in-free-Switch-tp7591980.html
Sent from the freeswitch-users mailing list archive at Nabble.com.
_________________________________________________________________________
consulting at freeswitch.org
http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com
Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com
FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

--
Anthony Minessale II

FreeSWITCH http://www.freeswitch.org/
ClueCon http://www.cluecon.com/
Twitter: http://twitter.com/FreeSWITCH_wire

AIM: anthm
MSN:anthony_minessale at hotmail.com
GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888 at conference.freeswitch.org
googletalk:conf+888 at conference.freeswitch.org
pstn:+19193869900
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130620/364c3bad/attachment-0001.html

Abdullah

2013-06-20 06:33:15 UTC

Permalink

thanks Anthony Minessale,

can you give example ??

--
View this message in context: http://freeswitch-users.2379917.n2.nabble.com/How-create-customize-CDR-in-free-Switch-tp7591980p7591985.html
Sent from the freeswitch-users mailing list archive at Nabble.com.

Ashwin Rath

2013-06-20 06:49:40 UTC

Permalink

Hi Abdullah

You can start by using the skeleton of the mod cdr csv

What exactly are you trying to achieve ? is it the formatting ? or is it
the rollout frequency ?

Post by Abdullah
thanks Anthony Minessale,
can you give example ??
--
http://freeswitch-users.2379917.n2.nabble.com/How-create-customize-CDR-in-free-Switch-tp7591980p7591985.html
Sent from the freeswitch-users mailing list archive at Nabble.com.
_________________________________________________________________________
consulting at freeswitch.org
http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com
Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com
FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

--
Ashwin Kumar Rath
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130620/13ddaf1b/attachment.html

Abdullah

2013-06-20 07:22:27 UTC

Permalink

hi ,

basically i want to store data of Call on A-Leg,
like following Field , caller-id ,context ,channel ,trunk information ,
duration , status (answer,hangup etc) ,Extension append with any
international code if call come from USA DID number to my FS like 444XXXXX.
i want to store caller_id with 1444xxxxx .

ANY IDEA ??

--
View this message in context: http://freeswitch-users.2379917.n2.nabble.com/How-create-customize-CDR-in-free-Switch-tp7591980p7591992.html
Sent from the freeswitch-users mailing list archive at Nabble.com.

Avi Marcus

2013-06-20 07:48:41 UTC

Permalink

We have lots of ideas. However, most of this information is readily
available on the wiki or in the FreeSWITCH books. Please give those a try.
If you run into an issue then you can ask a specific question.

If you want someone to just do it for you, that's always available for a
price: email consulting at FreeSWITCH.org for a quote or post to the biz list.

-Avi

Post by Abdullah
hi ,
basically i want to store data of Call on A-Leg,
like following Field , caller-id ,context ,channel ,trunk information ,
duration , status (answer,hangup etc) ,Extension append with any
international code if call come from USA DID number to my FS like 444XXXXX.
i want to store caller_id with 1444xxxxx .
ANY IDEA ??
--
http://freeswitch-users.2379917.n2.nabble.com/How-create-customize-CDR-in-free-Switch-tp7591980p7591992.html
Sent from the freeswitch-users mailing list archive at Nabble.com.
_________________________________________________________________________
consulting at freeswitch.org
http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com
Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com
FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130620/73d2c044/attachment.html

Nyamul Hassan

2013-06-20 07:44:18 UTC

Permalink

The requirement looks pretty basic.

I would personally do as follows:
1. Choose XML CDR
2. Write a script (my choice would be in PHP) that would:
a) get list of files in XML CDR folder
b) parse each of the XML files to extract the fields you mentioned
c) add 1444 in front of caller-id
d) write to database
e) move the XML file to a backup folder

Regards
HASSAN

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130620/3c626518/attachment.html

Nyamul Hassan

2013-06-20 07:10:38 UTC

Permalink

Hi Abdullah,

From my personal experience, XML CDR is the ultimate format you can ask for.

Understanding XML files does need some work in the start, but the way it
stores the call flow is priceless, and helps address many scenarios.

Perhaps you can be more specific as to why you don't want to use XML CDR?

Regards
HASSAN

Hi Abdullah
You can start by using the skeleton of the mod cdr csv
What exactly are you trying to achieve ? is it the formatting ? or is it
the rollout frequency ?

--
Ashwin Kumar Rath
_________________________________________________________________________
consulting at freeswitch.org
http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com
Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com
FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130620/8fec74cc/attachment.html

Michael Jerris

2013-06-20 14:41:07 UTC

Permalink

if you look in the event_handlers directory grep for on_reporting, there are several examples in there.

Mike

Post by Abdullah
thanks Anthony Minessale,
can you give example ??

Avi Marcus

2013-06-20 06:40:45 UTC

Permalink

Are you sure you don't just want a CSV file with the information about the
call?
http://wiki.freeswitch.org/wiki/Mod_cdr_csv

And for examples of how to build CDR reporting modules, check the code for
mod_cdr_csv and the other CDR modules.

-Avi

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130620/194d8b18/attachment-0001.html

Abdullah

2013-06-20 14:20:11 UTC

Permalink

HI ALL,

I have used *"XML-CDR"* in free-switch .

I have successfully created Cdr IN TABLE OF cdr with default pattern .

I want to change that field name and data with append some digit on its
caller_id .

any Idea,

THANKS

--
View this message in context: http://freeswitch-users.2379917.n2.nabble.com/How-create-customize-CDR-in-free-Switch-tp7591980p7592004.html
Sent from the freeswitch-users mailing list archive at Nabble.com.

Nyamul Hassan

2013-06-20 15:12:37 UTC

Permalink

Which method of output in XML_CDR did you implement? There are two:

1. Writing to a file on disk and then parsing the file
2. Writing to HTTP / HTTPS via POST and handle the parsing on the web
server side

As in the earlier suggested solution from myself, I prefer #1. An added
advantage of this is, I can see the content of the XML file in a simple
text file reader, and modify my parsing script accordingly.

Usually the "sip_from_user" variable carries the "caller id". If that is
true for your case, then in PHP it would be something like (assuming
$sip_from_user is initiated with the corresponding XML value):

$sip_from_user = "1444" . $sip_from_user;

Regards
HASSAN

Post by Abdullah
HI ALL,
I have used *"XML-CDR"* in free-switch .
I have successfully created Cdr IN TABLE OF cdr with default pattern .
I want to change that field name and data with append some digit on its
caller_id .
any Idea,
THANKS
--
http://freeswitch-users.2379917.n2.nabble.com/How-create-customize-CDR-in-free-Switch-tp7591980p7592004.html
Sent from the freeswitch-users mailing list archive at Nabble.com.
_________________________________________________________________________
consulting at freeswitch.org
http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com
Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com
FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130620/77240449/attachment.html

Abdullah

2013-06-21 05:59:02 UTC

Permalink

THANKS HASSAN,

i have write my own Perl script for CDR purpose . so tell me how i can call
this script on call hangup of free-switch .

i asterisk we can call that script on h extension . but in free-switch i am
little bit confused ??

Thanks again .

regards

Abdullah

--
View this message in context: http://freeswitch-users.2379917.n2.nabble.com/How-create-customize-CDR-in-free-Switch-tp7591980p7592028.html
Sent from the freeswitch-users mailing list archive at Nabble.com.

Nyamul Hassan

2013-06-21 06:11:08 UTC

Permalink

You're welcome Abdullah!

I do not trigger my PHP script from within FreeSWITCH. I run it every
minute from Linuxx cron through a bash wrapper. The wrapper serves an
important purpose --- finding out if there is already an instance of the
script running.

This method does result in a delay (max 1 min) from the time the CDR file
was created, to when it was posted in the DB. But, we accept this delay
for our use case, as it provides other benefits related to reliability,
load distribution, etc.

Regards
HASSAN

Post by Abdullah
THANKS HASSAN,
i have write my own Perl script for CDR purpose . so tell me how i can call
this script on call hangup of free-switch .
i asterisk we can call that script on h extension . but in free-switch i am
little bit confused ??
Thanks again .
regards
Abdullah
--
http://freeswitch-users.2379917.n2.nabble.com/How-create-customize-CDR-in-free-Switch-tp7591980p7592028.html
Sent from the freeswitch-users mailing list archive at Nabble.com.
_________________________________________________________________________
consulting at freeswitch.org
http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com
Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com
FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130621/b1332990/attachment-0001.html

Abdullah

2013-06-21 06:27:33 UTC

Permalink

hi ,

thanks again ,,

can you provide me the example . ??

regards.

Abdullah

--
View this message in context: http://freeswitch-users.2379917.n2.nabble.com/How-create-customize-CDR-in-free-Switch-tp7591980p7592032.html
Sent from the freeswitch-users mailing list archive at Nabble.com.

Nyamul Hassan

2013-06-21 06:49:15 UTC

Permalink

What I use is this:

=== start of file ===
#!/bin/sh
FILETORUN="/data/fs/cdr.php"
if ps -ef | grep -v grep | grep ${FILETORUN} ; then
exit 0
fi
/usr/bin/php ${FILETORUN}
=== end of file ===

Regards
HASSAN

Post by Abdullah
hi ,
thanks again ,,
can you provide me the example . ??
regards.
Abdullah
--
http://freeswitch-users.2379917.n2.nabble.com/How-create-customize-CDR-in-free-Switch-tp7591980p7592032.html
Sent from the freeswitch-users mailing list archive at Nabble.com.
_________________________________________________________________________
consulting at freeswitch.org
http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com
Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com
FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130621/0a1b8806/attachment.html

Steven Ayre

2013-06-21 07:44:03 UTC

Permalink

Lock files would be a better way of preventing multiple copies running.

http://php.net/manual/en/function.flock.php

Post by Nyamul Hassan
=== start of file ===
#!/bin/sh
FILETORUN="/data/fs/cdr.php"
if ps -ef | grep -v grep | grep ${FILETORUN} ; then
exit 0
fi
/usr/bin/php ${FILETORUN}
=== end of file ===
Regards
HASSAN

_________________________________________________________________________
consulting at freeswitch.org
http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com
Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com
FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130621/4490125c/attachment.html

Nyamul Hassan

2013-06-21 08:06:27 UTC

Permalink

Thanks Steve! Looks like a better option!!

Regards
HASSAN

Post by Steven Ayre
Lock files would be a better way of preventing multiple copies running.
http://php.net/manual/en/function.flock.php

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130621/39932084/attachment-0001.html

Ken Rice

2013-06-21 06:06:51 UTC

Permalink

If you drop xml_cdr's to the file system, and have your script stat the
filesystem every so often it can pick them up and process them, or you can
have mod_xml_cdr post them automattically on hangup to a webservice to
trigger the cdr processing

Post by Abdullah
THANKS HASSAN,
i have write my own Perl script for CDR purpose . so tell me how i can call
this script on call hangup of free-switch .
i asterisk we can call that script on h extension . but in free-switch i am
little bit confused ??
Thanks again .
regards
Abdullah
--
http://freeswitch-users.2379917.n2.nabble.com/How-create-customize-CDR-in-free
-Switch-tp7591980p7592028.html
Sent from the freeswitch-users mailing list archive at Nabble.com.
_________________________________________________________________________
consulting at freeswitch.org
http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com
Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com
FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

--
Ken
http://www.FreeSWITCH.org
http://www.ClueCon.com
http://www.OSTAG.org
irc.freenode.net #freeswitch

Continue reading on narkive:

Search results for '[Freeswitch-users] How create customize CDR in free-Switch .' (Questions and Answers)

replies

REMOVE SPYWARE GUARD 2008?

started 2009-01-18 07:01:05 UTC

security