[Freeswitch-users] Designing a schema for CDRs

[David Villasmil Govea]

I recommend it only you need something very basic. You won't learn anything
about freeSWITCH.
On Jan 1, 2015 5:27 PM, "Luis Daniel Lucio Quiroz" <
luis.daniel.lucio at gmail.com> wrote:

> Don't waste time, give a look into fusionpbx; it has what you are looking
> for
> On Jan 1, 2015 2:32 PM, "David Villasmil Govea" <david.villasmil at gmail.com>
> wrote:
>
>> There's a very nice php sample somewhere in the git, it parses the XML
>> and you can use it to validate fields,  do billing, whatever.
>> On Jan 1, 2015 2:16 PM, "Michael Collins" <msc at freeswitch.org> wrote:
>>
>>> It's also a good idea to validate field data before trying to write to
>>> your database. That way you could add fields that don't appear on every
>>> single call.
>>>
>>> -Michael
>>>
>>> On Thu, Jan 1, 2015 at 6:04 AM, Avi Marcus <avi at avimarcus.net> wrote:
>>>
>>>> Mod_xml_cdr gives you *all *the channel variables that you set, so it
>>>> changes all the time.
>>>>
>>>> If you want to save everything, you can't stuff that into columns in
>>>> mysql/postgres...
>>>>
>>>> You can pull out "common" fields for your schema, and then save the
>>>> rest (if you want) as an XML or json object... or use a nosql DB so you
>>>> don't need a schema.
>>>>
>>>> -Avi
>>>>
>>>> On Thu, Jan 1, 2015 at 12:19 PM, Tayyab Atiq <tayyabatiq at gmail.com>
>>>> wrote:
>>>>
>>>>> Hi.
>>>>>
>>>>> I have recently been trying to process CDR from mod_xml_cdr and store
>>>>> it in a db
>>>>> I first parsed and wrote all the information in a file, then designed
>>>>> a database based on the fields that appeared in the file.
>>>>> But it seems that FS adds/removes fields sometimes. This causes my
>>>>> query to fail as my program tries to insert columns that do not exist.
>>>>>
>>>>> Is there a way to figure out all the possible fields that might appear
>>>>> in the xml sent by mod_xml_cdr?
>>>>>
>>>>>
>>>>> _________________________________________________________________________
>>>>> Professional FreeSWITCH Consulting Services:
>>>>> consulting at freeswitch.org
>>>>> http://www.freeswitchsolutions.com
>>>>>
>>>>> Official FreeSWITCH Sites
>>>>> http://www.freeswitch.org
>>>>> http://confluence.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://confluence.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://confluence.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://confluence.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://confluence.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/20150101/7351c8bc/attachment-0001.html