Re: Setting custom field in CDR

2 msg	Voicemail Question
1 msg	VOIP Users Conference for Friday Dec 7 @ 12 Noo...
9 msg	CDR Function in Hangup Channel
6 msg	Probems receiving 200ok message
4 msg	Setting Multiple Values via func_odbc ...?
6 msg	Dial() Macro option error in 1.4.15

Setting custom field in CDR
\ Mike (6 Dec 2007)
. \ Atis Lezdins (6 Dec 2007)
. . \ Mike (6 Dec 2007)
. . \ Tilghman Lesher (6 Dec 2007)
. . \ Steve Edwards (6 Dec 2007)
. . . \ Matt Riddell (24 Dec 2007)
. \ Carlos Chavez (6 Dec 2007)

13 msg	Cisco power injector with GXP2000 phones
3 msg	Logging in and off sessions in the dialplan
1 msg	Re: Increasing the voice volume for digium card
5 msg	Call Center Scenario -- take 2
1 msg	IVR problem (Trixbox)
5 msg	Play Beep instead of MOH
2 msg	Re: Increasing the voice volume from the digium...
5 msg	DeadAgi
1 msg	Polycom call drops
4 msg	GSM and CDMA Gateways
1 msg	C&W ISDN110
1 msg	Re: Can Asterix seperate the signalling and the...
3 msg	Running AGI script if condition met?

Subject:	Re: Setting custom field in CDR
Group:	Asterisk-users
From:	Matt Riddell
Date:	24 Dec 2007

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Steve Edwards wrote:
> On Thu, 6 Dec 2007, Atis Lezdins wrote:
>
>> Only custom field you can use for now is CDR(userfield) and if you want
>> multiple values, you can separate them by something like #
>
> Adding multiple fields using userfield is a major hack that will
> repeatedly bite you for years.
>
> cdr_addon_mysql.c in the Asterisk addons package works great. It will take
> a minor bit of C skills to cut and paste to add new columns.

I wrote a patch for Asterisk (which is on the bugtracker) some time ago
to add 5 userfields. We still use this on our systems, but the patch on
the tracker has grown somewhat stale and will not be included because it
was deemed the incorrect way to do it (if you want to do it properly you
should allow some custom configuration in cdr_mysql.conf etc).

If you need any help applying the patch drop me a line and I'll see what
I can do.

- --
Kind Regards,

Matt Riddell
Director
_______________________________________________

http://www.venturevoip.com (Great new VoIP end to end solution)
http://www.venturevoip.com/news.php (Daily Asterisk News - html)
http://www.venturevoip.com/newrssfeed.php (Daily Asterisk News - rss)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFHbwDdDQNt8rg0Kp4RAqtSAJ9x6+rEXLa5/MnhjgIHM3mfexXVCACeLPPp
yEE7cwdyISAcalJlxbjT6QI=
=CBu0
-----END PGP SIGNATURE-----

_______________________________________________
--Bandwidth and Colocation Provided by http://www.api-digital.com--

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users