If you break your callerid into 2 parts, you should be able to use something like the following: AVP display: "John Doe" AVP uri: "sip:18005551212@example.com <mailto:18005551212@example.com>" uac_replace_from("$avp(s:display)","$avp(s:uri)"); The above information has been documented at http://www.openser.org/docs/modules/1.0.x/uac.html Regards, Norm Brandon Price wrote: > We are storing cnam (callerid name) values in a mysql database for > use with openser. I have openser pulling the values from the > database using avpops but I need to know how to insert the value > into the from so that it will be passed to my sip user agents. > Related code posed below > > modparam("avpops","db_scheme","cnam_scheme:username_col=phonenumber;table=cnam_cache;value_col=cnam;value_type=string") > modparam("avpops", "avp_aliases", "cnam=s:cnam") > > avp_db_load("$from/cnam_scheme","cnam/$cnam_scheme"); #sample > query -- select cnam from cnam_cache where phonenumber='13143212222' > > this should now store that value in $cnam. > now how do I put that value for example "John Smith" in the from > portion of sip messaging so that it displays on the users sip > phone, or phone attached to an ata? > > > > _______________________________________________ > Users mailing list > Users(a)openser.org <mailto:Users@openser.org> > http://openser.org/cgi-bin/mailman/listinfo/users > > > >

On 10/29/05 02:21, Brandon Price wrote: > Following that logic should I not be able to just replace the > display and leave the uri as is with... > uac_replace_from("$avp(s:cnam)",""); > > did you get some log messages? use xlog("cnam value [$avp(s:cnam)] \n") to see if there is a value for the avp in memory. Cheers, Daniel > > I have of coarse already trid that with no success. > > On Oct 28, 2005, at 3:38 PM, Norman Brandinger wrote: > > > >> If you break your callerid into 2 parts, you should be able to >> use something like the following: >> >> AVP display: "John Doe" >> AVP uri: "sip:18005551212@example.com <mailto: >> 18005551212(a)example.com&gt;&quot; >> >> uac_replace_from("$avp(s:display)","$avp(s:uri)"); >> >> The above information has been documented at http:// >> www.openser.org/docs/modules/1.0.x/uac.html >> >> Regards, >> Norm >> >> Brandon Price wrote: >> >> >> >>> We are storing cnam (callerid name) values in a mysql database >>> for use with openser. I have openser pulling the values from >>> the database using avpops but I need to know how to insert the >>> value into the from so that it will be passed to my sip user >>> agents. Related code posed below >>> >>> modparam >>> ("avpops","db_scheme","cnam_scheme:username_col=phonenumber;table >>> =cnam_cache;value_col=cnam;value_type=string") modparam >>> ("avpops", "avp_aliases", "cnam=s:cnam") >>> >>> avp_db_load("$from/cnam_scheme","cnam/$cnam_scheme"); #sample >>> query -- select cnam from cnam_cache where >>> phonenumber='13143212222' >>> >>> this should now store that value in $cnam. >>> now how do I put that value for example "John Smith" in the >>> from portion of sip messaging so that it displays on the users >>> sip phone, or phone attached to an ata? >>> >>> >>> >>> _______________________________________________ >>> Users mailing list >>> Users(a)openser.org <mailto:Users@openser.org> >>> http://openser.org/cgi-bin/mailman/listinfo/users >>> >>> >>> >>> >>> >> >> >> >> > > > _______________________________________________ > Users mailing list > Users(a)openser.org <mailto:Users@openser.org> > http://openser.org/cgi-bin/mailman/listinfo/users > >