[Freeswitch-users] Freeswitch Postgresql CDR

[Vik Killa]

Have mod_xml_cdr write the XML CDR to disk and check if the variables
are in there...
Personally, i write all my CDRs to disk with mod_xml_cdr, then i have
a perl script that parses them and inserts into a database.


On Thu, Mar 21, 2013 at 4:04 AM, Antonio Teixeira
<eagle.antonio at gmail.com> wrote:
> Hello All.
>
> Thanks for the help , I tried Mod_cdr_pg_csv and Mod_cdr_csv and both are
> incapable of dumping the 'entire' channels vars you can configure both to
> actually go and pick specific vars.
>
> The main problem is that i create some 'dynamic vars' at IVR Run Time , but
> since i use ESL i will stick with writing the vars into the DB instead of
> the channel. This will also be more memory friendly.
>
> Thanks for the help
> Antonio
>
>
>
> On 3/20/13 3:25 PM, David Villasmil wrote:
>
> Hello,
>
> mod_xml_cdr is your best bet, imo. Simple and easy to implement.
>
> David
>
>
> On Tue, Mar 19, 2013 at 8:30 PM, Avi Marcus <avi at avimarcus.net> wrote:
>>
>> If you need all the vars, I think that's only in mod_xml_cdr and
>> mod_json_cdr -- both can either write to disk for you to import, or will
>> post to a web server.
>>
>> -Avi
>>
>> On Tue, Mar 19, 2013 at 6:13 PM, Antonio Teixeira
>> <eagle.antonio at gmail.com> wrote:
>>>
>>> Hello guys.
>>>
>>> I'm trying to implement CDrs in Postgresql , my objective is something
>>> like :
>>> http://wiki.freeswitch.org/wiki/Mod_cdr_pg_csv
>>>
>>> What i would like :
>>>
>>> Receiving The Entire CDR with all the channel variables , some are
>>> created inside the channel at 'runtime' so i need all the variables for
>>> processing.
>>>
>>> So does Postgresql in the core changes something to the above link?
>>> Is it possible to say in the schema something like give me all the
>>> variables and place it inside a specific field ?
>>>
>>> What do you guys recommend write a CDR into a dir and have an app to
>>> monitor and send all the files into a DB
>>> or use cdr_pg_csv.
>>>
>>> Thanks for the input
>>> Antonio
>>>
>>>
>>> _________________________________________________________________________
>>> Professional FreeSWITCH Consulting Services:
>>> consulting at freeswitch.org
>>> http://www.freeswitchsolutions.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
>>
>>
>>
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services:
>> consulting at freeswitch.org
>> http://www.freeswitchsolutions.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
>>
>
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.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
>
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.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
>