Hi People, I work in a company that are using asterisk as pbx. I need a way to identify what client my employees are calling. For example: - For each call that an employee of my company make to a customer, must identify the client name in the CDR table. - Is there a way of my employee enter a code to identify the client and then enter a phone number to make the call? I would like to identify the customer's name in the table CDR. Thanks, Douglas -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20100224/df02f418/attachment.htm
Douglas Pasqua wrote:> Hi People, > > I work in a company that are using asterisk as pbx. > > I need a way to identify what client my employees are calling. For > example: > > - For each call that an employee of my company make to a customer, > must identify the client name in the CDR table. > - Is there a way of my employee enter a code to identify the client > and then enter a phone number to make the call? I would like to > identify the customer's name in the table > CDR.throw the information into a database and lookup the numbers before displaying the output with some other app. once they are in the db great but to build that up you could use any of the reverse lookup services and then just ask whoever made the calls to fill in whatever else is missing until you are up to a high hit rate of matches in your database. Have a procedure to enter new numbers for new clients. if you use something like sugar, just use the data in there to do your lookups since that is likely where the staff are looking up the numbers to make the calls in the first place.> > Thanks, > > Douglas > > > > >
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Douglas Pasqua skrev:> I need a way to identify what client my employees are calling. For example: > > - For each call that an employee of my company make to a customer, must > identify the client name in the CDR table. > - Is there a way of my employee enter a code to identify the client and > then enter a phone number to make the call? I would like to identify the > customer's name in the table > CDR.The easiest way of doing this is probably to have a separate database table with the customer names and phone numbers, and create a view that has the phone number as a key for both tables. This of course, depends on you having CDRs stored in a database, as well as up to date customer records. - - Tommy -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEAREKAAYFAkuFWAIACgkQ573V05EH/pYkvACeIVdlokIMk3Mnve7virfqRUsY 8FQAmQFHdoZXHKPX2J2QfKj0p+BcI0Dg =PZvI -----END PGP SIGNATURE-----
Why not set your clients up as "extensions" so your employee's
call them
with an extension code instead of dialing a number? For example
Exten => 1001,1,Dial(DAHDI/g1/18005551212)
Exten => 1002,1,Dial(DAHDI/g1/18005551213)
Exten => 1003,1,Dial(DAHDI/g1/18005551214)
Or more efficiently
Exten => _1xxx,1,Set(custid=${DB(${EXTEN})})
Exten => _1xxx,n,Dial(DAHDI/g1/${custid})
Solution 2 could be modified to use MYSQL, I just use ASTDB bc I don't care
for MYSQL.
In users.conf, set up the client companies as users like
[1001]
Username=abc widgets
[1002]
Username=at&t
[1003]
Username=IBM
Just a thought
Danny Nicholas
--
_____
From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Douglas Pasqua
Sent: Wednesday, February 24, 2010 10:36 AM
To: asterisk-users at lists.digium.com
Subject: [asterisk-users] identify the costumer
Hi People,
I work in a company that are using asterisk as pbx.
I need a way to identify what client my employees are calling. For example:
- For each call that an employee of my company make to a customer, must
identify the client name in the CDR table.
- Is there a way of my employee enter a code to identify the client and then
enter a phone number to make the call? I would like to identify the
customer's name in the table
CDR.
Thanks,
Douglas
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20100224/0eabcfdd/attachment.htm
Op 24-02-10 17:35, Douglas Pasqua schreef:> Hi People, > > I work in a company that are using asterisk as pbx. > > I need a way to identify what client my employees are calling. For example: > > - For each call that an employee of my company make to a customer, must > identify the client name in the CDR table. > - Is there a way of my employee enter a code to identify the client and > then enter a phone number to make the call? I would like to identify the > customer's name in the table > CDR. >SNOM phones have a CMC soft function key. When enabled, this allows you to enter a customer ID during a call. This is sent in a SIP info message to asterisk, and subsequently copied to the CDR userfield. Ron> Thanks, > > Douglas > > > > >-- NeoNova BV innovatieve internetoplossingen http://www.neonova.nl Science Park 140 1098 XG Amsterdam info: 020-5611300 servicedesk: 020-5611302 fax: 020-5611301 KvK Amsterdam 34151241 Op dit bericht is de volgende disclaimer van toepassing: http://www.neonova.nl/maildisclaimer