Hi Luis!
If this was a newest installation I will choose FusionPBX but as this is a running box I do prefer to not install Fusion, but just find a solution for adding a columns to channels table based on a custom variables (maybe declared into the dialplan or with a lua script).
Can  you give me a clue on this?

Thanks


Il giorno 18/gen/2015, alle ore 14:24, Luis Daniel Lucio Quiroz ha scritto:

> You may want to install FusionPBX, cdr code does exactly what you need
> Luis Daniel Lucio Quiroz
> CISSP, CISM, CISA
> Linux, VoIP and much more fun
> www.okay.com.mx
>
> Need LCR? Check out LCR for FusionPBX with FreeSWITCH
> Need Billing? Check out Billing for FusionPBX with FreeSWITCH
>
>
> 2015-01-18 5:59 GMT-05:00 Jack Cortez <mvar78@gmail.com>:
>> Hi,
>> I would like to add a column to channel table (created by FS automatically using ODBC) and populate this new columns with my own custom value.
>> Is this possible?
>>
>> In particular, as I'm creating a simple PHP page to show active calls, what I would like to add is a column with the gateway_name to identify the Outbound Provider Name. So, in my PHP page I can show where the call is going out.
>>
>> And also, I found that the application_data columns is showing the sofia dialstring (for ie. sofia/gateway/my_gateway/44798797978) but this columns is overwritten by last action I can't rely on this field.
>> I'm looking for days into the wiki but I didn't found anything interesting.
>>
>> Thank you so much!
>>
>>
>>
>>
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services:
>> consulting@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@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@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@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@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@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org