[Freeswitch-users] Freeswitch Postgresql CDR

[Antonio Teixeira]

Hello Vik.

I can vow for this the xml_cdr dumps , dumps all the channels vars.
Now just need to read the data and export it to our database.

Thanks
A/t



On 3/21/13 12:16 PM, Vik Killa wrote:
> 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
>>
> _________________________________________________________________________
> 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