andrewgroup Posted January 23, 2009 Report Share Posted January 23, 2009 I must have dreamed this, but does 3.2.x support a daily output of CSV file? If so, how? Quote Link to comment Share on other sites More sharing options...
pbx support Posted January 23, 2009 Report Share Posted January 23, 2009 I must have dreamed this, but does 3.2.x support a daily output of CSV file? If so, how? Are asking this for CDRs or something else in mind? Quote Link to comment Share on other sites More sharing options...
andrewgroup Posted January 23, 2009 Author Report Share Posted January 23, 2009 Are asking this for CDRs or something else in mind? I see the global settings for mysql cdr writing, and during a recent call about a pending installation I thought I heard the idea existing to create a daily CDR file that would mirror the Simple CDR settings. We plan to move all XML CDR, recordings daily, we plan to outpulse via TCP/IP the simple CDR output to a SMDR reporting system, and the creation of a daily CSV file that mirrors simple CDR output would be the Holy Grail. I must have been dreaming - We do that often. Quote Link to comment Share on other sites More sharing options...
pbx support Posted January 23, 2009 Report Share Posted January 23, 2009 I see the global settings for mysql cdr writing, and during a recent call about a pending installation I thought I heard the idea existing to create a daily CDR file that would mirror the Simple CDR settings. We plan to move all XML CDR, recordings daily, we plan to outpulse via TCP/IP the simple CDR output to a SMDR reporting system, and the creation of a daily CSV file that mirrors simple CDR output would be the Holy Grail. I must have been dreaming - We do that often. Well, that was a simple question I asked . Anyways, if you want CDRs in the CSV format under the local disk, you have to uses "file:disk" (without quotes) as the "SOAP CDR URL". The CDR files will be created under the <pbx-install-dir>/cdr folder based on "cdr_format" string. Please send an email to support@pbxnsip.com for the draft document (not published to wiki yet) that explains this. Quote Link to comment Share on other sites More sharing options...
Vodia PBX Posted January 24, 2009 Report Share Posted January 24, 2009 I see the global settings for mysql cdr writing, and during a recent call about a pending installation I thought I heard the idea existing to create a daily CDR file that would mirror the Simple CDR settings. We plan to move all XML CDR, recordings daily, we plan to outpulse via TCP/IP the simple CDR output to a SMDR reporting system, and the creation of a daily CSV file that mirrors simple CDR output would be the Holy Grail. There is also a way to write the CDR to a regular file. Similar to writing a log file, but only for CDR. You can specify the CDR filename in the SOAP CDR URL setting like "file:cdr.txt". Quote Link to comment Share on other sites More sharing options...
andrewgroup Posted January 24, 2009 Author Report Share Posted January 24, 2009 There is also a way to write the CDR to a regular file. Similar to writing a log file, but only for CDR. You can specify the CDR filename in the SOAP CDR URL setting like "file:cdr.txt". Will be attacking this tommorrow, can today's date be inserted into the name? "file:$d-cdr.tct" to prevent overwriting of historical CDR files? Quote Link to comment Share on other sites More sharing options...
reco Posted May 6, 2010 Report Share Posted May 6, 2010 does this work? file:$d-cdr.txt Quote Link to comment Share on other sites More sharing options...
Vodia PBX Posted May 6, 2010 Report Share Posted May 6, 2010 Should work. $m is the domain. $d is the date (day) $h is the hour Quote Link to comment Share on other sites More sharing options...
pbx support Posted May 7, 2010 Report Share Posted May 7, 2010 Should work. $m is the domain. $d is the date (day) $h is the hour Just an update to the previous post. The usage of CSV for CDR is explained in http://pbxnsipsupport.com/index.php?_m=kno...kbarticleid=389 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.