Jump to content

Daily CSV output


andrewgroup
 Share

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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".

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

  • 1 year later...

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...