[asterisk-users] SOLVED: Re: Setting `userfield` from within a callfile

[Tilghman Lesher]

On Tuesday 21 December 2010 04:49:42 A J Stiles wrote:
> On Monday 20 Dec 2010, Olivier wrote:
> > 2010/12/20 A J Stiles <asterisk_list at earthshod.co.uk>
> > 
> > > Our current Asterisk 1.6.2.9 setup includes a CGI auto-dial
> > > application (written by someone else before me)  which sets up
> > > calls by creating files of
> > > the general form
> > > 
> > > Channel: SIP/$INSIDE_NUMBER
> > > Context: $CONTEXT
> > > Extension: $OUTSIDE_NUMBER
> > > Priority: 1
> > > CallerId: $INSIDE_NUMBER
> > > 
> > > in /var/spool/asterisk/outgoing/ .
> > > 
> > > It works very well.  However, it would be nice to be able to attach
> > > an additional piece of information along with the call record 
> > > There is a userfield in the SQL database, which is a VARCHAR(255)
> > > and would be plenty for what we need.  Is there a way to set the
> > > userfield of the CDR database from within such a callfile?
> > 
> > Yes, adding a Set field in your call file (see
> > http://www.voip-info.org/wiki/view/Asterisk+auto-dial+out), you'll be
> > able to pass everything you need to your dialplan, and then, from
> > there, write everything you need to your CDR.
> 
> I've got it working now!  Thanks Olivier and Tilghman.
> 
> Now, for the benefit of anyone who may be searching the archives of this
> mailing list at some point in the future, here's what I did.
> 
> I have modified the callfile-generating CGI script to added an extra
> line to the callfile, something like;
> 
> Set: uid=$UID
> 
> and made sure that the calls it places are in a context of their own. 
> In my extensions.conf, I then have as part of that context, a line
> ending with the command
> ... ,Set(CDR(userfield)=${uid})
> 
> and it all Just Works Beautifully.

You shouldn't need to.  You should be able to just do:

Set: CDR(userfield)=$UID

in your spoolfile and it should work from there.

-- 
Tilghman