Simple Call Accounting

*Bump*

Sorry, I kept seeing this but didn't get to answering it for you.

Try this:
Open up /etc/asterisk/extensions.conf
Go down to the section
[macro-dialout-trunk]

look for the entry:
exten => s,n,GotoIf($["${custom}" = "AMP"]?customtrunk)
exten => s,n,Dial(${OUT_${DIAL_TRUNK}}/${OUTNUM},300,${DIAL_TRUNK_OPTIONS})

BETWEEN those two lines, insert the code below

exten => s,n,Playback(please-enter-the&accounting)
exten => s,n,Read(account|number|3)
exten => s,n,SetAccount(${account})

I have it set up for max 3 digits (you can change the 3 to any number or just remove |3 for no maximum)
You can just press # to get through.

Try it out, let me know. The data should show up in the ACCOUNTCODE column in the CDR table.

Its VERY easy to change that to look at a generic text file of numbers to IF you want to make sure they are coded to something that is actually a valid account number.

Of course you can use the code for whatever you need. Maybe throw a comment in there somewhere that you got it from the trixbox.org forum or something :)
Thats how this whole open source thing works, sharing the building blocks of code for others to develop upon.

I can add a couple of lines into that code to filter out a certain dial sequence if you want.

i put that in the wiki:)
http://www.trixbox.org/wiki/additional-scripts-and-tricks

Sorry - double post

Here is the updated code I use to accomplish the original desired functionality. The "Read" function also does what "Playback" does so Playback is no longer needed. I decided to include a line to test for the number of digits dialed so that users are not prompted for an account code for a local call. Place this in the extensions_custom.config file and it will not be over written when you update FreePBX modules. You must include the context heading.

[macro-dialout-trunk-predial-hook]

exten => s,1,Set(str=${LEN(${OUTNUM})})
exten => s,n,GotoIF($[${str} tests for 11 digits, skips prompt for account code if less than 11 digits are dialed
exten => s,n,GotoIF($[ ${REALCALLERIDNUM} = 7398 ]?localcall) --> this line lets me disable this for a specific extension number
exten => s,n,GotoIF($[ ${REALCALLERIDNUM} = 4549 ]?localcall)
exten => s,n,GotoIF($[ ${REALCALLERIDNUM} = 3300 ]?localcall)
exten => s,n,Read(account,jobnum,8,,,5) --> Look up the Read function for the details, the word 'jobnum' is the name of my custom recording file that is played to prompt the user to enter the account code
exten => s,n,Set(CDR(accountcode)=${account})
exten => s,n(localcall),Noop

Here is the code without the explanation text...
[macro-dialout-trunk-predial-hook]

exten => s,1,Set(str=${LEN(${OUTNUM})})
exten => s,n,GotoIF($[${str} exten => s,n,GotoIF($[ ${REALCALLERIDNUM} = 7398 ]?localcall)
exten => s,n,GotoIF($[ ${REALCALLERIDNUM} = 4549 ]?localcall)
exten => s,n,GotoIF($[ ${REALCALLERIDNUM} = 3300 ]?localcall)
exten => s,n,Read(account,jobnum,8,,,5)
exten => s,n,Set(CDR(accountcode)=${account})
exten => s,n(localcall),Noop

You cannot see the accountcode field in the CDR reports generated under the Reports tab of the FreePBX console. You have to look at the master CDR file and use another program to create custom reports so that you can see all the fields. Hope this explanation makes sense, let me know if you need clarification.

Wow! Thank you for your help. This is exactly what I needed!

;) Incidentally, if you know of any tools that are better than just a mysql frontend for viewing the data, please let me know!

I am a bit new to the trixbox thing. I am trying to get the CDR to record the pin sets that were used for outgoing calls, but it does not list them. th column for them also is not on the report page. would someone be able to help me please.

Thanks in advance

TelSoft have an application that can do this.

www.telsoft.net.nz