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
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@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@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
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@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@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@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@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
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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
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@avimarcus.net <mailto:avi@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@gmail.com <mailto:eagle.antonio@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@freeswitch.org <mailto:consulting@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@lists.freeswitch.org <mailto: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 <mailto:consulting@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@lists.freeswitch.org <mailto: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
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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
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@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@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@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@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@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
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@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
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@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
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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
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@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@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@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@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@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
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@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
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@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
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@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
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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
participants (4)
-
Antonio Teixeira
-
Avi Marcus
-
David Villasmil
-
Vik Killa