[rizsher]

Moving my query to a different thread. This is the initial post I made:

Originally Posted by rizsher

Chandave,

Not trying to hijack this thread, but, could you please tell me exactly where does the name we assign to a CID appear?. Does it appear as the name of the caller on the phone display, or, in the Call Detail Reports?

In my case, I took a number as it appeats in the 3rd column of FreePBX Call Detail Reports, the Title of the column is "Source", added it to the database using put cidname, get the followign result when I show

asterisk1*CLI> database show cidname 20105551234
/cidname/20105551234                              : Rizwan Turdff

however, subsequesnt calls from 20105551234 still only show the number, both on the phone and the FreePBX Call Reports STLLL only show 20105551234, "Rizwan Turdff" doesn't show anywhere...

This is the CLI output I get:

 -- Goto (timeconditions,1,1)
    -- Executing GotoIfTime("SIP/81123456-098df990", "00:10-07:00|*|*|*?ivr-3|s|1") in new stack
    -- Executing Goto("SIP/81123456-098df990", "ext-findmefollow|111|1") in new stack
    -- Goto (ext-findmefollow,111,1)
    -- Executing Macro("SIP/81123456-098df990", "user-callerid|") in new stack
    -- Executing GotoIf("SIP/81123456-098df990", "0?report") in new stack
    -- Executing GotoIf("SIP/81123456-098df990", "0?start") in new stack
    -- Executing Set("SIP/81123456-098df990", "REALCALLERIDNUM=20105551234") in new stack
    -- Executing NoOp("SIP/81123456-098df990", "REALCALLERIDNUM is 20105551234") in new stack
    -- Executing Set("SIP/81123456-098df990", "AMPUSER=") in new stack
    -- Executing AGI("SIP/81123456-098df990", "calleridname.agi") in new stack
  -- Launched AGI Script /var/lib/asterisk/agi-bin/calleridname.agi calleridname.agi: CALLERID IS: 20105551234 calleridname.agi: Unable to parse phone number for NPA/NXX/station. Phone number is: 20105551234
    -- AGI Script calleridname.agi completed, returning 0
    -- Executing Set("SIP/81123456-098df990", "AMPUSERCIDNAME=") in new stack
    -- Executing GotoIf("SIP/81123456-098df990", "1?report") in new stack
    -- Goto (macro-user-callerid,s,10)
    -- Executing NoOp("SIP/81123456-098df990", "Using CallerID "20105551234" <20105551234>") in new stack
    -- Executing GotoIf("SIP/81123456-098df990", "0?NEWPREFIX") in new stack
    -- Executing Set("SIP/81123456-098df990", "CALLERID(name)=20105551234") in new stack
    -- Executing Set("SIP/81123456-098df990", "RGPREFIX=") in new stack
    -- Executing Set("SIP/81123456-098df990", "CALLERID(name)=20105551234") in new stack

Following is the macro-user-callerid section of my extensions.conf file:

[macro-user-callerid]
exten => s,1,GotoIf($["${CHANNEL:0:5}" = "Local"]?report) 
exten => s,n,GotoIf($["${REALCALLERIDNUM:1:2}" != ""]?start)
exten => s,n,Set(REALCALLERIDNUM=${CALLERID(number)})
exten => s,n(start),NoOp(REALCALLERIDNUM is ${REALCALLERIDNUM})
exten => s,n,Set(AMPUSER=${DB(DEVICE/${REALCALLERIDNUM}/user)})
exten => s,n,AGI(calleridname.agi)
exten => s,n,Set(AMPUSERCIDNAME=${DB(AMPUSER/${AMPUSER}/cidname)})
exten => s,n,GotoIf($["x${AMPUSERCIDNAME:1:2}" = "x"]?report) 
exten => s,n,Set(CALLERID(all)=${AMPUSERCIDNAME} <${AMPUSER}>)
exten => s,n(report),NoOp(Using CallerID ${CALLERID(all)})
 
; overrides callerid out trunks
; arg1 is trunk
; macro-user-callerid should be called _before_ using this macro

I added exten => s,n,AGI(calleridname.agi) following the steps on the nerdvittles website.

[rizsher]

to which Chandave gave the following reply:

Originally Posted by chandave

(Looks like you have a typo in the phone number or someone is purposely prefixing a zero to your NXX...)


The CIDnum Asterisk is getting is:

20105551234

which is not in the format calleridname.agi expects. It expects a 10 digit number so it can parse it out as NPA (3-digits), NXX (3-digits), and STATION (4-digits). That's why you are getting the "Unable to parse phone number for NPA/NXX/station. Phone number is: 20105551234" message.

If you really want it to work, you can add the following between lines 47 and 48:

elsif ( (length($callerid)==11) && (substr($callerid,3,1)==0) && ($callerid =~ /^(\d{3})(\d{4})(\d{4})$/) ) {
$npa = $1;
$nxx = $2;
$station = $3;
$AGI->verbose("Checking funky zero-prefixed NXX: $npa $nxx $station...\n");
}

So, it would look something like:

$AGI->verbose("Checking $npa $nxx $station...\n");
}
elsif ( (length($callerid)==11) && (substr($callerid,3,1)==0) && ($callerid =~ /^(\d{3})(\d{4})(\d{4})$/) ) {
......
else {
$AGI->verbose("Unable to parse phone number for NPA/NXX/station. Phone number is: $callerid\n");
exit(0);
}

And to answer your other questions:

The CIDName will appear in your CDR (probably in /var/log/asterisk/cdr-csv/Master.csv) in the 5th column as "Real Name <cidnum>". How it appears on the phone is up to your phone...if it even understands CIDName.

See ya...

d.c.

(rizsher or Eric: please move this thread to a new topic if we need to continue it)

[rizsher]

Chandave,

I wasn't aware the script only worked for North American naming system. I'm actually in Egypt, and receive calls from Pakistan/Egypt/UK, in addition to the USA. Each country has its own number convention, and depending on the trunk being called, the incoming CLI is different as well, the 20105551234 number is actually my egyptian mobile phone... and... if I call my USA Incoming DID, it appears as 0020105551234, on the UK DID, it strips the 00.

Actually, I thought, since I was actually physically assigning a name to the number, it shoudln't matter if the number is in the NANP format or not. Is there a non-north american version of callingname available somewhere?

Thanks for all your help.

Regards.
Rizwan Sher

[chandave]

Well, if you are only using the calleridname.agi to retrieve CIDname from your own Asterisk database, then you can change:

elseif ( (length($callerid)==11) && (substr($callerid,3,1)==0) && ($callerid =~ /^(\d{3})(\d{4})(\d{4})$/) ) {
$npa = $1;
$nxx = $2;
$status = $3;
$AGI->verbose("Checking funky zero-prefixed NXX: $npa $nxx $station...\n");
}

to

elsif ( (length($callerid)>10) && ($callerid =~ /^(\d+)$/) ) {
$station = $1;
$AGI->verbose("Checking non NA-NPA formatted number $station...\n");
}

Also, make sure:

$Fonetastic = '0';
$AnyWho = '0';
$Google = '0';
$Asteridex = '1';

To force calleridname.agi to only lookup the info from your Asterisk database.

See ya...

d.c.

[rizsher]

Got it working by installing the module, steps here